metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA564013" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA564013" and tax_kingdom = "Orthornavirae"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
18398577	18398577	PRJNA564013_P_NODE_11295_length_1042_cov_12.998981_g9541_i0	PRJNA564013	11295	1042	12.998981	135.44938202	Alphachrysovirus aspergilli	607716	Viruses	Viruses	287	8.34e-86	NR	YP_009508103.1	607716	g9541	i0	84	0.486564299424184	169	27	48.7	0	678	172	92	260	YP_009508103.1 hypothetical protein [Alphachrysovirus aspergilli]	diamond	507	287	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Chrysoviridae	Alphachrysovirus	Alphachrysovirus aspergilli
26889667	26889667	PRJNA564013_P_NODE_344801_length_202_cov_1.382979_g341949_i0	PRJNA564013	344801	202	1.382979	2.79361758	Tymovirales sp.	1955157	Viruses	Viruses	88.2	2.17e-18	NR	XCO49695.1	1955157	g341949	i0	69.5	3.53465346534653	59	18	87.6	0	201	25	1669	1727	XCO49695.1 MAG: putative ORF1 protein [Tymovirales sp.]	diamond	714	88.2	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales			Tymovirales sp.
28009194	28009194	PRJNA564013_P_NODE_304885_length_222_cov_4.012422_g302033_i0	PRJNA564013	304885	222	4.012422	8.90757684	Totivirus	11007	Viruses	Viruses	51.2	2.87e-5	NR	UHK03295.1	2905246	g302033	i0	51	1.32432432432432	49	24	66.2	0	158	12	683	731	UHK03295.1 MAG: dehydrin, partial [Hangzhou totivirus 11]	diamond	294	51.6	0.992248062015504	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Hangzhou totivirus 11
31912586	31912586	PRJNA564013_P_NODE_35257_length_647_cov_8.984642_g32598_i0	PRJNA564013	35257	647	8.984642	58.13063374	Lariophagus distinguendus negative-strand RNA virus 1	2848911	Viruses	Viruses	70.9	2.09e-10	NR	QWT43293.1	2848911	g32598	i0	31.2	0.862442040185471	186	114	83.9	5	622	80	183	359	QWT43293.1 putative phosphoprotein [Lariophagus distinguendus negative-strand RNA virus 1]	diamond	558	70.9	1	Viruses	Orthornavirae	Negarnaviricota					Lariophagus distinguendus negative-strand RNA virus 1

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;