metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA743294" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA743294" 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
721893	721893	PRJNA743294_P_NODE_13741_length_431_cov_1.737430_g13285_i0	PRJNA743294	13741	431	1.73743	7.4883233	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	322	2.87e-83	NTclustered	gi\|2893356069\|emb\|OZ220492.1\|	2614250	g13285	i0	81.429	325.2343387471	420	54	94	21	26	431	2778239	2777830	MAG: Caldilineaceae bacterium isolate e886e3b1-96bd-41d4-96ed-8e2f365de7fb genome assembly, chromosome: 1	blastn	140176	322	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
722165	722165	PRJNA743294_P_NODE_54121_length_244_cov_1.701754_g53665_i0	PRJNA743294	54121	244	1.701754	4.15227976	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2621706198\|emb\|OY764542.1\|	2026734	g53665	i0	92.105	0.155737704918033	38	2	15	1	94	130	3165931	3165968	MAG: Dehalococcoidia bacterium isolate 6a5b5718-e0ca-4583-9154-875545b380e3 genome assembly, chromosome: 1	blastn	38	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
722230	722230	PRJNA743294_P_NODE_801_length_1417_cov_7.780506_g654_i0	PRJNA743294	801	1417	7.780506	110.24977002	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	1079	0	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g654	i0	80.857	118.014820042343	1447	213	99	49	10	1417	2202322	2203743	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	167227	1079	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
3273445	3273445	PRJNA743294_P_NODE_42703_length_261_cov_2.611702_g42247_i0	PRJNA743294	42703	261	2.611702	6.81654222	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	366	7.48e-97	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g42247	i0	92.248	127.904214559387	258	20	99	0	1	258	672012	672269	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	33383	366	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
3273526	3273526	PRJNA743294_P_NODE_52523_length_246_cov_0.901734_g52067_i0	PRJNA743294	52523	246	0.901734	2.21826564	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|148566298\|gb\|CP000686.1\|	357808	g52067	i0	100	0.113821138211382	28	0	11	0	51	78	3777398	3777425	Roseiflexus sp. RS-1, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
4550511	4550511	PRJNA743294_P_NODE_2844_length_881_cov_10.268564_g1241_i2	PRJNA743294	2844	881	10.268564	90.46604884	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	800	0	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g1241	i2	95.079	537.427922814983	508	25	98	0	1	508	8314	8821	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	473474	800	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
7100949	7100949	PRJNA743294_P_NODE_6546_length_608_cov_2.280374_g6095_i0	PRJNA743294	6546	608	2.280374	13.86467392	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	785	0	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g6095	i0	90.016	202.110197368421	611	55	100	5	1	608	671257	671864	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	122883	785	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9650423	9650423	PRJNA743294_P_NODE_23748_length_337_cov_1.181818_g23292_i0	PRJNA743294	23748	337	1.181818	3.98272666	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	342	1.69e-89	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g23292	i0	85.131	432.3353115727	343	42	100	8	1	337	564982	565321	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	145697	342	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12201687	12201687	PRJNA743294_P_NODE_8950_length_526_cov_4.527594_g8494_i0	PRJNA743294	8950	526	4.527594	23.81514444	Anaerolineales bacterium	2073117	Bacteria	Bacteria	795	0	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g8494	i0	94.727	128.467680608365	512	25	97	2	1	510	2028671	2028160	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	67574	795	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
14750829	14750829	PRJNA743294_P_NODE_1512_length_1143_cov_11.328037_g1241_i1	PRJNA743294	1512	1143	11.328037	129.47946291	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	1574	0	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g1241	i1	91.508	484.700787401575	1154	83	100	8	1	1143	7618	8767	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	554013	1574	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
14750988	14750988	PRJNA743294_P_NODE_38072_length_274_cov_2.940299_g37616_i0	PRJNA743294	38072	274	2.940299	8.05641926	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	259	1.3800000000000002e-64	NTclustered	gi\|2874253736\|emb\|OY969578.1\|	1672391	g37616	i0	84.586	333.306569343066	266	36	96	5	2	264	3181015	3180752	MAG: uncultured Chloroflexia bacterium isolate MFD05674.bin.c.2 genome assembly, chromosome: 1	blastn	91326	259	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
18573837	18573837	PRJNA743294_P_NODE_43955_length_258_cov_2.043243_g43499_i0	PRJNA743294	43955	258	2.043243	5.27156694	Anaerolineales bacterium	2073117	Bacteria	Bacteria	316	7.539999999999998e-82	NTclustered	gi\|2621701347\|emb\|OY760067.1\|	2073117	g43499	i0	92	154.515503875969	225	18	87	0	1	225	896211	896435	MAG: Anaerolineales bacterium isolate e1712b75-d4f6-4c5e-bc49-bbfdc0d5b476 genome assembly, chromosome: 2	blastn	39865	316	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
22399373	22399373	PRJNA743294_P_NODE_1478_length_1157_cov_11.603321_g1241_i0	PRJNA743294	1478	1157	11.603321	134.25042397000001	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	1570	0	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g1241	i0	91.293	654.624027657735	1160	87	99	8	1	1155	8767	7617	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	757400	1570	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
23674883	23674883	PRJNA743294_P_NODE_12859_length_444_cov_5.514825_g12403_i0	PRJNA743294	12859	444	5.514825	24.485823	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	726	0	NTclustered	gi\|339646428\|gb\|JN038817.1\|	166587	g12403	i0	96.171	99.7117117117117	444	17	100	0	1	444	463	20	Uncultured Chloroflexi bacterium clone P-R30 16S ribosomal RNA gene, partial sequence	blastn	44272	726	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
23675046	23675046	PRJNA743294_P_NODE_3379_length_817_cov_13.540323_g1241_i3	PRJNA743294	3379	817	13.540323	110.62443891	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	793	0	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g1241	i3	95.04	620.029375764994	504	25	98	0	1	504	8314	8817	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	506564	793	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
23675069	23675069	PRJNA743294_P_NODE_36519_length_279_cov_2.849515_g36063_i0	PRJNA743294	36519	279	2.849515	7.95014685	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	438	1.6899999999999996e-118	NTclustered	gi\|2874253704\|emb\|OY969431.1\|	1672391	g36063	i0	94.982	534.491039426523	279	14	100	0	1	279	65048	65326	MAG: uncultured Chloroflexia bacterium isolate MFD02979.bin.c.2 genome assembly, chromosome: 1	blastn	149123	438	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);;