metadata: contig_metadata: 27 rows where bioproject = "PRJNA278119", tax_phylum = "Chloroflexota" and tax

27 rows where bioproject = "PRJNA278119", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6748889	6748889	PRJNA278119_P_NODE_24246_length_201_cov_1.019737_g23997_i0	PRJNA278119	24246	201	1.019737	2.04967137	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	187	4.5899999999999985e-43	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g23997	i0	83.663	7.99502487562189	202	29	100	3	1	201	1494	1296	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	1607	187	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
8711565	8711565	PRJNA278119_P_NODE_4467_length_568_cov_22.454721_g4224_i0	PRJNA278119	4467	568	22.454721	127.54281528	Herpetosiphon	64	Bacteria	Bacteria	377	8.14e-100	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g4224	i0	79.387	54.6302816901408	587	82	100	32	1	568	572	6	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	31030	377	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
9299392	9299392	PRJNA278119_P_NODE_31308_length_177_cov_1.554688_g31059_i0	PRJNA278119	31308	177	1.554688	2.75179776	Anaerolinea thermophila	167964	Bacteria	Bacteria	172	1.0999999999999999e-38	NTclustered	gi\|319993263\|dbj\|AP012029.1\|	926569	g31059	i0	90.37	97.6666666666667	135	8	75	5	10	142	198095	198226	Anaerolinea thermophila UNI-1 DNA, complete genome	blastn	17287	172	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea thermophila
13125056	13125056	PRJNA278119_P_NODE_2551_length_767_cov_2.661560_g2330_i0	PRJNA278119	2551	767	2.66156	20.4141652	Anaerolineales bacterium	2073117	Bacteria	Bacteria	760	0	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g2330	i0	97.95	150.831812255541	439	8	95	1	4	441	2030032	2029594	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	115688	760	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
18222715	18222715	PRJNA278119_P_NODE_11775_length_335_cov_1.045455_g11527_i0	PRJNA278119	11775	335	1.045455	3.50227425	Anaerolineales bacterium	2073117	Bacteria	Bacteria	470	7.36e-128	NTclustered	gi\|2556903179\|gb\|CP129482.1\|	2073117	g11527	i0	92.012	548.017910447761	338	22	100	5	1	335	3066872	3067207	MAG: Anaerolineales bacterium isolate cMAG.14 chromosome, complete genome	blastn	183586	470	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
18223185	18223185	PRJNA278119_P_NODE_46075_length_162_cov_2.265487_g45826_i0	PRJNA278119	46075	162	2.265487	3.67008894	Anaerolineales bacterium	2073117	Bacteria	Bacteria	231	1.6099999999999998e-56	NTclustered	gi\|2556903179\|gb\|CP129482.1\|	2073117	g45826	i0	92.593	266.302469135802	162	10	99	2	2	162	3067031	3066871	MAG: Anaerolineales bacterium isolate cMAG.14 chromosome, complete genome	blastn	43141	231	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
24597348	24597348	PRJNA278119_P_NODE_26540_length_192_cov_1.090909_g26291_i0	PRJNA278119	26540	192	1.090909	2.09454528	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	69.4	1.64e-7	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g26291	i0	93.478	0.239583333333333	46	3	24	0	5	50	9732920	9732875	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	46	69.4	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
24597486	24597486	PRJNA278119_P_NODE_34980_length_169_cov_0.866667_g34731_i0	PRJNA278119	34980	169	0.866667	1.46466723	Anaerolineales bacterium	2073117	Bacteria	Bacteria	58.4	3.03e-4	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g34731	i0	97.059	0.621301775147929	34	1	20	0	127	160	3791396	3791429	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	105	58.4	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
26725486	26725486	PRJNA278119_P_NODE_2241_length_821_cov_2.126943_g2030_i0	PRJNA278119	2241	821	2.126943	17.46220203	Anaerolineales bacterium	2073117	Bacteria	Bacteria	368	2.71e-117	NR	HND47414.1	2073117	g2030	i0	63	1.08526187576127	297	82	99.8	3	3	821	402	694	HND47414.1 hypothetical protein [Anaerolineales bacterium]	diamond	891	368	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
27136881	27136881	PRJNA278119_P_NODE_5962_length_488_cov_2.234624_g5716_i0	PRJNA278119	5962	488	2.234624	10.90496512	Anaerolineales bacterium	2073117	Bacteria	Bacteria	110	1.22e-24	NR	HND47414.1	2073117	g5716	i0	45	0.860655737704918	140	61	78.7	7	3	386	183	318	HND47414.1 hypothetical protein [Anaerolineales bacterium]	diamond	420	110	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
27376564	27376564	PRJNA278119_P_NODE_46423_length_162_cov_1.380531_g46174_i0	PRJNA278119	46423	162	1.380531	2.23646022	Bacteria	2	Bacteria	Bacteria	81.6	1.76e-16	NR	HEY7467127.1	2026734	g46174	i0	69.2	8.57407407407407	52	16	96.3	0	3	158	262	313	HEY7467127.1 MBL fold metallo-hydrolase [Dehalococcoidia bacterium]	diamond	1389	82.4	0.990291262135922	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
27390339	27390339	PRJNA278119_P_NODE_44803_length_163_cov_1.210526_g44554_i0	PRJNA278119	44803	163	1.210526	1.97315738	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	83.6	5.17e-17	NR	HEU4326262.1	2762507	g44554	i0	75.9	0.993865030674847	54	13	99.4	0	1	162	519	572	HEU4326262.1 S9 family peptidase [Roseiflexaceae bacterium]	diamond	162	83.6	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae		Roseiflexaceae bacterium
28495404	28495404	PRJNA278119_P_NODE_35167_length_169_cov_0.866667_g34918_i0	PRJNA278119	35167	169	0.866667	1.46466723	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	112	1.26e-27	NR	HEU5101156.1	2762507	g34918	i0	94.6	0.994082840236686	56	3	99.4	0	2	169	149	204	HEU5101156.1 extracellular solute-binding protein [Roseiflexaceae bacterium]	diamond	168	112	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae		Roseiflexaceae bacterium
28495421	28495421	PRJNA278119_P_NODE_807_length_1315_cov_2.852291_g676_i0	PRJNA278119	807	1315	2.852291	37.50762665	Anaerolineales bacterium	2073117	Bacteria	Bacteria	175	1.44e-44	NR	HND47413.1	2073117	g676	i0	29.8	1.06539923954373	467	197	76.9	6	1315	305	171	636	HND47413.1 Ty1/Copia family ribonuclease HI [Anaerolineales bacterium]	diamond	1401	175	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29112945	29112945	PRJNA278119_P_NODE_46128_length_162_cov_1.840708_g45879_i0	PRJNA278119	46128	162	1.840708	2.98194696	PVC group	1783257	Bacteria	Bacteria	46.6	5.58e-4	NR	MCX6071241.1	2026724	g45879	i0	47.1	7.55555555555556	51	27	94.4	0	10	162	293	343	MCX6071241.1 transketolase [Chloroflexota bacterium]	diamond	1224	47	0.991489361702128	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
29789642	29789642	PRJNA278119_P_NODE_33711_length_171_cov_1.278689_g33462_i0	PRJNA278119	33711	171	1.278689	2.18655819	Anaerolineae bacterium	2052143	Bacteria	Bacteria	88.2	1.24e-18	NR	MCC7207441.1	2052143	g33462	i0	78.6	3.98245614035088	56	12	98.2	0	4	171	91	146	MCC7207441.1 orotidine-5'-phosphate decarboxylase [Anaerolineae bacterium]	diamond	681	88.2	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30091580	30091580	PRJNA278119_P_NODE_36672_length_168_cov_0.873950_g36423_i0	PRJNA278119	36672	168	0.87395	1.468236	Bacillati	1783272	Bacteria	Bacteria	43.1	0.00977	NR	OGO06267.1	1797632	g36423	i0	53.8	9.25	39	18	69.6	0	119	3	231	269	OGO06267.1 MAG: copper-translocating P-type ATPase, partial [Chloroflexi bacterium RBG_13_56_8]	diamond	1554	43.5	0.990804597701149	Bacteria		Bacillati	Chloroflexota					Chloroflexi bacterium RBG_13_56_8
30358924	30358924	PRJNA278119_P_NODE_11012_length_349_cov_4.010000_g10765_i0	PRJNA278119	11012	349	4.01	13.9949	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	90.5	1.76e-20	NR	MDO9333994.1	2026733	g10765	i0	92.2	0.438395415472779	51	3	43	1	3	152	89	139	MDO9333994.1 30S ribosomal protein S4 [Dehalococcoidales bacterium]	diamond	153	90.5	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
30358952	30358952	PRJNA278119_P_NODE_39672_length_166_cov_1.213675_g39423_i0	PRJNA278119	39672	166	1.213675	2.0147005	Anaerolineales bacterium	2073117	Bacteria	Bacteria	54.3	1.06e-6	NR	HND47414.1	2073117	g39423	i0	51	0.885542168674699	49	24	88.6	0	18	164	17	65	HND47414.1 hypothetical protein [Anaerolineales bacterium]	diamond	147	54.3	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31021964	31021964	PRJNA278119_P_NODE_14855_length_282_cov_1.484979_g14606_i0	PRJNA278119	14855	282	1.484979	4.18764078	Candidatus Lucifugimonas marina	3038979	Bacteria	Bacteria	64.3	5.7e-10	NR	WP_342835703.1	3038979	g14606	i0	67.4	1.37234042553191	43	14	45.7	0	153	281	158	200	WP_342835703.1 NAD(P)-dependent oxidoreductase [Candidatus Lucifugimonas marina]	diamond	387	64.3	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia	Candidatus Lucifugimonadales	Candidatus Lucifugimonadaceae	Candidatus Lucifugimonas	Candidatus Lucifugimonas marina
31085172	31085172	PRJNA278119_P_NODE_45955_length_163_cov_0.894737_g45706_i0	PRJNA278119	45955	163	0.894737	1.45842131	Chloroflexota bacterium	2026724	Bacteria	Bacteria	53.1	2.7e-6	NR	HET7770507.1	2026724	g45706	i0	84.8	0.607361963190184	33	5	60.7	0	100	2	388	420	HET7770507.1 YfhO family protein [Chloroflexota bacterium]	diamond	99	53.1	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
31116480	31116480	PRJNA278119_P_NODE_20355_length_221_cov_1.808140_g20106_i0	PRJNA278119	20355	221	1.80814	3.9959894	Anaerolineales bacterium	2073117	Bacteria	Bacteria	103	7.93e-24	NR	HND47414.1	2073117	g20106	i0	59.7	0.97737556561086	72	29	97.7	0	1	216	728	799	HND47414.1 hypothetical protein [Anaerolineales bacterium]	diamond	216	103	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31274734	31274734	PRJNA278119_P_NODE_23035_length_206_cov_1.210191_g22786_i0	PRJNA278119	23035	206	1.210191	2.49299346	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	69.3	4.07e-12	NR	HZS76708.1	2740538	g22786	i0	46.2	2.14077669902913	78	32	99	2	204	1	84	161	HZS76708.1 sulfotransferase [Ktedonobacteraceae bacterium]	diamond	441	69.3	1	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
31749077	31749077	PRJNA278119_P_NODE_12177_length_327_cov_1.859712_g11929_i0	PRJNA278119	12177	327	1.859712	6.08125824	Anaerolineales bacterium	2073117	Bacteria	Bacteria	95.9	2.24e-20	NR	HND47414.1	2073117	g11929	i0	60	0.688073394495413	75	27	66.1	1	322	107	801	875	HND47414.1 hypothetical protein [Anaerolineales bacterium]	diamond	225	95.9	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31907379	31907379	PRJNA278119_P_NODE_45817_length_163_cov_0.912281_g45568_i0	PRJNA278119	45817	163	0.912281	1.48701803	Chloroflexota bacterium	2026724	Bacteria	Bacteria	81.3	3.26e-16	NR	RPJ26839.1	2026724	g45568	i0	70.9	6.03680981595092	55	15	99.4	1	2	163	132	186	RPJ26839.1 MAG: aminotransferase class V-fold PLP-dependent enzyme [Chloroflexota bacterium]	diamond	984	81.3	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
32666232	32666232	PRJNA278119_P_NODE_7540_length_433_cov_1.625000_g7293_i0	PRJNA278119	7540	433	1.625	7.03625	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	144	2.82e-41	NR	RJP51470.1	2024896	g7293	i0	58.4	1.7459584295612	125	47	83.1	1	422	63	2	126	RJP51470.1 MAG: RidA family protein [Anaerolineaceae bacterium]	diamond	756	144	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
32760707	32760707	PRJNA278119_P_NODE_37100_length_168_cov_0.873950_g36851_i0	PRJNA278119	37100	168	0.87395	1.468236	Chloroflexota bacterium	2026724	Bacteria	Bacteria	72	5.94e-13	NR	MCH8062211.1	2026724	g36851	i0	56.4	0.982142857142857	55	24	98.2	0	2	166	318	372	MCH8062211.1 6-phosphofructokinase [Chloroflexota bacterium]	diamond	165	72	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);;