metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA902848" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA902848" 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
881879	881879	PRJNA902848_P_NODE_11161_length_272_cov_1.175879_g11111_i0	PRJNA902848	11161	272	1.175879	3.19839088	Bombyx mori latent virus	2065033	Viruses	Viruses	442	1.2699999999999995e-119	NTclustered	gi\|1464307034\|ref\|NC_038331.1\|	2065033	g11111	i0	95.956	4	272	11	100	0	1	272	2141	1870	Bombyx mori latent virus genomic RNA, complete genome	blastn	1088	442	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae		Bombyx mori latent virus
882070	882070	PRJNA902848_P_NODE_1_length_5615_cov_9.733670_g0_i0	PRJNA902848	1	5615	9.73367	546.5455705	La Jolla virus	1654357	Viruses	Viruses	8514	0	NTclustered	gi\|1417910481\|gb\|MH384285.1\|	1654357	g0	i0	94.034	31.2780053428317	5615	335	100	0	1	5615	10235	4621	La Jolla virus strain HUNplus6453 putative polyprotein gene, complete cds	blastn	175626	8514	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		La Jolla virus
882173	882173	PRJNA902848_P_NODE_5761_length_353_cov_1.114286_g5711_i0	PRJNA902848	5761	353	1.114286	3.93342958	Cripavirus drosophilae	3047809	Viruses	Viruses	597	3.42e-166	NTclustered	gi\|1743646607\|gb\|MK645238.1\|	64279	g5711	i0	97.167	9.97733711048159	353	10	100	0	1	353	8441	8089	Drosophila C virus isolate CYG, complete genome	blastn	3522	597	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
3432719	3432719	PRJNA902848_P_NODE_2423_length_485_cov_1.776699_g2373_i0	PRJNA902848	2423	485	1.776699	8.61699015	Ripakrox virus	3130763	Viruses	Viruses	300	1.53e-76	NTclustered	gi\|2717320712\|gb\|PP173065.1\|	3130763	g2373	i0	79.464	1.90721649484536	448	72	91	17	11	450	436	1	MAG: Ripakrox virus isolate KCAP3_k141_106909 genomic sequence	blastn	925	300	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripakrox virus
3432810	3432810	PRJNA902848_P_NODE_623_length_803_cov_2.001370_g581_i0	PRJNA902848	623	803	2.00137	16.0710011	Cripavirus drosophilae	3047809	Viruses	Viruses	1423	0	NTclustered	gi\|1743646607\|gb\|MK645238.1\|	64279	g581	i0	98.63	23.2739726027397	803	11	100	0	1	803	5903	6705	Drosophila C virus isolate CYG, complete genome	blastn	18689	1423	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
3432821	3432821	PRJNA902848_P_NODE_6623_length_335_cov_2.469466_g6573_i0	PRJNA902848	6623	335	2.469466	8.2727111	Cripavirus drosophilae	3047809	Viruses	Viruses	597	3.239999999999999e-166	NTclustered	gi\|1743646610\|gb\|MK645239.1\|	64279	g6573	i0	98.806	9.6089552238806	335	4	100	0	1	335	6895	7229	Drosophila C virus isolate EB, complete genome	blastn	3219	597	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
3432898	3432898	PRJNA902848_P_NODE_963_length_679_cov_1.783828_g916_i0	PRJNA902848	963	679	1.783828	12.11219212	La Jolla virus	1654357	Viruses	Viruses	1227	0	NTclustered	gi\|2463635383\|gb\|OP263081.1\|	1654357	g916	i0	99.265	23.2091310751105	680	4	100	1	1	679	13	692	La Jolla virus isolate GBM59 putative polyprotein gene, complete cds	blastn	15759	1227	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		La Jolla virus
3799097	3799097	PRJNA902848_P_NODE_5523_length_358_cov_1.080702_g5473_i0	PRJNA902848	5523	358	1.080702	3.86891316	Crinivirus	67753	Viruses	Viruses	660	0	NTclustered	gi\|2512036304\|gb\|OP976053.1\|	3049511	g5473	i0	100	5.98324022346369	357	0	99	0	2	358	6300	5944	Chieh-qua chlorotic virus isolate pumpkin-DF segment RNA2, complete sequence	blastn	2142	660	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Closteroviridae	Crinivirus	chieh-qua chlorotic virus
5985491	5985491	PRJNA902848_P_NODE_7585_length_318_cov_1.571429_g7535_i0	PRJNA902848	7585	318	1.571429	4.99714422	Cripavirus drosophilae	3047809	Viruses	Viruses	569	6.649999999999998e-158	NTclustered	gi\|1743646610\|gb\|MK645239.1\|	64279	g7535	i0	99.054	9.9685534591195	317	3	99	0	1	317	7446	7762	Drosophila C virus isolate EB, complete genome	blastn	3170	569	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
7260291	7260291	PRJNA902848_P_NODE_8466_length_305_cov_1.344828_g8416_i0	PRJNA902848	8466	305	1.344828	4.1017254	Chrocagosk virus	3129397	Viruses	Viruses	361	4.1599999999999996e-95	NTclustered	gi\|2717317479\|gb\|PP171845.1\|	3129397	g8416	i0	91.603	32.9016393442623	262	20	86	2	1	262	260	1	MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence	blastn	10035	361	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagosk virus
10175579	10175579	PRJNA902848_P_NODE_1908_length_531_cov_0.986900_g1859_i0	PRJNA902848	1908	531	0.9869	5.240439	Maculavirus	249185	Viruses	Viruses	915	0	NTclustered	gi\|612507560\|gb\|KJ433990.1\|	288456	g1859	i0	97.917	3.9774011299435	528	11	99	0	1	528	3923	4450	Bombyx mori Macula-like virus strain SZ, complete genome	blastn	2112	920	0.994565217391304	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae	Maculavirus	Bombyx mori Macula-like virus
11085802	11085802	PRJNA902848_P_NODE_6809_length_332_cov_1.444015_g6759_i0	PRJNA902848	6809	332	1.444015	4.7941298	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	475	1.5699999999999994e-129	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g6759	i0	92.47	1	332	25	100	0	1	332	6028	6359	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	332	475	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
11085829	11085829	PRJNA902848_P_NODE_789_length_733_cov_1.393939_g745_i0	PRJNA902848	789	733	1.393939	10.21757287	Bombyx mori latent virus	2065033	Viruses	Viruses	1243	0	NTclustered	gi\|1464307034\|ref\|NC_038331.1\|	2065033	g745	i0	97.271	4	733	20	100	0	1	733	3094	3826	Bombyx mori latent virus genomic RNA, complete genome	blastn	2932	1243	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae		Bombyx mori latent virus
12360880	12360880	PRJNA902848_P_NODE_1450_length_585_cov_2.134766_g1401_i0	PRJNA902848	1450	585	2.134766	12.4883811	Cripavirus drosophilae	3047809	Viruses	Viruses	1029	0	NTclustered	gi\|1743646607\|gb\|MK645238.1\|	64279	g1401	i0	98.459	11.6820512820513	584	9	99	0	1	584	8448	9031	Drosophila C virus isolate CYG, complete genome	blastn	6834	1029	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
12360987	12360987	PRJNA902848_P_NODE_190_length_1234_cov_1.589147_g165_i0	PRJNA902848	190	1234	1.589147	19.61007398	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	749	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g165	i0	93.137	0.640194489465154	510	35	64	0	81	590	4195	4704	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	790	749	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
13635765	13635765	PRJNA902848_P_NODE_2291_length_494_cov_2.688836_g2241_i0	PRJNA902848	2291	494	2.688836	13.28284984	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	745	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g2241	i0	93.737	1.00202429149798	495	30	100	1	1	494	6832	6338	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	495	745	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
14001031	14001031	PRJNA902848_P_NODE_4431_length_388_cov_1.641270_g4381_i0	PRJNA902848	4431	388	1.64127	6.3681276	Maculavirus	249185	Viruses	Viruses	645	1.3399999999999995e-180	NTclustered	gi\|612507560\|gb\|KJ433990.1\|	288456	g4381	i0	96.649	4.79381443298969	388	13	100	0	1	388	4898	4511	Bombyx mori Macula-like virus strain SZ, complete genome	blastn	1860	651	0.990783410138249	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae	Maculavirus	Bombyx mori Macula-like virus
16184648	16184648	PRJNA902848_P_NODE_11553_length_267_cov_1.871134_g11503_i0	PRJNA902848	11553	267	1.871134	4.99592778	Cripavirus drosophilae	3047809	Viruses	Viruses	477	3.3999999999999993e-130	NTclustered	gi\|1743646610\|gb\|MK645239.1\|	64279	g11503	i0	98.876	7.99250936329588	267	3	100	0	1	267	4680	4414	Drosophila C virus isolate EB, complete genome	blastn	2134	477	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
16184818	16184818	PRJNA902848_P_NODE_19213_length_243_cov_1.188235_g19163_i0	PRJNA902848	19213	243	1.188235	2.88741105	Bombyx mori latent virus	2065033	Viruses	Viruses	422	1.45e-113	NTclustered	gi\|1464307034\|ref\|NC_038331.1\|	2065033	g19163	i0	97.942	4	243	5	100	0	1	243	2837	2595	Bombyx mori latent virus genomic RNA, complete genome	blastn	972	422	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae		Bombyx mori latent virus
22558914	22558914	PRJNA902848_P_NODE_18_length_2456_cov_4.029375_g15_i0	PRJNA902848	18	2456	4.029375	98.96145	La Jolla virus	1654357	Viruses	Viruses	3832	0	NTclustered	gi\|2034669305\|gb\|MW556743.1\|	1654357	g15	i0	94.829	25.8334690553746	2456	127	100	0	1	2456	2218	4673	La Jolla virus putative polyprotein gene, complete cds	blastn	63447	3832	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		La Jolla virus
23834176	23834176	PRJNA902848_P_NODE_199_length_1211_cov_3.463093_g173_i0	PRJNA902848	199	1211	3.463093	41.93805623	Bombyx mori latent virus	2065033	Viruses	Viruses	1879	0	NTclustered	gi\|1464307034\|ref\|NC_038331.1\|	2065033	g173	i0	94.544	5.08257638315442	1228	47	99	2	4	1211	5154	6381	Bombyx mori latent virus genomic RNA, complete genome	blastn	6155	1879	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae		Bombyx mori latent virus
23834373	23834373	PRJNA902848_P_NODE_9859_length_287_cov_1.004673_g9809_i0	PRJNA902848	9859	287	1.004673	2.88341151	Cripavirus drosophilae	3047809	Viruses	Viruses	470	6.18e-128	NTclustered	gi\|1743646607\|gb\|MK645238.1\|	64279	g9809	i0	96.167	8.98954703832753	287	11	100	0	1	287	3660	3946	Drosophila C virus isolate CYG, complete genome	blastn	2580	470	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
24198563	24198563	PRJNA902848_P_NODE_2239_length_499_cov_1.098592_g2189_i0	PRJNA902848	2239	499	1.098592	5.48197408	Crinivirus	67753	Viruses	Viruses	922	0	NTclustered	gi\|2512036304\|gb\|OP976053.1\|	3049511	g2189	i0	100	6	499	0	100	0	1	499	3489	3987	Chieh-qua chlorotic virus isolate pumpkin-DF segment RNA2, complete sequence	blastn	2994	922	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Closteroviridae	Crinivirus	chieh-qua chlorotic virus
25107921	25107921	PRJNA902848_P_NODE_1320_length_603_cov_1.764151_g1271_i0	PRJNA902848	1320	603	1.764151	10.63783053	Bombyx mori Macula-like virus	288456	Viruses	Viruses	880	0	NTclustered	gi\|612507560\|gb\|KJ433990.1\|	288456	g1271	i0	94.7	3.75456053067993	566	30	94	0	37	602	1207	1772	Bombyx mori Macula-like virus strain SZ, complete genome	blastn	2264	880	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae	Maculavirus	Bombyx mori Macula-like virus
25108079	25108079	PRJNA902848_P_NODE_2160_length_506_cov_1.217090_g2111_i0	PRJNA902848	2160	506	1.21709	6.1584754	La Jolla virus	1654357	Viruses	Viruses	582	1.4199999999999996e-161	NTclustered	gi\|822477737\|gb\|KP969764.1\|	1654357	g2111	i0	99.074	42.5691699604743	324	3	64	0	1	324	365	688	La Jolla virus isolate UM01_LaJolla polyprotein gene, partial cds	blastn	21540	582	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		La Jolla 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);;