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

9 rows where bioproject = "PRJNA395690", 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
9339934	9339934	PRJNA395690_P_NODE_36528_length_159_cov_2.445455_g36376_i0	PRJNA395690	36528	159	2.445455	3.88827345	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	215	1.59e-51	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g36376	i0	91.195	38.6289308176101	159	13	99	1	1	158	2075338	2075496	Gemmatimonas phototrophica strain AP64, complete genome	blastn	6142	215	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
10615313	10615313	PRJNA395690_P_NODE_11089_length_244_cov_2.051282_g10937_i0	PRJNA395690	11089	244	2.051282	5.00512808	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	102	2.15e-17	NTclustered	gi\|2575820295\|emb\|OY730414.1\|	2910168	g10937	i0	84.112	53.2172131147541	107	15	43	2	11	116	1273586	1273691	MAG: Longimicrobiales bacterium isolate 35361606-ee58-41ba-9638-b7483a57a1ce genome assembly, chromosome: 1	blastn	12985	102	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
11890617	11890617	PRJNA395690_P_NODE_37010_length_154_cov_3.314286_g36857_i0	PRJNA395690	37010	154	3.314286	5.10400044	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	139	9.43e-29	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g36857	i0	88.034	107.025974025974	117	14	76	0	38	154	806351	806467	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	16482	139	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
21480736	21480736	PRJNA395690_P_NODE_31477_length_165_cov_0.879310_g31325_i0	PRJNA395690	31477	165	0.87931	1.4508615	Gemmatimonas	173479	Bacteria	Bacteria	294	2.08e-75	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g31325	i0	98.788	34.1333333333333	165	2	100	0	1	165	969	1133	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	5632	294	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
27580769	27580769	PRJNA395690_P_NODE_10284_length_254_cov_0.995122_g10132_i0	PRJNA395690	10284	254	0.995122	2.52760988	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	43.5	0.0231	NR	HEY8063046.1	2448054	g10132	i0	46	0.590551181102362	50	20	50.8	2	216	88	627	676	HEY8063046.1 protein kinase [Gemmatimonadales bacterium]	diamond	150	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28559802	28559802	PRJNA395690_P_NODE_27347_length_169_cov_1.325000_g27195_i0	PRJNA395690	27347	169	1.325	2.23925	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	95.9	3.87e-22	NR	MBA3759289.1	2448054	g27195	i0	97.9	1.70414201183432	48	1	85.2	0	145	2	1	48	MBA3759289.1 CDP-diacylglycerol--serine O-phosphatidyltransferase [Gemmatimonadales bacterium]	diamond	288	95.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28811954	28811954	PRJNA395690_P_NODE_36568_length_159_cov_2.154545_g36416_i0	PRJNA395690	36568	159	2.154545	3.42572655	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	43.9	0.00391	NR	HEY4659501.1	2026741	g36416	i0	49	1.92452830188679	51	19	83	2	15	146	73	123	HEY4659501.1 MFS transporter [Gemmatimonadaceae bacterium]	diamond	306	43.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30454814	30454814	PRJNA395690_P_NODE_29433_length_166_cov_1.307692_g29281_i0	PRJNA395690	29433	166	1.307692	2.17076872	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	65.9	8.87e-11	NR	HWC74330.1	2448054	g29281	i0	61.5	4.46385542168675	52	20	94	0	158	3	423	474	HWC74330.1 Ig-like domain-containing protein [Gemmatimonadales bacterium]	diamond	741	65.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30565715	30565715	PRJNA395690_P_NODE_7633_length_292_cov_1.469136_g7481_i0	PRJNA395690	7633	292	1.469136	4.28987712	Pseudomonadati	3379134	Bacteria	Bacteria	45.1	0.00851	NR	MBC7843425.1	2026741	g7481	i0	95.7	1.18150684931507	23	1	23.6	0	290	222	234	256	MBC7843425.1 type 1 glutamine amidotransferase domain-containing protein [Gemmatimonadaceae bacterium]	diamond	345	45.4	0.993392070484582	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae 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);;