metadata: contig_metadata: 12 rows where bioproject = "PRJEB12296" and tax

12 rows where bioproject = "PRJEB12296" 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
25636705	25636705	PRJEB12296_S_NODE_8890_length_178_cov_1.538462_g8858_i0	PRJEB12296	8890	178	1.538462	2.73846236	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	243	8.33e-60	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g8858	i0	92.899	64.3258426966292	169	9	94	3	12	178	2002481	2002314	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	11450	243	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
25636709	25636709	PRJEB12296_S_NODE_9082_length_177_cov_1.612676_g9050_i0	PRJEB12296	9082	177	1.612676	2.85443652	Telmatocola sphagniphila	1123043	Bacteria	Bacteria	226	8.329999999999998e-55	NTclustered	gi\|2041266541\|gb\|CP074694.1\|	1123043	g9050	i0	89.831	147.378531073446	177	16	99	2	1	176	3723819	3723994	Telmatocola sphagniphila strain SP2T chromosome, complete genome	blastn	26086	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
25908796	25908796	PRJEB12296_S_NODE_10684_length_170_cov_2.948148_g10652_i0	PRJEB12296	10684	170	2.948148	5.0118516	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	195	2.23e-45	NTclustered	gi\|2921913114\|gb\|CP182803.1\|	2026777	g10652	i0	87.719	306.841176470588	171	15	99	6	2	169	1302409	1302576	MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome	blastn	52163	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
25909072	25909072	PRJEB12296_S_NODE_9500_length_175_cov_2.335714_g9468_i0	PRJEB12296	9500	175	2.335714	4.0874995	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	243	8.15e-60	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g9468	i0	91.573	35.6742857142857	178	12	100	3	1	175	558603	558426	Gemmata sp. SH-PL17, complete genome	blastn	6243	243	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
26044970	26044970	PRJEB12296_S_NODE_1669_length_313_cov_2973.967626_g1637_i0	PRJEB12296	1669	313	2973.967626	9308.51866938	Coraliomargarita algicola	3092156	Bacteria	Bacteria	202	2.7499999999999996e-47	NTclustered	gi\|2623481368\|gb\|CP138858.1\|	3092156	g1637	i0	83.71	52.3546325878594	221	28	70	7	96	313	2458486	2458701	Coraliomargarita algicola strain J2-16 chromosome, complete genome	blastn	16387	202	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita algicola
26045099	26045099	PRJEB12296_S_NODE_5413_length_206_cov_1.087719_g5381_i0	PRJEB12296	5413	206	1.087719	2.24070114	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	248	2.14e-61	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g5381	i0	90.476	217.932038834951	189	16	91	2	18	204	2003310	2003122	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	44894	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
26045154	26045154	PRJEB12296_S_NODE_7821_length_184_cov_2.006711_g7789_i0	PRJEB12296	7821	184	2.006711	3.69234824	Limnoglobus roseus	2598579	Bacteria	Bacteria	198	1.9e-46	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g7789	i0	87.006	30.9184782608696	177	21	96	2	9	184	2958889	2958714	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	5689	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
26151297	26151297	PRJEB12296_S_NODE_325_length_515_cov_16.729167_g298_i0	PRJEB12296	325	515	16.729167	86.15521005	Synoicihabitans	2892920	Bacteria	Bacteria	388	3.38e-103	NTclustered	gi\|2891482117\|emb\|OZ219851.1\|	2026772	g298	i0	82.403	69.2	466	62	88	19	25	476	1410589	1410130	MAG: Opitutales bacterium isolate e4292735-b3b5-42df-bce3-ad3ef7a88f44 genome assembly, chromosome: 10	blastn	35638	388	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
26287266	26287266	PRJEB12296_S_NODE_2462_length_275_cov_160.741667_g2430_i0	PRJEB12296	2462	275	160.741667	442.03958425	Planctomycetaceae	126	Bacteria	Bacteria	230	1.0899999999999995e-55	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g2430	i0	86.829	41.5890909090909	205	27	75	0	50	254	1415677	1415473	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	11437	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
26453301	26453301	PRJEB12296_S_NODE_6976_length_190_cov_2.754839_g6944_i0	PRJEB12296	6976	190	2.754839	5.2341941	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	261	2.49e-65	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g6944	i0	94.643	18.1526315789474	168	9	88	0	1	168	4422720	4422887	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	3449	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
26453308	26453308	PRJEB12296_S_NODE_7272_length_188_cov_1.470588_g7240_i0	PRJEB12296	7272	188	1.470588	2.76470544	uncultured verrucomicrobium HF	723594	Bacteria	Bacteria	183	5.4799999999999996e-42	NTclustered	gi\|297170473\|gb\|GU567957.1\|	723594	g7240	i0	86.127	298.595744680851	173	20	91	4	18	188	15606	15436	Uncultured verrucomicrobium HF0070_15G23 genomic sequence	blastn	56136	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured verrucomicrobium HF0070_15G23
32942388	32942388	PRJEB12296_S_NODE_6418_length_195_cov_2.456250_g6386_i0	PRJEB12296	6418	195	2.45625	4.7896875	Planctomycetes bacterium SM23_25	1704028	Bacteria	Bacteria	42.4	0.0278	NR	KPK50769.1	1704028	g6386	i0	56.3	0.492307692307692	32	14	49.2	0	147	52	358	389	KPK50769.1 MAG: hypothetical protein AMK72_01325 [Planctomycetes bacterium SM23_25]	diamond	96	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium SM23_25

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