metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA911178" 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
2166613	2166613	PRJNA911178_P_NODE_105042_length_354_cov_1.128114_g102570_i0	PRJNA911178	105042	354	1.128114	3.99352356	Malassezia restricta associated totivirus 2	3048758	Viruses	Viruses	501	2.77e-137	NTclustered	gi\|2512878154\|emb\|OX637980.1\|	3048758	g102570	i0	93.023	1.7316384180791	344	22	97	2	12	354	808	466	Malassezia restricta associated totivirus 2 CP gene for capsid protein	blastn	613	501	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia restricta associated totivirus 2
3443795	3443795	PRJNA911178_P_NODE_303003_length_230_cov_2.197452_g300529_i0	PRJNA911178	303003	230	2.197452	5.0541396	Polerovirus CABYV	3431733	Viruses	Viruses	403	4.92e-108	NTclustered	gi\|388325686\|gb\|JF939813.1\|	91753	g300529	i0	99.548	93.6913043478261	221	1	96	0	1	221	3161	2941	Cucurbit aphid-borne yellows virus strain Sq/2005/9.2, complete genome	blastn	21549	403	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Sobelivirales	Solemoviridae	Polerovirus	Polerovirus CABYV
4720749	4720749	PRJNA911178_P_NODE_214104_length_264_cov_1.492147_g211630_i0	PRJNA911178	214104	264	1.492147	3.93926808	Polerovirus CABYV	3431733	Viruses	Viruses	466	7.27e-127	NTclustered	gi\|388325686\|gb\|JF939813.1\|	91753	g211630	i0	99.225	75.9242424242424	258	2	98	0	7	264	4279	4536	Cucurbit aphid-borne yellows virus strain Sq/2005/9.2, complete genome	blastn	20044	466	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Sobelivirales	Solemoviridae	Polerovirus	Polerovirus CABYV
5996771	5996771	PRJNA911178_P_NODE_83005_length_391_cov_1.113208_g80538_i0	PRJNA911178	83005	391	1.113208	4.35264328	Tobamovirus fructirugosum	3432872	Viruses	Viruses	706	0	NTclustered	gi\|2589097587\|gb\|OR500699.1\|	1761477	g80538	i0	99.233	100	391	3	100	0	1	391	3665	3275	Tomato brown rugose fruit virus isolate Zhangjiakou, complete genome	blastn	39100	706	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus fructirugosum
6353957	6353957	PRJNA911178_P_NODE_201565_length_271_cov_1.282828_g199091_i0	PRJNA911178	201565	271	1.282828	3.47646388	Tobamovirus	12234	Viruses	Viruses	486	5.7499999999999985e-133	NTclustered	gi\|1559989139\|gb\|MK273185.1\|	1761477	g199091	i0	100	97.0479704797048	263	0	97	0	3	265	752	490	Tomato brown rugose fruit virus isolate TAN3 RNA-dependent RNA polymerase (RdRp) gene, partial cds	blastn	26300	486	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus fructirugosum
7269900	7269900	PRJNA911178_P_NODE_153646_length_301_cov_451.934211_g151173_i0	PRJNA911178	153646	301	451.934211	1360.32197511	Qianjiang marna-like virus 21	3347640	Viruses	Viruses	350	8.87e-92	NTclustered	gi\|2806503321\|gb\|PQ055080.1\|	3347640	g151173	i0	89.531	28.9800664451827	277	28	92	1	15	291	636	361	MAG: Qianjiang marna-like virus 21 isolate QJ5MS697 genomic sequence	blastn	8723	350	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Qianjiang marna-like virus 21
8544808	8544808	PRJNA911178_P_NODE_175467_length_285_cov_21.924528_g172994_i0	PRJNA911178	175467	285	21.924528	62.4849048	Chrocagost virus	3129398	Viruses	Viruses	302	2.37e-77	NTclustered	gi\|2717317482\|gb\|PP171846.1\|	3129398	g172994	i0	87.405	318.571929824561	262	33	92	0	19	280	5862	5601	MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence	blastn	90793	302	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagost virus
8545419	8545419	PRJNA911178_P_NODE_246367_length_250_cov_0.870056_g243893_i0	PRJNA911178	246367	250	0.870056	2.17514	Malassezia restricta virus MrV40S	2727864	Viruses	Viruses	357	4.28e-94	NTclustered	gi\|1832308146\|gb\|MN603498.1\|	2727864	g243893	i0	92.771	0.996	249	14	98	3	5	249	575	823	Malassezia restricta virus MrV40S, complete genome	blastn	249	357	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40S
8545508	8545508	PRJNA911178_P_NODE_255967_length_248_cov_0.880000_g253493_i0	PRJNA911178	255967	248	0.88	2.1824	Ripakrox virus	3130763	Viruses	Viruses	237	5.77e-58	NTclustered	gi\|2717320712\|gb\|PP173065.1\|	3130763	g253493	i0	85.714	1.97177419354839	231	26	91	6	15	240	417	189	MAG: Ripakrox virus isolate KCAP3_k141_106909 genomic sequence	blastn	489	237	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripakrox virus
9819789	9819789	PRJNA911178_P_NODE_173948_length_286_cov_2.868545_g171475_i0	PRJNA911178	173948	286	2.868545	8.2040387	Ripaglys virus	3130696	Viruses	Viruses	211	4.12e-50	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g171475	i0	85.93	287.968531468531	199	26	70	2	87	285	2694	2498	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	82359	211	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
9820532	9820532	PRJNA911178_P_NODE_261668_length_247_cov_0.885057_g259194_i0	PRJNA911178	261668	247	0.885057	2.18609079	Potyvirus plumpoxi	3240600	Viruses	Viruses	448	2.4399999999999993e-121	NTclustered	gi\|294313\|gb\|M92280.1\|PPVPOLPRO	12211	g259194	i0	99.592	99.1902834008097	245	1	99	0	3	247	7503	7747	Plum pox virus strain M isolate SK 68, complete genome	blastn	24500	448	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus plumpoxi
9820612	9820612	PRJNA911178_P_NODE_271548_length_245_cov_0.895349_g269074_i0	PRJNA911178	271548	245	0.895349	2.19360505	Chemarfal virus 260	3063286	Viruses	Viruses	422	1.46e-113	NTclustered	gi\|2626079958\|gb\|OR270550.1\|	3063286	g269074	i0	99.145	0.955102040816327	234	2	96	0	1	234	493	726	MAG: Chemarfal virus 260 isolate ML188 genomic sequence	blastn	234	422	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 260
11094866	11094866	PRJNA911178_P_NODE_107069_length_351_cov_1.507194_g104597_i0	PRJNA911178	107069	351	1.507194	5.29025094	Ripasluq virus	3131229	Viruses	Viruses	316	1.0699999999999999e-81	NTclustered	gi\|2717321969\|gb\|PP173531.1\|	3131229	g104597	i0	93.427	293.435897435897	213	14	61	0	139	351	2903	3115	MAG: Ripasluq virus isolate MP3_k141_106077 genomic sequence	blastn	102996	316	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripasluq virus
11096422	11096422	PRJNA911178_P_NODE_296529_length_239_cov_2.331325_g294055_i0	PRJNA911178	296529	239	2.331325	5.57186675	Ripasluq virus	3131229	Viruses	Viruses	213	9.31e-51	NTclustered	gi\|2717321969\|gb\|PP173531.1\|	3131229	g294055	i0	87.912	91.1548117154812	182	20	76	1	58	239	2903	3082	MAG: Ripasluq virus isolate MP3_k141_106077 genomic sequence	blastn	21786	213	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripasluq virus
11097121	11097121	PRJNA911178_P_NODE_94409_length_370_cov_1.882155_g91939_i0	PRJNA911178	94409	370	1.882155	6.9639735	Ripakrox virus	3130763	Viruses	Viruses	359	1.85e-94	NTclustered	gi\|2717320712\|gb\|PP173065.1\|	3130763	g91939	i0	85.673	0.943243243243243	349	41	94	9	1	346	343	1	MAG: Ripakrox virus isolate KCAP3_k141_106909 genomic sequence	blastn	349	359	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripakrox virus
13647283	13647283	PRJNA911178_P_NODE_97711_length_365_cov_1.054795_g95241_i0	PRJNA911178	97711	365	1.054795	3.85000175	Penoulivirus zetaplasmoparae	2956297	Viruses	Viruses	180	1.52e-40	NTclustered	gi\|2500381432\|ref\|NC_076816.1\|	2686562	g95241	i0	92.126	1.56438356164384	127	10	35	0	10	136	1	127	Plasmopara viticola lesion associated ourmia-like virus 88 isolate DMS8_23510 RNA dependent RNA polymerase (QKR92_gp1) gene, complete cds	blastn	571	180	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Penoulivirus	Penoulivirus zetaplasmoparae
14919315	14919315	PRJNA911178_P_NODE_119272_length_336_cov_0.946768_g116800_i0	PRJNA911178	119272	336	0.946768	3.18114048	Ripakrox virus	3130763	Viruses	Viruses	322	2.19e-83	NTclustered	gi\|2717320712\|gb\|PP173065.1\|	3130763	g116800	i0	89.231	1.5952380952381	260	25	77	3	79	336	1	259	MAG: Ripakrox virus isolate KCAP3_k141_106909 genomic sequence	blastn	536	322	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripakrox virus
15278746	15278746	PRJNA911178_P_NODE_89812_length_378_cov_1.396721_g87342_i0	PRJNA911178	89812	378	1.396721	5.27960538	Mamastrovirus	249588	Viruses	Viruses	52.8	0.036	NTclustered	gi\|2618184178\|gb\|OR711901.1\|	1914442	g87342	i0	100	0.148148148148148	28	0	7	0	115	142	4050	4023	Rodent astrovirus strain CHN/YN/KM-5/2022, complete genome	blastn	56	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae	Mamastrovirus	Rodent astrovirus
17471607	17471607	PRJNA911178_P_NODE_67694_length_427_cov_3.333333_g65234_i0	PRJNA911178	67694	427	3.333333	14.23333191	Alternaria botybirnavirus 2	3081987	Viruses	Viruses	285	3.73e-72	NTclustered	gi\|2594582617\|gb\|OR584149.1\|	3081987	g65234	i0	83.23	4.11709601873536	322	43	74	11	112	426	86	403	Alternaria botybirnavirus 2 strain XC21-21C segment RNA1, complete sequence	blastn	1758	285	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Botybirnaviridae	Botybirnavirus	Alternaria botybirnavirus 2
18744277	18744277	PRJNA911178_P_NODE_274955_length_244_cov_1.672515_g272481_i0	PRJNA911178	274955	244	1.672515	4.0809366	Chemarfal virus 260	3063286	Viruses	Viruses	412	8.759999999999998e-111	NTclustered	gi\|2626079958\|gb\|OR270550.1\|	3063286	g272481	i0	98.707	0.950819672131147	232	3	95	0	10	241	325	94	MAG: Chemarfal virus 260 isolate ML188 genomic sequence	blastn	232	412	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 260
22568426	22568426	PRJNA911178_P_NODE_108818_length_349_cov_1.068841_g106346_i0	PRJNA911178	108818	349	1.068841	3.73025509	Locarnavirus sp.	2809529	Viruses	Viruses	145	5.2899999999999995e-30	NTclustered	gi\|2196309124\|gb\|MZ679257.1\|	2809529	g106346	i0	93	0.286532951289398	100	5	28	2	54	152	9101	9003	MAG: Locarnavirus sp. isolate s79-k141_884721 RNA-dependent RNA polymerase and structural polyprotein genes, complete cds	blastn	100	145	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Locarnavirus	Locarnavirus sp.
22568838	22568838	PRJNA911178_P_NODE_155698_length_300_cov_1.303965_g153225_i0	PRJNA911178	155698	300	1.303965	3.911895	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	296	1.17e-75	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g153225	i0	84.932	0.973333333333333	292	44	97	0	2	293	575	866	Malassezia restricta virus MrV40L, complete genome	blastn	292	296	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
22569601	22569601	PRJNA911178_P_NODE_252998_length_249_cov_0.875000_g250524_i0	PRJNA911178	252998	249	0.875	2.17875	Totiviridae sp.	1955172	Viruses	Viruses	198	2.74e-46	NTclustered	gi\|2396038768\|gb\|ON812661.1\|	1955172	g250524	i0	81.481	3.14056224899598	243	43	97	2	8	249	4212	4453	MAG: Totiviridae sp. isolate TIGMIC_4, complete genome	blastn	782	198	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
23845077	23845077	PRJNA911178_P_NODE_287839_length_242_cov_0.911243_g285365_i0	PRJNA911178	287839	242	0.911243	2.20520806	Chemarfal virus 258	3063149	Viruses	Viruses	403	5.22e-108	NTclustered	gi\|2626079799\|gb\|OR270470.1\|	3063149	g285365	i0	97.071	0.987603305785124	239	7	99	0	1	239	1496	1734	MAG: Chemarfal virus 258 isolate ML188 genomic sequence	blastn	239	403	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 258
25117814	25117814	PRJNA911178_P_NODE_159720_length_296_cov_2.443946_g157247_i0	PRJNA911178	159720	296	2.443946	7.23408016	Malassezia restricta associated totivirus 2	3048758	Viruses	Viruses	514	2.92e-141	NTclustered	gi\|2512878154\|emb\|OX637980.1\|	3048758	g157247	i0	99.296	1.06418918918919	284	2	96	0	12	295	287	570	Malassezia restricta associated totivirus 2 CP gene for capsid protein	blastn	315	514	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia restricta associated totivirus 2
25118173	25118173	PRJNA911178_P_NODE_198580_length_272_cov_2.477387_g196107_i0	PRJNA911178	198580	272	2.477387	6.73849264	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	272	1.7599999999999996e-68	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g196107	i0	85.283	0.974264705882353	265	37	97	2	6	269	4000	4263	Malassezia restricta virus MrV40L, complete genome	blastn	265	272	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
25118370	25118370	PRJNA911178_P_NODE_221820_length_260_cov_1.502674_g219346_i0	PRJNA911178	221820	260	1.502674	3.9069524	Potyvirus plumpoxi	3240600	Viruses	Viruses	472	1.53e-128	NTclustered	gi\|2235068481\|gb\|MW415764.1\|	12211	g219346	i0	100	98.0538461538462	255	0	98	0	6	260	1651	1905	Plum pox virus strain Marcus isolate BrMrPc10 polyprotein gene, complete cds	blastn	25494	472	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus plumpoxi
25118654	25118654	PRJNA911178_P_NODE_253840_length_248_cov_2.080000_g251366_i0	PRJNA911178	253840	248	2.08	5.1584	Polerovirus CABYV	3431733	Viruses	Viruses	435	1.91e-117	NTclustered	gi\|388325686\|gb\|JF939813.1\|	91753	g251366	i0	98.77	48.2338709677419	244	3	98	0	1	244	1375	1132	Cucurbit aphid-borne yellows virus strain Sq/2005/9.2, complete genome	blastn	11962	435	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Sobelivirales	Solemoviridae	Polerovirus	Polerovirus CABYV

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