metadata: contig_metadata: 9 rows where bioproject = "PRJNA1098727", tax_kingdom = "Bacillati" and tax

9 rows where bioproject = "PRJNA1098727", 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
3570359	3570359	PRJNA1098727_P_NODE_5103_length_285_cov_1.351695_g4862_i0	PRJNA1098727	5103	285	1.351695	3.85233075	Tepidiforma	2682228	Bacteria	Bacteria	448	2.8699999999999997e-121	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g4862	i0	95.07	92.3473684210526	284	14	99	0	2	285	2204205	2204488	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	26319	448	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
4037836	4037836	PRJNA1098727_P_NODE_16224_length_157_cov_2.851852_g15983_i0	PRJNA1098727	16224	157	2.851852	4.47740764	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	222	9.329999999999999e-54	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g15983	i0	92.357	410.369426751592	157	10	99	2	1	156	2202510	2202355	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	64428	222	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
18871404	18871404	PRJNA1098727_P_NODE_16055_length_160_cov_2.306306_g15814_i0	PRJNA1098727	16055	160	2.306306	3.6900896	Tepidiforma	2682228	Bacteria	Bacteria	211	2.07e-50	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g15814	i0	90.625	86.025	160	13	99	2	1	159	2203881	2203723	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	13764	211	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
20146216	20146216	PRJNA1098727_P_NODE_6836_length_238_cov_2.671958_g6595_i0	PRJNA1098727	6836	238	2.671958	6.35926004	Tepidiforma	2682228	Bacteria	Bacteria	353	5.23e-93	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g6595	i0	93.644	162.844537815126	236	15	99	0	2	237	2204692	2204927	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	38757	353	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
24437011	24437011	PRJNA1098727_P_NODE_7800_length_221_cov_1.488372_g7559_i0	PRJNA1098727	7800	221	1.488372	3.28930212	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	183	6.659999999999998e-42	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g7559	i0	82.143	235.723981900452	224	30	99	9	1	218	518	737	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	52095	183	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
26592593	26592593	PRJNA1098727_P_NODE_14561_length_165_cov_0.896552_g14320_i0	PRJNA1098727	14561	165	0.896552	1.4793108	Chloroflexota bacterium	2026724	Bacteria	Bacteria	46.2	9.9e-5	NR	MBT9165939.1	2026724	g14320	i0	46.2	0.945454545454545	52	28	94.5	0	2	157	22	73	MBT9165939.1 hypothetical protein [Chloroflexota bacterium]	diamond	156	46.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27762892	27762892	PRJNA1098727_P_NODE_15324_length_163_cov_0.912281_g15083_i0	PRJNA1098727	15324	163	0.912281	1.48701803	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	93.2	1.73e-22	NR	MCB0075578.1	2614250	g15083	i0	81.1	1.95092024539877	53	10	97.5	0	3	161	68	120	MCB0075578.1 ATP-binding cassette domain-containing protein [Caldilineaceae bacterium]	diamond	318	93.2	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
28195832	28195832	PRJNA1098727_P_NODE_14826_length_164_cov_0.904348_g14585_i0	PRJNA1098727	14826	164	0.904348	1.48313072	Caldilinea	233191	Bacteria	Bacteria	89.7	3.12e-20	NR	MCE7981694.1	2293554	g14585	i0	75.9	2.96341463414634	54	13	98.8	0	164	3	146	199	MCE7981694.1 transposase [Caldilinea sp. CFX5]	diamond	486	89.7	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea sp. CFX5
30320950	30320950	PRJNA1098727_P_NODE_14972_length_164_cov_0.904348_g14731_i0	PRJNA1098727	14972	164	0.904348	1.48313072	Chloroflexota bacterium	2026724	Bacteria	Bacteria	82	1.8e-16	NR	MBI2758786.1	2026724	g14731	i0	65.4	0.951219512195122	52	18	95.1	0	2	157	319	370	MBI2758786.1 hypothetical protein [Chloroflexota bacterium]	diamond	156	82	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);;