metadata: contig_metadata: 16 rows where bioproject = "PRJNA309466" and tax

16 rows where bioproject = "PRJNA309466" and tax_clade = "PVC group"

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
1651639	1651639	PRJNA309466_P_NODE_3742_length_304_cov_2.431373_g3686_i0	PRJNA309466	3742	304	2.431373	7.39137392	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	291	5.51e-74	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g3686	i0	84.211	8.50657894736842	304	42	98	4	5	303	2582826	2583128	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	2586	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
2927470	2927470	PRJNA309466_P_NODE_1443_length_608_cov_29.028623_g1398_i0	PRJNA309466	1443	608	29.028623	176.49402784	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	784	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g1398	i0	90.065	124.083881578947	614	48	99	11	1	607	1866203	1866810	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	75443	784	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
9304935	9304935	PRJNA309466_P_NODE_9448_length_203_cov_6.512987_g9391_i0	PRJNA309466	9448	203	6.512987	13.22136361	planctomycete str. 139	149588	Bacteria	Bacteria	294	2.66e-75	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g9391	i0	94.271	120.694581280788	192	11	95	0	1	192	1576	1767	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	24501	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
16954217	16954217	PRJNA309466_P_NODE_6054_length_238_cov_4.783069_g5997_i0	PRJNA309466	6054	238	4.783069	11.38370422	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	313	8.88e-81	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g5997	i0	90.756	198.504201680672	238	17	99	5	2	236	1829908	1830143	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	47244	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
20778422	20778422	PRJNA309466_P_NODE_8697_length_209_cov_4.018750_g8640_i0	PRJNA309466	8697	209	4.01875	8.3991875	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	278	2.78e-70	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g8640	i0	91.919	375.622009569378	198	16	95	0	1	198	3095669	3095472	Pirellula sp. SH-Sr6A, complete genome	blastn	78505	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
24602916	24602916	PRJNA309466_P_NODE_4640_length_267_cov_2.940367_g4584_i0	PRJNA309466	4640	267	2.940367	7.85077989	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	405	1.63e-108	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g4584	i0	95.294	103.007490636704	255	12	96	0	9	263	1867071	1866817	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	27503	405	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
26757597	26757597	PRJNA309466_P_NODE_14941_length_171_cov_2.360656_g14884_i0	PRJNA309466	14941	171	2.360656	4.03672176	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	86.3	2.08e-18	NR	MFM9963103.1	2026779	g14884	i0	73.9	4.03508771929825	46	12	80.7	0	140	3	2	47	MFM9963103.1 phage Gp37/Gp68 family protein [Planctomycetaceae bacterium]	diamond	690	86.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
26821250	26821250	PRJNA309466_P_NODE_18141_length_162_cov_0.920354_g18084_i0	PRJNA309466	18141	162	0.920354	1.49097348	Candidatus Auribacterota bacterium	2093365	Bacteria	Bacteria	43.9	0.00505	NR	MCX6348641.1	2093365	g18084	i0	43.2	0.685185185185185	37	17	68.5	1	138	28	167	199	MCX6348641.1 alanine--tRNA ligase [Candidatus Auribacterota bacterium]	diamond	111	43.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Auribacterota					Candidatus Auribacterota bacterium
27692338	27692338	PRJNA309466_P_NODE_19804_length_152_cov_2.019417_g19747_i0	PRJNA309466	19804	152	2.019417	3.06951384	Pseudomonadati	3379134	Bacteria	Bacteria	73.2	2.81e-15	NR	MFH1226526.1	2026780	g19747	i0	70.2	3.71052631578947	47	14	92.8	0	12	152	17	63	MFH1226526.1 nucleotide pyrophosphohydrolase [Planctomycetota bacterium]	diamond	564	73.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27706438	27706438	PRJNA309466_P_NODE_11844_length_187_cov_1.876812_g11787_i0	PRJNA309466	11844	187	1.876812	3.50963844	Waddlia chondrophila	71667	Bacteria	Bacteria	51.2	6.46e-7	NR	WP_282954073.1	71667	g11787	i0	88	1.29946524064171	25	3	40.1	0	123	49	1	25	WP_282954073.1 hypothetical protein [Waddlia chondrophila]	diamond	243	51.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
29853182	29853182	PRJNA309466_P_NODE_12771_length_182_cov_1.759398_g12714_i0	PRJNA309466	12771	182	1.759398	3.20210436	Akkermansia muciniphila	239935	Bacteria	Bacteria	53.9	1.78e-6	NR	WP_306701351.1	239935	g12714	i0	51.1	4.56593406593407	45	22	74.2	0	3	137	183	227	WP_306701351.1 phage terminase large subunit family protein [Akkermansia muciniphila]	diamond	831	53.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
31591424	31591424	PRJNA309466_P_NODE_4496_length_271_cov_8.423423_g4440_i0	PRJNA309466	4496	271	8.423423	22.82747633	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	45.8	0.00358	NR	HEY4813219.1	2201154	g4440	i0	34.3	0.774907749077491	70	45	76.4	1	49	255	89	158	HEY4813219.1 peptidase E [Chthoniobacterales bacterium]	diamond	210	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31654312	31654312	PRJNA309466_P_NODE_17617_length_163_cov_1.394737_g17560_i0	PRJNA309466	17617	163	1.394737	2.27342131	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	82.4	2.87e-18	NR	MDI9320589.1	2052180	g17560	i0	76.9	0.957055214723926	52	12	95.7	0	5	160	81	132	MDI9320589.1 hypothetical protein [Phycisphaerales bacterium]	diamond	156	82.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32224063	32224063	PRJNA309466_P_NODE_17078_length_164_cov_6.200000_g17021_i0	PRJNA309466	17078	164	6.2	10.168	Luteolibacter marinus	2776705	Bacteria	Bacteria	62.8	1.25e-10	NR	WP_193214802.1	2776705	g17021	i0	55.6	0.823170731707317	45	20	82.3	0	156	22	92	136	WP_193214802.1 hypothetical protein [Luteolibacter marinus]	diamond	135	62.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter marinus
32382222	32382222	PRJNA309466_P_NODE_10099_length_199_cov_1.253333_g10042_i0	PRJNA309466	10099	199	1.253333	2.49413267	Verrucomicrobiota bacterium JB023	3064552	Bacteria	Bacteria	42	0.0386	NR	MDP0490338.1	3064552	g10042	i0	39.7	0.874371859296482	58	33	87.4	1	10	183	162	217	MDP0490338.1 DMT family transporter [Verrucomicrobiota bacterium JB023]	diamond	174	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium JB023
32666390	32666390	PRJNA309466_P_NODE_8280_length_213_cov_4.481707_g8223_i0	PRJNA309466	8280	213	4.481707	9.54603591	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	42	0.0489	NR	HUJ72028.1	2499141	g8223	i0	39.7	0.887323943661972	63	33	88.7	2	7	195	154	211	HUJ72028.1 tetratricopeptide repeat protein [Verrucomicrobiia bacterium]	diamond	189	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;