metadata: contig_metadata: 27 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax

27 rows where analysis = "diamond", bioproject = "PRJNA1240804" 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
5452026	5452026	PRJNA1240804_P_NODE_5525_length_518_cov_2.036247_g5168_i0	PRJNA1240804	5525	518	2.036247	10.54775946	Erysiphe necator associated narnavirus 17	2736374	Viruses	Viruses	186	7.859999999999999e-52	NR	QJT93749.1	2736374	g5168	i0	57	0.955598455598456	165	68	93.8	2	28	513	1	165	QJT93749.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 17]	diamond	495	186	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Erysiphe necator associated narnavirus 17
8001790	8001790	PRJNA1240804_P_NODE_52527_length_215_cov_1.409639_g52161_i0	PRJNA1240804	52527	215	1.409639	3.03072385	Sanya narnavirus 8	2905320	Viruses	Viruses	106	8.04e-25	NR	UHR49711.1	2905320	g52161	i0	72.7	0.92093023255814	66	18	92.1	0	16	213	477	542	UHR49711.1 MAG: RNA-dependent RNA polymerase, partial [Sanya narnavirus 8]	diamond	198	106	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Sanya narnavirus 8
22024807	22024807	PRJNA1240804_P_NODE_32818_length_257_cov_0.884615_g32452_i0	PRJNA1240804	32818	257	0.884615	2.27346055	Sanya narnavirus 8	2905320	Viruses	Viruses	131	2.65e-33	NR	UHR49711.1	2905320	g32452	i0	75.6	2.82490272373541	78	19	91.1	0	5	238	344	421	UHR49711.1 MAG: RNA-dependent RNA polymerase, partial [Sanya narnavirus 8]	diamond	726	131	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Sanya narnavirus 8
26756810	26756810	PRJNA1240804_P_NODE_27241_length_276_cov_1.854626_g26875_i0	PRJNA1240804	27241	276	1.854626	5.11876776	Erysiphe necator associated narnavirus 17	2736374	Viruses	Viruses	79	1.01e-14	NR	QJT93749.1	2736374	g26875	i0	54.4	0.858695652173913	79	35	85.9	1	263	27	432	509	QJT93749.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 17]	diamond	237	79	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Erysiphe necator associated narnavirus 17
26978616	26978616	PRJNA1240804_P_NODE_99302_length_174_cov_1.136000_g98936_i0	PRJNA1240804	99302	174	1.136	1.97664	Malassezia globosa associated totivirus 1	3048756	Viruses	Viruses	127	3.0299999999999996e-32	NR	CAI9858973.1	3048756	g98936	i0	98.2	0.982758620689655	57	1	98.3	0	3	173	343	399	CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1]	diamond	171	127	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia globosa associated totivirus 1
27010151	27010151	PRJNA1240804_P_NODE_7322_length_462_cov_4.292978_g6961_i0	PRJNA1240804	7322	462	4.292978	19.83355836	Erysiphe necator associated narnavirus 17	2736374	Viruses	Viruses	164	4.22e-44	NR	QJT93749.1	2736374	g6961	i0	53.7	0.954545454545455	147	68	95.5	0	17	457	527	673	QJT93749.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 17]	diamond	441	164	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Erysiphe necator associated narnavirus 17
27041924	27041924	PRJNA1240804_P_NODE_44962_length_227_cov_2.443820_g44596_i0	PRJNA1240804	44962	227	2.44382	5.5474714	Ripabrum virus	3130326	Viruses	Viruses	70.1	1.75e-12	NR	WZH59433.1	3130326	g44596	i0	59.5	0.977973568281938	74	24	91.2	3	208	2	27	99	WZH59433.1 MAG: RNA-dependent RNA polymerase, partial [Ripabrum virus]	diamond	222	70.1	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Ripabrum virus
27768680	27768680	PRJNA1240804_P_NODE_137344_length_164_cov_0.904348_g136978_i0	PRJNA1240804	137344	164	0.904348	1.48313072	Yellow silver pine associated narna-like virus 48	3067107	Viruses	Viruses	51.6	9.5e-6	NR	WPR17317.1	3067107	g136978	i0	48.9	3.4390243902439	47	24	86	0	142	2	299	345	WPR17317.1 MAG: RNA-dependent RNA polymerase, partial [Yellow silver pine associated narna-like virus 48]	diamond	564	51.6	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Yellow silver pine associated narna-like virus 48
28305159	28305159	PRJNA1240804_P_NODE_143626_length_163_cov_0.912281_g143260_i0	PRJNA1240804	143626	163	0.912281	1.48701803	Bunyaviricetes sp.	3240187	Viruses	Viruses	49.7	4.38e-5	NR	XKB76342.1	3240187	g143260	i0	51	0.901840490797546	49	24	90.2	0	15	161	516	564	XKB76342.1 MAG: RNA-dependent RNA polymerase, partial [Bunyaviricetes sp.]	diamond	147	49.7	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes				Bunyaviricetes sp.
28368218	28368218	PRJNA1240804_P_NODE_121486_length_167_cov_0.881356_g121120_i0	PRJNA1240804	121486	167	0.881356	1.47186452	Malassezia restricta virus MrV4	76775	Viruses	Viruses	77.4	7.93e-15	NR	QJA42330.1	2727863	g121120	i0	76.6	1.68862275449102	47	11	84.4	0	9	149	1	47	QJA42330.1 capsid protein [Malassezia restricta virus MrV40L]	diamond	282	77.4	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
28526399	28526399	PRJNA1240804_P_NODE_128107_length_166_cov_0.888889_g127741_i0	PRJNA1240804	128107	166	0.888889	1.47555574	Chronaberk virus	3129719	Viruses	Viruses	94.7	6.360000000000001e-21	NR	WZH58762.1	3129719	g127741	i0	83.7	0.885542168674699	49	8	88.6	0	20	166	219	267	WZH58762.1 MAG: RNA-dependent RNA polymerase [Chronaberk virus]	diamond	147	94.7	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Chronaberk virus
29031642	29031642	PRJNA1240804_P_NODE_144128_length_163_cov_0.912281_g143762_i0	PRJNA1240804	144128	163	0.912281	1.48701803	Totivirus sp.	2776824	Viruses	Viruses	67	1.23e-11	NR	QOQ37359.1	2776824	g143762	i0	75	2.42944785276074	44	11	81	0	32	163	21	64	QOQ37359.1 RNA-dependent RNA polymerase, partial [Totivirus sp.]	diamond	396	67	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus sp.
29031704	29031704	PRJNA1240804_P_NODE_75688_length_189_cov_2.000000_g75322_i0	PRJNA1240804	75688	189	2	3.78	Moss associated narna-like virus 6	3067018	Viruses	Viruses	82	2.21e-16	NR	WPR17193.1	3067019	g75322	i0	67.2	0.920634920634921	58	19	92.1	0	182	9	380	437	WPR17193.1 MAG: RNA-dependent RNA polymerase, partial [Moss associated narna-like virus 60]	diamond	174	82	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Moss associated narna-like virus 60
29094739	29094739	PRJNA1240804_P_NODE_65588_length_198_cov_1.563758_g65222_i0	PRJNA1240804	65588	198	1.563758	3.09624084	Hebei narnavirus 13	3371267	Viruses	Viruses	92.4	6.41e-20	NR	XHY85191.1	3371267	g65222	i0	69.2	0.984848484848485	65	19	98.5	1	196	2	501	564	XHY85191.1 MAG: hypothetical protein, partial [Hebei narnavirus 13]	diamond	195	92.4	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Hebei narnavirus 13
29473213	29473213	PRJNA1240804_P_NODE_70510_length_193_cov_1.409722_g70144_i0	PRJNA1240804	70510	193	1.409722	2.72076346	Erysiphe necator associated negative-stranded RNA virus 1	2737053	Viruses	Viruses	118	5.44e-29	NR	QJW70360.1	2737054	g70144	i0	94.7	1.7720207253886	57	3	88.6	0	177	7	679	735	QJW70360.1 RNA-dependent RNA polymerase [Erysiphe necator associated negative-stranded RNA virus 10]	diamond	342	118	1	Viruses	Orthornavirae	Negarnaviricota					Erysiphe necator associated negative-stranded RNA virus 10
29852439	29852439	PRJNA1240804_P_NODE_23051_length_295_cov_1.662602_g22685_i0	PRJNA1240804	23051	295	1.662602	4.9046759	Erysiphe necator associated narnavirus 17	2736374	Viruses	Viruses	80.5	3.8e-15	NR	QJT93749.1	2736374	g22685	i0	47.3	0.925423728813559	91	47	91.5	1	277	8	209	299	QJT93749.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 17]	diamond	273	80.5	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Erysiphe necator associated narnavirus 17
29870524	29870524	PRJNA1240804_P_NODE_26811_length_278_cov_1.371179_g26445_i0	PRJNA1240804	26811	278	1.371179	3.81187762	Narnavirus	186767	Viruses	Viruses	102	5.869999999999999e-23	NR	UHR49711.1	2905320	g26445	i0	53.3	1.86690647482014	90	42	97.1	0	7	276	28	117	UHR49711.1 MAG: RNA-dependent RNA polymerase, partial [Sanya narnavirus 8]	diamond	519	102	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Sanya narnavirus 8
30484341	30484341	PRJNA1240804_P_NODE_58313_length_207_cov_1.481013_g57947_i0	PRJNA1240804	58313	207	1.481013	3.06569691	Hebei narnavirus 13	3371267	Viruses	Viruses	73.6	3.13e-13	NR	XHY85191.1	3371267	g57947	i0	83.7	0.623188405797101	43	7	62.3	0	196	68	252	294	XHY85191.1 MAG: hypothetical protein, partial [Hebei narnavirus 13]	diamond	129	73.6	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Hebei narnavirus 13
30642042	30642042	PRJNA1240804_P_NODE_147133_length_162_cov_1.256637_g146767_i0	PRJNA1240804	147133	162	1.256637	2.03575194	Sanya narnavirus 8	2905320	Viruses	Viruses	86.7	4.27e-18	NR	UHR49711.1	2905320	g146767	i0	72.2	1	54	15	100	0	162	1	175	228	UHR49711.1 MAG: RNA-dependent RNA polymerase, partial [Sanya narnavirus 8]	diamond	162	86.7	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Sanya narnavirus 8
30705294	30705294	PRJNA1240804_P_NODE_14_length_3555_cov_12.361666_g6_i0	PRJNA1240804	14	3555	12.361666	439.4572263	Goldenrod fern yue-like virus	2933170	Viruses	Viruses	1260	0	NR	CAI5383876.1	2933170	g6	i0	59.5	0.90295358649789	1070	419	90.3	3	128	3337	26	1081	CAI5383876.1 RNA-dependent RNA polymerase, partial [Goldenrod fern yue-like virus]	diamond	3210	1260	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		Goldenrod fern yue-like virus
30705367	30705367	PRJNA1240804_P_NODE_89634_length_180_cov_1.343511_g89268_i0	PRJNA1240804	89634	180	1.343511	2.4183198	Grapevine-associated tymo-like virus 2	2814378	Viruses	Viruses	86.3	3.73e-18	NR	QXN75448.1	2814378	g89268	i0	76.6	0.783333333333333	47	11	78.3	0	148	8	1	47	QXN75448.1 MAG: RNA-dependent RNA polymerase, partial [Grapevine-associated tymo-like virus 2]	diamond	141	86.3	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales			Grapevine-associated tymo-like virus 2
31102575	31102575	PRJNA1240804_P_NODE_92835_length_178_cov_1.224806_g92469_i0	PRJNA1240804	92835	178	1.224806	2.18015468	Hahmbtovirus	3152728	Viruses	Viruses	42	0.0283	NR	QDH86744.1	2027243	g92469	i0	41.3	1.56741573033708	46	27	77.5	0	18	155	105	150	QDH86744.1 MAG: hypothetical protein H4Bulk46826_000003 [Leviviridae sp.]	diamond	279	42	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.
31400881	31400881	PRJNA1240804_P_NODE_141096_length_163_cov_1.403509_g140730_i0	PRJNA1240804	141096	163	1.403509	2.28771967	Erysiphe necator associated totivirus 4	2737094	Viruses	Viruses	57.8	6.3e-8	NR	QJW70332.1	2737094	g140730	i0	100	0.552147239263804	30	0	55.2	0	114	25	89	118	QJW70332.1 coat protein [Erysiphe necator associated totivirus 4]	diamond	90	57.8	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Erysiphe necator associated totivirus 4
32064987	32064987	PRJNA1240804_P_NODE_91438_length_179_cov_1.176923_g91072_i0	PRJNA1240804	91438	179	1.176923	2.10669217	Aspergillus terreus chrysovirus 1	3064026	Viruses	Viruses	68.2	1.7e-11	NR	WKU83718.1	3064026	g91072	i0	94.3	0.58659217877095	35	2	58.7	0	109	5	427	461	WKU83718.1 RNA-dependent RNA polymerase [Aspergillus terreus chrysovirus 1]	diamond	105	68.2	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Chrysoviridae	Alphachrysovirus	Aspergillus terreus chrysovirus 1
32508272	32508272	PRJNA1240804_P_NODE_8939_length_428_cov_1.693931_g8577_i0	PRJNA1240804	8939	428	1.693931	7.25002468	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	92.8	9.85e-19	NR	UVF58767.1	2951531	g8577	i0	38.5	1.65420560747664	117	72	82	0	425	75	90	206	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	diamond	708	92.8	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus
32791422	32791422	PRJNA1240804_P_NODE_131520_length_165_cov_0.896552_g131154_i0	PRJNA1240804	131520	165	0.896552	1.4793108	Skokie dicistro-like virus	2789443	Viruses	Viruses	93.2	2.24e-20	NR	QPG92979.1	2789443	g131154	i0	89.6	0.872727272727273	48	5	87.3	0	144	1	588	635	QPG92979.1 polyprotein 2 [Skokie dicistro-like virus]	diamond	144	93.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
32791441	32791441	PRJNA1240804_P_NODE_148860_length_162_cov_0.920354_g148494_i0	PRJNA1240804	148860	162	0.920354	1.49097348	Tacheng Tick Virus 4	1608086	Viruses	Viruses	48.9	8.2e-5	NR	YP_009177716.1	1608086	g148494	i0	53.1	0.907407407407407	49	23	90.7	0	160	14	894	942	YP_009177716.1 polymerase [Tacheng Tick Virus 4]	diamond	147	48.9	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Morsusvirus	Morsusvirus argatis

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