metadata: contig_metadata: 21 rows where bioproject = "PRJNA674048", tax_clade = "PVC group" and tax

21 rows where bioproject = "PRJNA674048", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"

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
642959	642959	PRJNA674048_P_NODE_13761_length_243_cov_3.484536_g13558_i0	PRJNA674048	13761	243	3.484536	8.46742248	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	420	5.21e-113	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g13558	i0	97.942	279.111111111111	243	3	100	2	1	243	1528	1768	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	67824	420	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
642965	642965	PRJNA674048_P_NODE_14441_length_236_cov_3.422460_g14238_i0	PRJNA674048	14441	236	3.42246	8.0770056	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	363	8.609999999999998e-96	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g14238	i0	94.468	22.9449152542373	235	13	99	0	1	235	180	414	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	5415	363	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
3193947	3193947	PRJNA674048_P_NODE_18283_length_207_cov_1.645570_g18080_i0	PRJNA674048	18283	207	1.64557	3.4063299	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	359	9.53e-95	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g18080	i0	98.068	1.72946859903382	207	3	99	1	1	206	2997876	2997670	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	358	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
8296419	8296419	PRJNA674048_P_NODE_24927_length_176_cov_1.322835_g24724_i0	PRJNA674048	24927	176	1.322835	2.3281896	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	97.1	6.76e-16	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g24724	i0	79.021	50.0227272727273	143	29	81	1	1	142	1316569	1316427	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	8804	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9571595	9571595	PRJNA674048_P_NODE_21288_length_190_cov_3.695035_g21085_i0	PRJNA674048	21288	190	3.695035	7.0205665	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	316	5.24e-82	NTclustered	gi\|164510704\|emb\|AJ966883.1\|	48466	g21085	i0	97.312	252.678947368421	186	5	98	0	5	190	4820	4635	Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252	blastn	48009	316	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
11369515	11369515	PRJNA674048_P_NODE_22249_length_186_cov_2.927007_g22046_i0	PRJNA674048	22249	186	2.927007	5.44423302	Pseudomonadati	3379134	Bacteria	Bacteria	344	2.34e-90	NTclustered	gi\|164510704\|emb\|AJ966883.1\|	48466	g22046	i0	100	99.3924731182796	186	0	100	0	1	186	712	897	Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252	blastn	18487	344	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
12122397	12122397	PRJNA674048_P_NODE_2310_length_764_cov_5.240559_g2158_i0	PRJNA674048	2310	764	5.240559	40.03787076	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	1256	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g2158	i0	96.335	283.388743455497	764	28	100	0	1	764	538	1301	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	216509	1256	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
12122478	12122478	PRJNA674048_P_NODE_33130_length_160_cov_3.747748_g32927_i0	PRJNA674048	33130	160	3.747748	5.9963968	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	239	9.49e-59	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g32927	i0	93.789	6.15	161	6	99	4	1	159	2035	2193	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	984	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
13397127	13397127	PRJNA674048_P_NODE_11411_length_275_cov_1.358407_g11208_i0	PRJNA674048	11411	275	1.358407	3.73561925	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	449	7.670000000000001e-122	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g11208	i0	96.029	165.818181818182	277	9	100	2	1	275	558227	557951	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	45600	449	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13397164	13397164	PRJNA674048_P_NODE_16231_length_221_cov_1.639535_g16028_i0	PRJNA674048	16231	221	1.639535	3.62337235	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	228	3.0299999999999988e-55	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g16028	i0	86.473	18.9366515837104	207	28	94	0	15	221	2784	2578	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	4185	228	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
13397221	13397221	PRJNA674048_P_NODE_25251_length_174_cov_4.696000_g25048_i0	PRJNA674048	25251	174	4.696	8.17104	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	283	4.769999999999999e-72	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g25048	i0	95.977	83.7873563218391	174	7	100	0	1	174	1308	1481	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	14579	283	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
15945748	15945748	PRJNA674048_P_NODE_1853_length_864_cov_3.920245_g1715_i0	PRJNA674048	1853	864	3.920245	33.8709168	Pedosphaera parvula	1032527	Bacteria	Bacteria	859	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g1715	i0	84.783	67.9270833333333	874	113	99	20	1	863	938	1802	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	58689	859	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
18495424	18495424	PRJNA674048_P_NODE_16495_length_219_cov_1.935294_g16292_i0	PRJNA674048	16495	219	1.935294	4.23829386	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	327	2.87e-85	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g16292	i0	93.636	117.073059360731	220	12	100	2	1	219	5636759	5636977	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	25639	327	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
19770056	19770056	PRJNA674048_P_NODE_33376_length_158_cov_3.587156_g33173_i0	PRJNA674048	33376	158	3.587156	5.66770648	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	267	4.2799999999999996e-67	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g33173	i0	97.436	113.360759493671	156	4	99	0	1	156	2251	2406	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	17911	267	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
21045578	21045578	PRJNA674048_P_NODE_12757_length_255_cov_2.388350_g12554_i0	PRJNA674048	12757	255	2.38835	6.0902925	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	372	1.57e-98	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g12554	i0	94.606	153.450980392157	241	11	94	2	17	255	1315318	1315558	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	39130	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21045702	21045702	PRJNA674048_P_NODE_30097_length_165_cov_0.896552_g29894_i0	PRJNA674048	30097	165	0.896552	1.4793108	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	106	2.63e-27	NR	MCX7827560.1	2499141	g29894	i0	100	1	55	0	100	0	1	165	62	116	MCX7827560.1 SLC13 family permease [Verrucomicrobiia bacterium]	diamond	165	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
23595868	23595868	PRJNA674048_P_NODE_12219_length_262_cov_2.441315_g12016_i0	PRJNA674048	12219	262	2.441315	6.3962453	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g12016	i0	99.618	48.5	262	1	100	0	1	262	2498382	2498643	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	12707	479	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
27018479	27018479	PRJNA674048_P_NODE_33642_length_156_cov_2.542056_g33439_i0	PRJNA674048	33642	156	2.542056	3.96560736	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	102	7.8e-24	NR	MBN9691045.1	2026799	g33439	i0	96.1	0.980769230769231	51	2	98.1	0	155	3	12	62	MBN9691045.1 efflux transporter outer membrane subunit [Verrucomicrobiota bacterium]	diamond	153	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28786904	28786904	PRJNA674048_P_NODE_31987_length_163_cov_0.912281_g31784_i0	PRJNA674048	31987	163	0.912281	1.48701803	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	94	2.8400000000000003e-21	NR	HVR65458.1	2499141	g31784	i0	78.8	0.957055214723926	52	11	95.7	0	162	7	101	152	HVR65458.1 agmatinase [Verrucomicrobiia bacterium]	diamond	156	94	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30472953	30472953	PRJNA674048_P_NODE_24713_length_177_cov_1.007812_g24510_i0	PRJNA674048	24713	177	1.007812	1.78382724	Bacteria	2	Bacteria	Bacteria	101	2.39e-23	NR	HSY54503.1	2006848	g24510	i0	81	5.89830508474576	58	11	98.3	0	176	3	32	89	HSY54503.1 transketolase [Opitutaceae bacterium]	diamond	1044	101	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30555500	30555500	PRJNA674048_P_NODE_31173_length_164_cov_0.904348_g30970_i0	PRJNA674048	31173	164	0.904348	1.48313072	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	41.2	0.0445	NR	MBS0658504.1	2026799	g30970	i0	43.9	0.75	41	23	75	0	2	124	177	217	MBS0658504.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	123	41.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium

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