metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA605033" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA605033" 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_family	tax_genus	tax_species
581175	581175	PRJNA605033_P_NODE_116861_length_222_cov_1.663102_g115292_i0	PRJNA605033	116861	222	1.663102	3.69208644	Anaerolineales bacterium	2073117	Bacteria	Bacteria	124	4.11e-24	NTclustered	gi\|2621701347\|emb\|OY760067.1\|	2073117	g115292	i0	98.571	35.545045045045	70	1	34	0	1	70	896216	896285	MAG: Anaerolineales bacterium isolate e1712b75-d4f6-4c5e-bc49-bbfdc0d5b476 genome assembly, chromosome: 2	blastn	7891	124	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
1858071	1858071	PRJNA605033_P_NODE_209102_length_162_cov_2.204724_g207533_i0	PRJNA605033	209102	162	2.204724	3.57165288	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2893358447\|emb\|OZ220739.1\|	3022862	g207533	i0	100	0.37037037037037	30	0	19	0	120	149	1711752	1711723	MAG: Tepidiformaceae bacterium isolate ddb3cf28-bb63-44a4-8fd1-08202229d10a genome assembly, chromosome: 1	blastn	60	56.5	1	Bacteria		Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
1858390	1858390	PRJNA605033_P_NODE_243322_length_151_cov_2.112069_g241753_i0	PRJNA605033	243322	151	2.112069	3.18922419	Roseiflexus castenholzii	120962	Bacteria	Bacteria	52.8	0.012	NTclustered	gi\|156231356\|gb\|CP000804.1\|	383372	g241753	i0	100	0.185430463576159	28	0	19	0	46	73	2943676	2943649	Roseiflexus castenholzii DSM 13941, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
7522634	7522634	PRJNA605033_P_NODE_143206_length_201_cov_1.186747_g141637_i0	PRJNA605033	143206	201	1.186747	2.38536147	Nitrospinota/Tectimicrobiota group	1802340	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2531948664\|emb\|OY282448.1\|	166587	g141637	i0	100	0.298507462686567	28	0	14	0	149	176	2316056	2316029	MAG: uncultured Chloroflexota bacterium genome assembly, chromosome: 1	blastn	60	52.8	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
7523309	7523309	PRJNA605033_P_NODE_249766_length_150_cov_1.043478_g248197_i0	PRJNA605033	249766	150	1.043478	1.565217	Bacteria	2	Bacteria	Bacteria	60.2	7.3e-5	NTclustered	gi\|2891482052\|emb\|OZ219801.1\|	2026724	g248197	i0	100	35.66	32	0	21	0	117	148	332163	332132	MAG: Chloroflexota bacterium isolate 50a8419b-8e17-430b-920a-11f3287aca29 genome assembly, chromosome: 1	blastn	5349	60.2	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
17159125	17159125	PRJNA605033_P_NODE_13194_length_385_cov_2.780000_g11655_i0	PRJNA605033	13194	385	2.78	10.703	Candidatus Chlorohelix allophototropha	3003348	Bacteria	Bacteria	283	1.2e-71	NTclustered	gi\|2530750984\|gb\|CP128400.1\|	3003348	g11655	i0	86.59	313.451948051948	261	29	67	6	50	307	320279	320022	Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence	blastn	120679	283	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
17160813	17160813	PRJNA605033_P_NODE_68394_length_222_cov_3.310160_g66825_i0	PRJNA605033	68394	222	3.31016	7.3485552	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2893358379\|emb\|OZ220673.1\|	2026734	g66825	i0	85.714	0.220720720720721	49	7	22	0	152	200	2393914	2393866	MAG: Dehalococcoidia bacterium isolate 74ad39ee-730f-4e91-a86b-9a5c45ef094d genome assembly, chromosome: 1	blastn	49	52.8	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
18997331	18997331	PRJNA605033_P_NODE_79035_length_222_cov_2.545455_g77466_i0	PRJNA605033	79035	222	2.545455	5.6509101	root	1	Root_unresolved	Root_unresolved	63.9	9.1e-6	NTclustered	gi\|2893358390\|emb\|OZ220681.1\|	2026734	g77466	i0	95	2.63063063063063	40	2	18	0	183	222	2217905	2217866	MAG: Dehalococcoidia bacterium isolate b3870ce4-b2c0-4886-bd94-d5608d47d969 genome assembly, chromosome: 1	blastn	584	63.9	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
22259192	22259192	PRJNA605033_P_NODE_195058_length_168_cov_1.353383_g193489_i0	PRJNA605033	195058	168	1.353383	2.27368344	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	93.5	8.32e-15	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g193489	i0	78.986	0.821428571428571	138	27	82	2	6	142	521168	521304	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	138	93.5	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23535576	23535576	PRJNA605033_P_NODE_77059_length_222_cov_2.641711_g75490_i0	PRJNA605033	77059	222	2.641711	5.86459842	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2518540574\|emb\|OX638292.1\|	498747	g75490	i0	96.97	0.445945945945946	33	1	15	0	2	34	740101	740069	MAG: uncultured Dehalococcoidia bacterium isolate 695a8b18-9d85-47ae-89af-9793d4c73328 genome assembly, chromosome: 1	blastn	99	56.5	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
23535646	23535646	PRJNA605033_P_NODE_88839_length_222_cov_2.213904_g87270_i0	PRJNA605033	88839	222	2.213904	4.91486688	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	78.7	3.25e-10	NTclustered	gi\|2626233621\|emb\|OY820591.1\|	2026734	g87270	i0	85.333	0.337837837837838	75	11	34	0	148	222	359811	359737	MAG: Dehalococcoidia bacterium isolate bad7acc4-ca48-4abb-846f-85865ba1c961 genome assembly, chromosome: 1	blastn	75	78.7	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
23535701	23535701	PRJNA605033_P_NODE_99779_length_222_cov_1.962567_g98210_i0	PRJNA605033	99779	222	1.962567	4.35689874	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	84.2	6.98e-12	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g98210	i0	86.842	23.7612612612613	76	8	34	2	148	222	2259502	2259428	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	5275	84.2	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
24809083	24809083	PRJNA605033_P_NODE_41860_length_252_cov_2.082949_g40292_i0	PRJNA605033	41860	252	2.082949	5.24903148	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	182	2.79e-41	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g40292	i0	85.165	71.9960317460317	182	21	71	4	33	211	1720826	1720648	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	18143	182	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.

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