metadata: contig_metadata: 6 rows where bioproject = "PRJNA255848", tax_clade = "FCB group" and tax

6 rows where bioproject = "PRJNA255848", 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
1643458	1643458	PRJNA255848_P_NODE_26422_length_194_cov_1.020690_g26104_i0	PRJNA255848	26422	194	1.02069	1.9801386	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	248	1.99e-61	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g26104	i0	92.045	2.70103092783505	176	14	91	0	1	176	802237	802062	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	524	248	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9296669	9296669	PRJNA255848_P_NODE_18328_length_232_cov_2.672131_g18010_i0	PRJNA255848	18328	232	2.672131	6.19934392	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	313	8.62e-81	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g18010	i0	90.948	165.103448275862	232	21	100	0	1	232	1104420	1104189	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	38304	313	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
10572659	10572659	PRJNA255848_P_NODE_11249_length_306_cov_2.319066_g10931_i0	PRJNA255848	11249	306	2.319066	7.09634196	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	488	1.8399999999999996e-133	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g10931	i0	95.455	129.957516339869	308	10	100	4	1	306	1102763	1102458	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	39767	488	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
22045225	22045225	PRJNA255848_P_NODE_10098_length_327_cov_1.870504_g9780_i0	PRJNA255848	10098	327	1.870504	6.11654808	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	433	9.399999999999999e-117	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g9780	i0	90.578	34.5412844036697	329	28	100	3	1	327	1103198	1102871	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	11295	433	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
23320779	23320779	PRJNA255848_P_NODE_6279_length_437_cov_2.085052_g5961_i0	PRJNA255848	6279	437	2.085052	9.11167724	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	597	4.319999999999998e-166	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g5961	i0	91.344	30.9016018306636	439	34	100	4	1	437	1101496	1101932	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	13504	597	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
24594931	24594931	PRJNA255848_P_NODE_43420_length_163_cov_0.894737_g43102_i0	PRJNA255848	43420	163	0.894737	1.45842131	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	279	5.73e-71	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g43102	i0	97.546	114.312883435583	163	4	100	0	1	163	803977	803815	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	18633	279	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured 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);;