metadata: contig_metadata: 9 rows where bioproject = "PRJNA814235", tax_kingdom = "Orthornavirae" and tax

9 rows where bioproject = "PRJNA814235", 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
3369014	3369014	PRJNA814235_P_NODE_60803_length_244_cov_2.144928_g59409_i0	PRJNA814235	60803	244	2.144928	5.23362432	Alfamovirus AMV	12321	Viruses	Viruses	435	1.87e-117	NTclustered	gi\|2097420456\|gb\|MW633766.1\|	12321	g59409	i0	98.77	99.9918032786885	244	3	100	0	1	244	7	250	Alfalfa mosaic virus isolate XIANGGELILA/2017/19 coat protein gene, complete cds	blastn	24398	435	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Alfamovirus	Alfamovirus AMV
11020000	11020000	PRJNA814235_P_NODE_155249_length_170_cov_1.766917_g153854_i0	PRJNA814235	155249	170	1.766917	3.0037589	Alfamovirus AMV	12321	Viruses	Viruses	303	3.55e-78	NTclustered	gi\|2202915138\|gb\|OL706249.1\|	12321	g153854	i0	98.824	92.9705882352941	170	2	100	0	1	170	2452	2621	Alfalfa mosaic virus isolate AMV/China_Wenxian_2/H6 replicase P1 gene, complete cds	blastn	15805	303	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Alfamovirus	Alfamovirus AMV
14843268	14843268	PRJNA814235_P_NODE_103412_length_203_cov_2.295181_g102017_i0	PRJNA814235	103412	203	2.295181	4.65921743	Alfamovirus AMV	12321	Viruses	Viruses	141	3.67e-29	NTclustered	gi\|2202915138\|gb\|OL706249.1\|	12321	g102017	i0	100	69.8817733990148	76	0	75	0	128	203	2267	2192	Alfalfa mosaic virus isolate AMV/China_Wenxian_2/H6 replicase P1 gene, complete cds	blastn	14186	141	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Alfamovirus	Alfamovirus AMV
17393722	17393722	PRJNA814235_P_NODE_118174_length_203_cov_1.831325_g116779_i0	PRJNA814235	118174	203	1.831325	3.71758975	Alfamovirus AMV	12321	Viruses	Viruses	141	3.67e-29	NTclustered	gi\|2202915138\|gb\|OL706249.1\|	12321	g116779	i0	100	62.4729064039409	76	0	75	0	128	203	1794	1719	Alfalfa mosaic virus isolate AMV/China_Wenxian_2/H6 replicase P1 gene, complete cds	blastn	12682	141	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Alfamovirus	Alfamovirus AMV
17394234	17394234	PRJNA814235_P_NODE_141094_length_183_cov_1.404110_g139699_i0	PRJNA814235	141094	183	1.40411	2.5695213	Ripokey virus	3130967	Viruses	Viruses	102	1.53e-17	NTclustered	gi\|2717321269\|gb\|PP173269.1\|	3130967	g139699	i0	82.5	0.655737704918033	120	17	64	4	56	173	286	169	MAG: Ripokey virus isolate KCAP3_k141_298256 genomic sequence	blastn	120	102	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales			Ripokey virus
17395526	17395526	PRJNA814235_P_NODE_199994_length_150_cov_3.008850_g198599_i0	PRJNA814235	199994	150	3.00885	4.513275	Hainan alphaflexivirus 2	2824425	Viruses	Viruses	121	3.3e-23	NTclustered	gi\|2075444288\|gb\|MW897284.1\|	2824425	g198599	i0	82.237	59.62	152	16	94	4	10	150	4533	4382	MAG: Hainan alphaflexivirus 2 isolate R87-k141_314575 replicase gene, partial cds; and NTP-binding helicase and hypothetical protein genes, complete cds	blastn	8943	121	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae		Hainan alphaflexivirus 2
18667342	18667342	PRJNA814235_P_NODE_141875_length_182_cov_1.841379_g140480_i0	PRJNA814235	141875	182	1.841379	3.35130978	Alfamovirus AMV	12321	Viruses	Viruses	337	3.82e-88	NTclustered	gi\|2202915138\|gb\|OL706249.1\|	12321	g140480	i0	100	97.956043956044	182	0	100	0	1	182	829	648	Alfalfa mosaic virus isolate AMV/China_Wenxian_2/H6 replicase P1 gene, complete cds	blastn	17828	337	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Alfamovirus	Alfamovirus AMV
19942465	19942465	PRJNA814235_P_NODE_139396_length_184_cov_3.578231_g138001_i0	PRJNA814235	139396	184	3.578231	6.58394504	Alfamovirus AMV	12321	Viruses	Viruses	335	1.3899999999999996e-87	NTclustered	gi\|2202915138\|gb\|OL706249.1\|	12321	g138001	i0	99.457	98.1304347826087	184	1	100	0	1	184	1027	844	Alfalfa mosaic virus isolate AMV/China_Wenxian_2/H6 replicase P1 gene, complete cds	blastn	18056	335	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Alfamovirus	Alfamovirus AMV
30686178	30686178	PRJNA814235_P_NODE_4373_length_884_cov_14.471074_g3618_i0	PRJNA814235	4373	884	14.471074	127.92429416	Sclerotinia sclerotiorum deltaflexivirus 1	1788309	Viruses	Viruses	63.2	5.62e-8	NR	UOJ41055.1	1788309	g3618	i0	29.6	1.02828054298643	152	95	49.2	5	772	338	17	163	UOJ41055.1 hypothetical protein [Sclerotinia sclerotiorum deltaflexivirus 1]	diamond	909	63.2	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Deltaflexiviridae	Deltaflexivirus	Deltaflexivirus sclerotiniae

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