metadata: contig_metadata: 28 rows where analysis = "diamond", bioproject = "PRJNA1067443" and tax

28 rows where analysis = "diamond", bioproject = "PRJNA1067443" 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
10384808	10384808	PRJNA1067443_P_NODE_20729_length_244_cov_0.900585_g20711_i0	PRJNA1067443	20729	244	0.900585	2.1974274	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	127	1.96e-32	NR	HEY6570708.1	2952938	g20711	i0	80.2	0.995901639344262	81	15	98.4	1	243	4	146	226	HEY6570708.1 extracellular solute-binding protein [Candidatus Limnocylindrales bacterium]	diamond	243	127	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
19307107	19307107	PRJNA1067443_P_NODE_21436_length_243_cov_0.905882_g21418_i0	PRJNA1067443	21436	243	0.905882	2.20129326	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	124	5.6999999999999996e-33	NR	MBI1282250.1	2024896	g21418	i0	82.4	1.82716049382716	74	13	91.4	0	22	243	1	74	MBI1282250.1 heme ABC exporter ATP-binding protein CcmA [Anaerolineaceae bacterium]	diamond	444	124	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
19307117	19307117	PRJNA1067443_P_NODE_21876_length_242_cov_0.911243_g21858_i0	PRJNA1067443	21876	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	160	3.46e-45	NR	MEP6986310.1	2026724	g21858	i0	98.8	3.96694214876033	80	1	99.2	0	241	2	120	199	MEP6986310.1 2-isopropylmalate synthase [Chloroflexota bacterium]	diamond	960	160	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
26750368	26750368	PRJNA1067443_P_NODE_13661_length_264_cov_1.403141_g13643_i0	PRJNA1067443	13661	264	1.403141	3.70429224	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	119	2.4e-29	NR	MCB0070303.1	2614250	g13643	i0	55.3	0.965909090909091	85	37	95.5	1	2	253	247	331	MCB0070303.1 phage terminase large subunit [Caldilineaceae bacterium]	diamond	255	119	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
27035657	27035657	PRJNA1067443_P_NODE_20262_length_245_cov_0.895349_g20244_i0	PRJNA1067443	20262	245	0.895349	2.19360505	Chloroflexota bacterium	2026724	Bacteria	Bacteria	167	7.6899999999999985e-47	NR	MEO8469307.1	2026724	g20244	i0	92.6	0.991836734693878	81	6	99.2	0	244	2	73	153	MEO8469307.1 PEP-utilizing enzyme [Chloroflexota bacterium]	diamond	243	167	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27130086	27130086	PRJNA1067443_P_NODE_20602_length_244_cov_0.900585_g20584_i0	PRJNA1067443	20602	244	0.900585	2.1974274	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	152	2.22e-45	NR	MBI1276499.1	2024896	g20584	i0	95	0.983606557377049	80	4	98.4	0	242	3	45	124	MBI1276499.1 cyclic nucleotide-binding domain-containing protein [Anaerolineaceae bacterium]	diamond	240	152	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
27193580	27193580	PRJNA1067443_P_NODE_12822_length_268_cov_2.261538_g12804_i0	PRJNA1067443	12822	268	2.261538	6.06092184	Anaerolineales bacterium	2073117	Bacteria	Bacteria	99	8.94e-22	NR	MCA9951763.1	2073117	g12804	i0	51.2	1.88059701492537	84	37	94	1	14	265	441	520	MCA9951763.1 VWA domain-containing protein [Anaerolineales bacterium]	diamond	504	99	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
27351985	27351985	PRJNA1067443_P_NODE_16803_length_250_cov_1.694915_g16785_i0	PRJNA1067443	16803	250	1.694915	4.2372875	Chloroflexota bacterium	2026724	Bacteria	Bacteria	87	3.77e-19	NR	MDQ3549066.1	2026724	g16785	i0	90.2	0.492	41	4	49.2	0	126	248	1	41	MDQ3549066.1 GNAT family N-acetyltransferase [Chloroflexota bacterium]	diamond	123	87	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27730964	27730964	PRJNA1067443_P_NODE_18284_length_248_cov_0.880000_g18266_i0	PRJNA1067443	18284	248	0.88	2.1824	Anaerolineae bacterium	2052143	Bacteria	Bacteria	98.2	3.92e-22	NR	MBA3872912.1	2052143	g18266	i0	56.1	0.991935483870968	82	36	99.2	0	248	3	163	244	MBA3872912.1 hybrid sensor histidine kinase/response regulator [Anaerolineae bacterium]	diamond	246	98.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27762507	27762507	PRJNA1067443_P_NODE_12344_length_271_cov_1.959596_g12326_i0	PRJNA1067443	12344	271	1.959596	5.31050516	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	67.4	6.85e-11	NR	HEY5472886.1	2952938	g12326	i0	68.3	0.907749077490775	41	13	45.4	0	266	144	254	294	HEY5472886.1 hypothetical protein [Candidatus Limnocylindrales bacterium]	diamond	246	67.4	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
28448695	28448695	PRJNA1067443_P_NODE_17206_length_250_cov_0.870056_g17188_i0	PRJNA1067443	17206	250	0.870056	2.17514	Bacillati	1783272	Bacteria	Bacteria	114	1.89e-30	NR	MEX2185040.1	2026724	g17188	i0	70.7	5.892	82	24	98.4	0	248	3	6	87	MEX2185040.1 DUF3037 domain-containing protein [Chloroflexota bacterium]	diamond	1473	114	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28457015	28457015	PRJNA1067443_P_NODE_20666_length_244_cov_0.900585_g20648_i0	PRJNA1067443	20666	244	0.900585	2.1974274	Chloroflexota bacterium	2026724	Bacteria	Bacteria	130	1.6e-35	NR	MCA0453126.1	2026724	g20648	i0	98.5	0.811475409836066	66	1	81.1	0	200	3	1	66	MCA0453126.1 YebC/PmpR family DNA-binding transcriptional regulator [Chloroflexota bacterium]	diamond	198	130	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28732715	28732715	PRJNA1067443_P_NODE_20847_length_244_cov_0.900585_g20829_i0	PRJNA1067443	20847	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	151	1.18e-40	NR	MBI1281904.1	2024896	g20829	i0	90.1	4.9672131147541	81	8	99.6	0	244	2	30	110	MBI1281904.1 replicative DNA helicase [Anaerolineaceae bacterium]	diamond	1212	151	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
28732717	28732717	PRJNA1067443_P_NODE_4667_length_365_cov_1.044521_g4649_i0	PRJNA1067443	4667	365	1.044521	3.81250165	FCB group	1783270	Bacteria	Bacteria	115	6.9e-27	NR	MEW6401338.1	2026724	g4649	i0	47.9	2.88493150684931	117	61	96.2	0	7	357	1410	1526	MEW6401338.1 RHS repeat-associated core domain-containing protein [Chloroflexota bacterium]	diamond	1053	115	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28993943	28993943	PRJNA1067443_P_NODE_5188_length_352_cov_1.655914_g5170_i0	PRJNA1067443	5188	352	1.655914	5.82881728	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	82	7.01e-18	NR	HYC00407.1	2952938	g5170	i0	69.1	0.9375	55	17	46.9	0	183	19	4	58	HYC00407.1 hypothetical protein [Candidatus Limnocylindrales bacterium]	diamond	330	82	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
29120156	29120156	PRJNA1067443_P_NODE_22849_length_241_cov_0.916667_g22831_i0	PRJNA1067443	22849	241	0.916667	2.20916747	Anaerolineae bacterium	2052143	Bacteria	Bacteria	142	3.0699999999999997e-37	NR	MBA3871223.1	2052143	g22831	i0	86.1	0.983402489626556	79	11	98.3	0	3	239	216	294	MBA3871223.1 GAF domain-containing protein [Anaerolineae bacterium]	diamond	237	142	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29341058	29341058	PRJNA1067443_P_NODE_16589_length_251_cov_0.865169_g16571_i0	PRJNA1067443	16589	251	0.865169	2.17157419	Promineifilum sp.	2664178	Bacteria	Bacteria	146	3.73e-41	NR	MBX7251338.1	2664178	g16571	i0	73.5	1.9840637450199201	83	22	99.2	0	249	1	193	275	MBX7251338.1 hypothetical protein [Promineifilum sp.]	diamond	498	146	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Promineifilum sp.
30193547	30193547	PRJNA1067443_P_NODE_12392_length_271_cov_1.489899_g12374_i0	PRJNA1067443	12392	271	1.489899	4.03762629	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	180	4.3e-52	NR	MBI1277643.1	2024896	g12374	i0	95.6	0.996309963099631	90	4	99.6	0	1	270	299	388	MBI1277643.1 ABC transporter substrate-binding protein [Anaerolineaceae bacterium]	diamond	270	180	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
30320592	30320592	PRJNA1067443_P_NODE_21912_length_242_cov_0.911243_g21894_i0	PRJNA1067443	21912	242	0.911243	2.20520806	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	136	4.899999999999998e-35	NR	MBI1279053.1	2024896	g21894	i0	87.3	1.95867768595041	79	10	97.9	0	4	240	2075	2153	MBI1279053.1 GAF domain-containing protein [Anaerolineaceae bacterium]	diamond	474	136	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
31109773	31109773	PRJNA1067443_P_NODE_17815_length_249_cov_0.875000_g17797_i0	PRJNA1067443	17815	249	0.875	2.17875	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	155	1.21e-41	NR	MBI1281780.1	2024896	g17797	i0	95.1	0.987951807228916	82	4	98.8	0	248	3	571	652	MBI1281780.1 DUF4118 domain-containing protein [Anaerolineaceae bacterium]	diamond	246	155	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
31141130	31141130	PRJNA1067443_P_NODE_10875_length_280_cov_1.444444_g10857_i0	PRJNA1067443	10875	280	1.444444	4.0444432	Chloroflexota bacterium	2026724	Bacteria	Bacteria	153	1.41e-44	NR	MCA0458568.1	2026724	g10857	i0	82.4	0.910714285714286	85	15	91.1	0	279	25	146	230	MCA0458568.1 rhomboid family intramembrane serine protease [Chloroflexota bacterium]	diamond	255	153	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31584472	31584472	PRJNA1067443_P_NODE_17676_length_249_cov_0.875000_g17658_i0	PRJNA1067443	17676	249	0.875	2.17875	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	110	4.75e-29	NR	MBI1282380.1	2024896	g17658	i0	80.7	0.686746987951807	57	11	68.7	0	1	171	59	115	MBI1282380.1 metalloregulator ArsR/SmtB family transcription factor [Anaerolineaceae bacterium]	diamond	171	110	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
31607514	31607514	PRJNA1067443_P_NODE_17036_length_250_cov_0.870056_g17018_i0	PRJNA1067443	17036	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	166	5.809999999999999e-46	NR	MEP6986637.1	2026724	g17018	i0	92.8	1.992	83	6	99.6	0	1	249	23	105	MEP6986637.1 NADH-quinone oxidoreductase subunit NuoG [Chloroflexota bacterium]	diamond	498	166	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31733825	31733825	PRJNA1067443_P_NODE_16557_length_251_cov_0.865169_g16539_i0	PRJNA1067443	16557	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	155	5.18e-45	NR	MBI1279162.1	2024896	g16539	i0	89.2	1.9840637450199201	83	9	99.2	0	249	1	35	117	MBI1279162.1 DUF4013 domain-containing protein [Anaerolineaceae bacterium]	diamond	498	155	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
31765589	31765589	PRJNA1067443_P_NODE_10477_length_282_cov_2.119617_g10459_i0	PRJNA1067443	10477	282	2.119617	5.97731994	Bacteria	2	Bacteria	Bacteria	168	3.54e-51	NR	MDQ3542002.1	2026724	g10459	i0	84.9	4.9468085106383	93	14	98.9	0	280	2	6	98	MDQ3542002.1 50S ribosomal protein L3 [Chloroflexota bacterium]	diamond	1395	168	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32153758	32153758	PRJNA1067443_P_NODE_19698_length_246_cov_0.890173_g19680_i0	PRJNA1067443	19698	246	0.890173	2.18982558	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	53.5	5.85e-6	NR	MBI1281079.1	2024896	g19680	i0	85.2	0.329268292682927	27	4	32.9	0	166	246	10	36	MBI1281079.1 gfo/Idh/MocA family oxidoreductase [Anaerolineaceae bacterium]	diamond	81	53.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
32596653	32596653	PRJNA1067443_P_NODE_19380_length_246_cov_0.890173_g19362_i0	PRJNA1067443	19380	246	0.890173	2.18982558	Chloroflexota bacterium	2026724	Bacteria	Bacteria	94	2.5300000000000003e-22	NR	MEO8470355.1	2026724	g19362	i0	88.1	0.719512195121951	59	7	72	0	69	245	1	59	MEO8470355.1 copper-binding protein [Chloroflexota bacterium]	diamond	177	94	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32627856	32627856	PRJNA1067443_P_NODE_21540_length_243_cov_0.905882_g21522_i0	PRJNA1067443	21540	243	0.905882	2.20129326	Anaerolineae bacterium	2052143	Bacteria	Bacteria	93.2	7.8e-21	NR	MBA3868746.1	2052143	g21522	i0	58.8	0.987654320987654	80	33	98.8	0	241	2	106	185	MBA3868746.1 helix-turn-helix transcriptional regulator [Anaerolineae bacterium]	diamond	240	93.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae 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);;