metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA1059246" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA1059246" 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
1451750	1451750	PRJNA1059246_P_NODE_41442_length_329_cov_1.503906_g40816_i0	PRJNA1059246	41442	329	1.503906	4.94785074	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	191	6.29e-44	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g40816	i0	80	71.1033434650456	265	48	80	3	43	305	400124	399863	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	23393	191	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
2727558	2727558	PRJNA1059246_P_NODE_35843_length_360_cov_1.073171_g35217_i0	PRJNA1059246	35843	360	1.073171	3.8634156	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	62.1	5.67e-5	NTclustered	gi\|2621704111\|emb\|OY761558.1\|	2026734	g35217	i0	100	0.183333333333333	33	0	9	0	280	312	1051	1019	MAG: Dehalococcoidia bacterium isolate 6ae818db-717c-4d07-8374-be93c3d6d717 genome assembly, chromosome: 1	blastn	66	62.1	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
4003288	4003288	PRJNA1059246_P_NODE_21444_length_489_cov_1.134615_g20825_i0	PRJNA1059246	21444	489	1.134615	5.54826735	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	436	1.13e-117	NTclustered	gi\|2626233621\|emb\|OY820591.1\|	2026734	g20825	i0	84.564	154.294478527607	447	61	91	8	45	487	2074205	2074647	MAG: Dehalococcoidia bacterium isolate bad7acc4-ca48-4abb-846f-85865ba1c961 genome assembly, chromosome: 1	blastn	75450	436	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
4003315	4003315	PRJNA1059246_P_NODE_23264_length_466_cov_1.702290_g22641_i0	PRJNA1059246	23264	466	1.70229	7.9326714	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.045	NTclustered	gi\|2621703647\|emb\|OY762633.1\|	2026734	g22641	i0	100	0.0600858369098712	28	0	6	0	54	81	42016	42043	MAG: Dehalococcoidia bacterium isolate 17254eae-7cb3-4ac9-839e-465292e2b3d4 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
7389197	7389197	PRJNA1059246_P_NODE_36366_length_357_cov_1.010563_g35740_i0	PRJNA1059246	36366	357	1.010563	3.60770991	Caldilinea	233191	Bacteria	Bacteria	440	6.169999999999999e-119	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g35740	i0	90.029	175.694677871148	341	32	95	2	18	357	967	628	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	62723	440	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
11655874	11655874	PRJNA1059246_P_NODE_60590_length_254_cov_1.430939_g59964_i0	PRJNA1059246	60590	254	1.430939	3.63458506	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	436	5.45e-118	NTclustered	gi\|339792301\|gb\|JN002744.1\|	166587	g59964	i0	97.638	97.3897637795276	254	6	100	0	1	254	456	203	Uncultured Chloroflexi bacterium clone F15cmL161 16S ribosomal RNA gene, partial sequence	blastn	24737	436	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
12930731	12930731	PRJNA1059246_P_NODE_35571_length_361_cov_2.177083_g34945_i0	PRJNA1059246	35571	361	2.177083	7.85926963	Anaerolineales bacterium	2073117	Bacteria	Bacteria	350	1.08e-91	NTclustered	gi\|2556903179\|gb\|CP129482.1\|	2073117	g34945	i0	84.658	6.93905817174515	365	40	100	8	1	361	414085	414437	MAG: Anaerolineales bacterium isolate cMAG.14 chromosome, complete genome	blastn	2505	350	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
14206148	14206148	PRJNA1059246_P_NODE_73072_length_230_cov_2.375796_g72446_i0	PRJNA1059246	73072	230	2.375796	5.4643308	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	285	1.86e-72	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g72446	i0	89.13	116.313043478261	230	23	99	2	2	230	2064718	2064946	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	26752	285	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
15479544	15479544	PRJNA1059246_P_NODE_13473_length_643_cov_1.231579_g12888_i0	PRJNA1059246	13473	643	1.231579	7.91905297	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	839	0	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g12888	i0	90.263	561.166407465008	647	55	100	8	1	643	671321	671963	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	360830	839	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
18029090	18029090	PRJNA1059246_P_NODE_62755_length_250_cov_0.870056_g62129_i0	PRJNA1059246	62755	250	0.870056	2.17514	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	241	4.5e-59	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g62129	i0	85.714	163.568	231	29	92	4	14	242	2202583	2202355	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	40892	241	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
19302474	19302474	PRJNA1059246_P_NODE_15156_length_602_cov_1.323251_g14557_i0	PRJNA1059246	15156	602	1.323251	7.96597102	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	845	0	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g14557	i0	92.053	640.993355481728	604	42	99	5	1	600	2202731	2202130	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	385878	845	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
19303109	19303109	PRJNA1059246_P_NODE_65156_length_248_cov_0.880000_g64530_i0	PRJNA1059246	65156	248	0.88	2.1824	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	364	2.539999999999999e-96	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g64530	i0	93.145	43.8306451612903	248	17	100	0	1	248	1859117	1858870	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	10870	364	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
20137866	20137866	PRJNA1059246_P_NODE_27856_length_418_cov_2.768116_g27231_i0	PRJNA1059246	27856	418	2.768116	11.57072488	Tepidiforma	2682228	Bacteria	Bacteria	604	2.4599999999999985e-168	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g27231	i0	92.806	293.311004784689	417	30	99	0	2	418	2203690	2203274	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	122604	604	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
20578006	20578006	PRJNA1059246_P_NODE_27237_length_424_cov_2.960114_g26612_i0	PRJNA1059246	27237	424	2.960114	12.55088336	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	261	6.24e-65	NTclustered	gi\|2891482139\|emb\|OZ219872.1\|	2026734	g26612	i0	84.444	126.933962264151	270	36	63	6	154	421	448950	449215	MAG: Dehalococcoidia bacterium isolate adc01b0e-c114-4b94-a05b-fd73c1a39460 genome assembly, chromosome: 6	blastn	53820	261	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
20578142	20578142	PRJNA1059246_P_NODE_38957_length_342_cov_1.672862_g38331_i0	PRJNA1059246	38957	342	1.672862	5.72118804	uncultured Chloroflexus sp.	214040	Bacteria	Bacteria	490	5.78e-134	NTclustered	gi\|219811506\|gb\|FJ551720.1\|	214040	g38331	i0	92.308	107.652046783626	351	18	100	3	1	342	443	93	Uncultured Chloroflexus sp. clone LTSP_BACT_P4E05 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36817	490	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	uncultured Chloroflexus sp.
20578145	20578145	PRJNA1059246_P_NODE_39277_length_340_cov_2.262172_g38651_i0	PRJNA1059246	39277	340	2.262172	7.6913848	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	551	2.5999999999999993e-152	NTclustered	gi\|313576369\|gb\|HQ397165.1\|	166587	g38651	i0	95.906	89.7176470588235	342	10	100	4	1	340	499	160	Uncultured Chloroflexi bacterium clone NLS1.1 16S ribosomal RNA gene, partial sequence	blastn	30504	551	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
20578490	20578490	PRJNA1059246_P_NODE_7037_length_926_cov_2.286049_g6557_i0	PRJNA1059246	7037	926	2.286049	21.16881374	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	1275	0	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g6557	i0	91.622	527.772138228942	931	64	99	12	1	923	2202128	2203052	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	488717	1275	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
21853964	21853964	PRJNA1059246_P_NODE_42538_length_324_cov_1.071713_g41912_i0	PRJNA1059246	42538	324	1.071713	3.47235012	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	483	9.11e-132	NTclustered	gi\|2814788335\|emb\|OY760861.2\|	3022862	g41912	i0	93.519	97.8518518518518	324	21	100	0	1	324	947847	948170	MAG: Tepidiformaceae bacterium isolate 815c9385-4915-413f-8b4b-d9ebc7d9cf62 genome assembly, chromosome: 1	blastn	31704	483	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
21854260	21854260	PRJNA1059246_P_NODE_67558_length_246_cov_0.890173_g66932_i0	PRJNA1059246	67558	246	0.890173	2.18982558	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	220	5.76e-53	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g66932	i0	82.996	73.3861788617886	247	38	99	4	3	246	8161106	8160861	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	18053	220	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23129794	23129794	PRJNA1059246_P_NODE_73119_length_228_cov_3.374194_g72493_i0	PRJNA1059246	73119	228	3.374194	7.69316232	Chloroflexota bacterium	2026724	Bacteria	Bacteria	58.4	4.37e-4	NTclustered	gi\|2621706018\|emb\|OY764080.1\|	2026724	g72493	i0	94.595	0.162280701754386	37	2	16	0	84	120	167581	167617	MAG: Chloroflexota bacterium isolate a04a8705-9522-4335-bb9c-b9bb47e5c42e genome assembly, chromosome: 1	blastn	37	58.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
24403108	24403108	PRJNA1059246_P_NODE_45600_length_309_cov_1.631356_g44974_i0	PRJNA1059246	45600	309	1.631356	5.04089004	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	401	2.4899999999999988e-107	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g44974	i0	90.26	116.401294498382	308	28	99	2	2	308	273848	274154	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	35968	401	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);;