metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA611476" 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
1865714	1865714	PRJNA611476_P_NODE_64722_length_276_cov_1.881773_g63931_i0	PRJNA611476	64722	276	1.881773	5.19369348	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	115	3.1900000000000003e-21	NTclustered	gi\|2531949176\|emb\|OY282458.1\|	498747	g63931	i0	91.566	0.695652173913043	83	7	30	0	24	106	518886	518804	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	192	115	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
3140712	3140712	PRJNA611476_P_NODE_66043_length_274_cov_1.233831_g65252_i0	PRJNA611476	66043	274	1.233831	3.38069694	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2891482126\|emb\|OZ219860.1\|	2026734	g65252	i0	100	0.102189781021898	28	0	10	0	171	198	897977	897950	MAG: Dehalococcoidia bacterium isolate 64608d2e-b53d-4acf-b835-26db22483995 genome assembly, chromosome: 2	blastn	28	52.8	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
3140766	3140766	PRJNA611476_P_NODE_71683_length_263_cov_1.436842_g70892_i0	PRJNA611476	71683	263	1.436842	3.77889446	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2874253741\|emb\|OY969584.1\|	1672391	g70892	i0	100	0.216730038022814	29	0	11	0	103	131	1222447	1222419	MAG: uncultured Chloroflexia bacterium isolate MFD01299.bin.c.4 genome assembly, chromosome: 1	blastn	57	54.7	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4976350	4976350	PRJNA611476_P_NODE_7124_length_727_cov_3.524465_g6361_i0	PRJNA611476	7124	727	3.524465	25.62286055	Chloroflexus	1107	Bacteria	Bacteria	438	4.779999999999999e-118	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g6361	i0	81.701	375.558459422283	541	85	74	12	167	701	1186	654	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	273031	438	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
7525478	7525478	PRJNA611476_P_NODE_17586_length_472_cov_0.994987_g16796_i0	PRJNA611476	17586	472	0.994987	4.69633864	Bacillati	1783272	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g16796	i0	100	0.13135593220339	28	0	6	0	430	457	2146251	2146224	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	62	52.8	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
9517985	9517985	PRJNA611476_P_NODE_55948_length_293_cov_0.986364_g55157_i0	PRJNA611476	55948	293	0.986364	2.89004652	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	195	4.27e-45	NTclustered	gi\|2531948664\|emb\|OY282448.1\|	166587	g55157	i0	80.682	2.97610921501706	264	39	88	10	3	260	2398032	2397775	MAG: uncultured Chloroflexota bacterium genome assembly, chromosome: 1	blastn	872	195	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
9518174	9518174	PRJNA611476_P_NODE_69048_length_268_cov_1.579487_g68257_i0	PRJNA611476	69048	268	1.579487	4.23302516	Anaerolineales bacterium	2073117	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2320772474\|gb\|CP075526.1\|	2073117	g68257	i0	100	0.108208955223881	29	0	11	0	71	99	600252	600280	MAG: Anaerolineales bacterium isolate TGS_CHL3 chromosome	blastn	29	54.7	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
17167488	17167488	PRJNA611476_P_NODE_5134_length_852_cov_1.482670_g4408_i0	PRJNA611476	5134	852	1.48267	12.6323484	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	56.5	0.007	NTclustered	gi\|2814788337\|emb\|OY760908.2\|	2026734	g4408	i0	100	0.34037558685446	30	0	4	0	760	789	887103	887074	MAG: Dehalococcoidia bacterium isolate 99511b8e-fdeb-40b8-a9fc-769d5cc020c2 genome assembly, chromosome: 1	blastn	290	56.5	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
19715717	19715717	PRJNA611476_P_NODE_19216_length_453_cov_1.463158_g18425_i0	PRJNA611476	19216	453	1.463158	6.62810574	Anaerolineae bacterium	2052143	Bacteria	Bacteria	52.8	0.044	NTclustered	gi\|2107864099\|gb\|CP070818.1\|	2052143	g18425	i0	100	0.0618101545253863	28	0	6	0	114	141	4166631	4166604	MAG: Anaerolineae bacterium isolate bin1159 chromosome	blastn	28	52.8	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
19715763	19715763	PRJNA611476_P_NODE_21996_length_427_cov_1.293785_g21205_i0	PRJNA611476	21996	427	1.293785	5.52446195	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g21205	i0	96.97	0.0772833723653396	33	1	8	0	24	56	679713	679681	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	33	56.5	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19715922	19715922	PRJNA611476_P_NODE_32556_length_364_cov_1.446735_g31765_i0	PRJNA611476	32556	364	1.446735	5.2661154	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	65.8	4.44e-6	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g31765	i0	95.122	4.33241758241758	41	2	11	0	57	97	387504	387464	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	1577	65.8	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19716440	19716440	PRJNA611476_P_NODE_73536_length_259_cov_2.295699_g72745_i0	PRJNA611476	73536	259	2.295699	5.94586041	Anaerolineales bacterium	2073117	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g72745	i0	100	0.108108108108108	28	0	11	0	97	124	2332587	2332560	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
20992458	20992458	PRJNA611476_P_NODE_92017_length_248_cov_0.880000_g91226_i0	PRJNA611476	92017	248	0.88	2.1824	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	62.1	3.73e-5	NTclustered	gi\|2621704807\|emb\|OY763072.1\|	2026734	g91226	i0	100	3.08064516129032	33	0	13	0	72	104	2563726	2563758	MAG: Dehalococcoidia bacterium isolate 40e540cc-5106-4b3b-ab2b-631d7f64572a genome assembly, chromosome: 1	blastn	764	62.1	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
25374496	25374496	PRJNA611476_P_NODE_69620_length_267_cov_1.561856_g68829_i0	PRJNA611476	69620	267	1.561856	4.17015552	Herpetosiphon	64	Bacteria	Bacteria	126	1.42e-24	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g68829	i0	80.22	15.2696629213483	182	24	66	9	92	267	371	546	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	4077	126	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus

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