metadata: contig_metadata: 19 rows where bioproject = "PRJNA1253698" and tax

19 rows where bioproject = "PRJNA1253698" 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
359563	359563	PRJNA1253698_S_NODE_18261_length_168_cov_3.310924_g17895_i0	PRJNA1253698	18261	168	3.310924	5.56235232	Skokie dicistro-like virus	2789443	Viruses	Viruses	263	5.989999999999999e-66	NTclustered	gi\|1935607033\|gb\|MT747992.1\|	2789443	g17895	i0	96.25	1.67857142857143	160	6	95	0	1	160	8501	8660	Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds	blastn	282	263	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
1634450	1634450	PRJNA1253698_S_NODE_2902_length_416_cov_5.539510_g2538_i0	PRJNA1253698	2902	416	5.53951	23.0443616	Skokie dicistro-like virus	2789443	Viruses	Viruses	586	8.87e-163	NTclustered	gi\|1935607033\|gb\|MT747992.1\|	2789443	g2538	i0	98.209	0.805288461538462	335	6	81	0	1	335	335	1	Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds	blastn	335	586	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
6737398	6737398	PRJNA1253698_S_NODE_20946_length_165_cov_0.896552_g20580_i0	PRJNA1253698	20946	165	0.896552	1.4793108	Tobamovirus fructirugosum	3432872	Viruses	Viruses	305	9.59e-79	NTclustered	gi\|2837380181\|gb\|PP099897.1\|	1761477	g20580	i0	100	100	165	0	100	0	1	165	2469	2305	Tomato brown rugose fruit virus isolate NPPO-NL 36648757, complete genome	blastn	16500	305	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus fructirugosum
8013067	8013067	PRJNA1253698_S_NODE_1167_length_1058_cov_6.127849_g883_i0	PRJNA1253698	1167	1058	6.127849	64.83264242	Skokie dicistro-like virus	2789443	Viruses	Viruses	1847	0	NTclustered	gi\|1935607033\|gb\|MT747992.1\|	2789443	g883	i0	98.202	0.999054820415879	1057	19	99	0	2	1058	1367	311	Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds	blastn	1057	1847	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
9287908	9287908	PRJNA1253698_S_NODE_828_length_2798_cov_7.310295_g637_i0	PRJNA1253698	828	2798	7.310295	204.5420541	Skokie dicistro-like virus	2789443	Viruses	Viruses	4634	0	NTclustered	gi\|1935607033\|gb\|MT747992.1\|	2789443	g637	i0	96.568	1.5360972122945	2797	96	99	0	2	2798	4164	1368	Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds	blastn	4298	4634	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
13113562	13113562	PRJNA1253698_S_NODE_651_length_4373_cov_8.246531_g501_i0	PRJNA1253698	651	4373	8.246531	360.62080063	Skokie dicistro-like virus	2789443	Viruses	Viruses	7371	0	NTclustered	gi\|2806502719\|gb\|PQ054859.1\|	2789443	g501	i0	97.095	3.38989252229591	4372	127	99	0	2	4373	5230	859	MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence	blastn	14824	7371	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
16936881	16936881	PRJNA1253698_S_NODE_10014_length_217_cov_4.464286_g9648_i0	PRJNA1253698	10014	217	4.464286	9.68750062	Alphapartitivirus sp.	2809141	Viruses	Viruses	111	3.12e-20	NTclustered	gi\|2120560313\|gb\|MZ556440.1\|	2809141	g9648	i0	95.652	192.179723502304	69	3	32	0	1	69	1943	2011	MAG: Alphapartitivirus sp. isolate s20-k141_862889 putative RNA-dependent RNA polymerase gene, complete cds	blastn	41703	111	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Alphapartitivirus	Alphapartitivirus sp.
17630362	17630362	PRJNA1253698_S_NODE_10594_length_212_cov_1.251534_g10228_i0	PRJNA1253698	10594	212	1.251534	2.65325208	Tobamovirus	12234	Viruses	Viruses	381	2.0899999999999994e-101	NTclustered	gi\|2647550519\|gb\|OR843964.1\|	12242	g10228	i0	100	97.1698113207547	206	0	97	0	7	212	2265	2060	Tobacco mosaic virus strain MR644-18E/3430 nonstructural polyprotein p183, nonstructural polyprotein p126, and movement protein genes, partial cds	blastn	20600	381	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tabaci
24585953	24585953	PRJNA1253698_S_NODE_19980_length_166_cov_1.128205_g19614_i0	PRJNA1253698	19980	166	1.128205	1.8728203	Tobamovirus fructirugosum	3432872	Viruses	Viruses	300	4.5e-77	NTclustered	gi\|1805995756\|gb\|MN882044.1\|	1761477	g19614	i0	99.394	99.3975903614458	165	1	99	0	1	165	4654	4818	Tomato brown rugose fruit virus isolate 39563388_A, complete genome	blastn	16500	300	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus fructirugosum
27200008	27200008	PRJNA1253698_S_NODE_7902_length_244_cov_1.558974_g7536_i0	PRJNA1253698	7902	244	1.558974	3.80389656	Hubei toti-like virus 2	1923308	Viruses	Viruses	77.4	2.36e-14	NR	YP_009336496.1	1923308	g7536	i0	48.8	2.98770491803279	82	41	99.6	1	2	244	586	667	YP_009336496.1 hypothetical protein 2 [Hubei toti-like virus 2]	diamond	729	77.4	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus jyugo
27534075	27534075	PRJNA1253698_S_NODE_9983_length_218_cov_1.207101_g9617_i0	PRJNA1253698	9983	218	1.207101	2.63148018	Ghabrivirales	2732540	Viruses	Viruses	102	1.92e-23	NR	YP_009336496.1	1923308	g9617	i0	71.8	7.88532110091743	71	20	97.7	0	2	214	489	559	YP_009336496.1 hypothetical protein 2 [Hubei toti-like virus 2]	diamond	1719	103	0.990291262135922	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus jyugo
27547736	27547736	PRJNA1253698_S_NODE_3984_length_349_cov_1.886667_g3618_i0	PRJNA1253698	3984	349	1.886667	6.58446783	Cynanchum associated totivirus	3161584	Viruses	Viruses	177	2.38e-49	NR	WZE63370.1	3161584	g3618	i0	73.3	0.997134670487106	116	30	99.7	1	2	349	359	473	WZE63370.1 putative RNA-directed RNA polymerase [Cynanchum associated totivirus]	diamond	348	177	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Cynanchum associated totivirus
28621397	28621397	PRJNA1253698_S_NODE_1667_length_629_cov_1.774138_g1325_i0	PRJNA1253698	1667	629	1.774138	11.15932802	Cynanchum associated totivirus	3161584	Viruses	Viruses	175	2.78e-47	NR	WZE63369.1	3161584	g1325	i0	67.6	0.529411764705882	111	36	52.9	0	295	627	483	593	WZE63369.1 putative capsid protein [Cynanchum associated totivirus]	diamond	333	175	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Cynanchum associated totivirus
28652873	28652873	PRJNA1253698_S_NODE_14027_length_187_cov_1.862319_g13661_i0	PRJNA1253698	14027	187	1.862319	3.48253653	Panax notoginseng virus A	1777016	Viruses	Viruses	83.6	7.01e-17	NR	YP_009225665.1	1777016	g13661	i0	60	3.85026737967914	60	24	96.3	0	3	182	64	123	YP_009225665.1 putative RNA-dependent RNA polymerase [Panax notoginseng virus A]	diamond	720	83.6	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus jyushi
28652874	28652874	PRJNA1253698_S_NODE_5167_length_304_cov_1.764706_g4801_i0	PRJNA1253698	5167	304	1.764706	5.36470624	Cynanchum associated totivirus	3161584	Viruses	Viruses	108	8.04e-25	NR	WZE63370.1	3161584	g4801	i0	55.6	1.77631578947368	90	40	88.8	0	5	274	685	774	WZE63370.1 putative RNA-directed RNA polymerase [Cynanchum associated totivirus]	diamond	540	108	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Cynanchum associated totivirus
29852738	29852738	PRJNA1253698_S_NODE_3671_length_364_cov_2.273016_g3305_i0	PRJNA1253698	3671	364	2.273016	8.27377824	Cynanchum associated totivirus	3161584	Viruses	Viruses	183	3.13e-51	NR	WZE63370.1	3161584	g3305	i0	77.1	2.69505494505495	109	25	89.8	0	364	38	258	366	WZE63370.1 putative RNA-directed RNA polymerase [Cynanchum associated totivirus]	diamond	981	183	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Cynanchum associated totivirus
30059958	30059958	PRJNA1253698_S_NODE_1871_length_570_cov_2.019194_g1523_i0	PRJNA1253698	1871	570	2.019194	11.5094058	Totivirus	11007	Viruses	Viruses	213	3.2e-61	NR	AWX94599.1	2248770	g1523	i0	53.4	2.97894736842105	189	86	99.5	1	569	3	34	220	AWX94599.1 putative RNA-dependent RNA polymerase [Panax notoginseng virus B]	diamond	1698	213	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus jyushi
32318762	32318762	PRJNA1253698_S_NODE_7979_length_243_cov_1.319588_g7613_i0	PRJNA1253698	7979	243	1.319588	3.20659884	Cynanchum associated totivirus	3161584	Viruses	Viruses	110	7.11e-26	NR	WZE63369.1	3161584	g7613	i0	62	0.975308641975309	79	30	97.5	0	238	2	178	256	WZE63369.1 putative capsid protein [Cynanchum associated totivirus]	diamond	237	110	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Cynanchum associated totivirus
32791762	32791762	PRJNA1253698_S_NODE_7260_length_255_cov_1.470874_g6894_i0	PRJNA1253698	7260	255	1.470874	3.7507287	Carrot-associated toti-like virus	3051703	Viruses	Viruses	84.3	9.8e-17	NR	WIL96218.1	3051703	g6894	i0	53.7	0.788235294117647	67	31	78.8	0	208	8	34	100	WIL96218.1 RNA-dependent RNA polymerase [Carrot-associated toti-like virus]	diamond	201	84.3	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Carrot-associated toti-like virus

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