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

12 rows where bioproject = "PRJNA1063685" and tax_phylum = "Gemmatimonadota"

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
1454028	1454028	PRJNA1063685_S_NODE_13662_length_578_cov_5.924752_g13141_i0	PRJNA1063685	13662	578	5.924752	34.24506656	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	715	0	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g13141	i0	89.157	84.719723183391	581	53	99	8	1	576	3486147	3485572	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	48968	715	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5282537	5282537	PRJNA1063685_S_NODE_5605_length_715_cov_14.691589_g5147_i0	PRJNA1063685	5605	715	14.691589	105.04486135	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	870	0	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g5147	i0	88.828	248.383216783217	725	60	99	18	1	713	3486287	3485572	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	177594	870	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11658076	11658076	PRJNA1063685_S_NODE_28370_length_441_cov_3.114130_g27829_i0	PRJNA1063685	28370	441	3.11413	13.7333133	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	499	1.27e-136	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g27829	i0	88.443	42.3605442176871	424	35	94	12	1	416	3042722	3042305	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	18681	499	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
15482655	15482655	PRJNA1063685_S_NODE_74233_length_241_cov_2.857143_g73690_i0	PRJNA1063685	74233	241	2.857143	6.88571463	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	337	5.35e-88	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g73690	i0	92.05	151.278008298755	239	19	100	0	1	239	5292644	5292882	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	36458	337	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
28141234	28141234	PRJNA1063685_S_NODE_65385_length_263_cov_1.621053_g64842_i0	PRJNA1063685	65385	263	1.621053	4.26336939	Gemmatimonas sp.	1962908	Bacteria	Bacteria	96.3	9.41e-22	NR	MQA90154.1	1962908	g64842	i0	55.7	4.03802281368821	88	33	99.2	2	1	261	173	255	MQA90154.1 pirin family protein [Gemmatimonas sp.]	diamond	1062	96.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
28330339	28330339	PRJNA1063685_S_NODE_69706_length_251_cov_0.865169_g69163_i0	PRJNA1063685	69706	251	0.865169	2.17157419	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	79.3	5.31e-15	NR	MDX1567991.1	2910168	g69163	i0	40.2	0.9800796812749	82	49	98	0	247	2	235	316	MDX1567991.1 sulfate permease [Longimicrobiales bacterium]	diamond	246	79.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
30248645	30248645	PRJNA1063685_S_NODE_58012_length_287_cov_2.224299_g57469_i0	PRJNA1063685	58012	287	2.224299	6.38373813	FCB group	1783270	Bacteria	Bacteria	56.2	1.13e-6	NR	OLC69051.1	1805193	g57469	i0	61.4	2.96864111498258	44	17	46	0	273	142	124	167	OLC69051.1 MAG: hypothetical protein AUH78_24905 [Gemmatimonadetes bacterium 13_1_40CM_4_69_8]	diamond	852	56.6	0.992932862190813	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium 13_1_40CM_4_69_8
30762286	30762286	PRJNA1063685_S_NODE_53194_length_305_cov_2.655172_g52651_i0	PRJNA1063685	53194	305	2.655172	8.0982746	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	128	1.9e-35	NR	HWL40450.1	2026741	g52651	i0	71.3	1.58360655737705	80	23	78.7	0	243	4	6	85	HWL40450.1 nuclear transport factor 2 family protein [Gemmatimonadaceae bacterium]	diamond	483	128	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30817127	30817127	PRJNA1063685_S_NODE_1894_length_919_cov_8.812057_g1571_i0	PRJNA1063685	1894	919	8.812057	80.98280383	Pseudomonadati	3379134	Bacteria	Bacteria	263	1.1999999999999997e-82	NR	MDB4890106.1	2026742	g1571	i0	51.7	15.8552774755169	288	127	91.7	2	1	843	53	335	MDB4890106.1 NADP-dependent oxidoreductase domain protein [Gemmatimonadota bacterium]	diamond	14571	263	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32280297	32280297	PRJNA1063685_S_NODE_16759_length_542_cov_7.371002_g16227_i0	PRJNA1063685	16759	542	7.371002	39.95083084	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	127	3.07e-30	NR	MCH7715181.1	2026742	g16227	i0	39.7	2.00922509225092	184	95	95.2	2	8	523	484	663	MCH7715181.1 oligopeptide transporter, OPT family [Gemmatimonadota bacterium]	diamond	1089	127	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32525305	32525305	PRJNA1063685_S_NODE_64719_length_265_cov_1.302083_g64176_i0	PRJNA1063685	64719	265	1.302083	3.45051995	FCB group	1783270	Bacteria	Bacteria	52.8	1.43e-5	NR	MEJ2216291.1	2026742	g64176	i0	55.1	0.99622641509434	49	21	54.3	1	235	92	406	454	MEJ2216291.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	264	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32565168	32565168	PRJNA1063685_S_NODE_37139_length_384_cov_1.620579_g36596_i0	PRJNA1063685	37139	384	1.620579	6.22302336	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	61.2	5.95e-8	NR	HTL04498.1	2448054	g36596	i0	41.6	2.3671875	77	42	60.2	2	382	152	37	110	HTL04498.1 Ig-like domain-containing protein [Gemmatimonadales bacterium]	diamond	909	61.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales 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);;