metadata: contig_metadata: 8 rows where bioproject = "PRJNA771359" and tax

8 rows where bioproject = "PRJNA771359" 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
1206705	1206705	PRJNA771359_S_NODE_1001_length_328_cov_3.941581_g918_i0	PRJNA771359	1001	328	3.941581	12.92838568	Gemmatimonas	173479	Bacteria	Bacteria	350	9.77e-92	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g918	i0	86.322	615.271341463415	329	35	98	9	6	327	1582	1907	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	201809	350	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
3298249	3298249	PRJNA771359_S_NODE_3483_length_180_cov_2.328671_g3400_i0	PRJNA771359	3483	180	2.328671	4.1916078	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	209	8.56e-50	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g3400	i0	87.709	302.694444444444	179	22	99	0	2	180	421701	421523	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	54485	209	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
7125738	7125738	PRJNA771359_S_NODE_1406_length_286_cov_4.128514_g1323_i0	PRJNA771359	1406	286	4.128514	11.80755004	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	298	3.07e-76	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g1323	i0	86.022	19.3006993006993	279	37	97	2	5	282	1102759	1103036	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	5520	298	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
8400307	8400307	PRJNA771359_S_NODE_947_length_334_cov_2.451178_g864_i0	PRJNA771359	947	334	2.451178	8.18693452	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	518	2.58e-142	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g864	i0	94.627	38.5389221556886	335	16	100	2	1	334	3043244	3043577	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	12872	518	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
18598840	18598840	PRJNA771359_S_NODE_995_length_329_cov_2.500000_g912_i0	PRJNA771359	995	329	2.5	8.225	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	390	5.779999999999999e-104	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g912	i0	88.45	7.06382978723404	329	31	100	2	1	329	3043662	3043983	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	2324	390	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
19873839	19873839	PRJNA771359_S_NODE_4476_length_160_cov_2.544715_g4393_i0	PRJNA771359	4476	160	2.544715	4.071544	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	213	5.75e-51	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g4393	i0	91.613	125.03125	155	12	97	1	6	160	232524	232371	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	20005	213	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
22884455	22884455	PRJNA771359_S_NODE_1778_length_251_cov_5.757009_g1695_i0	PRJNA771359	1778	251	5.757009	14.45009259	Gemmatimonas	173479	Bacteria	Bacteria	331	2.6100000000000006e-86	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g1695	i0	90.551	111.808764940239	254	19	99	4	3	251	571	318	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	28064	331	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
25433406	25433406	PRJNA771359_S_NODE_2400_length_216_cov_4.296089_g2317_i0	PRJNA771359	2400	216	4.296089	9.27955224	Gemmatimonas	173479	Bacteria	Bacteria	226	1.0599999999999999e-54	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g2317	i0	87	12.0185185185185	200	26	93	0	16	215	299	100	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	2596	226	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca

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