metadata: contig_metadata: 9 rows where bioproject = "PRJNA293022", tax_clade = "FCB group" and tax

9 rows where bioproject = "PRJNA293022", 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
373463	373463	PRJNA293022_P_NODE_79681_length_162_cov_0.920354_g78944_i0	PRJNA293022	79681	162	0.920354	1.49097348	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	220	3.49e-53	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g78944	i0	91.358	8.50617283950617	162	12	99	2	1	161	172427	172267	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	1378	220	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5476941	5476941	PRJNA293022_P_NODE_75845_length_164_cov_0.904348_g75108_i0	PRJNA293022	75845	164	0.904348	1.48313072	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	257	2.7e-64	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g75108	i0	95.092	42.7317073170732	163	8	99	0	2	164	1592852	1592690	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	7008	257	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10577310	10577310	PRJNA293022_P_NODE_60709_length_178_cov_2.131783_g59972_i0	PRJNA293022	60709	178	2.131783	3.79457374	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	279	6.35e-71	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g59972	i0	95.429	11.6685393258427	175	8	98	0	4	178	2076169	2075995	Gemmatimonas phototrophica strain AP64, complete genome	blastn	2077	279	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
11262874	11262874	PRJNA293022_P_NODE_49049_length_199_cov_1.393333_g48312_i0	PRJNA293022	49049	199	1.393333	2.77273267	Gemmatimonas	173479	Bacteria	Bacteria	287	4.35e-73	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g48312	i0	92.893	14.608040201005	197	14	99	0	1	197	1107	911	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	2907	287	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
14402243	14402243	PRJNA293022_P_NODE_47912_length_201_cov_3.059211_g47175_i0	PRJNA293022	47912	201	3.059211	6.14901411	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	309	9.39e-80	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g47175	i0	94.5	78.4776119402985	200	11	99	0	2	201	2075191	2074992	Gemmatimonas phototrophica strain AP64, complete genome	blastn	15774	309	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
18224851	18224851	PRJNA293022_P_NODE_16095_length_356_cov_1.335505_g15358_i0	PRJNA293022	16095	356	1.335505	4.7543978	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	486	7.79e-133	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g15358	i0	91.977	194.733146067416	349	24	97	4	10	356	2076174	2076520	Gemmatimonas phototrophica strain AP64, complete genome	blastn	69325	486	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
20774645	20774645	PRJNA293022_P_NODE_17197_length_344_cov_1.637288_g16460_i0	PRJNA293022	17197	344	1.637288	5.63227072	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	102	3.19e-17	NTclustered	gi\|2531976023\|emb\|OY282356.1\|	2026742	g16460	i0	91.026	222.226744186047	78	4	22	3	1	76	758	682	MAG: Gemmatimonadota bacterium genome assembly, chromosome: 1	blastn	76446	102	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
24599494	24599494	PRJNA293022_P_NODE_67060_length_169_cov_1.716667_g66323_i0	PRJNA293022	67060	169	1.716667	2.90116723	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	126	8.2e-25	NTclustered	gi\|2893358411\|emb\|OZ220702.1\|	2910168	g66323	i0	85.484	98.0177514792899	124	14	72	4	4	125	1324200	1324079	MAG: Longimicrobiales bacterium isolate 5c038fdb-8e0b-4cbd-9550-43be1afc0bbf genome assembly, chromosome: 1	blastn	16565	126	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
30453577	30453577	PRJNA293022_P_NODE_22413_length_300_cov_1.645418_g21676_i0	PRJNA293022	22413	300	1.645418	4.936254	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	43.1	0.0482	NR	HEX5634159.1	2448054	g21676	i0	33.3	0.66	66	39	66	1	4	201	74	134	HEX5634159.1 cytochrome c oxidase assembly protein [Gemmatimonadales bacterium]	diamond	198	43.1	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);;