metadata: contig_metadata: 19 rows where bioproject = "PRJNA752572" and tax

19 rows where bioproject = "PRJNA752572" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
728560	728560	PRJNA752572_P_NODE_158861_length_212_cov_1.751412_g158354_i0	PRJNA752572	158861	212	1.751412	3.71299344	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	58.4	4.01e-4	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g158354	i0	100	0.679245283018868	31	0	15	0	1	31	56	86	Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds	blastn	144	58.4	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Dolerus tritici iflavirus 1
2004641	2004641	PRJNA752572_P_NODE_235622_length_173_cov_0.956522_g235115_i0	PRJNA752572	235622	173	0.956522	1.65478306	Caudoviricetes sp.	2832643	Viruses	Viruses	169	1.38e-37	NTclustered	gi\|2914840859\|gb\|OR222850.1\|	2832643	g235115	i0	93.805	1.11560693641618	113	6	100	1	61	173	38388	38277	MAG: Caudoviricetes sp. isolate MSP0504 genomic sequence	blastn	193	169	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
2004650	2004650	PRJNA752572_P_NODE_250922_length_168_cov_2.157895_g250415_i0	PRJNA752572	250922	168	2.157895	3.6252636	Gammapapillomavirus 1	333926	Viruses	Viruses	311	2.11e-80	NTclustered	gi\|1878296596\|gb\|MN605989.1\|	10617	g250415	i0	100	5.70238095238095	168	0	100	0	1	168	3554	3387	Human papillomavirus 4 isolate P2, complete genome	blastn	958	311	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Gammapapillomavirus	Gammapapillomavirus 1
3753062	3753062	PRJNA752572_P_NODE_12323_length_745_cov_6.233803_g11951_i0	PRJNA752572	12323	745	6.233803	46.44183235	Terrestrivirus sp.	2487775	Viruses	Viruses	224	5.64e-69	NR	AYV76217.1	2487775	g11951	i0	46	1.01476510067114	252	125	98.3	6	732	1	43	291	AYV76217.1 MAG: DUF3050 domain-containing protein [Terrestrivirus sp.]	diamond	756	224	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
13482422	13482422	PRJNA752572_P_NODE_147451_length_220_cov_2.513514_g146944_i0	PRJNA752572	147451	220	2.513514	5.5297308	Solumvirus sp.	2487773	Viruses	Viruses	130	5.96e-36	NR	AYV86227.1	2487773	g146944	i0	84.9	0.995454545454545	73	11	99.5	0	219	1	112	184	AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.]	diamond	219	130	1	Viruses	Pithoviruses							Solumvirus sp.
22405999	22405999	PRJNA752572_P_NODE_246318_length_170_cov_0.977778_g245811_i0	PRJNA752572	246318	170	0.977778	1.6622226	Caudoviricetes sp.	2832643	Viruses	Viruses	292	7.69e-75	NTclustered	gi\|2914810319\|gb\|OR221740.1\|	2832643	g245811	i0	97.647	3	170	4	100	0	1	170	14868	15037	MAG: Caudoviricetes sp. isolate MSP1300 genomic sequence	blastn	510	292	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
23681571	23681571	PRJNA752572_P_NODE_261079_length_166_cov_1.007634_g260572_i0	PRJNA752572	261079	166	1.007634	1.67267244	Maltschvirus maltsch	2956182	Viruses	Viruses	135	1.34e-27	NTclustered	gi\|1862940772\|emb\|LR797824.1\|	2100421	g260572	i0	83.117	5.19277108433735	154	21	92	4	5	157	130044	130193	uncultured Caudovirales phage genome assembly	blastn	862	135	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
26704457	26704457	PRJNA752572_P_NODE_239201_length_172_cov_0.963504_g238694_i0	PRJNA752572	239201	172	0.963504	1.65722688	Brevundimonas phage vB_BpoS-MaInes	2948603	Viruses	Viruses	84.7	3.84e-19	NR	UTC30091.1	2948603	g238694	i0	74.5	0.959302325581395	55	13	95.9	1	166	2	22	75	UTC30091.1 hypothetical protein MAINES_00520 [Brevundimonas phage vB_BpoS-MaInes]	diamond	165	84.7	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Brevundimonas phage vB_BpoS-MaInes
26926315	26926315	PRJNA752572_P_NODE_3742_length_1174_cov_2.842845_g3544_i0	PRJNA752572	3742	1174	2.842845	33.3750003	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	458	5.7599999999999986e-157	NR	YP_010803269.1	3060017	g3544	i0	66.8	0.830494037478705	325	107	83	1	1172	198	91	414	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	975	458	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
27274154	27274154	PRJNA752572_P_NODE_236263_length_172_cov_2.591241_g235756_i0	PRJNA752572	236263	172	2.591241	4.45693452	Mimivirus LCMiAC	2506609	Viruses	Viruses	47.8	2.43e-4	NR	QBK89257.1	2506609	g235756	i0	39.3	0.976744186046512	56	33	97.7	1	1	168	257	311	QBK89257.1 MAG: protein phosphatase 2C [Mimivirus LCMiAC02]	diamond	168	47.8	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Mimivirus LCMiAC02
27874129	27874129	PRJNA752572_P_NODE_90085_length_285_cov_3.144000_g89578_i0	PRJNA752572	90085	285	3.144	8.9604	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	112	7.12e-27	NR	YP_010803269.1	3060017	g89578	i0	59.8	0.863157894736842	82	33	86.3	0	251	6	8	89	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	246	112	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
28632121	28632121	PRJNA752572_P_NODE_168067_length_206_cov_1.631579_g167560_i0	PRJNA752572	168067	206	1.631579	3.36105274	Solumvirus sp.	2487773	Viruses	Viruses	80.1	2.04e-16	NR	AYV86227.1	2487773	g167560	i0	64.7	0.990291262135922	68	23	97.6	1	204	4	28	95	AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.]	diamond	204	80.1	1	Viruses	Pithoviruses							Solumvirus sp.
29147353	29147353	PRJNA752572_P_NODE_85549_length_293_cov_2.255814_g85042_i0	PRJNA752572	85549	293	2.255814	6.60953502	Gammaretrovirus	153135	Viruses	Viruses	199	7.73e-57	NR	ABU54795.1	11786	g85042	i0	99	8.93856655290102	97	1	99.3	0	2	292	660	756	ABU54795.1 gag-pro-pol polyprotein [Murine leukemia virus]	diamond	2619	201	0.990049751243781	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
29800047	29800047	PRJNA752572_P_NODE_2151_length_1394_cov_4.524650_g2004_i0	PRJNA752572	2151	1394	4.52465	63.073621	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	398	3.5799999999999987e-132	NR	YP_010803269.1	3060017	g2004	i0	48.1	0.871592539454806	405	208	87.2	2	1359	145	11	413	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	1215	398	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
30747998	30747998	PRJNA752572_P_NODE_106794_length_261_cov_1.792035_g106287_i0	PRJNA752572	106794	261	1.792035	4.67721135	Cyanophage P-RSM6	929832	Viruses	Viruses	44.7	0.00196	NR	YP_007675168.1	929832	g106287	i0	47.3	0.632183908045977	55	21	54	2	16	156	12	66	YP_007675168.1 hypothetical protein CPXG_00131 [Cyanophage P-RSM6]	diamond	165	44.7	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Kyanoviridae		Cyanophage P-RSM6
31000850	31000850	PRJNA752572_P_NODE_63994_length_341_cov_1.745098_g63487_i0	PRJNA752572	63994	341	1.745098	5.95078418	Klosneuvirus KNV1	1977640	Viruses	Viruses	86.3	5.45e-17	NR	ARF11468.1	1977640	g63487	i0	38.5	0.914956011730205	104	61	91.5	1	339	28	64	164	ARF11468.1 deoxyribodipyrimidine photolyase [Klosneuvirus KNV1]	diamond	312	86.3	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
31126745	31126745	PRJNA752572_P_NODE_240075_length_171_cov_2.036765_g239568_i0	PRJNA752572	240075	171	2.036765	3.48286815	Dishui Lake phycodnavirus 4	2704072	Viruses	Viruses	73.2	2.42e-13	NR	QIG59965.1	2704072	g239568	i0	64.7	0.894736842105263	51	18	89.5	0	1	153	351	401	QIG59965.1 ornithine decarboxylase [Dishui Lake phycodnavirus 4]	diamond	153	73.2	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Dishui Lake phycodnavirus 4
32075995	32075995	PRJNA752572_P_NODE_123698_length_241_cov_3.082524_g123191_i0	PRJNA752572	123698	241	3.082524	7.42888284	Megaviridae environmental sample	1737588	Viruses	Viruses	45.1	0.00221	NR	QFG74487.1	1737588	g123191	i0	51.2	0.535269709543568	43	20	53.5	1	209	81	101	142	QFG74487.1 MAG: hypothetical protein [Megaviridae environmental sample]	diamond	129	45.1	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Megaviridae environmental sample
32550917	32550917	PRJNA752572_P_NODE_29199_length_505_cov_1.261702_g28721_i0	PRJNA752572	29199	505	1.261702	6.3715951	Klosneuvirus KNV1	1977640	Viruses	Viruses	85.1	2.07e-16	NR	ARF12509.1	1977640	g28721	i0	31.1	0.992079207920792	167	115	99.2	0	502	2	78	244	ARF12509.1 stomatin family protein [Klosneuvirus KNV1]	diamond	501	85.1	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1

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