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

13 rows where analysis = "blastn", bioproject = "PRJNA393181" 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_species
1684961	1684961	PRJNA393181_S_NODE_13862_length_324_cov_2.041812_g13756_i0	PRJNA393181	13862	324	2.041812	6.61547088	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	95.3	4.99e-15	NTclustered	gi\|2893358390\|emb\|OZ220681.1\|	2026734	g13756	i0	89.333	0.231481481481481	75	8	23	0	241	315	492088	492162	MAG: Dehalococcoidia bacterium isolate b3870ce4-b2c0-4886-bd94-d5608d47d969 genome assembly, chromosome: 1	blastn	75	95.3	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
2961651	2961651	PRJNA393181_S_NODE_47703_length_150_cov_2.185841_g47597_i0	PRJNA393181	47703	150	2.185841	3.2787615	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	60.2	7.3e-5	NTclustered	gi\|2621706268\|emb\|OY764162.1\|	2026734	g47597	i0	94.737	0.253333333333333	38	2	25	0	113	150	1307372	1307335	MAG: Dehalococcoidia bacterium isolate c2b86379-bd31-4c30-aa6f-eeb60e07e050 genome assembly, chromosome: 1	blastn	38	60.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
2961658	2961658	PRJNA393181_S_NODE_47923_length_150_cov_1.336283_g47817_i0	PRJNA393181	47923	150	1.336283	2.0044245	Chloroflexota bacterium	2026724	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2621702192\|emb\|OY760183.1\|	2026724	g47817	i0	85.455	0.366666666666667	55	7	36	1	24	77	1319640	1319694	MAG: Chloroflexota bacterium isolate 1e5240b1-722b-4dd6-bc08-6f4f73fd4587 genome assembly, chromosome: 1	blastn	55	56.5	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
5514046	5514046	PRJNA393181_S_NODE_21925_length_249_cov_3.853774_g21819_i0	PRJNA393181	21925	249	3.853774	9.59589726	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	187	5.919999999999998e-43	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g21819	i0	83.173	57.5863453815261	208	32	83	3	41	246	1602567	1602773	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	14339	187	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
5514756	5514756	PRJNA393181_S_NODE_7705_length_429_cov_3.204082_g7599_i0	PRJNA393181	7705	429	3.204082	13.74551178	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	52.8	0.041	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g7599	i0	100	0.0652680652680653	28	0	7	0	226	253	1842641	1842668	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
6787738	6787738	PRJNA393181_S_NODE_10886_length_366_cov_2.145897_g10780_i0	PRJNA393181	10886	366	2.145897	7.85398302	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	302	3.12e-77	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g10780	i0	83.801	3.04644808743169	321	48	87	4	16	334	9707660	9707342	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	1115	302	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
11888889	11888889	PRJNA393181_S_NODE_13590_length_327_cov_2.541379_g13484_i0	PRJNA393181	13590	327	2.541379	8.31030933	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	217	1.03e-51	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g13484	i0	79.042	94.697247706422	334	56	100	14	1	327	1604284	1603958	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	30966	217	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
15106486	15106486	PRJNA393181_S_NODE_9352_length_394_cov_2.915966_g9246_i0	PRJNA393181	9352	394	2.915966	11.48890604	Bacteria	2	Bacteria	Bacteria	134	1.31e-26	NTclustered	gi\|2621704807\|emb\|OY763072.1\|	2026734	g9246	i0	88.496	1.07868020304569	113	9	28	3	53	163	927228	927118	MAG: Dehalococcoidia bacterium isolate 40e540cc-5106-4b3b-ab2b-631d7f64572a genome assembly, chromosome: 1	blastn	425	135	0.992592592592593	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
15713139	15713139	PRJNA393181_S_NODE_27973_length_214_cov_2.152542_g27867_i0	PRJNA393181	27973	214	2.152542	4.60643988	Chloroflexota bacterium	2026724	Bacteria	Bacteria	124	3.94e-24	NTclustered	gi\|2893358419\|emb\|OZ220711.1\|	2026724	g27867	i0	81.879	3.01401869158878	149	25	69	2	4	151	1629239	1629092	MAG: Chloroflexota bacterium isolate becf4303-f7f7-40d2-ac05-50973768c6f1 genome assembly, chromosome: 1	blastn	645	124	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
17656309	17656309	PRJNA393181_S_NODE_7134_length_444_cov_2.361179_g7028_i0	PRJNA393181	7134	444	2.361179	10.48363476	Bacteria	2	Bacteria	Bacteria	62.1	7.14e-5	NTclustered	gi\|2621704807\|emb\|OY763072.1\|	2026734	g7028	i0	100	21.0202702702703	33	0	10	0	238	270	1364597	1364629	MAG: Dehalococcoidia bacterium isolate 40e540cc-5106-4b3b-ab2b-631d7f64572a genome assembly, chromosome: 1	blastn	9333	62.1	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
18262061	18262061	PRJNA393181_S_NODE_27255_length_217_cov_3.183333_g27149_i0	PRJNA393181	27255	217	3.183333	6.90783261	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2531948656\|emb\|OY282446.1\|	3022862	g27149	i0	96.774	0.142857142857143	31	1	14	0	159	189	226947	226917	MAG: Tepidiformaceae bacterium genome assembly, chromosome: 1	blastn	31	52.8	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiformaceae bacterium
19536141	19536141	PRJNA393181_S_NODE_216_length_1266_cov_3.095199_g177_i0	PRJNA393181	216	1266	3.095199	39.18521934	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	470	3.01e-127	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g177	i0	79.33	7.27883096366509	687	128	54	14	46	724	8011128	8010448	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	9215	470	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
24636955	24636955	PRJNA393181_S_NODE_32440_length_194_cov_3.885350_g32334_i0	PRJNA393181	32440	194	3.88535	7.537579	Chloroflexota bacterium	2026724	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2893358419\|emb\|OZ220711.1\|	2026724	g32334	i0	96.875	0.164948453608247	32	1	16	0	101	132	1697335	1697304	MAG: Chloroflexota bacterium isolate becf4303-f7f7-40d2-ac05-50973768c6f1 genome assembly, chromosome: 1	blastn	32	54.7	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota 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);;