metadata: contig_metadata: 22 rows where bioproject = "PRJNA760976" and tax

22 rows where bioproject = "PRJNA760976" 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
742326	742326	PRJNA760976_P_NODE_2301_length_841_cov_2.235677_g2026_i0	PRJNA760976	2301	841	2.235677	18.80204357	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1452	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g2026	i0	97.86	3.00118906064209	841	16	100	1	1	841	127	965	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	2524	1452	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
2018386	2018386	PRJNA760976_P_NODE_3482_length_698_cov_2.305600_g3179_i0	PRJNA760976	3482	698	2.3056	16.093088	brine shrimp arlivirus 7	2900382	Viruses	Viruses	1190	0	NTclustered	gi\|2209095168\|gb\|OL472412.1\|	2900382	g3179	i0	97.071	1.02722063037249	717	2	100	2	1	698	4125	4841	MAG: Brine shrimp arlivirus 7 isolate XZ/98-19 hypothetical protein, RNA-dependent RNA polymerase, and hypothetical protein genes, complete cds	blastn	717	1190	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Arlivirus	brine shrimp arlivirus 7
5845881	5845881	PRJNA760976_P_NODE_1605_length_989_cov_1.907205_g1369_i0	PRJNA760976	1605	989	1.907205	18.86225745	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1574	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g1369	i0	95.363	3.00910010111223	992	43	100	1	1	989	2458	3449	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	2976	1574	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
9670872	9670872	PRJNA760976_P_NODE_588_length_1530_cov_2.117364_g472_i0	PRJNA760976	588	1530	2.117364	32.3956692	Zebrafish picornavirus 1	2304617	Viruses	Viruses	2599	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g472	i0	97.32	3	1530	41	100	0	1	1530	5049	3520	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	4590	2599	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
16045055	16045055	PRJNA760976_P_NODE_52373_length_245_cov_0.860465_g52052_i0	PRJNA760976	52373	245	0.860465	2.10813925	brine shrimp yue-like virus 9	2900461	Viruses	Viruses	448	2.41e-121	NTclustered	gi\|2209095304\|gb\|OL472858.1\|	2900461	g52052	i0	99.592	2	245	1	100	0	1	245	7332	7088	MAG: Brine shrimp yue-like virus 9 isolate XZ/98-19 segment 1 RNA-dependent RNA polymerase gene, complete cds	blastn	490	448	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		brine shrimp yue-like virus 9
17320678	17320678	PRJNA760976_P_NODE_29694_length_303_cov_1.991304_g29373_i0	PRJNA760976	29694	303	1.991304	6.03365112	Dicistroviridae sp.	1955144	Viruses	Viruses	560	3.79e-155	NTclustered	gi\|2756423162\|gb\|PP745372.1\|	1955144	g29373	i0	100	2	303	0	100	0	1	303	1943	1641	MAG: Dicistroviridae sp. isolate 037_370 genomic sequence	blastn	606	560	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
17320788	17320788	PRJNA760976_P_NODE_874_length_1299_cov_4.314029_g714_i0	PRJNA760976	874	1299	4.314029	56.03923671	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1962	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g714	i0	96.769	3.5927636643572	1176	38	99	0	124	1299	8214	7039	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	4667	1962	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
21144936	21144936	PRJNA760976_P_NODE_357_length_1863_cov_2.587151_g280_i0	PRJNA760976	357	1863	2.587151	48.19862313	Zebrafish picornavirus 1	2304617	Viruses	Viruses	3090	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g280	i0	96.617	2.99838969404187	1862	63	99	0	1	1862	7082	5221	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	5586	3090	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
24968945	24968945	PRJNA760976_P_NODE_2280_length_844_cov_1.501946_g2007_i0	PRJNA760976	2280	844	1.501946	12.67642424	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1384	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g2007	i0	96.318	2.99289099526066	842	31	99	0	1	842	1352	2193	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	2526	1384	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
24969028	24969028	PRJNA760976_P_NODE_53980_length_243_cov_0.905882_g53659_i0	PRJNA760976	53980	243	0.905882	2.20129326	brine shrimp arlivirus 7	2900382	Viruses	Viruses	433	6.69e-117	NTclustered	gi\|2209095168\|gb\|OL472412.1\|	2900382	g53659	i0	98.765	1	243	3	100	0	1	243	3892	4134	MAG: Brine shrimp arlivirus 7 isolate XZ/98-19 hypothetical protein, RNA-dependent RNA polymerase, and hypothetical protein genes, complete cds	blastn	243	433	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Arlivirus	brine shrimp arlivirus 7
26799898	26799898	PRJNA760976_P_NODE_4461_length_622_cov_2.060109_g4152_i0	PRJNA760976	4461	622	2.060109	12.813877979999999	Durnavirales sp.	2809355	Viruses	Viruses	155	5.31e-41	NR	WRQ64726.1	2809355	g4152	i0	39.3	0.993569131832797	206	124	98.9	1	621	7	238	443	WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.]	diamond	618	155	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Durnavirales sp.
27053216	27053216	PRJNA760976_P_NODE_14562_length_390_cov_1.637224_g14242_i0	PRJNA760976	14562	390	1.637224	6.3851736	Cryphonectria naterciae splipalmivirus 1	2841740	Viruses	Viruses	73.6	3.22e-12	NR	BCX55510.1	2841740	g14242	i0	32.3	1	130	84	96.9	2	378	1	108	237	BCX55510.1 putative RNA-dependent RNA polymerase [Cryphonectria naterciae splipalmivirus 1]	diamond	390	73.6	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Divipalmivirus	Divipalmivirus cryphonectriae
27116129	27116129	PRJNA760976_P_NODE_1322_length_1082_cov_3.175421_g1113_i0	PRJNA760976	1322	1082	3.175421	34.35805522	Downy mildew lesion associated splipalmivirus 46	3065434	Viruses	Viruses	63.9	5.23e-7	NR	WLJ60693.1	3065434	g1113	i0	32.1	0.371534195933457	134	80	36.3	3	13	405	415	540	WLJ60693.1 MAG: putative RdRp [Downy mildew lesion associated splipalmivirus 46]	diamond	402	63.9	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Downy mildew lesion associated splipalmivirus 46
28642013	28642013	PRJNA760976_P_NODE_16947_length_370_cov_0.989899_g16626_i0	PRJNA760976	16947	370	0.989899	3.6626263	Wolframvirales	2732502	Viruses	Viruses	102	1.45e-22	NR	UTQ48830.1	2964624	g16626	i0	39.5	4.67837837837838	114	69	92.4	0	343	2	158	271	UTQ48830.1 RNA-dependent RNA polymerase [Monilinia fructicola binarnavirus 1]	diamond	1731	102	1	Viruses	Orthornavirae				Birnaviridae		Monilinia fructicola binarnavirus 1
29683472	29683472	PRJNA760976_P_NODE_770_length_1365_cov_2.842105_g629_i0	PRJNA760976	770	1365	2.842105	38.79473325	Wolframvirales	2732502	Viruses	Viruses	116	7.48e-24	NR	BCH36628.1	2250450	g629	i0	26.6	2.05934065934066	305	213	65.9	6	1029	130	56	354	BCH36628.1 hypothetical protein [Aspergillus fumigatus narnavirus 2]	diamond	2811	116	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Divipalmivirus	Divipalmivirus aspergilli
29926916	29926916	PRJNA760976_P_NODE_2471_length_814_cov_2.979757_g2190_i0	PRJNA760976	2471	814	2.979757	24.25522198	Downy mildew lesion associated splipalmivirus 3	2719514	Viruses	Viruses	86.3	4.9e-16	NR	WNA22210.1	2719514	g2190	i0	31.6	0.77027027027027	209	123	73.3	7	688	92	40	238	WNA22210.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 3]	diamond	627	86.3	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Jakapalmivirus	Jakapalmivirus ibericum
30779833	30779833	PRJNA760976_P_NODE_674_length_1436_cov_2.030081_g543_i0	PRJNA760976	674	1436	2.030081	29.15196316	Penaeus vannamei narna-like virus 2	3132560	Viruses	Viruses	387	1.4e-123	NR	WWZ85650.1	3132560	g543	i0	44.7	0.981894150417827	470	247	97.6	10	33	1433	2	461	WWZ85650.1 hypothetical protein [Penaeus vannamei narna-like virus 2]	diamond	1410	387	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Penaeus vannamei narna-like virus 2
31538659	31538659	PRJNA760976_P_NODE_2176_length_862_cov_1.612167_g1906_i0	PRJNA760976	2176	862	1.612167	13.89687954	Rhabdoviridae sp.	1955137	Viruses	Viruses	80.1	8.02e-13	NR	XKB76561.1	1955137	g1906	i0	27.6	0.755220417633411	217	134	71.3	6	243	857	170	375	XKB76561.1 MAG: hypothetical protein [Rhabdoviridae sp.]	diamond	651	80.1	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae		Rhabdoviridae sp.
31664861	31664861	PRJNA760976_P_NODE_39897_length_272_cov_1.095477_g39576_i0	PRJNA760976	39897	272	1.095477	2.97969744	Novo Mesto dicistrovirus 2	2950811	Viruses	Viruses	172	8.139999999999998e-48	NR	UTQ50719.1	2950811	g39576	i0	91.1	0.992647058823529	90	8	99.3	0	270	1	730	819	UTQ50719.1 MAG: capsid protein [Novo Mesto dicistrovirus 2]	diamond	270	172	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Novo Mesto dicistrovirus 2
31990926	31990926	PRJNA760976_P_NODE_6918_length_518_cov_1.375281_g6600_i0	PRJNA760976	6918	518	1.375281	7.12395558	Narnavirus	186767	Viruses	Viruses	62.4	3.34e-8	NR	WNA22207.1	2719503	g6600	i0	34.5	1.28571428571429	113	73	65.4	1	376	38	5	116	WNA22207.1 MAG: hypothetical protein, partial [Downy mildew lesion associated splipalmivirus 2]	diamond	666	62.8	0.993630573248408	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Downy mildew lesion associated splipalmivirus 2
32107871	32107871	PRJNA760976_P_NODE_15498_length_381_cov_2.032468_g15177_i0	PRJNA760976	15498	381	2.032468	7.74370308	Penaeus vannamei narna-like virus 2	3132560	Viruses	Viruses	76.3	3.35e-13	NR	WWZ85650.1	3132560	g15177	i0	40.4	0.740157480314961	94	56	74	0	1	282	558	651	WWZ85650.1 hypothetical protein [Penaeus vannamei narna-like virus 2]	diamond	282	76.3	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Penaeus vannamei narna-like virus 2
32645094	32645094	PRJNA760976_P_NODE_640_length_1468_cov_4.090323_g513_i0	PRJNA760976	640	1468	4.090323	60.04594164	Durnavirales sp.	2809355	Viruses	Viruses	287	1.2699999999999996e-87	NR	WRQ64726.1	2809355	g513	i0	36.8	0.960490463215259	470	284	94	7	1384	5	6	472	WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.]	diamond	1410	287	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Durnavirales sp.

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