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

11 rows where analysis = "blastn", bioproject = "PRJEB30004" 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
47353	47353	PRJEB30004_P_NODE_540241_length_180_cov_2.943262_g524614_i0	PRJEB30004	540241	180	2.943262	5.2978716	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	235	1.4099999999999998e-57	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g524614	i0	90.503	18.3055555555556	179	15	99	2	1	178	275961	275784	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	3295	235	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
1310484	1310484	PRJEB30004_P_NODE_306482_length_277_cov_2.294118_g290855_i0	PRJEB30004	306482	277	2.294118	6.35470686	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	327	3.78e-85	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g290855	i0	88.087	138.429602888087	277	32	100	1	1	277	273757	274032	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	38345	327	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
3857053	3857053	PRJEB30004_P_NODE_191744_length_390_cov_2.646724_g176127_i0	PRJEB30004	191744	390	2.646724	10.3222236	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	340	7.1e-89	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g176127	i0	87.96	148.389743589744	299	22	76	8	94	390	1398	1112	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	57872	340	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
8967944	8967944	PRJEB30004_P_NODE_406048_length_224_cov_2.064865_g390421_i0	PRJEB30004	406048	224	2.064865	4.6252976	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	167	6.81e-37	NTclustered	gi\|2874253704\|emb\|OY969431.1\|	1672391	g390421	i0	84.615	24.7544642857143	169	24	75	2	12	178	64228	64396	MAG: uncultured Chloroflexia bacterium isolate MFD02979.bin.c.2 genome assembly, chromosome: 1	blastn	5545	167	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9916769	9916769	PRJEB30004_P_NODE_40088_length_1215_cov_6.208333_g29545_i0	PRJEB30004	40088	1215	6.208333	75.43124595	Caldilinea	233191	Bacteria	Bacteria	1358	0	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g29545	i0	86.851	146.869958847737	1232	141	100	10	1	1215	496	1723	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	178447	1358	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
12807209	12807209	PRJEB30004_P_NODE_671191_length_153_cov_1.438596_g655564_i0	PRJEB30004	671191	153	1.438596	2.20105188	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	147	5.589999999999999e-31	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g655564	i0	90.826	149.78431372549	109	10	71	0	34	142	3495577	3495469	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	22917	147	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
14082643	14082643	PRJEB30004_P_NODE_686552_length_150_cov_2.396396_g670925_i0	PRJEB30004	686552	150	2.396396	3.594594	Dehalogenimonas formicexedens	1839801	Bacteria	Bacteria	73.1	9.38e-9	NTclustered	gi\|1132444150\|gb\|CP018258.1\|	1839801	g670925	i0	86.364	0.44	66	9	44	0	1	66	639493	639558	Dehalogenimonas formicexedens strain NSZ-14, complete genome	blastn	66	73.1	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidaceae	Dehalogenimonas	Dehalogenimonas formicexedens
17890762	17890762	PRJEB30004_P_NODE_369195_length_241_cov_2.316832_g353568_i0	PRJEB30004	369195	241	2.316832	5.58356512	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	278	3.29e-70	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g353568	i0	89.189	85.2697095435685	222	24	92	0	16	237	8228154	8227933	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	20550	278	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19166291	19166291	PRJEB30004_P_NODE_403856_length_225_cov_1.973118_g388229_i0	PRJEB30004	403856	225	1.973118	4.4395155	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	195	3.14e-45	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g388229	i0	88.679	331.884444444444	159	18	71	0	42	200	274850	274692	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	74674	195	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21730561	21730561	PRJEB30004_P_NODE_674538_length_152_cov_2.787611_g658911_i0	PRJEB30004	674538	152	2.787611	4.23716872	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	126	7.22e-25	NTclustered	gi\|2893356069\|emb\|OZ220492.1\|	2614250	g658911	i0	81.818	5.06578947368421	154	25	100	3	1	152	2778246	2778094	MAG: Caldilineaceae bacterium isolate e886e3b1-96bd-41d4-96ed-8e2f365de7fb genome assembly, chromosome: 1	blastn	770	126	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
23000809	23000809	PRJEB30004_P_NODE_570039_length_173_cov_2.022388_g554412_i0	PRJEB30004	570039	173	2.022388	3.49873124	uncultured Aggregatilineales bacterium	3063736	Bacteria	Bacteria	111	2.36e-20	NTclustered	gi\|2550423267\|gb\|OR335971.1\|	3063736	g554412	i0	92.308	0.901734104046243	78	6	45	0	96	173	2408	2331	Uncultured Aggregatilineales bacterium clone ASV-503 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	156	111	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales	Aggregatilineaceae		uncultured Aggregatilineales 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);;