metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA429937" 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
425900	425900	PRJNA429937_P_NODE_13761_length_987_cov_5.175365_g8136_i0	PRJNA429937	13761	987	5.175365	51.08085255	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	1694	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g8136	i0	97.186	1.49138804457953	995	20	100	2	1	987	2677	3671	Malassezia restricta virus MrV40L, complete genome	blastn	1472	1694	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
427264	427264	PRJNA429937_P_NODE_7001_length_1330_cov_7.739431_g4121_i0	PRJNA429937	7001	1330	7.739431	102.9344323	Soybean thrips picorna-like virus 7	2800859	Viruses	Viruses	2152	0	NTclustered	gi\|1956563416\|gb\|MT293128.1\|	2800859	g4121	i0	99.494	2.75488721804511	1185	3	89	3	125	1308	8960	7778	Soybean thrips picorna-like virus 7 strain STN1 polyprotein (STPLV7_gp1) gene, complete cds	blastn	3664	2152	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Soybean thrips picorna-like virus 7
1702591	1702591	PRJNA429937_P_NODE_97702_length_309_cov_3.164286_g75096_i0	PRJNA429937	97702	309	3.164286	9.77764374	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.029	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g75096	i0	100	0.0906148867313916	28	0	9	0	1	28	16	43	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
2362820	2362820	PRJNA429937_P_NODE_146602_length_194_cov_1.539394_g123975_i0	PRJNA429937	146602	194	1.539394	2.98642436	root	1	Root_unresolved	Root_unresolved	215	2.02e-51	NTclustered	gi\|2067732485\|gb\|MT994243.1\|	11250	g123975	i0	100	103.438144329897	116	0	100	0	1	116	2880	2995	Mutant Human orthopneumovirus isolate recombinant hRSV-P-BFP, complete genome	blastn	20067	215	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Pneumoviridae	Orthopneumovirus	Orthopneumovirus hominis
2976841	2976841	PRJNA429937_P_NODE_19023_length_843_cov_3.094595_g11234_i0	PRJNA429937	19023	843	3.094595	26.08743585	Coltivirus dermacentoris	3428066	Viruses	Viruses	532	2.49e-146	NTclustered	gi\|2758887253\|gb\|PP473574.1\|	46839	g11234	i0	92.328	49.8386714116251	378	24	81	4	147	522	5357	4983	MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence	blastn	42014	532	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Coltivirus	Coltivirus dermacentoris
2977383	2977383	PRJNA429937_P_NODE_4163_length_1640_cov_9.869025_g2458_i0	PRJNA429937	4163	1640	9.869025	161.85201	Penoulivirus alphaerysiphe	3060537	Viruses	Viruses	1118	0	NTclustered	gi\|1848976575\|gb\|MN611549.1\|	2741801	g2458	i0	86.273	2.0969512195122	1049	120	98	15	1	1046	1621	594	Erysiphe necator associated ourmia-like virus 21 isolate PMS10_36, complete genome	blastn	3439	1118	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Penoulivirus	Penoulivirus alphaerysiphe
4253031	4253031	PRJNA429937_P_NODE_153664_length_168_cov_3.215827_g131037_i0	PRJNA429937	153664	168	3.215827	5.40258936	Ripasluj virus	3131271	Viruses	Viruses	154	3.76e-33	NTclustered	gi\|2717322074\|gb\|PP173573.1\|	3131271	g131037	i0	84.049	2.97619047619048	163	22	97	4	6	168	224	66	MAG: Ripasluj virus isolate MP3_k141_176986 genomic sequence	blastn	500	154	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Ripasluj virus
4253458	4253458	PRJNA429937_P_NODE_3104_length_1824_cov_8.448468_g1838_i0	PRJNA429937	3104	1824	8.448468	154.10005632	Botourmiaviridae sp.	2808997	Viruses	Viruses	1670	0	NTclustered	gi\|2320142624\|gb\|ON585086.1\|	2808997	g1838	i0	83.647	9.23684210526316	1804	265	98	26	35	1824	140	1927	MAG: Botourmiaviridae sp. isolate PMS1_Contig50 RNA-dependent RNA polymerase gene, complete cds	blastn	16848	1670	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
5529758	5529758	PRJNA429937_P_NODE_155405_length_162_cov_1.924812_g132778_i0	PRJNA429937	155405	162	1.924812	3.11819544	Cripavirus drosophilae	3047809	Viruses	Viruses	165	1.66e-36	NTclustered	gi\|2322367289\|gb\|OK188767.1\|	64279	g132778	i0	97.895	8.25308641975309	95	2	100	0	1	95	4682	4588	Drosophila C virus isolate SMN, complete genome	blastn	1337	165	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
5530172	5530172	PRJNA429937_P_NODE_3105_length_1824_cov_8.408357_g1838_i1	PRJNA429937	3105	1824	8.408357	153.36843168	Botourmiaviridae sp.	2808997	Viruses	Viruses	1664	0	NTclustered	gi\|2320142624\|gb\|ON585086.1\|	2808997	g1838	i1	83.592	9.23684210526316	1804	266	98	26	35	1824	140	1927	MAG: Botourmiaviridae sp. isolate PMS1_Contig50 RNA-dependent RNA polymerase gene, complete cds	blastn	16848	1664	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
5530426	5530426	PRJNA429937_P_NODE_43305_length_545_cov_2.812016_g27656_i0	PRJNA429937	43305	545	2.812016	15.3254872	Coltivirus dermacentoris	3428066	Viruses	Viruses	448	5.85e-121	NTclustered	gi\|2758887253\|gb\|PP473574.1\|	46839	g27656	i0	92.857	46.051376146789	308	22	69	0	169	476	4559	4866	MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence	blastn	25098	448	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Coltivirus	Coltivirus dermacentoris
6804377	6804377	PRJNA429937_P_NODE_39406_length_574_cov_16.820183_g24846_i0	PRJNA429937	39406	574	16.820183	96.54785042	Chrocaturd virus	3129638	Viruses	Viruses	603	1.2499999999999999e-167	NTclustered	gi\|2717318092\|gb\|PP172086.1\|	3129638	g24846	i0	88.583	55.3466898954704	508	43	87	13	23	524	3405	2907	MAG: Chrocaturd virus isolate CC1C_k141_57646 genomic sequence	blastn	31769	603	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocaturd virus
7465424	7465424	PRJNA429937_P_NODE_152946_length_171_cov_2.084507_g130319_i0	PRJNA429937	152946	171	2.084507	3.56450697	root	1	Root_unresolved	Root_unresolved	252	1.32e-62	NTclustered	gi\|2575892337\|gb\|OR233204.1\|	112229	g130319	i0	92.778	21.280701754386	180	3	100	7	1	171	6389	6211	Pepino mosaic virus isolate DSMZ PV-0975, complete genome	blastn	3639	252	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus pepini
8079256	8079256	PRJNA429937_P_NODE_144907_length_197_cov_3.130952_g122280_i0	PRJNA429937	144907	197	3.130952	6.16797544	Cripavirus drosophilae	3047809	Viruses	Viruses	348	1.94e-91	NTclustered	gi\|2322367289\|gb\|OK188767.1\|	64279	g122280	i0	98.477	8.9746192893401	197	3	100	0	1	197	3648	3844	Drosophila C virus isolate SMN, complete genome	blastn	1768	348	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
9354075	9354075	PRJNA429937_P_NODE_145508_length_196_cov_2.520958_g122881_i0	PRJNA429937	145508	196	2.520958	4.94107768	Sopamon virus	3131721	Viruses	Viruses	291	3.3e-74	NTclustered	gi\|2717323235\|gb\|PP174022.1\|	3131721	g122881	i0	93.814	50.3010204081633	194	10	98	2	4	196	220	412	MAG: Sopamon virus isolate SP1B_k141_91399 genomic sequence	blastn	9859	291	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Sopamon virus
9354254	9354254	PRJNA429937_P_NODE_17568_length_878_cov_3.030624_g10403_i0	PRJNA429937	17568	878	3.030624	26.60887872	Coltivirus dermacentoris	3428066	Viruses	Viruses	534	7.21e-147	NTclustered	gi\|2758887253\|gb\|PP473574.1\|	46839	g10403	i0	92.348	47.8530751708428	379	24	78	4	322	698	4983	5358	MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence	blastn	42015	534	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Coltivirus	Coltivirus dermacentoris
9354823	9354823	PRJNA429937_P_NODE_40388_length_566_cov_27.234637_g25563_i0	PRJNA429937	40388	566	27.234637	154.14804542	Chrocaturd virus	3129638	Viruses	Viruses	564	5.8e-156	NTclustered	gi\|2717318092\|gb\|PP172086.1\|	3129638	g25563	i0	87.084	33.1201413427562	511	50	90	14	38	544	2907	3405	MAG: Chrocaturd virus isolate CC1C_k141_57646 genomic sequence	blastn	18746	564	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocaturd virus
10630677	10630677	PRJNA429937_P_NODE_46209_length_525_cov_2.852823_g29824_i0	PRJNA429937	46209	525	2.852823	14.97732075	Coltivirus dermacentoris	3428066	Viruses	Viruses	453	1.21e-122	NTclustered	gi\|2758887253\|gb\|PP473574.1\|	46839	g29824	i0	93.182	47.7904761904762	308	21	59	0	50	357	4866	4559	MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence	blastn	25090	453	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Coltivirus	Coltivirus dermacentoris
10631001	10631001	PRJNA429937_P_NODE_63089_length_432_cov_6.910670_g42782_i0	PRJNA429937	63089	432	6.91067	29.8540944	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	54.7	0.012	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g42782	i0	100	0.0671296296296296	29	0	7	0	404	432	87	59	Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds	blastn	29	54.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Dolerus tritici iflavirus 1
10631460	10631460	PRJNA429937_P_NODE_90149_length_333_cov_2.325658_g67574_i0	PRJNA429937	90149	333	2.325658	7.74444114	Cripavirus drosophilae	3047809	Viruses	Viruses	496	1.21e-135	NTclustered	gi\|2322367289\|gb\|OK188767.1\|	64279	g67574	i0	99.631	12.4894894894895	271	1	100	0	63	333	6023	6293	Drosophila C virus isolate SMN, complete genome	blastn	4159	496	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
11906388	11906388	PRJNA429937_P_NODE_92430_length_325_cov_4.141892_g69844_i0	PRJNA429937	92430	325	4.141892	13.461149	Porcine bastrovirus	2588662	Viruses	Viruses	52.8	0.031	NTclustered	gi\|1682068313\|gb\|MK387176.1\|	2588662	g69844	i0	100	0.0861538461538462	28	0	9	0	1	28	15	42	Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Porcine bastrovirus
14454423	14454423	PRJNA429937_P_NODE_103312_length_293_cov_1.121212_g80697_i0	PRJNA429937	103312	293	1.121212	3.28515116	Cripavirus drosophilae	3047809	Viruses	Viruses	191	5.52e-44	NTclustered	gi\|2714662726\|gb\|OR820583.1\|	64279	g80697	i0	99.057	5.35153583617747	106	1	67	0	1	106	8172	8277	Drosophila C virus isolate Davidson2006, complete genome	blastn	1568	191	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
14455978	14455978	PRJNA429937_P_NODE_61252_length_441_cov_3.536408_g41303_i0	PRJNA429937	61252	441	3.536408	15.59555928	Cripavirus drosophilae	3047809	Viruses	Viruses	765	0	NTclustered	gi\|2322367289\|gb\|OK188767.1\|	64279	g41303	i0	97.959	12.2199546485261	441	9	100	0	1	441	5445	5885	Drosophila C virus isolate SMN, complete genome	blastn	5389	765	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
15728625	15728625	PRJNA429937_P_NODE_148833_length_187_cov_2.025316_g126206_i0	PRJNA429937	148833	187	2.025316	3.78734092	Cripavirus drosophilae	3047809	Viruses	Viruses	268	1.46e-67	NTclustered	gi\|1743646610\|gb\|MK645239.1\|	64279	g126206	i0	91.96	9.57754010695187	199	4	100	1	1	187	7747	7945	Drosophila C virus isolate EB, complete genome	blastn	1791	268	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
18278760	18278760	PRJNA429937_P_NODE_63755_length_429_cov_7.600000_g43316_i0	PRJNA429937	63755	429	7.6	32.604	Varroa picorna-like virus	2873563	Viruses	Viruses	486	9.569999999999999e-133	NTclustered	gi\|2111829811\|gb\|MZ822077.1\|	2873563	g43316	i0	91.977	1.38228438228438	349	25	81	3	63	408	7924	7576	MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome	blastn	593	486	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Varroa picorna-like virus
19553382	19553382	PRJNA429937_P_NODE_8336_length_1235_cov_3.791045_g4913_i0	PRJNA429937	8336	1235	3.791045	46.81940575	Bromovirus BMV	3427622	Viruses	Viruses	2049	0	NTclustered	gi\|2329659867\|gb\|OK558647.1\|	12302	g4913	i0	98.038	38.4453441295547	1172	16	98	2	7	1171	2339	1168	Brome mosaic virus isolate Portage- MB strain hypothetical protein gene, complete cds	blastn	47480	2049	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Bromovirus	Bromovirus BMV
20829327	20829327	PRJNA429937_P_NODE_9437_length_1171_cov_16.560420_g5551_i0	PRJNA429937	9437	1171	16.56042	193.9225182	Totivirus ichi	3432942	Viruses	Viruses	2063	0	NTclustered	gi\|558066\|gb\|J04692.1\|SCSCOATRNA	11008	g5551	i0	98.877	2.9666951323655	1158	9	99	4	1	1156	1470	315	Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds	blastn	3474	2063	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus ichi
22102954	22102954	PRJNA429937_P_NODE_27558_length_697_cov_3.305389_g16590_i0	PRJNA429937	27558	697	3.305389	23.03856133	Coltivirus dermacentoris	3428066	Viruses	Viruses	538	4.3799999999999986e-148	NTclustered	gi\|2758887253\|gb\|PP473574.1\|	46839	g16590	i0	92.593	60.7919655667145	378	23	98	4	322	697	4983	5357	MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence	blastn	42372	538	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Coltivirus	Coltivirus dermacentoris
22103849	22103849	PRJNA429937_P_NODE_72058_length_395_cov_2.207650_g50274_i0	PRJNA429937	72058	395	2.20765	8.7202175	Potexvirus trifolii	3433859	Viruses	Viruses	298	4.4e-76	NTclustered	gi\|1078555000\|dbj\|LC190455.1\|	12188	g50274	i0	93.909	11.2759493670886	197	12	87	0	47	243	274	470	White clover mosaic virus CP gene for coat protein, complete cds, isolate: Namwon	blastn	4454	298	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus trifolii
23378643	23378643	PRJNA429937_P_NODE_33699_length_625_cov_2.860738_g20783_i0	PRJNA429937	33699	625	2.860738	17.8796125	Cripavirus drosophilae	3047809	Viruses	Viruses	987	0	NTclustered	gi\|2322367289\|gb\|OK188767.1\|	64279	g20783	i0	94.488	9.1456	635	24	100	3	1	625	4281	3648	Drosophila C virus isolate SMN, complete genome	blastn	5716	987	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae

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