metadata: contig_metadata: 29 rows where bioproject = "PRJNA1174234" and tax

29 rows where bioproject = "PRJNA1174234" and tax_superkingdom = "Viruses"

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
316272	316272	PRJNA1174234_P_NODE_6641_length_529_cov_1.758772_g6445_i0	PRJNA1174234	6641	529	1.758772	9.30390388	Escherichia virus KFS-EC3	2836074	Viruses	Viruses	60.2	3.1e-4	NTclustered	gi\|2045607952\|gb\|MZ065353.1\|	2836074	g6445	i0	97.143	0.130434782608696	35	1	7	0	260	294	127645	127611	Escherichia virus KFS-EC3, complete genome	blastn	69	60.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Tequatrovirus	Escherichia virus KFS-EC3
2316232	2316232	PRJNA1174234_P_NODE_3282_length_725_cov_3.616564_g3104_i0	PRJNA1174234	3282	725	3.616564	26.220089	Chlorella virus XW	10507	Viruses	Viruses	234	6.94e-71	NR	ULY68464.1	2922419	g3104	i0	62.3	1.32413793103448	162	57	65.4	1	123	596	276	437	ULY68464.1 deoxyribodipyrimidine photo-lyase [Chlorella virus XW01]	diamond	960	234	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Chlorella virus XW01
2866876	2866876	PRJNA1174234_P_NODE_13223_length_378_cov_3.331148_g13027_i0	PRJNA1174234	13223	378	3.331148	12.59173944	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.036	NTclustered	gi\|2056962135\|tpg\|BK022939.1\|	2832643	g13027	i0	100	0.148148148148148	28	0	7	0	214	241	7338	7365	MAG TPA_asm: Caudoviricetes sp. isolate ctDW64, partial genome	blastn	56	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
2866943	2866943	PRJNA1174234_P_NODE_21823_length_295_cov_87.283784_g21627_i0	PRJNA1174234	21823	295	87.283784	257.4871628	Mitovirus sp.	2587224	Viruses	Viruses	174	5.6e-39	NTclustered	gi\|1698234317\|gb\|MN033515.1\|	2587224	g21627	i0	94.643	3.18305084745763	112	6	38	0	8	119	1	112	MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence	blastn	939	174	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Mitovirus sp.
6694022	6694022	PRJNA1174234_P_NODE_19706_length_311_cov_1.109244_g19510_i0	PRJNA1174234	19706	311	1.109244	3.44974884	Bandra megavirus	2071566	Viruses	Viruses	54.7	0.008	NTclustered	gi\|1336444313\|gb\|MG779343.1\|	2071566	g19510	i0	92.308	0.665594855305466	39	1	13	1	17	55	903	867	Bandra megavirus isolate KK-1 genomic sequence	blastn	207	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Bandra megavirus
6694062	6694062	PRJNA1174234_P_NODE_2766_length_777_cov_2.276989_g2595_i0	PRJNA1174234	2766	777	2.276989	17.69220453	Terrestrivirus sp.	2487775	Viruses	Viruses	84.7	5.5e-15	NR	AYV75160.1	2487775	g2595	i0	36.8	0.525096525096525	136	75	51.7	3	776	375	212	338	AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.]	diamond	408	84.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
18892463	18892463	PRJNA1174234_P_NODE_21695_length_296_cov_1.721973_g21499_i0	PRJNA1174234	21695	296	1.721973	5.09704008	root	1	Root_unresolved	Root_unresolved	54.7	0.008	NTclustered	gi\|769793965\|gb\|KM082124.1\|	11676	g21499	i0	100	3.45945945945946	29	0	10	0	42	70	769	741	HIV-1 isolate 1906CDNAPBMC21OCT2009.P3F9 from USA vpu protein (vpu) and envelope glycoprotein (env) genes, complete cds	blastn	1024	54.7	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus humimdef1
19442164	19442164	PRJNA1174234_P_NODE_3016_length_751_cov_3.646018_g2841_i0	PRJNA1174234	3016	751	3.646018	27.38159518	Terrestrivirus sp.	2487775	Viruses	Viruses	226	2.14e-69	NR	AYV76217.1	2487775	g2841	i0	47.8	0.978695073235686	245	117	94.7	6	37	747	51	292	AYV76217.1 MAG: DUF3050 domain-containing protein [Terrestrivirus sp.]	diamond	735	226	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
23268348	23268348	PRJNA1174234_P_NODE_30379_length_249_cov_0.875000_g30183_i0	PRJNA1174234	30379	249	0.875	2.17875	Zebrafish picornavirus 1	2304617	Viruses	Viruses	409	1.16e-109	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g30183	i0	96.735	2.95180722891566	245	8	98	0	5	249	6404	6160	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	735	409	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
24542072	24542072	PRJNA1174234_P_NODE_21540_length_297_cov_4.562500_g21344_i0	PRJNA1174234	21540	297	4.5625	13.550625	Burkholderia phage BCSR5	2805747	Viruses	Viruses	67.6	9.85e-7	NTclustered	gi\|1971775256\|gb\|MW460245.1\|	2805747	g21344	i0	100	0.508417508417508	36	0	12	0	140	175	654	619	Burkholderia phage BCSR5, complete genome	blastn	151	67.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Burkholderia phage BCSR5
27830250	27830250	PRJNA1174234_P_NODE_30624_length_249_cov_0.875000_g30428_i0	PRJNA1174234	30624	249	0.875	2.17875	Caudoviricetes sp.	2832643	Viruses	Viruses	171	2.13e-49	NR	DAW14969.1	2832643	g30428	i0	95.1	0.987951807228916	82	4	98.8	0	247	2	40	121	DAW14969.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	246	171	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28114312	28114312	PRJNA1174234_P_NODE_35685_length_241_cov_0.916667_g35489_i0	PRJNA1174234	35685	241	0.916667	2.20916747	Diaporthe gulyae mitovirus 3	3077427	Viruses	Viruses	48.5	3.24e-4	NR	WNM95031.1	3077427	g35489	i0	81.5	0.336099585062241	27	5	33.6	0	3	83	690	716	WNM95031.1 MAG: RNA-dependent RNA polymerase [Diaporthe gulyae mitovirus 3]	diamond	81	48.5	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Diaporthe gulyae mitovirus 3
28272119	28272119	PRJNA1174234_P_NODE_27646_length_259_cov_1.209677_g27450_i0	PRJNA1174234	27646	259	1.209677	3.13306343	Pegivirus scotophili	3052612	Viruses	Viruses	44.3	0.0137	NR	YP_009506366.1	3052612	g27450	i0	42.9	0.405405405405405	35	20	40.5	0	50	154	519	553	YP_009506366.1 polyprotein [Pegivirus scotophili]	diamond	105	44.3	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pegivirus	Pegivirus scotophili
28619835	28619835	PRJNA1174234_P_NODE_5667_length_570_cov_1.503018_g5471_i0	PRJNA1174234	5667	570	1.503018	8.5672026	Edafosvirus sp.	2487765	Viruses	Viruses	70.9	1.76e-10	NR	AYV78747.1	2487765	g5471	i0	28.7	0.789473684210526	150	77	73.7	5	502	83	1013	1142	AYV78747.1 MAG: hypothetical protein Edafosvirus29_11 [Edafosvirus sp.]	diamond	450	70.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
28651253	28651253	PRJNA1174234_P_NODE_31127_length_248_cov_0.880000_g30931_i0	PRJNA1174234	31127	248	0.88	2.1824	Pimephales minnow adintovirus	2609864	Viruses	Viruses	71.2	1.71e-12	NR	DAC81400.1	2609864	g30931	i0	41.5	0.991935483870968	82	48	99.2	0	1	246	39	120	DAC81400.1 TPA_asm: penton [Pimephales minnow adintovirus]	diamond	246	71.2	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Pimephales minnow adintovirus
28714367	28714367	PRJNA1174234_P_NODE_13187_length_379_cov_1.241830_g12991_i0	PRJNA1174234	13187	379	1.24183	4.7065357	Klosneuvirus KNV1	1977640	Viruses	Viruses	94.4	1.71e-20	NR	ARF12509.1	1977640	g12991	i0	40.5	10.9709762532982	126	75	99.7	0	379	2	59	184	ARF12509.1 stomatin family protein [Klosneuvirus KNV1]	diamond	4158	94.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
28808750	28808750	PRJNA1174234_P_NODE_22588_length_290_cov_1.419355_g22392_i0	PRJNA1174234	22588	290	1.419355	4.1161295	Marseillevirus LCMAC1	2506602	Viruses	Viruses	92	2.16e-21	NR	QBK85938.1	2506602	g22392	i0	51	0.993103448275862	96	45	99.3	1	1	288	42	135	QBK85938.1 MAG: hypothetical protein LCMAC101_05330 [Marseillevirus LCMAC101]	diamond	288	92	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC101
29061814	29061814	PRJNA1174234_P_NODE_18608_length_320_cov_1.109312_g18412_i0	PRJNA1174234	18608	320	1.109312	3.5497984	flactilig virus 22	2985755	Viruses	Viruses	85.5	9.05e-17	NR	UZT54538.1	2985755	g18412	i0	43.9	0.91875	98	55	91.9	0	1	294	230	327	UZT54538.1 MAG: RNA-dependent RNA polymerase, partial [flactilig virus 22]	diamond	294	85.5	1	Viruses							flactilig virus 22
29219685	29219685	PRJNA1174234_P_NODE_34609_length_243_cov_0.864706_g34413_i0	PRJNA1174234	34609	243	0.864706	2.10123558	Adintovirus pavo15764	3115938	Viruses	Viruses	82.4	4.26e-17	NR	DBA50340.1	3115938	g34413	i0	49.3	0.925925925925926	75	38	92.6	0	239	15	81	155	DBA50340.1 MAG TPA_asm: PacK [Adintovirus pavo15764]	diamond	225	82.4	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus pavo15764
29648771	29648771	PRJNA1174234_P_NODE_4070_length_661_cov_1.295918_g3882_i0	PRJNA1174234	4070	661	1.295918	8.56601798	root	1	Root_unresolved	Root_unresolved	97.1	6.160000000000001e-22	NR	QWO71601.1	10450	g3882	i0	62	11.9591527987897	79	30	35.9	0	639	403	24	102	QWO71601.1 ubiquitin [Orgyia pseudotsugata single capsid nuclopolyhedrovirus]	diamond	7905	97.1	1	Viruses			Naldaviricetes	Lefavirales	Baculoviridae	Alphabaculovirus	Orgyia pseudotsugata single capsid nuclopolyhedrovirus
30028315	30028315	PRJNA1174234_P_NODE_28031_length_257_cov_0.788043_g27835_i0	PRJNA1174234	28031	257	0.788043	2.02527051	root	1	Root_unresolved	Root_unresolved	43.1	0.0331	NR	CAH6419199.1	340016	g27835	i0	32.8	1.90272373540856	67	39	78.2	1	206	6	754	814	CAH6419199.1 2-5 RNA ligase superfamily [uncultured virus]	diamond	489	43.1	1	Viruses							uncultured virus
30134987	30134987	PRJNA1174234_P_NODE_10892_length_419_cov_1.228324_g10696_i0	PRJNA1174234	10892	419	1.228324	5.14667756	Mimivirus sp.	2742700	Viruses	Viruses	98.2	3.929999999999999e-23	NR	QZX43511.1	2742700	g10696	i0	45	1.43198090692124	100	52	69.5	1	26	316	40	139	QZX43511.1 phosphatidylethanolamine-binding protein [Mimivirus sp.]	diamond	600	98.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus sp.
30217646	30217646	PRJNA1174234_P_NODE_11492_length_407_cov_1.380240_g11296_i0	PRJNA1174234	11492	407	1.38024	5.6175768	root	1	Root_unresolved	Root_unresolved	102	1.2399999999999999e-23	NR	CAB4125944.1	2100421	g11296	i0	79.4	3.21375921375921	63	13	46.4	0	304	116	60	122	CAB4125944.1 FolE GTP cyclohydrolase I [uncultured Caudovirales phage]	diamond	1308	102	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
30988560	30988560	PRJNA1174234_P_NODE_27774_length_258_cov_1.351351_g27578_i0	PRJNA1174234	27774	258	1.351351	3.48648558	Orius laevigatus tombus-like virus 1	3344938	Viruses	Viruses	47.8	7.45e-4	NR	XGU09131.1	3344938	g27578	i0	41	0.709302325581395	61	36	70.9	0	9	191	451	511	XGU09131.1 MAG: RdRp [Orius laevigatus tombus-like virus 1]	diamond	183	47.8	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Orius laevigatus tombus-like virus 1
31133720	31133720	PRJNA1174234_P_NODE_30235_length_249_cov_1.289773_g30039_i0	PRJNA1174234	30235	249	1.289773	3.21153477	root	1	Root_unresolved	Root_unresolved	50.1	9.63e-5	NR	VBB18459.1	2420051	g30039	i0	35.3	1.78313253012048	68	41	78.3	1	36	230	161	228	VBB18459.1 class I SAM-dependent methyltransferase [Yasminevirus sp. GU-2018]	diamond	444	50.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
31430935	31430935	PRJNA1174234_P_NODE_2596_length_798_cov_1.743448_g2430_i0	PRJNA1174234	2596	798	1.743448	13.91271504	Catovirus sp. 'naegleriensis'	3072188	Viruses	Viruses	134	4.3199999999999996e-32	NR	CAK7596644.1	3072188	g2430	i0	39.1	0.654135338345865	174	101	65	3	796	278	355	524	CAK7596644.1 Ubiquitin-conjugating enzyme/RWD-like homologoussuperfamily domain-containing protein [Catovirus sp. 'naegleriensis']	diamond	522	134	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus sp. 'naegleriensis'
31557727	31557727	PRJNA1174234_P_NODE_12936_length_383_cov_0.993548_g12740_i0	PRJNA1174234	12936	383	0.993548	3.80528884	Qianjiang noda-like virus 99	3348689	Viruses	Viruses	66.6	5.08e-10	NR	XHA86106.1	3348689	g12740	i0	34.1	0.986945169712794	126	76	97.9	3	7	381	143	262	XHA86106.1 MAG: hypothetical protein [Qianjiang noda-like virus 99]	diamond	378	66.6	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae		Qianjiang noda-like virus 99
31936997	31936997	PRJNA1174234_P_NODE_9037_length_459_cov_1.378238_g8841_i0	PRJNA1174234	9037	459	1.378238	6.32611242	Tupanvirus deep ocean	2126984	Viruses	Viruses	166	2.4899999999999997e-48	NR	YP_010780318.1	2126984	g8841	i0	58.7	1.81699346405229	138	50	85.6	2	61	453	69	206	YP_010780318.1 hypothetical protein QJ856_gp1047 [Tupanvirus deep ocean]	diamond	834	166	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
32285479	32285479	PRJNA1174234_P_NODE_1519_length_975_cov_1.506652_g1388_i0	PRJNA1174234	1519	975	1.506652	14.689857	Orius laevigatus tombus-like virus 1	3344938	Viruses	Viruses	145	6.46e-36	NR	XGU09133.1	3344938	g1388	i0	42.3	0.516923076923077	168	94	50.8	2	409	903	154	321	XGU09133.1 MAG: RdRp [Orius laevigatus tombus-like virus 1]	diamond	504	145	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Orius laevigatus tombus-like virus 1

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