metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA358490" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA358490" 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
1673808	1673808	PRJNA358490_P_NODE_7142_length_477_cov_2.680365_g6809_i0	PRJNA358490	7142	477	2.680365	12.78534105	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	121	1.26e-22	NTclustered	gi\|2531976022\|emb\|OY282355.1\|	498747	g6809	i0	85	11.4989517819706	120	16	25	2	351	469	2403026	2402908	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	5485	121	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			uncultured Dehalococcoidia bacterium
5502646	5502646	PRJNA358490_P_NODE_3125_length_811_cov_1.402850_g2918_i0	PRJNA358490	3125	811	1.40285	11.3771135	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	257	1.61e-63	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g2918	i0	82.026	0.567200986436498	306	51	37	4	151	454	3392404	3392101	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	460	257	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
5502700	5502700	PRJNA358490_P_NODE_6845_length_493_cov_11.202643_g6514_i0	PRJNA358490	6845	493	11.202643	55.22902999	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	226	2.6799999999999996e-54	NTclustered	gi\|2893358443\|emb\|OZ220735.1\|	3069543	g6514	i0	76	42.7119675456389	500	84	97	26	3	479	2878312	2878798	MAG: Phototrophicaceae bacterium isolate 252cb3c6-93c9-4785-98a9-44529c25b936 genome assembly, chromosome: 1	blastn	21057	226	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicaceae bacterium
8052317	8052317	PRJNA358490_P_NODE_3907_length_720_cov_2.731278_g3682_i0	PRJNA358490	3907	720	2.731278	19.6652016	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	427	1.02e-114	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g3682	i0	78.355	1.78333333333333	693	126	95	20	19	700	3493775	3494454	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	1284	427	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
10602682	10602682	PRJNA358490_P_NODE_11689_length_261_cov_1.472973_g11345_i0	PRJNA358490	11689	261	1.472973	3.84445953	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	150	8.2e-32	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g11345	i0	77.734	0.980842911877395	256	50	96	6	1	251	1335294	1335547	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	256	150	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
14427912	14427912	PRJNA358490_P_NODE_9392_length_365_cov_1.794479_g9050_i0	PRJNA358490	9392	365	1.794479	6.54984835	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	431	3.809999999999999e-116	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g9050	i0	88.076	18.8767123287671	369	36	100	5	1	365	933864	933500	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	6890	431	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
15701773	15701773	PRJNA358490_P_NODE_5133_length_606_cov_4.047619_g4850_i0	PRJNA358490	5133	606	4.047619	24.52857114	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	562	2.24e-155	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g4850	i0	85.018	81.1980198019802	554	81	91	2	31	583	1031176	1030624	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	49206	562	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
16976307	16976307	PRJNA358490_P_NODE_10274_length_319_cov_1.232143_g9932_i0	PRJNA358490	10274	319	1.232143	3.93053617	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	67.6	1.07e-6	NTclustered	gi\|2893358442\|emb\|OZ220734.1\|	2026734	g9932	i0	93.333	1.23510971786834	45	3	14	0	142	186	2406178	2406134	MAG: Dehalococcoidia bacterium isolate 0c714f15-409a-4665-a51d-e85178f2a5b0 genome assembly, chromosome: 1	blastn	394	67.6	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
16976313	16976313	PRJNA358490_P_NODE_11134_length_282_cov_1.460905_g10791_i0	PRJNA358490	11134	282	1.460905	4.1197521	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	291	5.06e-74	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g10791	i0	85.357	99.613475177305	280	41	99	0	3	282	3307180	3307459	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	28091	291	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
16976540	16976540	PRJNA358490_P_NODE_9714_length_347_cov_3.259740_g9372_i0	PRJNA358490	9714	347	3.25974	11.3112978	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	532	9.63e-147	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g9372	i0	96.061	198.550432276657	330	8	94	5	22	347	19845	19517	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	68897	532	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
18250582	18250582	PRJNA358490_P_NODE_12915_length_224_cov_1.540541_g12571_i0	PRJNA358490	12915	224	1.540541	3.45081184	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	143	1.15e-29	NTclustered	gi\|2621703647\|emb\|OY762633.1\|	2026734	g12571	i0	78.972	2.69196428571429	214	41	95	4	12	223	1300472	1300261	MAG: Dehalococcoidia bacterium isolate 17254eae-7cb3-4ac9-839e-465292e2b3d4 genome assembly, chromosome: 1	blastn	603	143	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
20199242	20199242	PRJNA358490_P_NODE_10536_length_306_cov_1.359551_g10194_i0	PRJNA358490	10536	306	1.359551	4.16022606	Bacteria	2	Bacteria	Bacteria	76.8	1.69e-9	NTclustered	gi\|2531976022\|emb\|OY282355.1\|	498747	g10194	i0	97.727	11.8137254901961	44	1	14	0	1	44	2377295	2377338	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	3615	76.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			uncultured Dehalococcoidia bacterium
20800417	20800417	PRJNA358490_P_NODE_10977_length_288_cov_2.425703_g10635_i0	PRJNA358490	10977	288	2.425703	6.98602464	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	196	1.16e-45	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g10635	i0	89.61	59.0138888888889	154	16	53	0	115	268	3360332	3360179	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	16996	196	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
20800552	20800552	PRJNA358490_P_NODE_3937_length_716_cov_2.580502_g3712_i0	PRJNA358490	3937	716	2.580502	18.47639432	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	351	6.300000000000001e-92	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g3712	i0	82.353	34.2779329608939	408	69	57	3	308	714	1434523	1434928	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	24543	351	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
22075501	22075501	PRJNA358490_P_NODE_13858_length_201_cov_3.037037_g13514_i0	PRJNA358490	13858	201	3.037037	6.10444437	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	320	4.34e-83	NTclustered	gi\|2874253812\|emb\|OY969796.1\|	1672391	g13514	i0	97.34	256.014925373134	188	5	94	0	1	188	3033727	3033540	MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1	blastn	51459	320	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
24625271	24625271	PRJNA358490_P_NODE_2620_length_883_cov_3.928910_g2442_i0	PRJNA358490	2620	883	3.92891	34.6922753	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	763	0	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g2442	i0	84.054	28.20724801812	809	112	90	15	54	852	1106465	1107266	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	24907	763	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
24625295	24625295	PRJNA358490_P_NODE_4000_length_708_cov_1.814649_g3772_i0	PRJNA358490	4000	708	1.814649	12.84771492	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	577	9.439999999999999e-160	NTclustered	gi\|2874253835\|emb\|OY969885.1\|	1672391	g3772	i0	82.249	2.14265536723164	676	113	95	6	9	679	1179454	1178781	MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1	blastn	1517	577	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);;