metadata: contig_metadata: 13 rows where bioproject = "PRJNA757618" and tax

13 rows where bioproject = "PRJNA757618" 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
732473	732473	PRJNA757618_P_NODE_30581_length_251_cov_0.865169_g29529_i0	PRJNA757618	30581	251	0.865169	2.17157419	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	183	7.73e-42	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g29529	i0	79.921	1.01195219123506	254	48	100	2	1	251	787443	787696	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	254	183	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13486562	13486562	PRJNA757618_P_NODE_47471_length_242_cov_0.923077_g46419_i0	PRJNA757618	47471	242	0.923077	2.23384634	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	309	1.17e-79	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g46419	i0	89.712	34.5495867768595	243	23	100	2	1	242	3864056	3864297	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	8361	309	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
14761473	14761473	PRJNA757618_P_NODE_30212_length_251_cov_0.870787_g29160_i0	PRJNA757618	30212	251	0.870787	2.18567537	Pseudomonadati	3379134	Bacteria	Bacteria	124	1.61e-31	NR	HEU5175800.1	2026741	g29160	i0	68.4	2.78486055776892	79	25	94.4	0	250	14	45	123	HEU5175800.1 erythromycin esterase family protein [Gemmatimonadaceae bacterium]	diamond	699	124	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
21135059	21135059	PRJNA757618_P_NODE_29477_length_251_cov_0.876404_g28425_i0	PRJNA757618	29477	251	0.876404	2.19977404	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	167	7.789999999999999e-37	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g28425	i0	81.221	0.848605577689243	213	34	84	4	42	251	3440775	3440566	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	213	167	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
24959092	24959092	PRJNA757618_P_NODE_30480_length_251_cov_0.865169_g29428_i0	PRJNA757618	30480	251	0.865169	2.17157419	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	180	1e-40	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g29428	i0	86.228	5.60159362549801	167	21	66	2	1	166	4245438	4245603	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	1406	180	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
27274248	27274248	PRJNA757618_P_NODE_34323_length_249_cov_0.875000_g33271_i0	PRJNA757618	34323	249	0.875	2.17875	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	152	5.139999999999999e-42	NR	HET8713385.1	2448054	g33271	i0	93.9	0.987951807228916	82	5	98.8	0	2	247	41	122	HET8713385.1 FAD-binding oxidoreductase [Gemmatimonadales bacterium]	diamond	246	152	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28632219	28632219	PRJNA757618_P_NODE_19327_length_279_cov_2.184466_g18275_i0	PRJNA757618	19327	279	2.184466	6.09466014	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	121	7.04e-30	NR	GJG85342.1	2839016	g18275	i0	78.3	0.989247311827957	92	14	98.9	3	278	3	380	465	GJG85342.1 hypothetical protein tb265_05230 [Gemmatimonadetes bacterium T265]	diamond	276	121	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
28789721	28789721	PRJNA757618_P_NODE_34047_length_249_cov_0.880682_g32995_i0	PRJNA757618	34047	249	0.880682	2.19289818	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	86.3	1.84e-17	NR	NUP55471.1	2026741	g32995	i0	69.4	1.51807228915663	62	18	73.5	1	185	3	2	63	NUP55471.1 SusD/RagB family nutrient-binding outer membrane lipoprotein [Gemmatimonadaceae bacterium]	diamond	378	86.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30558261	30558261	PRJNA757618_P_NODE_45673_length_243_cov_0.911765_g44621_i0	PRJNA757618	45673	243	0.911765	2.21558895	Longimicrobium sp.	2029185	Bacteria	Bacteria	49.7	9.5e-5	NR	HEU0013642.1	2029185	g44621	i0	43.2	0.91358024691358	74	39	88.9	2	218	3	150	222	HEU0013642.1 hypothetical protein [Longimicrobium sp.]	diamond	222	49.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
31032680	31032680	PRJNA757618_P_NODE_35475_length_248_cov_0.891429_g34423_i0	PRJNA757618	35475	248	0.891429	2.21074392	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	106	1.5e-25	NR	HEX9892793.1	2448054	g34423	i0	58.4	0.931451612903226	77	32	93.1	0	6	236	153	229	HEX9892793.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	231	106	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31864236	31864236	PRJNA757618_P_NODE_24057_length_261_cov_1.382979_g23005_i0	PRJNA757618	24057	261	1.382979	3.60957519	Pseudomonadati	3379134	Bacteria	Bacteria	142	2.83e-38	NR	HKW41145.1	2448054	g23005	i0	75.6	4.94252873563218	86	21	98.9	0	259	2	277	362	HKW41145.1 IS1182 family transposase [Gemmatimonadales bacterium]	diamond	1290	143	0.993006993006993	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32044456	32044456	PRJNA757618_P_NODE_47858_length_242_cov_0.917160_g46806_i0	PRJNA757618	47858	242	0.91716	2.2195272	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	128	2.88e-36	NR	MEO7137140.1	2448054	g46806	i0	77.2	1.95867768595041	79	18	97.9	0	242	6	14	92	MEO7137140.1 four helix bundle protein [Gemmatimonadales bacterium]	diamond	474	128	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32275972	32275972	PRJNA757618_P_NODE_26718_length_253_cov_0.866667_g25666_i0	PRJNA757618	26718	253	0.866667	2.19266751	Pseudomonadati	3379134	Bacteria	Bacteria	116	1.72e-28	NR	MEW5917188.1	2026742	g25666	i0	62.7	7.79051383399209	83	31	98.4	0	249	1	16	98	MEW5917188.1 FAD-binding oxidoreductase [Gemmatimonadota bacterium]	diamond	1971	117	0.991452991452991	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);;