metadata: contig_metadata: 26 rows where bioproject = "PRJNA1164198" and tax

26 rows where bioproject = "PRJNA1164198" 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
1586630	1586630	PRJNA1164198_P_NODE_27342_length_248_cov_0.891429_g27073_i0	PRJNA1164198	27342	248	0.891429	2.21074392	Caudoviricetes sp.	2832643	Viruses	Viruses	436	5.3e-118	NTclustered	gi\|2914786054\|gb\|OR222556.1\|	2832643	g27073	i0	98.387	4.20564516129032	248	4	100	0	1	248	66396	66643	MAG: Caudoviricetes sp. isolate MSP0376 genomic sequence	blastn	1043	436	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
4138870	4138870	PRJNA1164198_P_NODE_4204_length_614_cov_2.251386_g3956_i0	PRJNA1164198	4204	614	2.251386	13.82351004	Giant panda Iflaviridae	2903093	Viruses	Viruses	446	2.39e-120	NTclustered	gi\|2164966906\|gb\|MZ956593.1\|	2903093	g3956	i0	80.132	14.8192182410423	604	115	98	5	7	607	5113	4512	MAG: Giant panda Iflaviridae isolate PPLV1, partial genome	blastn	9099	446	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
5415090	5415090	PRJNA1164198_P_NODE_30525_length_242_cov_1.846154_g30256_i0	PRJNA1164198	30525	242	1.846154	4.46769268	Bacteriophage sp.	38018	Viruses	Viruses	440	3.9799999999999986e-119	NTclustered	gi\|2295308463\|gb\|OP075212.1\|	38018	g30256	i0	99.587	119.053719008264	242	0	100	1	1	242	351	111	MAG: Bacteriophage sp. isolate 3109_38181, partial genome	blastn	28811	440	1	Viruses							Bacteriophage sp.
13065512	13065512	PRJNA1164198_P_NODE_10611_length_382_cov_1.009709_g10343_i0	PRJNA1164198	10611	382	1.009709	3.85708838	Caudoviricetes sp.	2832643	Viruses	Viruses	279	1.5400000000000002e-70	NTclustered	gi\|2057855660\|tpg\|BK050442.1\|	2832643	g10343	i0	80.319	0.984293193717278	376	69	97	5	11	382	25808	26182	MAG TPA_asm: Caudoviricetes sp. isolate ctANV3, partial genome	blastn	376	279	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
14340872	14340872	PRJNA1164198_P_NODE_10932_length_376_cov_1.521452_g10664_i0	PRJNA1164198	10932	376	1.521452	5.72065952	Caudoviricetes sp.	2832643	Viruses	Viruses	667	0	NTclustered	gi\|2054434277\|tpg\|BK035998.1\|	2832643	g10664	i0	99.189	418.188829787234	370	3	98	0	7	376	18368	17999	MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome	blastn	157239	667	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
18163614	18163614	PRJNA1164198_P_NODE_30055_length_243_cov_0.917647_g29786_i0	PRJNA1164198	30055	243	0.917647	2.22988221	Caudoviricetes sp.	2832643	Viruses	Viruses	444	3.09e-120	NTclustered	gi\|2057879443\|tpg\|BK050812.1\|	2832643	g29786	i0	99.588	95.3909465020576	243	1	100	0	1	243	6673	6431	MAG TPA_asm: Caudoviricetes sp. isolate ctEG41, partial genome	blastn	23180	444	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19437968	19437968	PRJNA1164198_P_NODE_30076_length_243_cov_0.917647_g29807_i0	PRJNA1164198	30076	243	0.917647	2.22988221	Caudoviricetes sp.	2832643	Viruses	Viruses	449	6.65e-122	NTclustered	gi\|2056961566\|tpg\|BK022926.1\|	2832643	g29807	i0	100	34.7901234567901	243	0	100	0	1	243	23187	23429	MAG TPA_asm: Caudoviricetes sp. isolate ctCkG11, partial genome	blastn	8454	449	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19437979	19437979	PRJNA1164198_P_NODE_3096_length_714_cov_2.068643_g2872_i0	PRJNA1164198	3096	714	2.068643	14.77011102	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	298	1.44e-98	NR	YP_010803019.1	3060017	g2872	i0	57	1.98739495798319	237	102	99.6	0	2	712	17	253	YP_010803019.1 peptidase C1a [Fadolivirus algeromassiliense]	diamond	1419	298	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
19437981	19437981	PRJNA1164198_P_NODE_31696_length_228_cov_3.019355_g31427_i0	PRJNA1164198	31696	228	3.019355	6.8841294	Catovirus CTV1	1977631	Viruses	Viruses	228	3.1499999999999988e-55	NTclustered	gi\|1174569070\|gb\|KY684083.1\|	1977631	g31427	i0	85.714	0.951754385964912	217	29	95	2	13	228	355783	355998	Catovirus CTV1 isolate CTV1 clone Catovirus_1, sequence	blastn	217	228	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
23264233	23264233	PRJNA1164198_P_NODE_28459_length_246_cov_0.901734_g28190_i0	PRJNA1164198	28459	246	0.901734	2.21826564	Caudoviricetes sp.	2832643	Viruses	Viruses	381	2.5e-101	NTclustered	gi\|2059941745\|tpg\|BK024795.1\|	2832643	g28190	i0	94.694	0.995934959349594	245	13	99	0	2	246	31866	32110	MAG TPA_asm: Caudoviricetes sp. isolate ctaYm21, partial genome	blastn	245	381	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
24537917	24537917	PRJNA1164198_P_NODE_27720_length_247_cov_0.896552_g27451_i0	PRJNA1164198	27720	247	0.896552	2.21448344	Klebsiella phage vB_KM5a1-KLB28	3145203	Viruses	Viruses	433	6.82e-117	NTclustered	gi\|2899263775\|gb\|PP582755.1\|	3145203	g27451	i0	98.765	2.97570850202429	243	3	98	0	5	247	9765	9523	Klebsiella phage vB_KM5a1-KLB28, complete genome	blastn	735	433	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Klebsiella phage vB_KM5a1-KLB28
26850764	26850764	PRJNA1164198_P_NODE_28821_length_245_cov_0.906977_g28552_i0	PRJNA1164198	28821	245	0.906977	2.22209365	Tupanvirus soda lake	2126985	Viruses	Viruses	50.1	4.98e-5	NR	YP_010782233.1	2126985	g28552	i0	39.2	1.93469387755102	79	48	96.7	0	237	1	52	130	YP_010782233.1 hypothetical protein QJ857_gp0474 [Tupanvirus soda lake]	diamond	474	50.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
27261810	27261810	PRJNA1164198_P_NODE_6803_length_482_cov_1.760391_g6543_i0	PRJNA1164198	6803	482	1.760391	8.48508462	Tupanvirus soda lake	2126985	Viruses	Viruses	198	2.08e-57	NR	YP_010782121.1	2126985	g6543	i0	61.8	0.977178423236514	157	60	97.7	0	481	11	246	402	YP_010782121.1 arylsulfatase [Tupanvirus soda lake]	diamond	471	198	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
27388308	27388308	PRJNA1164198_P_NODE_31423_length_234_cov_2.670807_g31154_i0	PRJNA1164198	31423	234	2.670807	6.24968838	Giant panda Iflaviridae	2903093	Viruses	Viruses	111	2.69e-26	NR	UGV21557.1	2903093	g31154	i0	68	0.961538461538462	75	24	96.2	0	231	7	965	1039	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	225	111	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
27609259	27609259	PRJNA1164198_P_NODE_22244_length_263_cov_1.884211_g21975_i0	PRJNA1164198	22244	263	1.884211	4.95547493	Giant panda Iflaviridae	2903093	Viruses	Viruses	135	1.68e-34	NR	UGV21557.1	2903093	g21975	i0	74.7	0.992395437262357	87	22	99.2	0	2	262	1144	1230	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	261	135	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
27988080	27988080	PRJNA1164198_P_NODE_17665_length_294_cov_1.407240_g17396_i0	PRJNA1164198	17665	294	1.40724	4.1372856	Catovirus CTV1	1977631	Viruses	Viruses	77.4	1e-15	NR	ARF09177.1	1977631	g17396	i0	42.7	0.979591836734694	96	52	98	1	6	293	6	98	ARF09177.1 hypothetical protein Catovirus_2_126 [Catovirus CTV1]	diamond	288	77.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
28146115	28146115	PRJNA1164198_P_NODE_28545_length_246_cov_0.901734_g28276_i0	PRJNA1164198	28545	246	0.901734	2.21826564	Dickeya phage vB_DsoM_JA11	2382310	Viruses	Viruses	82	1.63e-17	NR	YP_009813682.1	2382310	g28276	i0	56.4	0.951219512195122	78	34	95.1	0	245	12	31	108	YP_009813682.1 hypothetical protein HOU32_gp237 [Dickeya phage vB_DsoM_JA11]	diamond	234	82	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Salmondvirus	Salmondvirus JA11
28808640	28808640	PRJNA1164198_P_NODE_28708_length_245_cov_1.523256_g28439_i0	PRJNA1164198	28708	245	1.523256	3.7319772	Giant panda Iflaviridae	2903093	Viruses	Viruses	116	5.36e-28	NR	UGV21557.1	2903093	g28439	i0	69.5	1.00408163265306	82	24	99.2	1	3	245	697	778	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	246	116	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
28872004	28872004	PRJNA1164198_P_NODE_10908_length_376_cov_2.435644_g10640_i0	PRJNA1164198	10908	376	2.435644	9.15802144	Giant panda Iflaviridae	2903093	Viruses	Viruses	218	4.45e-63	NR	UGV21557.1	2903093	g10640	i0	87.9	0.98936170212766	124	15	98.9	0	374	3	170	293	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	372	218	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
29819117	29819117	PRJNA1164198_P_NODE_12531_length_350_cov_1.891697_g12262_i0	PRJNA1164198	12531	350	1.891697	6.6209395	Giant panda Iflaviridae	2903093	Viruses	Viruses	164	3.16e-44	NR	UGV21557.1	2903093	g12262	i0	66.1	0.985714285714286	115	39	98.6	0	5	349	1228	1342	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	345	164	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
30609055	30609055	PRJNA1164198_P_NODE_4633_length_584_cov_1.921722_g4385_i0	PRJNA1164198	4633	584	1.921722	11.22285648	Giant panda Iflaviridae	2903093	Viruses	Viruses	226	1.1e-64	NR	UGV21557.1	2903093	g4385	i0	57.9	0.976027397260274	190	80	97.6	0	581	12	1772	1961	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	570	226	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
30925352	30925352	PRJNA1164198_P_NODE_21934_length_265_cov_2.135417_g21665_i0	PRJNA1164198	21934	265	2.135417	5.65885505	Crogonang virus 178	3063382	Viruses	Viruses	86.3	5.01e-18	NR	WPR18581.1	3063382	g21665	i0	53.6	0.950943396226415	84	36	95.1	1	264	13	23	103	WPR18581.1 MAG: RNA-dependent RNA polymerase, partial [Crogonang virus 178]	diamond	252	86.3	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Crogonang virus 178
31145840	31145840	PRJNA1164198_P_NODE_21375_length_269_cov_0.979592_g21106_i0	PRJNA1164198	21375	269	0.979592	2.63510248	Giant panda Iflaviridae	2903093	Viruses	Viruses	171	2.8e-47	NR	UGV21557.1	2903093	g21106	i0	93.3	0.992565055762082	89	6	99.3	0	268	2	284	372	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	267	171	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
32443542	32443542	PRJNA1164198_P_NODE_27779_length_247_cov_0.896552_g27510_i0	PRJNA1164198	27779	247	0.896552	2.21448344	Acanthamoeba polyphaga mimivirus	212035	Viruses	Viruses	88.2	4.51e-19	NR	AVG46078.1	212035	g27510	i0	63	2.95141700404858	81	28	98.4	2	3	245	98	176	AVG46078.1 hypothetical protein [Acanthamoeba polyphaga mimivirus]	diamond	729	88.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus bradfordmassiliense
32664082	32664082	PRJNA1164198_P_NODE_29880_length_243_cov_1.835294_g29611_i0	PRJNA1164198	29880	243	1.835294	4.45976442	Saccharomyces 2	3431059	Viruses	Viruses	120	1.64e-29	NR	NP_660178.1	186772	g29611	i0	76.3	0.987654320987654	80	19	98.8	0	3	242	21	100	NP_660178.1 RNA-dependent RNA polymerase [Saccharomyces 20S RNA narnavirus]	diamond	240	120	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Narnavirus saccharominor
32758732	32758732	PRJNA1164198_P_NODE_5700_length_527_cov_2.603524_g5445_i0	PRJNA1164198	5700	527	2.603524	13.72057148	Giant panda Iflaviridae	2903093	Viruses	Viruses	226	9.71e-65	NR	UGV21557.1	2903093	g5445	i0	62.6	0.973434535104364	171	63	97.3	1	513	1	2060	2229	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	513	226	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae

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