metadata: contig_metadata: 11 rows where bioproject = "PRJNA358009", tax_kingdom = "Bacillati" and tax

11 rows where bioproject = "PRJNA358009", tax_kingdom = "Bacillati" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
10601879	10601879	PRJNA358009_P_NODE_10129_length_182_cov_1.533835_g10060_i0	PRJNA358009	10129	182	1.533835	2.7915797	Thermoflexales bacterium	2497639	Bacteria	Bacteria	72.8	1.24e-13	NR	MFN4295148.1	2497639	g10060	i0	65.6	1.05494505494505	64	8	82.4	1	2	151	166	229	MFN4295148.1 hypothetical protein [Thermoflexales bacterium]	diamond	192	72.8	1	Bacteria	Bacillati	Chloroflexota	Thermoflexia	Thermoflexales			Thermoflexales bacterium
11876836	11876836	PRJNA358009_P_NODE_13310_length_166_cov_5.564103_g13241_i0	PRJNA358009	13310	166	5.564103	9.23641098	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	180	6.11e-41	NTclustered	gi\|2621704001\|emb\|OY762956.1\|	2026734	g13241	i0	87.821	194.626506024096	156	16	93	3	7	161	1513506	1513353	MAG: Dehalococcoidia bacterium isolate caf6cba7-c187-4a53-abc2-184ab5dfaca7 genome assembly, chromosome: 1	blastn	32308	180	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
15700931	15700931	PRJNA358009_P_NODE_18473_length_151_cov_4.450980_g18404_i0	PRJNA358009	18473	151	4.45098	6.7209798	Chloroflexus aurantiacus	1108	Bacteria	Bacteria	124	2.5699999999999997e-24	NTclustered	gi\|163666892\|gb\|CP000909.1\|	324602	g18404	i0	86.087	7.64238410596027	115	16	76	0	8	122	3209501	3209615	Chloroflexus aurantiacus J-10-fl, complete genome	blastn	1154	124	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
15700957	15700957	PRJNA358009_P_NODE_3533_length_327_cov_2.586331_g3470_i0	PRJNA358009	3533	327	2.586331	8.45730237	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	159	1.76e-34	NTclustered	gi\|310755722\|gb\|HQ213612.1\|	166587	g3470	i0	96.842	7.62385321100917	95	3	29	0	6	100	871	965	Uncultured Chloroflexi bacterium clone 4_I11 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	2493	159	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
16975729	16975729	PRJNA358009_P_NODE_6794_length_324_cov_2.385455_g6731_i0	PRJNA358009	6794	324	2.385455	7.7288742	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	176	1.73e-39	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g6731	i0	98.98	49.5771604938272	98	1	30	0	226	323	2427952	2427855	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	16063	176	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
18249824	18249824	PRJNA358009_P_NODE_13775_length_165_cov_6.491379_g13706_i0	PRJNA358009	13775	165	6.491379	10.71077535	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	84.2	4.89e-12	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g13706	i0	91.667	21.3757575757576	60	5	36	0	1	60	3521027	3521086	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	3527	84.2	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19524183	19524183	PRJNA358009_P_NODE_8156_length_206_cov_4.815287_g8087_i0	PRJNA358009	8156	206	4.815287	9.91949122	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	196	7.86e-46	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g8087	i0	88.75	52.0291262135922	160	18	78	0	5	164	597665	597506	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	10718	196	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
30106348	30106348	PRJNA358009_P_NODE_9672_length_184_cov_7.111111_g9603_i0	PRJNA358009	9672	184	7.111111	13.08444424	Anaerolineae bacterium	2052143	Bacteria	Bacteria	43.9	7.68e-4	NR	MBC7872294.1	2052143	g9603	i0	80.8	0.423913043478261	26	5	42.4	0	83	6	16	41	MBC7872294.1 hypothetical protein [Anaerolineae bacterium]	diamond	78	43.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31211835	31211835	PRJNA358009_P_NODE_1995_length_330_cov_2.711744_g1932_i0	PRJNA358009	1995	330	2.711744	8.9487552	Anaerolineae bacterium	2052143	Bacteria	Bacteria	63.5	5.34e-9	NR	HOT91191.1	2052143	g1932	i0	81.6	0.7	38	7	34.5	0	330	217	606	643	HOT91191.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Anaerolineae bacterium]	diamond	231	63.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31560423	31560423	PRJNA358009_P_NODE_4636_length_327_cov_2.046763_g4573_i0	PRJNA358009	4636	327	2.046763	6.69291501	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	62.4	1.27e-8	NR	MCC6455735.1	2614250	g4573	i0	84.8	0.302752293577982	33	5	30.3	0	99	1	561	593	MCC6455735.1 alpha/beta fold hydrolase [Caldilineaceae bacterium]	diamond	99	62.4	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
32066271	32066271	PRJNA358009_P_NODE_18398_length_151_cov_7.127451_g18329_i0	PRJNA358009	18398	151	7.127451	10.76245101	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	54.7	3.94e-8	NR	MBP7041017.1	2024896	g18329	i0	96.2	1.03311258278146	26	1	51.7	0	84	7	26	51	MBP7041017.1 DUF1294 domain-containing protein [Anaerolineaceae bacterium]	diamond	156	54.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae 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);;