metadata: contig_metadata: 5 rows where bioproject = "PRJNA1031674", tax_kingdom = "Orthornavirae" and tax

5 rows where bioproject = "PRJNA1031674", tax_kingdom = "Orthornavirae" and tax_phylum = "Kitrinoviricota"

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
3993175	3993175	PRJNA1031674_P_NODE_17864_length_267_cov_1.587629_g17653_i0	PRJNA1031674	17864	267	1.587629	4.23896943	Crinivirus flavisolani	3428113	Viruses	Viruses	62.1	4.06e-5	NTclustered	gi\|375127651\|gb\|JN701960.1\|	103881	g17653	i0	100	3.21348314606742	33	0	12	0	77	109	379	411	Potato yellow vein virus isolate 716 Ipiales heat shock protein gene, complete cds	blastn	858	62.1	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Closteroviridae	Crinivirus	Crinivirus flavisolani
12920387	12920387	PRJNA1031674_P_NODE_17511_length_268_cov_2.194872_g17300_i0	PRJNA1031674	17511	268	2.194872	5.88225696	Bromovirus BMV	3427622	Viruses	Viruses	484	2.0399999999999996e-132	NTclustered	gi\|2329659857\|gb\|OK558642.1\|	12302	g17300	i0	99.257	33.910447761194	269	1	100	1	1	268	1671	1939	Brome mosaic virus isolate VRS-315 hypothetical protein gene, complete cds	blastn	9088	484	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Bromovirus	Bromovirus BMV
15469465	15469465	PRJNA1031674_P_NODE_17253_length_269_cov_2.117347_g17042_i0	PRJNA1031674	17253	269	2.117347	5.69566343	Johnsongrass virus	2845206	Viruses	Viruses	497	2.63e-136	NTclustered	gi\|2052625483\|gb\|MW756210.1\|	2845206	g17042	i0	100	7	269	0	100	0	1	269	1928	2196	Johnsongrass virus isolate JVG-1 polyprotein gene, complete cds	blastn	1883	497	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Endornaviridae		Johnsongrass virus
27224585	27224585	PRJNA1031674_P_NODE_13643_length_281_cov_2.192308_g13432_i0	PRJNA1031674	13643	281	2.192308	6.16038548	Nigrospora oryzae umbra-like virus 1	3234285	Viruses	Viruses	65.1	7.87e-10	NR	XCW89614.1	3234285	g13432	i0	67.4	0.491103202846975	46	15	49.1	0	280	143	449	494	XCW89614.1 RNA-dependent RNA polymerase [Nigrospora oryzae umbra-like virus 1]	diamond	138	65.1	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Nigrospora oryzae umbra-like virus 1
32248392	32248392	PRJNA1031674_P_NODE_13878_length_281_cov_1.110577_g13667_i0	PRJNA1031674	13878	281	1.110577	3.12072137	Grapevine endophyte alphaendornavirus	1249676	Viruses	Viruses	188	5.33e-53	NR	YP_007003829.1	1249676	g13667	i0	92.5	0.99288256227758	93	7	99.3	0	280	2	62	154	YP_007003829.1 polyprotein [Grapevine endophyte alphaendornavirus]	diamond	279	188	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Endornaviridae	Alphaendornavirus	Alphaendornavirus vitis

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);;