metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA495391" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA495391" 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
477289	477289	PRJNA495391_S_NODE_70681_length_150_cov_2.165217_g69629_i0	PRJNA495391	70681	150	2.165217	3.2478255	Potexvirus trifolii	3433859	Viruses	Viruses	267	4.009999999999999e-67	NTclustered	gi\|564614830\|gb\|KF421939.1\|	12188	g69629	i0	98.667	33.84	150	2	100	0	1	150	5248	5397	White clover mosaic virus isolate 05TGP00172 putative RNA replicase, putative triple gene block protein 1, putative triple gene block protein 2, putative triple gene block protein 3, and putative coat protein genes, complete cds	blastn	5076	267	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus trifolii
1750855	1750855	PRJNA495391_S_NODE_19642_length_271_cov_1.644068_g18590_i0	PRJNA495391	19642	271	1.644068	4.45542428	Pestivirus bovis	3052619	Viruses	Viruses	451	2.0999999999999997e-122	NTclustered	gi\|380719829\|gb\|JQ071528.1\|	11099	g18590	i0	96.679	99.3579335793358	271	9	100	0	1	271	16	286	Bovine viral diarrhea virus 1 strain GS2 polyprotein gene, partial cds	blastn	26926	451	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
1750900	1750900	PRJNA495391_S_NODE_2142_length_949_cov_11.221007_g1285_i0	PRJNA495391	2142	949	11.221007	106.48735643	Pestivirus brazilense	3052620	Viruses	Viruses	1642	0	NTclustered	gi\|2813517649\|gb\|PQ362002.1\|	381707	g1285	i0	97.803	66.4257112750263	956	13	99	4	2	949	1017	62	Bovine viral diarrhea virus 3 isolate HN2009, partial genome	blastn	63038	1642	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus brazilense
1751225	1751225	PRJNA495391_S_NODE_33102_length_211_cov_3.125000_g32050_i0	PRJNA495391	33102	211	3.125	6.59375	Erysiphe necator associated deltaflexivirus 4	2743097	Viruses	Viruses	390	3.459999999999999e-104	NTclustered	gi\|2288523299\|gb\|ON811606.1\|	2743097	g32050	i0	100	1.51184834123223	211	0	100	0	1	211	6837	7047	MAG: Erysiphe necator associated deltaflexivirus 4 isolate TIGMIC_2, complete genome	blastn	319	390	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Deltaflexiviridae	Deltaflexivirus	Erysiphe necator associated deltaflexivirus 4
1751329	1751329	PRJNA495391_S_NODE_36982_length_201_cov_1.542169_g35930_i0	PRJNA495391	36982	201	1.542169	3.09975969	Pestivirus bovis	3052619	Viruses	Viruses	333	5.569999999999999e-87	NTclustered	gi\|2440740783\|gb\|ON411191.1\|	11099	g35930	i0	96.517	22.9800995024876	201	7	100	0	1	201	9588	9388	Bovine viral diarrhea virus 1 isolate 21NM-44 polyprotein gene, complete cds	blastn	4619	333	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
4303079	4303079	PRJNA495391_S_NODE_30344_length_220_cov_1.875676_g29292_i0	PRJNA495391	30344	220	1.875676	4.1264872	Botourmiaviridae sp.	2808997	Viruses	Viruses	252	1.79e-62	NTclustered	gi\|2320142628\|gb\|ON585088.1\|	2808997	g29292	i0	87.387	1.00909090909091	222	24	100	4	1	220	2430	2211	MAG: Botourmiaviridae sp. isolate PMS2_Contig239 RNA-dependent RNA polymerase gene, complete cds	blastn	222	252	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
6210681	6210681	PRJNA495391_S_NODE_33685_length_210_cov_1.428571_g32633_i0	PRJNA495391	33685	210	1.428571	2.9999991	Botourmiaviridae	2560063	Viruses	Viruses	75	3.93e-9	NTclustered	gi\|2500381378\|ref\|NC_076801.1\|	2686545	g32633	i0	100	5.76190476190476	40	0	19	0	1	40	2325	2286	Plasmopara viticola lesion associated ourmia-like virus 72 isolate DMG-F_43929 RNA dependent RNA polymerase (QKR77_gp1) gene, complete cds	blastn	1210	75	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Scleroulivirus	Scleroulivirus lambdaplasmoparae
6854383	6854383	PRJNA495391_S_NODE_50226_length_174_cov_2.611511_g49174_i0	PRJNA495391	50226	174	2.611511	4.54402914	Xian Totiv tick virus 2	2972358	Viruses	Viruses	283	4.769999999999999e-72	NTclustered	gi\|2320153247\|gb\|ON746556.1\|	2972358	g49174	i0	95.977	1	174	7	100	0	1	174	435	262	MAG: Xian Totiv tick virus 2 isolate TIGMIC 1 genomic sequence	blastn	174	283	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Xian Totiv tick virus 2
8128812	8128812	PRJNA495391_S_NODE_14607_length_313_cov_2.262590_g13555_i0	PRJNA495391	14607	313	2.26259	7.0819067	Jakapalmivirus cinereae	3429993	Viruses	Viruses	484	2.4399999999999998e-132	NTclustered	gi\|1841761922\|gb\|MN619795.1\|	2802527	g13555	i0	94.569	2.96805111821086	313	17	100	0	1	313	638	326	Botrytis cinerea binarnavirus 1 isolate BCI12_DN4441 segment 1, complete sequence	blastn	929	484	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Jakapalmivirus	Jakapalmivirus cinereae
8129835	8129835	PRJNA495391_S_NODE_51747_length_172_cov_1.737226_g50695_i0	PRJNA495391	51747	172	1.737226	2.98802872	Pestivirus bovis	3052619	Viruses	Viruses	278	2.19e-70	NTclustered	gi\|586616531\|gb\|KF896608.1\|	11099	g50695	i0	95.906	95.8662790697674	171	7	99	0	2	172	6754	6924	Bovine viral diarrhea virus 1 isolate Bega-like polyprotein gene, complete cds	blastn	16489	278	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
10679312	10679312	PRJNA495391_S_NODE_11089_length_360_cov_5.092308_g10037_i0	PRJNA495391	11089	360	5.092308	18.3323088	Potexvirus trifolii	3433859	Viruses	Viruses	612	1.2499999999999997e-170	NTclustered	gi\|2054359742\|gb\|MW248353.1\|	12188	g10037	i0	97.486	30.1361111111111	358	9	99	0	3	360	5843	5486	White clover mosaic virus isolate DSMZ PV-0310 replication-associated protein (ORF1), triple gene block 1 protein (ORF2), triple gene block 2 protein (ORF3), triple gene block 3 protein (ORF4), and capsid protein (ORF5) genes, complete cds	blastn	10849	612	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus trifolii
10679912	10679912	PRJNA495391_S_NODE_32829_length_212_cov_2.435028_g31777_i0	PRJNA495391	32829	212	2.435028	5.16225936	Pestivirus bovis	3052619	Viruses	Viruses	331	2.1400000000000006e-86	NTclustered	gi\|2448011657\|gb\|ON624287.1\|	11099	g31777	i0	94.811	97.3349056603774	212	11	100	0	1	212	7146	7357	Bovine viral diarrhea virus 1 isolate 21SD-16 polyprotein gene, complete cds	blastn	20635	331	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
11954891	11954891	PRJNA495391_S_NODE_29170_length_224_cov_1.751323_g28118_i0	PRJNA495391	29170	224	1.751323	3.92296352	Jakapalmivirus cinereae	3429993	Viruses	Viruses	387	4.8e-103	NTclustered	gi\|1841761922\|gb\|MN619795.1\|	2802527	g28118	i0	97.768	3.97321428571429	224	5	100	0	1	224	596	819	Botrytis cinerea binarnavirus 1 isolate BCI12_DN4441 segment 1, complete sequence	blastn	890	387	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Jakapalmivirus	Jakapalmivirus cinereae
15778400	15778400	PRJNA495391_S_NODE_14333_length_316_cov_2.362989_g13281_i0	PRJNA495391	14333	316	2.362989	7.46704524	Pestivirus bovis	3052619	Viruses	Viruses	464	3.2099999999999996e-126	NTclustered	gi\|2449445617\|gb\|OQ348280.1\|	11099	g13281	i0	92.722	61.1170886075949	316	23	100	0	1	316	8405	8720	MAG: Bovine viral diarrhea virus 1 isolate ASRA5 polyprotein gene, partial cds	blastn	19313	464	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
15779824	15779824	PRJNA495391_S_NODE_68173_length_153_cov_1.144068_g67121_i0	PRJNA495391	68173	153	1.144068	1.75042404	Pestivirus bovis	3052619	Viruses	Viruses	241	2.49e-59	NTclustered	gi\|1831805881\|emb\|LR760748.1\|	11099	g67121	i0	95.364	34.8496732026144	151	7	99	0	3	153	1945	1795	Bovine viral diarrhea virus 1 complete genome gene for viral polyprotein	blastn	5332	241	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
17053729	17053729	PRJNA495391_S_NODE_37294_length_200_cov_1.878788_g36242_i0	PRJNA495391	37294	200	1.878788	3.757576	Jakapalmivirus cinereae	3429993	Viruses	Viruses	359	9.14e-95	NTclustered	gi\|1841761922\|gb\|MN619795.1\|	2802527	g36242	i0	99	6.865	200	2	100	0	1	200	1968	1769	Botrytis cinerea binarnavirus 1 isolate BCI12_DN4441 segment 1, complete sequence	blastn	1373	359	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Jakapalmivirus	Jakapalmivirus cinereae
18327845	18327845	PRJNA495391_S_NODE_29595_length_222_cov_2.711230_g28543_i0	PRJNA495391	29595	222	2.71123	6.0189306	Pestivirus bovis	3052619	Viruses	Viruses	313	8.18e-81	NTclustered	gi\|2905035930\|gb\|PQ782224.1\|	11099	g28543	i0	91.964	28.3513513513514	224	16	100	2	1	222	10534	10311	Bovine viral diarrhea virus 1 isolate BVDV-1c-IM-2018, complete genome	blastn	6294	313	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
18328280	18328280	PRJNA495391_S_NODE_46075_length_181_cov_3.095890_g45023_i0	PRJNA495391	46075	181	3.09589	5.6035609	Pestivirus bovis	3052619	Viruses	Viruses	285	1.39e-72	NTclustered	gi\|2429573847\|gb\|ON098979.1\|	11099	g45023	i0	95.028	82.4585635359116	181	9	100	0	1	181	8055	8235	Bovine viral diarrhea virus 1 isolate 21NX-300, complete genome	blastn	14925	285	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
18328722	18328722	PRJNA495391_S_NODE_63495_length_157_cov_2.614754_g62443_i0	PRJNA495391	63495	157	2.614754	4.10516378	Jakapalmivirus cinereae	3429993	Viruses	Viruses	279	5.46e-71	NTclustered	gi\|1841761922\|gb\|MN619795.1\|	2802527	g62443	i0	98.726	3.98726114649682	157	2	100	0	1	157	2234	2078	Botrytis cinerea binarnavirus 1 isolate BCI12_DN4441 segment 1, complete sequence	blastn	626	279	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Jakapalmivirus	Jakapalmivirus cinereae
18958738	18958738	PRJNA495391_S_NODE_25755_length_237_cov_3.069307_g24703_i0	PRJNA495391	25755	237	3.069307	7.27425759	root	1	Root_unresolved	Root_unresolved	383	6.64e-102	NTclustered	gi\|1129880669\|gb\|KX170702.1\|	11099	g24703	i0	95.781	99.4725738396624	237	10	100	0	1	237	850	614	Bovine viral diarrhea virus 1 isolate V008 NS5B gene, partial cds	blastn	23575	383	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
19601684	19601684	PRJNA495391_S_NODE_14536_length_314_cov_1.792115_g13484_i0	PRJNA495391	14536	314	1.792115	5.6272411	Jakapalmivirus cinereae	3429993	Viruses	Viruses	560	3.95e-155	NTclustered	gi\|1841761922\|gb\|MN619795.1\|	2802527	g13484	i0	99.038	1.99363057324841	312	3	99	0	3	314	1602	1291	Botrytis cinerea binarnavirus 1 isolate BCI12_DN4441 segment 1, complete sequence	blastn	626	560	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Jakapalmivirus	Jakapalmivirus cinereae
20233940	20233940	PRJNA495391_S_NODE_53176_length_170_cov_1.696296_g52124_i0	PRJNA495391	53176	170	1.696296	2.8837032	Iflavirus	232799	Viruses	Viruses	315	1.64e-81	NTclustered	gi\|2889516159\|gb\|PP437925.1\|	198112	g52124	i0	100	99.9823529411765	170	0	100	0	1	170	8420	8589	Deformed wing virus isolate HR-HrvatskaKostajnica50_2017_P_G1 genotype DWV-B, complete genome	blastn	16997	315	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Iflavirus aladeformis
20877575	20877575	PRJNA495391_S_NODE_1477_length_1260_cov_4.899592_g713_i0	PRJNA495391	1477	1260	4.899592	61.7348592	Pestivirus bovis	3052619	Viruses	Viruses	1733	0	NTclustered	gi\|2563906172\|gb\|ON732849.1\|	11099	g713	i0	91.515	80.7150793650794	1261	104	100	3	1	1260	10421	9163	Bovine viral diarrhea virus 1 isolate SDJN01, complete genome	blastn	101701	1733	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
20879136	20879136	PRJNA495391_S_NODE_8457_length_416_cov_2.556430_g7406_i0	PRJNA495391	8457	416	2.55643	10.6347488	Pestivirus bovis	3052619	Viruses	Viruses	625	1.8799999999999998e-174	NTclustered	gi\|2563906172\|gb\|ON732849.1\|	11099	g7406	i0	93.75	44.1129807692308	416	26	100	0	1	416	8815	8400	Bovine viral diarrhea virus 1 isolate SDJN01, complete genome	blastn	18351	625	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
22152744	22152744	PRJNA495391_S_NODE_29058_length_224_cov_2.407407_g28006_i0	PRJNA495391	29058	224	2.407407	5.39259168	Iflavirus aladeformis	3047792	Viruses	Viruses	403	4.7699999999999995e-108	NTclustered	gi\|2594802893\|gb\|OR497389.1\|	2498590	g28006	i0	99.107	99.9910714285714	224	2	100	0	1	224	8972	9195	Deformed wing virus B isolate 12-2-C_B DWV polyprotein gene, complete cds	blastn	22398	403	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Iflavirus aladeformis
22152888	22152888	PRJNA495391_S_NODE_34658_length_207_cov_1.761628_g33606_i0	PRJNA495391	34658	207	1.761628	3.64656996	Erysiphe necator associated ourmia-like virus 78	2741858	Viruses	Viruses	344	2.67e-90	NTclustered	gi\|1848976689\|gb\|MN611606.1\|	2741858	g33606	i0	96.618	2.84541062801932	207	7	100	0	1	207	2126	1920	Erysiphe necator associated ourmia-like virus 78 isolate PMS3_72, complete genome	blastn	589	344	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Ourmiavirus	Erysiphe necator associated ourmia-like virus 78
22153846	22153846	PRJNA495391_S_NODE_71138_length_150_cov_1.382609_g70086_i0	PRJNA495391	71138	150	1.382609	2.0739135	Pestivirus bovis	3052619	Viruses	Viruses	265	1.44e-66	NTclustered	gi\|2905035930\|gb\|PQ782224.1\|	11099	g70086	i0	98.658	23.98	149	2	99	0	1	149	8664	8812	Bovine viral diarrhea virus 1 isolate BVDV-1c-IM-2018, complete genome	blastn	3597	265	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
23428475	23428475	PRJNA495391_S_NODE_25559_length_238_cov_2.650246_g24507_i0	PRJNA495391	25559	238	2.650246	6.30758548	Pestivirus bovis	3052619	Viruses	Viruses	348	2.4300000000000005e-91	NTclustered	gi\|1831805881\|emb\|LR760748.1\|	11099	g24507	i0	92.917	51.6554621848739	240	15	100	1	1	238	7982	7743	Bovine viral diarrhea virus 1 complete genome gene for viral polyprotein	blastn	12294	348	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
23429602	23429602	PRJNA495391_S_NODE_68039_length_153_cov_1.338983_g66987_i0	PRJNA495391	68039	153	1.338983	2.04864399	Pestivirus brazilense	3052620	Viruses	Viruses	272	8.84e-69	NTclustered	gi\|2813517655\|gb\|PQ362005.1\|	381707	g66987	i0	98.693	29.9738562091503	153	2	100	0	1	153	9630	9782	Bovine viral diarrhea virus 3 isolate HN2247, partial genome	blastn	4586	272	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus brazilense

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