metadata: contig_metadata: 10 rows where bioproject = "PRJNA635397", tax_phylum = "Chloroflexota" and tax

10 rows where bioproject = "PRJNA635397", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27175556	27175556	PRJNA635397_P_NODE_42982_length_247_cov_0.885057_g42528_i0	PRJNA635397	42982	247	0.885057	2.18609079	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	129	1.9299999999999998e-32	NR	HEU0235307.1	2952938	g42528	i0	81.6	7.38461538461539	76	14	92.3	0	2	229	434	509	HEU0235307.1 excinuclease ABC subunit UvrA [Candidatus Limnocylindrales bacterium]	diamond	1824	129	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
27207116	27207116	PRJNA635397_P_NODE_13662_length_454_cov_2.412073_g13208_i0	PRJNA635397	13662	454	2.412073	10.95081142	Anaerolineae bacterium	2052143	Bacteria	Bacteria	47.4	0.00769	NR	MBN1640624.1	2052143	g13208	i0	36.2	0.455947136563877	69	44	45.6	0	236	30	559	627	MBN1640624.1 hypothetical protein [Anaerolineae bacterium]	diamond	207	47.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28502166	28502166	PRJNA635397_P_NODE_39107_length_253_cov_0.866667_g38653_i0	PRJNA635397	39107	253	0.866667	2.19266751	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	42	0.0201	NR	MCK5653638.1	2026734	g38653	i0	41.3	0.545454545454545	46	26	54.5	1	66	203	37	81	MCK5653638.1 4Fe-4S binding protein [Dehalococcoidia bacterium]	diamond	138	42	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
28691767	28691767	PRJNA635397_P_NODE_21207_length_349_cov_2.423913_g20753_i0	PRJNA635397	21207	349	2.423913	8.45945637	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	43.1	0.0322	NR	MCE2467757.1	2614250	g20753	i0	34.6	0.696275071633238	81	43	62.8	2	4	222	53	131	MCE2467757.1 helix-turn-helix domain-containing protein [Caldilineaceae bacterium]	diamond	243	43.1	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
29291408	29291408	PRJNA635397_P_NODE_22469_length_338_cov_4.328302_g22015_i0	PRJNA635397	22469	338	4.328302	14.62966076	Chloroflexota bacterium	2026724	Bacteria	Bacteria	45.8	0.00713	NR	MEW5956611.1	2026724	g22015	i0	44.6	0.497041420118343	56	31	49.7	0	110	277	40	95	MEW5956611.1 hypothetical protein [Chloroflexota bacterium]	diamond	168	45.8	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29714055	29714055	PRJNA635397_P_NODE_13150_length_465_cov_3.803571_g12696_i0	PRJNA635397	13150	465	3.803571	17.68660515	FCB group	1783270	Bacteria	Bacteria	178	4.959999999999999e-52	NR	WP_028459308.1	867845	g12696	i0	67.5	3.10967741935484	120	39	77.4	0	371	12	3	122	WP_028459308.1 alcohol dehydrogenase AdhP [Chloroflexus sp. Y-396-1]	diamond	1446	179	0.994413407821229	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus sp. Y-396-1
30219758	30219758	PRJNA635397_P_NODE_22772_length_336_cov_1.471483_g22318_i0	PRJNA635397	22772	336	1.471483	4.94418288	Chloroflexota	200795	Bacteria	Bacteria	86.7	2.53e-18	NR	WP_062283304.1	1678840	g22318	i0	60.3	11.25	63	25	56.3	0	4	192	145	207	WP_062283304.1 uracil phosphoribosyltransferase [Flexilinea flocculi]	diamond	3780	86.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Flexilinea	Flexilinea flocculi
30315122	30315122	PRJNA635397_P_NODE_1552_length_1596_cov_3.696651_g1373_i0	PRJNA635397	1552	1596	3.696651	58.99854996	Flexilinea	1769713	Bacteria	Bacteria	109	1.73e-21	NR	MBQ6504680.1	2017390	g1373	i0	39.6	2.53947368421053	139	81	25.9	2	1008	1421	273	409	MBQ6504680.1 transporter substrate-binding domain-containing protein [Flexilinea sp.]	diamond	4053	109	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Flexilinea	Flexilinea sp.
31629629	31629629	PRJNA635397_P_NODE_4856_length_878_cov_2.826087_g4474_i0	PRJNA635397	4856	878	2.826087	24.81304386	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	47.4	0.0148	NR	HEY6202453.1	3047546	g4474	i0	36.5	0.252847380410023	74	47	25.3	0	686	465	35	108	HEY6202453.1 hypothetical protein [Candidatus Limnocylindria bacterium]	diamond	222	47.4	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria bacterium
32009227	32009227	PRJNA635397_P_NODE_39138_length_253_cov_0.866667_g38684_i0	PRJNA635397	39138	253	0.866667	2.19266751	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.1	0.0298	NR	MEA2610032.1	2026724	g38684	i0	37.1	0.735177865612648	62	39	73.5	0	26	211	11	72	MEA2610032.1 hypothetical protein [Chloroflexota bacterium]	diamond	186	43.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota 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);;