metadata: contig_metadata: 11 rows where bioproject = "PRJNA890871" and tax

11 rows where bioproject = "PRJNA890871" 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
865112	865112	PRJNA890871_P_NODE_71501_length_247_cov_1.574713_g71366_i0	PRJNA890871	71501	247	1.574713	3.88954111	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	69.4	2.22e-7	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g71366	i0	81.928	0.336032388663968	83	13	33	2	7	88	2458717	2458798	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	83	69.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
2140474	2140474	PRJNA890871_P_NODE_70162_length_248_cov_0.880000_g70027_i0	PRJNA890871	70162	248	0.88	2.1824	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	381	2.519999999999999e-101	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g70027	i0	94.355	70.6088709677419	248	14	100	0	1	248	3905743	3905496	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	17511	381	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
4693390	4693390	PRJNA890871_P_NODE_65484_length_250_cov_0.870056_g65349_i0	PRJNA890871	65484	250	0.870056	2.17514	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	173	2.04e-48	NR	MBL8961854.1	2026742	g65349	i0	91.6	0.996	83	7	99.6	0	250	2	501	583	MBL8961854.1 ABC-2 transporter permease [Gemmatimonadota bacterium]	diamond	249	173	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
5967746	5967746	PRJNA890871_P_NODE_40165_length_282_cov_1.244019_g40030_i0	PRJNA890871	40165	282	1.244019	3.50813358	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	135	2.5100000000000004e-27	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g40030	i0	91	2.62056737588652	100	9	35	0	174	273	4674697	4674796	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	739	135	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
11067665	11067665	PRJNA890871_P_NODE_29349_length_313_cov_2.483333_g29214_i0	PRJNA890871	29349	313	2.483333	7.77283229	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	110	9.96e-28	NR	MBA3672972.1	2026741	g29214	i0	55.6	1.03514376996805	108	43	99.7	3	2	313	57	163	MBA3672972.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	324	110	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
20369109	20369109	PRJNA890871_P_NODE_80036_length_243_cov_2.200000_g79901_i0	PRJNA890871	80036	243	2.2	5.346	Gemmatimonas	173479	Bacteria	Bacteria	75	4.67e-9	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g79901	i0	86.111	14.917695473251	72	7	29	2	164	233	515360	515290	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	3625	75	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
27087239	27087239	PRJNA890871_P_NODE_62922_length_251_cov_0.865169_g62787_i0	PRJNA890871	62922	251	0.865169	2.17157419	Longimicrobium sp.	2029185	Bacteria	Bacteria	72.8	3.31e-13	NR	HEX9940226.1	2029185	g62787	i0	64.4	0.537848605577689	45	16	53.8	0	141	7	4	48	HEX9940226.1 isochorismatase family cysteine hydrolase [Longimicrobium sp.]	diamond	135	72.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
27149920	27149920	PRJNA890871_P_NODE_29202_length_314_cov_1.597510_g29067_i0	PRJNA890871	29202	314	1.59751	5.0161814	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	44.3	0.0204	NR	HEU4700501.1	2448054	g29067	i0	32.4	0.64968152866242	68	46	65	0	111	314	180	247	HEU4700501.1 SAM-dependent chlorinase/fluorinase [Gemmatimonadales bacterium]	diamond	204	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27687775	27687775	PRJNA890871_P_NODE_66184_length_250_cov_0.870056_g66049_i0	PRJNA890871	66184	250	0.870056	2.17514	Longimicrobium sp.	2029185	Bacteria	Bacteria	115	1.18e-28	NR	HEX8430915.1	2029185	g66049	i0	98.4	0.768	64	1	76.8	0	58	249	1	64	HEX8430915.1 hypothetical protein [Longimicrobium sp.]	diamond	192	115	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
29613053	29613053	PRJNA890871_P_NODE_52950_length_262_cov_3.010582_g52815_i0	PRJNA890871	52950	262	3.010582	7.88772484	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	104	2.41e-25	NR	MBK8249898.1	2026742	g52815	i0	75.7	0.801526717557252	70	17	80.2	0	210	1	1	70	MBK8249898.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	210	104	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30718949	30718949	PRJNA890871_P_NODE_27934_length_319_cov_2.764228_g27799_i0	PRJNA890871	27934	319	2.764228	8.81788732	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	114	6.12e-29	NR	TVP57081.1	2448054	g27799	i0	52.4	4.81504702194357	105	49	97.8	1	8	319	30	134	TVP57081.1 MAG: pyridoxamine 5'-phosphate oxidase [Gemmatimonadales bacterium]	diamond	1536	114	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);;