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

10 rows where bioproject = "PRJNA505329" 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
1110332	1110332	PRJNA505329_P_NODE_33641_length_182_cov_1.263158_g33170_i0	PRJNA505329	33641	182	1.263158	2.29894756	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	108	4.33e-27	NR	MDQ3522939.1	2026742	g33170	i0	86.7	1.97802197802198	60	8	98.9	0	2	181	136	195	MDQ3522939.1 IS3 family transposase [Gemmatimonadota bacterium]	diamond	360	108	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
2385841	2385841	PRJNA505329_P_NODE_29342_length_188_cov_2.208633_g28871_i0	PRJNA505329	29342	188	2.208633	4.15223004	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	82.8	7.65e-17	NR	HEX6104385.1	2448054	g28871	i0	56.5	1.3563829787234	85	3	81.4	1	154	2	1	85	HEX6104385.1 XdhC family protein [Gemmatimonadales bacterium]	diamond	255	82.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
9411521	9411521	PRJNA505329_P_NODE_35668_length_178_cov_3.178295_g35197_i0	PRJNA505329	35668	178	3.178295	5.6573651	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g35197	i0	96.97	0.52247191011236	33	1	19	0	1	33	4068852	4068884	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	93	56.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9411628	9411628	PRJNA505329_P_NODE_44908_length_166_cov_2.564103_g44437_i0	PRJNA505329	44908	166	2.564103	4.25641098	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	87.4	9.94e-19	NR	HSD33230.1	2448054	g44437	i0	80.4	5.25903614457831	51	10	92.2	0	155	3	19	69	HSD33230.1 IS481 family transposase [Gemmatimonadales bacterium]	diamond	873	87.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
10686973	10686973	PRJNA505329_P_NODE_18029_length_214_cov_2.157576_g17558_i0	PRJNA505329	18029	214	2.157576	4.61721264	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	302	1.7e-77	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g17558	i0	92.453	323.92523364486	212	14	99	2	1	211	1902278	1902488	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	69320	302	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15785947	15785947	PRJNA505329_P_NODE_21453_length_201_cov_3.125000_g20982_i0	PRJNA505329	21453	201	3.125	6.28125	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	198	2.12e-46	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g20982	i0	84.793	134.582089552239	217	12	98	4	1	196	131142	131358	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	27051	198	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
28466808	28466808	PRJNA505329_P_NODE_14366_length_233_cov_2.766304_g13895_i0	PRJNA505329	14366	233	2.766304	6.44548832	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	66.2	1.68e-10	NR	MBK8246937.1	2026742	g13895	i0	100	0.412017167381974	32	0	41.2	0	230	135	362	393	MBK8246937.1 PQQ-binding-like beta-propeller repeat protein [Gemmatimonadota bacterium]	diamond	96	66.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28703227	28703227	PRJNA505329_P_NODE_44847_length_166_cov_2.632479_g44376_i0	PRJNA505329	44847	166	2.632479	4.36991514	Bacteria	2	Bacteria	Bacteria	40.4	0.0246	NR	HEU4565390.1	2026741	g44376	i0	44.4	4.1566265060241	45	25	81.3	0	6	140	41	85	HEU4565390.1 CPXCG motif-containing cysteine-rich protein [Gemmatimonadaceae bacterium]	diamond	690	40.8	0.990196078431373	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29950759	29950759	PRJNA505329_P_NODE_24211_length_196_cov_3.857143_g23740_i0	PRJNA505329	24211	196	3.857143	7.56000028	Gemmatimonas sp.	1962908	Bacteria	Bacteria	65.9	1.43e-10	NR	MQA90924.1	1962908	g23740	i0	67.4	0.704081632653061	46	15	70.4	0	58	195	785	830	MQA90924.1 helicase [Gemmatimonas sp.]	diamond	138	65.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
30361897	30361897	PRJNA505329_P_NODE_27492_length_191_cov_1.443662_g27021_i0	PRJNA505329	27492	191	1.443662	2.75739442	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	117	1.18e-28	NR	MBP2646843.1	2026742	g27021	i0	95.2	0.989528795811518	63	3	99	0	1	189	1	63	MBP2646843.1 Threonyl-tRNA synthetase [Gemmatimonadota bacterium]	diamond	189	117	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;