metadata: contig_metadata: 7 rows where bioproject = "PRJNA613025", tax_clade = "FCB group" and tax

7 rows where bioproject = "PRJNA613025", tax_clade = "FCB group" 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
6252414	6252414	PRJNA613025_S_NODE_11225_length_358_cov_1.941748_g11071_i0	PRJNA613025	11225	358	1.941748	6.95145784	Gemmatimonas	173479	Bacteria	Bacteria	573	5.849999999999999e-159	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g11071	i0	95.531	125.337988826816	358	16	100	0	1	358	1323	966	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	44871	573	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
13902694	13902694	PRJNA613025_S_NODE_19931_length_220_cov_2.678363_g19777_i0	PRJNA613025	19931	220	2.678363	5.8923986	Gemmatimonas	173479	Bacteria	Bacteria	351	1.72e-92	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g19777	i0	95.455	352.645454545455	220	10	100	0	1	220	2713	2932	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	77582	351	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
14620973	14620973	PRJNA613025_S_NODE_3432_length_912_cov_2.297798_g3315_i0	PRJNA613025	3432	912	2.297798	20.95591776	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	1430	0	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g3315	i0	95.154	385.941885964912	908	40	99	4	1	906	2075624	2074719	Gemmatimonas phototrophica strain AP64, complete genome	blastn	351979	1430	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
17726661	17726661	PRJNA613025_S_NODE_21494_length_209_cov_0.975000_g21340_i0	PRJNA613025	21494	209	0.975	2.03775	Gemmatimonas	173479	Bacteria	Bacteria	303	4.58e-78	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g21340	i0	92.857	32.8038277511962	210	13	100	2	1	209	2004	2212	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	6856	303	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
19718151	19718151	PRJNA613025_S_NODE_16116_length_262_cov_0.976526_g15962_i0	PRJNA613025	16116	262	0.976526	2.55849812	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	139	1.78e-28	NTclustered	gi\|2621703510\|emb\|OY762557.1\|	2910168	g15962	i0	80	35.1297709923664	190	36	72	2	9	197	547982	547794	MAG: Longimicrobiales bacterium isolate c10e2151-7d97-4465-9cf7-a78a4796a63d genome assembly, chromosome: 1	blastn	9204	139	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
24817874	24817874	PRJNA613025_S_NODE_15840_length_266_cov_1.645161_g15686_i0	PRJNA613025	15840	266	1.645161	4.37612826	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	337	6e-88	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g15686	i0	89.552	79.5	268	24	100	4	1	266	2076498	2076233	Gemmatimonas phototrophica strain AP64, complete genome	blastn	21147	337	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
29322253	29322253	PRJNA613025_S_NODE_17009_length_250_cov_2.751244_g16855_i0	PRJNA613025	17009	250	2.751244	6.87811	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	42.4	0.0489	NR	MFI5249647.1	2448054	g16855	i0	36.5	0.888	74	40	81.6	2	250	47	94	166	MFI5249647.1 SDR family oxidoreductase [Gemmatimonadales bacterium]	diamond	222	42.4	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);;