metadata: contig_metadata: 27 rows where bioproject = "PRJNA753704", tax_kingdom = "Bacillati" and tax

27 rows where bioproject = "PRJNA753704", 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2006984	2006984	PRJNA753704_P_NODE_1442_length_909_cov_10.529904_g1137_i0	PRJNA753704	1442	909	10.529904	95.71682736	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	765	0	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g1137	i0	82.77	587.1100110011	888	124	96	26	33	909	2827196	2828065	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	533683	765	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
3282270	3282270	PRJNA753704_P_NODE_1343_length_943_cov_5.255172_g1043_i0	PRJNA753704	1343	943	5.255172	49.55627196	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	689	0	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g1043	i0	81.85	437.42948038176	865	115	89	34	101	943	239295	240139	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	412496	689	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4559662	4559662	PRJNA753704_P_NODE_8684_length_396_cov_4.396285_g8323_i0	PRJNA753704	8684	396	4.396285	17.4092886	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	532	1.11e-146	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g8323	i0	91.667	528.752525252525	384	32	97	0	6	389	3497867	3497484	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	209386	532	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
5834729	5834729	PRJNA753704_P_NODE_28805_length_239_cov_10.246988_g28444_i0	PRJNA753704	28805	239	10.246988	24.49030132	Litorilinea aerophila	1204385	Bacteria	Bacteria	359	1.13e-94	NTclustered	gi\|393193706\|gb\|JQ733906.1\|	1204385	g28444	i0	94.068	686.556485355649	236	14	99	0	4	239	5050	5285	Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence	blastn	164087	359	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
8384464	8384464	PRJNA753704_P_NODE_4507_length_532_cov_4.191721_g4148_i0	PRJNA753704	4507	532	4.191721	22.29995572	uncultured Anaerolineales bacterium	444458	Bacteria	Bacteria	763	0	NTclustered	gi\|1494623956\|gb\|MK077662.1\|	444458	g4148	i0	95.287	90.8609022556391	488	11	90	12	1	477	487	1	Uncultured Anaerolineales bacterium clone OTU3240-CR 16S ribosomal RNA gene, partial sequence	blastn	48338	763	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			uncultured Anaerolineales bacterium
9659652	9659652	PRJNA753704_P_NODE_3508_length_597_cov_7.650763_g3152_i0	PRJNA753704	3508	597	7.650763	45.67505511	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	492	2.939999999999999e-134	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g3152	i0	82.444	100.509212730318	581	84	96	16	26	597	2202583	2202012	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	60004	492	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
10935113	10935113	PRJNA753704_P_NODE_24709_length_250_cov_0.881356_g24348_i0	PRJNA753704	24709	250	0.881356	2.20339	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	111	1.21e-26	NR	MCC6454279.1	2614250	g24348	i0	73.3	1.836	75	20	90	0	245	21	220	294	MCC6454279.1 peptidylprolyl isomerase [Caldilineaceae bacterium]	diamond	459	111	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
12210637	12210637	PRJNA753704_P_NODE_30310_length_224_cov_12.993377_g29949_i0	PRJNA753704	30310	224	12.993377	29.10516448	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	254	5.08e-63	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g29949	i0	87.168	16.5446428571429	226	25	100	3	1	224	2924	2701	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	3706	254	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
13484929	13484929	PRJNA753704_P_NODE_291_length_1812_cov_6.902243_g182_i0	PRJNA753704	291	1812	6.902243	125.06864316	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	1519	0	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g182	i0	82.131	420.007726269316	1830	273	99	44	13	1808	672577	670768	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	761054	1519	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
13955972	13955972	PRJNA753704_P_NODE_15111_length_308_cov_3.327660_g14750_i0	PRJNA753704	15111	308	3.32766	10.2491928	Caldilinea	233191	Bacteria	Bacteria	359	1.51e-94	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g14750	i0	87.702	296.042207792208	309	37	100	1	1	308	2622	2930	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	91181	359	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
17309084	17309084	PRJNA753704_P_NODE_134_length_2416_cov_43.332480_g75_i0	PRJNA753704	134	2416	43.33248	1046.9127168	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	1670	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g75	i0	82.488	118.554635761589	1953	297	99	34	478	2408	3496359	3494430	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	286428	1670	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
19053808	19053808	PRJNA753704_P_NODE_24795_length_250_cov_0.881356_g24434_i0	PRJNA753704	24795	250	0.881356	2.20339	Chloroflexi bacterium 13_1_2	1805063	Bacteria	Bacteria	76.3	6.17e-16	NR	OLD63741.1	1805063	g24434	i0	52.9	0.84	70	32	84	1	246	37	23	91	OLD63741.1 MAG: hypothetical protein AUF65_01150 [Chloroflexi bacterium 13_1_20CM_50_12]	diamond	210	76.3	1	Bacteria		Bacillati	Chloroflexota					Chloroflexi bacterium 13_1_20CM_50_12
22408392	22408392	PRJNA753704_P_NODE_16598_length_295_cov_2.689189_g16237_i0	PRJNA753704	16598	295	2.689189	7.93310755	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	298	3.19e-76	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g16237	i0	85.274	124.810169491525	292	39	99	3	5	295	241178	241466	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	36819	298	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
26831452	26831452	PRJNA753704_P_NODE_27361_length_244_cov_0.912281_g27000_i0	PRJNA753704	27361	244	0.912281	2.22596564	Anaerolineae bacterium	2052143	Bacteria	Bacteria	95.5	1.08e-21	NR	MCW1971027.1	2052143	g27000	i0	48.3	1.06967213114754	87	39	99.6	1	244	2	69	155	MCW1971027.1 hypothetical protein [Anaerolineae bacterium]	diamond	261	95.5	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27210747	27210747	PRJNA753704_P_NODE_6902_length_440_cov_4.087193_g6541_i0	PRJNA753704	6902	440	4.087193	17.9836492	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	105	9.409999999999999e-25	NR	MDR3573577.1	2024896	g6541	i0	47.7	0.756818181818182	111	56	75.7	1	439	107	134	242	MDR3573577.1 hypothetical protein [Anaerolineaceae bacterium]	diamond	333	105	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
27337492	27337492	PRJNA753704_P_NODE_22763_length_256_cov_2.404372_g22402_i0	PRJNA753704	22763	256	2.404372	6.15519232	Bellilinea sp.	2838785	Bacteria	Bacteria	89	2.43e-18	NR	MEN4013721.1	2838785	g22402	i0	51.4	0.8671875	74	36	86.7	0	222	1	163	236	MEN4013721.1 S8 family serine peptidase [Bellilinea sp.]	diamond	222	89	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Bellilinea	Bellilinea sp.
27874158	27874158	PRJNA753704_P_NODE_25705_length_248_cov_0.891429_g25344_i0	PRJNA753704	25705	248	0.891429	2.21074392	Chloroflexota bacterium	2026724	Bacteria	Bacteria	154	5.62e-42	NR	MDH4141024.1	2026724	g25344	i0	89	0.991935483870968	82	9	99.2	0	1	246	425	506	MDH4141024.1 hypothetical protein [Chloroflexota bacterium]	diamond	246	154	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
28884463	28884463	PRJNA753704_P_NODE_25688_length_248_cov_0.891429_g25327_i0	PRJNA753704	25688	248	0.891429	2.21074392	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	80.5	1.3e-17	NR	MFN2200815.1	2614250	g25327	i0	50.6	0.955645161290323	79	35	95.6	1	1	237	18	92	MFN2200815.1 DUF5132 domain-containing protein [Caldilineaceae bacterium]	diamond	237	80.5	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
28915850	28915850	PRJNA753704_P_NODE_18728_length_280_cov_1.246377_g18367_i0	PRJNA753704	18728	280	1.246377	3.4898556	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	98.6	1.4500000000000002e-21	NR	HEX6288077.1	2720503	g18367	i0	56.3	0.857142857142857	80	35	85.7	0	279	40	1925	2004	HEX6288077.1 non-ribosomal peptide synthase/polyketide synthase [Herpetosiphonaceae bacterium]	diamond	240	98.6	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae		Herpetosiphonaceae bacterium
29494298	29494298	PRJNA753704_P_NODE_28530_length_242_cov_0.923077_g28169_i0	PRJNA753704	28530	242	0.923077	2.23384634	root	1	Root_unresolved	Root_unresolved	55.8	6.64e-7	NR	HOH21690.1	2024896	g28169	i0	46.1	1.88429752066116	76	38	93	2	17	241	51	124	HOH21690.1 hypothetical protein [Anaerolineaceae bacterium]	diamond	456	55.8	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
30115979	30115979	PRJNA753704_P_NODE_18132_length_284_cov_1.265403_g17771_i0	PRJNA753704	18132	284	1.265403	3.59374452	Chloroflexota bacterium	2026724	Bacteria	Bacteria	56.2	1.12e-6	NR	NOZ30064.1	2026724	g17771	i0	40	0.792253521126761	75	43	77.1	1	271	53	443	517	NOZ30064.1 tetratricopeptide repeat protein [Chloroflexota bacterium]	diamond	225	56.2	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
30748040	30748040	PRJNA753704_P_NODE_12334_length_338_cov_2.569811_g11973_i0	PRJNA753704	12334	338	2.569811	8.68596118	Chloroflexaceae bacterium	2562117	Bacteria	Bacteria	99.8	1.47e-23	NR	MCU0495311.1	2562117	g11973	i0	64.4	0.772189349112426	87	31	77.2	0	76	336	42	128	MCU0495311.1 DUF2809 domain-containing protein [Chloroflexaceae bacterium]	diamond	261	99.8	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae		Chloroflexaceae bacterium
30779608	30779608	PRJNA753704_P_NODE_26374_length_246_cov_1.768786_g26013_i0	PRJNA753704	26374	246	1.768786	4.35121356	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	57	3.71e-7	NR	HEY9075989.1	2024896	g26013	i0	44.8	0.707317073170732	58	32	70.7	0	6	179	70	127	HEY9075989.1 sortase [Anaerolineaceae bacterium]	diamond	174	57	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
32044407	32044407	PRJNA753704_P_NODE_27078_length_245_cov_0.906977_g26717_i0	PRJNA753704	27078	245	0.906977	2.22209365	Caldilinea sp. CFX5	2293554	Bacteria	Bacteria	47.4	8.89e-4	NR	MCE7983218.1	2293554	g26717	i0	43.2	0.991836734693878	81	35	99.2	2	244	2	70	139	MCE7983218.1 M23 family peptidase [Caldilinea sp. CFX5]	diamond	243	47.4	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea sp. CFX5
32234529	32234529	PRJNA753704_P_NODE_13778_length_321_cov_2.758065_g13417_i0	PRJNA753704	13778	321	2.758065	8.85338865	Candidatus Promineifilaceae bacterium	3085104	Bacteria	Bacteria	70.9	1.11e-11	NR	MDX1616302.1	3085104	g13417	i0	42.3	1.42056074766355	78	39	72.9	1	270	37	53	124	MDX1616302.1 tyrosinase family protein [Candidatus Promineifilaceae bacterium]	diamond	456	70.9	1	Bacteria		Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae		Candidatus Promineifilaceae bacterium
32865552	32865552	PRJNA753704_P_NODE_26640_length_246_cov_0.901734_g26279_i0	PRJNA753704	26640	246	0.901734	2.21826564	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	68.6	3.08e-11	NR	MCB0083329.1	2614250	g26279	i0	50.6	1.97560975609756	81	35	92.7	2	236	9	351	431	MCB0083329.1 hypothetical protein [Caldilineaceae bacterium]	diamond	486	68.6	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
32896890	32896890	PRJNA753704_P_NODE_14820_length_311_cov_1.592437_g14459_i0	PRJNA753704	14820	311	1.592437	4.95247907	Thermosporothrix hazakensis	644383	Bacteria	Bacteria	78.2	1.47e-14	NR	WP_111323242.1	644383	g14459	i0	42.9	0.877813504823151	91	46	82	3	311	57	142	232	WP_111323242.1 trypsin-like serine peptidase [Thermosporothrix hazakensis]	diamond	273	78.2	1	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Thermosporotrichaceae	Thermosporothrix	Thermosporothrix hazakensis

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);;