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

9 rows where bioproject = "PRJNA498309", tax_clade = "FCB group" and tax_phylum = "Chlorobiota"

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_species
3660128	3660128	PRJNA498309_P_NODE_58483_length_334_cov_4.919192_g56335_i0	PRJNA498309	58483	334	4.919192	16.43010128	Chlorobi bacterium NICIL-2	1662223	Bacteria	Bacteria	162	1.36e-45	NR	KXB98655.1	1662223	g56335	i0	95.1	1.45508982035928	81	4	72.8	0	9	251	197	277	KXB98655.1 MAG: ATP-dependent Clp protease ATP-binding subunit ClpX [Chlorobi bacterium NICIL-2]	diamond	486	162	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobi bacterium NICIL-2
18331895	18331895	PRJNA498309_P_NODE_14875_length_765_cov_33.862637_g13242_i0	PRJNA498309	14875	765	33.862637	259.04917305	Chlorobi bacterium NICIL-2	1662223	Bacteria	Bacteria	241	1.73e-74	NR	KXB96970.1	1662223	g13242	i0	95.1	0.47843137254902	122	6	47.8	0	13	378	266	387	KXB96970.1 MAG: hypothetical protein AA908_09310 [Chlorobi bacterium NICIL-2]	diamond	366	241	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobi bacterium NICIL-2
20882772	20882772	PRJNA498309_P_NODE_44037_length_411_cov_2.427807_g41912_i0	PRJNA498309	44037	411	2.427807	9.97828677	Chlorobi bacterium NICIL-2	1662223	Bacteria	Bacteria	235	2.77e-74	NR	KXB97918.1	1662223	g41912	i0	89.8	0.934306569343066	128	13	93.4	0	410	27	175	302	KXB97918.1 MAG: hypothetical protein AA908_00425 [Chlorobi bacterium NICIL-2]	diamond	384	235	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobi bacterium NICIL-2
27203211	27203211	PRJNA498309_P_NODE_38762_length_446_cov_1.948655_g36683_i0	PRJNA498309	38762	446	1.948655	8.6910013	Chlorobi bacterium NICIL-2	1662223	Bacteria	Bacteria	226	8.18e-73	NR	KXB97019.1	1662223	g36683	i0	78.7	1.89686098654709	141	28	94.8	1	441	19	12	150	KXB97019.1 MAG: hypothetical protein AA908_08735 [Chlorobi bacterium NICIL-2]	diamond	846	226	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobi bacterium NICIL-2
27266704	27266704	PRJNA498309_P_NODE_45963_length_399_cov_8.505525_g43829_i0	PRJNA498309	45963	399	8.505525	33.93704475	Chlorobiota bacterium	2268192	Bacteria	Bacteria	75.5	7.41e-13	NR	NPA33482.1	2268192	g43829	i0	59.6	0.428571428571429	57	22	42.1	1	292	125	157	213	NPA33482.1 hypothetical protein [Chlorobiota bacterium]	diamond	171	75.5	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiota bacterium
27424922	27424922	PRJNA498309_P_NODE_41243_length_428_cov_26.127877_g39132_i0	PRJNA498309	41243	428	26.127877	111.82731356	Chlorobi bacterium NICIL-2	1662223	Bacteria	Bacteria	264	8.610000000000001e-79	NR	KXB98639.1	1662223	g39132	i0	95.5	0.925233644859813	132	4	91.1	1	21	410	280	411	KXB98639.1 MAG: hypothetical protein AA908_04470 [Chlorobi bacterium NICIL-2]	diamond	396	264	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobi bacterium NICIL-2
28403472	28403472	PRJNA498309_P_NODE_25346_length_572_cov_5.637383_g23407_i0	PRJNA498309	25346	572	5.637383	32.24583076	Chlorobi bacterium NICIL-2	1662223	Bacteria	Bacteria	239	2.6e-76	NR	KXB97608.1	1662223	g23407	i0	90.2	0.697552447552448	133	13	69.8	0	564	166	48	180	KXB97608.1 MAG: hypothetical protein AA908_05640 [Chlorobi bacterium NICIL-2]	diamond	399	239	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobi bacterium NICIL-2
29982241	29982241	PRJNA498309_P_NODE_24111_length_587_cov_30.805455_g22198_i0	PRJNA498309	24111	587	30.805455	180.82802085	Chlorobi bacterium NICIL-2	1662223	Bacteria	Bacteria	339	1.77e-105	NR	KXB97521.1	1662223	g22198	i0	90.2	0.93526405451448	183	18	93.5	0	571	23	775	957	KXB97521.1 MAG: hypothetical protein AA908_06595 [Chlorobi bacterium NICIL-2]	diamond	549	339	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobi bacterium NICIL-2
30203133	30203133	PRJNA498309_P_NODE_16672_length_719_cov_6.073314_g14969_i0	PRJNA498309	16672	719	6.073314	43.66712766	Chlorobi bacterium NICIL-2	1662223	Bacteria	Bacteria	256	4.0499999999999996e-82	NR	KXB96977.1	1662223	g14969	i0	79	0.876216968011127	210	44	87.6	0	81	710	1	210	KXB96977.1 MAG: hypothetical protein AA908_09345 [Chlorobi bacterium NICIL-2]	diamond	630	256	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobi bacterium NICIL-2

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