metadata: contig_metadata: 24 rows where bioproject = "PRJNA917598", tax_kingdom = "Bacillati" and tax

24 rows where bioproject = "PRJNA917598", tax_kingdom = "Bacillati" 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
10180261	10180261	PRJNA917598_P_NODE_75208_length_261_cov_1.228723_g74264_i0	PRJNA917598	75208	261	1.228723	3.20696703	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	116	2.38e-31	NR	MDO9334217.1	2026733	g74264	i0	90.6	0.735632183908046	64	6	73.6	0	1	192	55	118	MDO9334217.1 class I fructose-bisphosphate aldolase [Dehalococcoidales bacterium]	diamond	192	116	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
20023147	20023147	PRJNA917598_P_NODE_59476_length_292_cov_2.767123_g58532_i0	PRJNA917598	59476	292	2.7671230000000002	8.07999916	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	322	1.87e-83	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g58532	i0	89.96	150.02397260274	249	25	85	0	1	249	274031	274279	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	43807	322	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
20023473	20023473	PRJNA917598_P_NODE_73536_length_264_cov_2.015707_g72592_i0	PRJNA917598	73536	264	2.015707	5.32146648	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	241	4.8e-59	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g72592	i0	85.774	7.50757575757576	239	20	90	9	28	264	1401	1175	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	1982	241	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
21298465	21298465	PRJNA917598_P_NODE_59857_length_291_cov_2.527523_g58913_i0	PRJNA917598	59857	291	2.527523	7.35509193	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	263	1.14e-65	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g58913	i0	87.391	86.8865979381443	230	27	79	2	33	261	2202583	2202355	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	25284	263	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
27404042	27404042	PRJNA917598_P_NODE_76643_length_257_cov_1.717391_g75699_i0	PRJNA917598	76643	257	1.717391	4.41369487	Chloroflexota bacterium	2026724	Bacteria	Bacteria	92.8	1.7e-20	NR	MEP6468247.1	2026724	g75699	i0	71.2	0.852140077821012	73	21	85.2	0	255	37	218	290	MEP6468247.1 ABC transporter ATP-binding protein [Chloroflexota bacterium]	diamond	219	92.8	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27498729	27498729	PRJNA917598_P_NODE_68503_length_275_cov_1.415842_g67559_i0	PRJNA917598	68503	275	1.415842	3.8935655	Anaerolineae bacterium	2052143	Bacteria	Bacteria	89	6.58e-20	NR	MBX3081337.1	2052143	g67559	i0	97.4	0.850909090909091	39	1	42.5	0	273	157	135	173	MBX3081337.1 NADH-quinone oxidoreductase subunit C [Anaerolineae bacterium]	diamond	234	89	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27790201	27790201	PRJNA917598_P_NODE_23224_length_481_cov_0.943627_g22282_i0	PRJNA917598	23224	481	0.943627	4.53884587	FCB group	1783270	Bacteria	Bacteria	133	1.43e-32	NR	MDR3574547.1	2024896	g22282	i0	46	3.03742203742204	161	79	96	3	2	463	2408	2567	MDR3574547.1 SdrD B-like domain-containing protein [Anaerolineaceae bacterium]	diamond	1461	133	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
27845820	27845820	PRJNA917598_P_NODE_96524_length_237_cov_2.146341_g95580_i0	PRJNA917598	96524	237	2.146341	5.08682817	Anaerolineales bacterium	2073117	Bacteria	Bacteria	46.6	0.00151	NR	HND47414.1	2073117	g95580	i0	70	0.379746835443038	30	9	38	0	2	91	417	446	HND47414.1 hypothetical protein [Anaerolineales bacterium]	diamond	90	46.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
27877494	27877494	PRJNA917598_P_NODE_60885_length_289_cov_1.736111_g59941_i0	PRJNA917598	60885	289	1.736111	5.01736079	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	89.7	1.92e-18	NR	KAF0107808.1	2024896	g59941	i0	47.2	2.74048442906574	89	46	91.3	1	24	287	408	496	KAF0107808.1 MAG: hypothetical protein FD146_1439 [Anaerolineaceae bacterium]	diamond	792	89.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
28130181	28130181	PRJNA917598_P_NODE_21765_length_497_cov_1.856132_g20826_i0	PRJNA917598	21765	497	1.856132	9.22497604	Chloroflexota bacterium	2026724	Bacteria	Bacteria	139	7.419999999999998e-35	NR	RMG85325.1	2026724	g20826	i0	43.6	0.995975855130785	165	93	99.6	0	496	2	205	369	RMG85325.1 MAG: hypothetical protein D6712_09700 [Chloroflexota bacterium]	diamond	495	139	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28130231	28130231	PRJNA917598_P_NODE_84385_length_248_cov_0.880000_g83441_i0	PRJNA917598	84385	248	0.88	2.1824	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	48.1	4.86e-4	NR	HUX48375.1	2026734	g83441	i0	60	0.544354838709677	45	16	52	1	138	10	1	45	HUX48375.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	135	48.1	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
28414361	28414361	PRJNA917598_P_NODE_24206_length_470_cov_2.120907_g23263_i0	PRJNA917598	24206	470	2.120907	9.9682629	Anaerolineales bacterium	2073117	Bacteria	Bacteria	48.9	0.00127	NR	HKY54116.1	2073117	g23263	i0	28.3	0.587234042553191	92	64	57.4	1	468	199	107	198	HKY54116.1 hypothetical protein [Anaerolineales bacterium]	diamond	276	48.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29273877	29273877	PRJNA917598_P_NODE_79389_length_251_cov_1.297753_g78445_i0	PRJNA917598	79389	251	1.297753	3.25736003	Bacteria	2	Bacteria	Bacteria	112	1.51e-29	NR	MDO9084837.1	2024896	g78445	i0	82.3	3.71713147410359	62	11	74.1	0	188	3	1	62	MDO9084837.1 SRPBCC family protein [Anaerolineaceae bacterium]	diamond	933	112	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
29740123	29740123	PRJNA917598_P_NODE_64870_length_282_cov_1.363636_g63926_i0	PRJNA917598	64870	282	1.363636	3.84545352	Anaerolineales bacterium	2073117	Bacteria	Bacteria	137	3.3899999999999995e-35	NR	HND47414.1	2073117	g63926	i0	66	1	94	32	100	0	1	282	545	638	HND47414.1 hypothetical protein [Anaerolineales bacterium]	diamond	282	137	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
30561503	30561503	PRJNA917598_P_NODE_65273_length_281_cov_1.480769_g64329_i0	PRJNA917598	65273	281	1.480769	4.16096089	Chloroflexi bacterium CFX7	2293711	Bacteria	Bacteria	55.8	1.37e-6	NR	MCE7929641.1	2293711	g64329	i0	50	0.491103202846975	46	23	49.1	0	203	66	345	390	MCE7929641.1 hypothetical protein [Chloroflexi bacterium CFX7]	diamond	138	55.8	1	Bacteria	Bacillati	Chloroflexota					Chloroflexi bacterium CFX7
31074654	31074654	PRJNA917598_P_NODE_55255_length_306_cov_2.416309_g54311_i0	PRJNA917598	55255	306	2.416309	7.3939055400000004	Bacteria	2	Bacteria	Bacteria	56.6	2.71e-8	NR	HID53125.1	2052143	g54311	i0	72.2	1.87254901960784	36	10	35.3	0	244	137	24	59	HID53125.1 hemin uptake protein HemP [Anaerolineae bacterium]	diamond	573	57	0.992982456140351	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31193267	31193267	PRJNA917598_P_NODE_30735_length_415_cov_2.014620_g29791_i0	PRJNA917598	30735	415	2.01462	8.360673	Chloroflexota bacterium	2026724	Bacteria	Bacteria	55.8	4.86e-7	NR	NWG07724.1	2026724	g29791	i0	34.1	0.592771084337349	82	53	59.3	1	144	389	19	99	NWG07724.1 DUF1874 domain-containing protein [Chloroflexota bacterium]	diamond	246	55.8	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31415043	31415043	PRJNA917598_P_NODE_21596_length_499_cov_2.159624_g20657_i0	PRJNA917598	21596	499	2.159624	10.77652376	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	65.5	1.46e-9	NR	HOR78930.1	2024896	g20657	i0	51.8	0.336673346693387	56	27	33.7	0	1	168	121	176	HOR78930.1 hypothetical protein [Anaerolineaceae bacterium]	diamond	168	65.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
31446739	31446739	PRJNA917598_P_NODE_72516_length_267_cov_1.056701_g71572_i0	PRJNA917598	72516	267	1.056701	2.82139167	Chloroflexota bacterium	2026724	Bacteria	Bacteria	44.3	0.0133	NR	HEY3081668.1	2026724	g71572	i0	36.7	0.887640449438202	79	45	83.1	2	233	12	15	93	HEY3081668.1 aldo/keto reductase [Chloroflexota bacterium]	diamond	237	44.3	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31826081	31826081	PRJNA917598_P_NODE_55397_length_306_cov_1.321888_g54453_i0	PRJNA917598	55397	306	1.321888	4.04497728	Chloroflexota bacterium	2026724	Bacteria	Bacteria	89.7	2.42e-18	NR	RMG85783.1	2026724	g54453	i0	47.5	0.990196078431373	101	49	99	2	3	305	102	198	RMG85783.1 MAG: hypothetical protein D6712_08860 [Chloroflexota bacterium]	diamond	303	89.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32079361	32079361	PRJNA917598_P_NODE_95298_length_241_cov_0.916667_g94354_i0	PRJNA917598	95298	241	0.916667	2.20916747	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	51.6	1.17e-5	NR	HYB99903.1	2952938	g94354	i0	30.4	0.983402489626556	79	54	98.3	1	5	241	67	144	HYB99903.1 hypothetical protein [Candidatus Limnocylindrales bacterium]	diamond	237	51.6	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
32332899	32332899	PRJNA917598_P_NODE_90559_length_244_cov_1.222222_g89615_i0	PRJNA917598	90559	244	1.222222	2.98222168	Anaerolineales bacterium	2073117	Bacteria	Bacteria	54.3	3.27e-6	NR	HXQ37646.1	2073117	g89615	i0	57.4	1.15573770491803	47	15	51.6	2	139	14	373	419	HXQ37646.1 D-alanyl-D-alanine carboxypeptidase family protein [Anaerolineales bacterium]	diamond	282	54.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32466641	32466641	PRJNA917598_P_NODE_56159_length_303_cov_2.008696_g55215_i0	PRJNA917598	56159	303	2.008696	6.08634888	Bacteria	2	Bacteria	Bacteria	47.4	0.00177	NR	MFN8474653.1	2052143	g55215	i0	41	2.72277227722772	61	34	58.4	1	100	276	420	480	MFN8474653.1 META domain-containing protein [Anaerolineae bacterium]	diamond	825	47.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32750234	32750234	PRJNA917598_P_NODE_91160_length_244_cov_0.900585_g90216_i0	PRJNA917598	91160	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	122	2.0599999999999997e-31	NR	MFO7170389.1	2026724	g90216	i0	69.6	7.77049180327869	79	24	97.1	0	242	6	52	130	MFO7170389.1 phosphoenolpyruvate carboxykinase (GTP) [Chloroflexota bacterium]	diamond	1896	123	0.991869918699187	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);;