metadata: contig_metadata: 10 rows where bioproject = "PRJNA691918" and tax

10 rows where bioproject = "PRJNA691918" 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
1948483	1948483	PRJNA691918_S_NODE_122_length_217_cov_16133.559140_g121_i0	PRJNA691918	122	217	16133.55914	35009.8233338	Aureliella helgolandensis	2527968	Bacteria	Bacteria	187	5.04e-43	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g121	i0	85.475	299.391705069124	179	26	82	0	38	216	6999007	6998829	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	64968	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
4500492	4500492	PRJNA691918_S_NODE_224_length_191_cov_18719.943750_g223_i0	PRJNA691918	224	191	18719.94375	35755.0925625	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	263	6.97e-66	NTclustered	gi\|129563783\|gb\|EF438255.1\|	120965	g223	i0	100	75.869109947644	142	0	74	0	49	190	623	482	Uncultured planctomycete clone G1-1_72 16S ribosomal RNA gene, partial sequence	blastn	14491	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
4500497	4500497	PRJNA691918_S_NODE_64_length_245_cov_14003.957944_g63_i0	PRJNA691918	64	245	14003.957944	34309.6969628	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	244	3.4e-60	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g63	i0	87.923	24.7510204081633	207	25	84	0	2	208	3097776	3097570	Pirellula sp. SH-Sr6A, complete genome	blastn	6064	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
5007569	5007569	PRJNA691918_S_NODE_244_length_187_cov_19640.801282_g243_i0	PRJNA691918	244	187	19640.801282	36728.29839734	Gemmata	113	Bacteria	Bacteria	152	1.5299999999999998e-32	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g243	i0	86.765	114.117647058824	136	18	73	0	52	187	2941936	2941801	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	21340	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
5775985	5775985	PRJNA691918_S_NODE_25_length_284_cov_11223.498024_g24_i0	PRJNA691918	25	284	11223.498024	31874.73438816	Aureliella helgolandensis	2527968	Bacteria	Bacteria	204	6.839999999999999e-48	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g24	i0	84.112	61.3485915492958	214	30	75	3	72	283	6999040	6998829	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	17423	204	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
12151685	12151685	PRJNA691918_S_NODE_230_length_190_cov_19.477987_g229_i0	PRJNA691918	230	190	19.477987	37.0081753	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	187	4.29e-43	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g229	i0	86.127	10.3578947368421	173	24	91	0	2	174	7050234	7050406	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	1968	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14701473	14701473	PRJNA691918_S_NODE_152_length_207_cov_17421.960227_g151_i0	PRJNA691918	152	207	17421.960227	36063.45766989	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	91.6	3.84e-14	NTclustered	gi\|2874253676\|emb\|OY969110.1\|	305355	g151	i0	81.739	23.1739130434783	115	16	54	5	51	162	416036	415924	MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1	blastn	4797	91.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
22349827	22349827	PRJNA691918_S_NODE_138_length_212_cov_16959.027624_g137_i0	PRJNA691918	138	212	16959.027624	35953.13856288	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	217	6.249999999999999e-52	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g137	i0	89.881	24.4245283018868	168	17	79	0	7	174	2001627	2001794	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	5178	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24898761	24898761	PRJNA691918_S_NODE_100_length_224_cov_15524.031088_g99_i0	PRJNA691918	100	224	15524.031088	34773.82963712	Aureliella helgolandensis	2527968	Bacteria	Bacteria	246	8.51e-61	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g99	i0	90.374	30.5714285714286	187	18	83	0	38	224	6999007	6998821	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	6848	246	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
24898762	24898762	PRJNA691918_S_NODE_140_length_211_cov_17076.033333_g139_i0	PRJNA691918	140	211	17076.033333	36030.43033263	Lignipirellula cremea	2528010	Bacteria	Bacteria	139	1.38e-28	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g139	i0	81.395	23.8815165876777	172	31	82	1	2	173	1145580	1145410	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	5039	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea

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