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

13 rows where analysis = "blastn", bioproject = "PRJNA1095825" 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
4027374	4027374	PRJNA1095825_P_NODE_248484_length_249_cov_0.875000_g245421_i0	PRJNA1095825	248484	249	0.875	2.17875	Leptolinea sp. HRD-7	2830982	Bacteria	Bacteria	394	3.25e-105	NTclustered	gi\|2250018340\|dbj\|AP024710.1\|	2830982	g245421	i0	95.181	1	249	12	100	0	1	249	1279353	1279105	Leptolinea sp. HRD-7 DNA, complete genome	blastn	249	394	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Leptolinea	Leptolinea sp. HRD-7
4027863	4027863	PRJNA1095825_P_NODE_294564_length_241_cov_0.916667_g291501_i0	PRJNA1095825	294564	241	0.916667	2.20916747	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	204	5.66e-48	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g291501	i0	82.479	7.23236514522822	234	39	97	2	7	239	1591726	1591494	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	1743	204	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7853866	7853866	PRJNA1095825_P_NODE_292747_length_241_cov_1.476190_g289684_i0	PRJNA1095825	292747	241	1.47619	3.5576179	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	154	5.78e-33	NTclustered	gi\|2531963199\|emb\|OY282442.1\|	498747	g289684	i0	80.288	0.863070539419087	208	37	85	4	14	219	2913676	2913881	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	208	154	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
9128557	9128557	PRJNA1095825_P_NODE_259388_length_247_cov_0.885057_g256325_i0	PRJNA1095825	259388	247	0.885057	2.18609079	uncultured Caldilineaceae bacterium	543031	Bacteria	Bacteria	60.2	1.33e-4	NTclustered	gi\|2518551077\|emb\|OX638330.1\|	543031	g256325	i0	97.143	0.267206477732794	35	1	14	0	190	224	629621	629587	MAG: uncultured Caldilineaceae bacterium isolate 76db5b8c-001f-43e6-88b1-0bf759d03ef1 genome assembly, chromosome: 1	blastn	66	60.2	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		uncultured Caldilineaceae bacterium
10404190	10404190	PRJNA1095825_P_NODE_262209_length_247_cov_0.885057_g259146_i0	PRJNA1095825	262209	247	0.885057	2.18609079	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	187	5.87e-43	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g259146	i0	80.488	1.99595141700405	246	46	99	2	3	247	477807	478051	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	493	187	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
10404325	10404325	PRJNA1095825_P_NODE_275489_length_244_cov_1.385965_g272426_i0	PRJNA1095825	275489	244	1.385965	3.3817546	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	241	4.38e-59	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g272426	i0	87.037	0.885245901639344	216	24	88	3	19	232	2643713	2643500	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	216	241	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11678811	11678811	PRJNA1095825_P_NODE_185630_length_287_cov_1.200935_g182567_i0	PRJNA1095825	185630	287	1.200935	3.44668345	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	99	3.36e-16	NTclustered	gi\|2621703647\|emb\|OY762633.1\|	2026734	g182567	i0	91.549	20.2439024390244	71	6	25	0	37	107	1587402	1587332	MAG: Dehalococcoidia bacterium isolate 17254eae-7cb3-4ac9-839e-465292e2b3d4 genome assembly, chromosome: 1	blastn	5810	99	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
11680054	11680054	PRJNA1095825_P_NODE_43790_length_582_cov_1.504912_g40744_i0	PRJNA1095825	43790	582	1.504912	8.75858784	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	292	3.1099999999999993e-74	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g40744	i0	80.67	132.084192439863	388	66	66	8	198	582	3522345	3521964	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	76873	292	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12954316	12954316	PRJNA1095825_P_NODE_226951_length_257_cov_1.625000_g223888_i0	PRJNA1095825	226951	257	1.625	4.17625	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	207	4.71e-49	NTclustered	gi\|2874253812\|emb\|OY969796.1\|	1672391	g223888	i0	81.423	1.92607003891051	253	47	98	0	5	257	2159131	2158879	MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1	blastn	495	207	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
15503335	15503335	PRJNA1095825_P_NODE_237713_length_251_cov_0.865169_g234650_i0	PRJNA1095825	237713	251	0.865169	2.17157419	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	182	2.78e-41	NTclustered	gi\|2874253736\|emb\|OY969578.1\|	1672391	g234650	i0	90.511	0.545816733067729	137	13	55	0	115	251	1047129	1046993	MAG: uncultured Chloroflexia bacterium isolate MFD05674.bin.c.2 genome assembly, chromosome: 1	blastn	137	182	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
16777819	16777819	PRJNA1095825_P_NODE_243974_length_250_cov_0.870056_g240911_i0	PRJNA1095825	243974	250	0.870056	2.17514	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	316	7.269999999999998e-82	NTclustered	gi\|2626282194\|emb\|OY839116.1\|	2026734	g240911	i0	89.919	14.12	248	22	99	3	1	248	1267976	1267732	MAG: Dehalococcoidia bacterium isolate 44b3abb6-b6b9-4f11-be96-93ee54cc77f6 genome assembly, chromosome: 1	blastn	3530	316	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
20602234	20602234	PRJNA1095825_P_NODE_285757_length_243_cov_0.905882_g282694_i0	PRJNA1095825	285757	243	0.905882	2.20129326	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	255	1.5600000000000001e-63	NTclustered	gi\|2874253812\|emb\|OY969796.1\|	1672391	g282694	i0	85.714	66.0864197530864	245	31	100	4	1	243	205483	205241	MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1	blastn	16059	255	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
20602274	20602274	PRJNA1095825_P_NODE_288877_length_242_cov_0.911243_g285814_i0	PRJNA1095825	288877	242	0.911243	2.20520806	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	248	2.59e-61	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g285814	i0	85.124	1.66528925619835	242	36	100	0	1	242	462073	461832	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	403	248	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);;