metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1174207" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1174207" 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
315791	315791	PRJNA1174207_P_NODE_33201_length_251_cov_1.730337_g32672_i0	PRJNA1174207	33201	251	1.730337	4.34314587	Litorilinea aerophila	1204385	Bacteria	Bacteria	366	7.15e-97	NTclustered	gi\|393193706\|gb\|JQ733906.1\|	1204385	g32672	i0	93.2	251.143426294821	250	16	99	1	3	251	3701	3950	Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence	blastn	63037	366	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
316005	316005	PRJNA1174207_P_NODE_43581_length_211_cov_6.384058_g43052_i0	PRJNA1174207	43581	211	6.384058	13.47036238	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	257	3.66e-64	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g43052	i0	88.679	18.1469194312796	212	22	100	2	1	211	276000	275790	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	3829	257	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
2316127	2316127	PRJNA1174207_P_NODE_6022_length_679_cov_1.665017_g5511_i0	PRJNA1174207	6022	679	1.665017	11.30546543	Bacteria	2	Bacteria	Bacteria	510	9.29e-140	NTclustered	gi\|2531946085\|emb\|OY282385.1\|	498747	g5511	i0	81.069	96.9469808541973	655	110	95	12	2	646	1885067	1884417	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	65827	510	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
6693829	6693829	PRJNA1174207_P_NODE_42826_length_230_cov_2.828025_g42297_i0	PRJNA1174207	42826	230	2.828025	6.5044575	Chloroflexota bacterium	2026724	Bacteria	Bacteria	207	4.14e-49	NTclustered	gi\|2621702192\|emb\|OY760183.1\|	2026724	g42297	i0	84.259	119.430434782609	216	30	93	4	1	214	2633147	2632934	MAG: Chloroflexota bacterium isolate 1e5240b1-722b-4dd6-bc08-6f4f73fd4587 genome assembly, chromosome: 1	blastn	27469	207	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
6693915	6693915	PRJNA1174207_P_NODE_8266_length_548_cov_5.012632_g7742_i0	PRJNA1174207	8266	548	5.012632	27.46922336	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	649	0	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g7742	i0	89.231	192.082116788321	520	55	95	1	1	520	273761	274279	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	105261	649	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7418560	7418560	PRJNA1174207_P_NODE_35406_length_248_cov_3.325714_g34877_i0	PRJNA1174207	35406	248	3.325714	8.24777072	Chloroflexota	200795	Bacteria	Bacteria	211	3.5e-50	NTclustered	gi\|2531946085\|emb\|OY282385.1\|	498747	g34877	i0	82.661	148.576612903226	248	34	98	5	7	248	1885640	1885884	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	36847	211	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
10518967	10518967	PRJNA1174207_P_NODE_12009_length_429_cov_1.039326_g11482_i0	PRJNA1174207	12009	429	1.039326	4.45870854	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	261	6.32e-65	NTclustered	gi\|2874253741\|emb\|OY969584.1\|	1672391	g11482	i0	81.703	166.589743589744	317	54	74	4	111	426	1351132	1351445	MAG: uncultured Chloroflexia bacterium isolate MFD01299.bin.c.4 genome assembly, chromosome: 1	blastn	71467	261	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
10519316	10519316	PRJNA1174207_P_NODE_31429_length_258_cov_3.881081_g30900_i0	PRJNA1174207	31429	258	3.881081	10.01318898	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	302	2.11e-77	NTclustered	gi\|2531946085\|emb\|OY282385.1\|	498747	g30900	i0	88.755	236.244186046512	249	24	95	2	1	246	1883916	1884163	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	60951	302	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
15068338	15068338	PRJNA1174207_P_NODE_30732_length_261_cov_3.776596_g30203_i0	PRJNA1174207	30732	261	3.776596	9.85691556	Bacteria	2	Bacteria	Bacteria	248	2.8299999999999997e-61	NTclustered	gi\|297181775\|gb\|GU474878.1\|	710736	g30203	i0	85.957	70.8888888888889	235	29	89	4	29	261	9514	9746	Uncultured Chloroflexi bacterium HF0200_09I09 genomic sequence	blastn	18502	250	0.992	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexi bacterium HF0200_09I09
15618392	15618392	PRJNA1174207_P_NODE_27353_length_276_cov_0.896552_g26824_i0	PRJNA1174207	27353	276	0.896552	2.47448352	Litorilinea aerophila	1204385	Bacteria	Bacteria	353	6.21e-93	NTclustered	gi\|393193706\|gb\|JQ733906.1\|	1204385	g26824	i0	91.221	126.70652173913	262	20	95	3	10	270	4036	4295	Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence	blastn	34971	353	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
21992549	21992549	PRJNA1174207_P_NODE_5198_length_744_cov_4.737705_g4700_i0	PRJNA1174207	5198	744	4.737705	35.2485252	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	651	0	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g4700	i0	82.79	197.524193548387	767	94	100	30	1	744	273052	273803	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	146958	651	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia 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);;