metadata: contig_metadata: 5 rows where bioproject = "PRJNA692200" and tax

5 rows where bioproject = "PRJNA692200" and tax_phylum = "Chloroflexota"

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_genus	tax_species
21075503	21075503	PRJNA692200_S_NODE_9297_length_230_cov_12.464088_g9240_i0	PRJNA692200	9297	230	12.464088	28.6674024	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	147	9.16e-31	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g9240	i0	80	278.760869565217	205	35	88	6	28	229	3494631	3494430	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	64115	147	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia		Candidatus Roseilinea	Candidatus Roseilinea sp.
27788950	27788950	PRJNA692200_S_NODE_10084_length_223_cov_1.149425_g10027_i0	PRJNA692200	10084	223	1.149425	2.56321775	Bacillati	1783272	Bacteria	Bacteria	75.5	4.11e-16	NR	MEO0563457.1	2026724	g10027	i0	75.6	6.75336322869955	45	11	60.5	0	85	219	3	47	MEO0563457.1 cold-shock protein [Chloroflexota bacterium]	diamond	1506	75.9	0.994729907773386	Bacteria		Bacillati	Chloroflexota				Chloroflexota bacterium
30493381	30493381	PRJNA692200_S_NODE_2973_length_341_cov_2.702055_g2916_i0	PRJNA692200	2973	341	2.702055	9.21400755	Anaerolineae bacterium	2052143	Bacteria	Bacteria	62.4	1.04e-9	NR	MCW5848612.1	2052143	g2916	i0	49.3	0.607038123167155	69	35	60.7	0	43	249	56	124	MCW5848612.1 profilin [Anaerolineae bacterium]	diamond	207	62.4	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
31156485	31156485	PRJNA692200_S_NODE_435_length_517_cov_14.869658_g402_i0	PRJNA692200	435	517	14.869658	76.87613186	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	94	5.1800000000000006e-21	NR	MDO9333994.1	2026733	g402	i0	92.5	0.307543520309478	53	3	30.2	1	5	160	83	135	MDO9333994.1 30S ribosomal protein S4 [Dehalococcoidales bacterium]	diamond	159	94	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales		Dehalococcoidales bacterium
31694400	31694400	PRJNA692200_S_NODE_14157_length_192_cov_4.286713_g14100_i0	PRJNA692200	14157	192	4.286713	8.23048896	Chloroflexota bacterium	2026724	Bacteria	Bacteria	41.6	0.0499	NR	NOH04063.1	2026724	g14100	i0	45.9	0.578125	37	20	57.8	0	180	70	419	455	NOH04063.1 dipeptidase [Chloroflexota bacterium]	diamond	111	41.6	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);;