metadata: contig_metadata: 11 rows where bioproject = "PRJNA492406" and tax

11 rows where bioproject = "PRJNA492406" 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
14481463	14481463	PRJNA492406_P_NODE_8312_length_423_cov_1.760000_g8013_i0	PRJNA492406	8312	423	1.76	7.4448	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	442	2.0699999999999988e-119	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g8013	i0	85.647	574.333333333333	425	56	99	4	1	422	2827480	2827902	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	242943	442	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
18950857	18950857	PRJNA492406_P_NODE_8215_length_425_cov_1.866477_g7916_i0	PRJNA492406	8215	425	1.866477	7.93252725	Caldilinea	233191	Bacteria	Bacteria	564	4.249999999999999e-156	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g7916	i0	90.588	529.461176470588	425	40	100	0	1	425	2113	2537	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	225021	564	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
22129025	22129025	PRJNA492406_P_NODE_28558_length_247_cov_1.471264_g28259_i0	PRJNA492406	28558	247	1.471264	3.63402208	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	156	1.65e-33	NTclustered	gi\|374850026\|dbj\|AP011646.1\|	166587	g28259	i0	78.4	22.3198380566802	250	47	100	7	1	247	2529	2774	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF004_B01	blastn	5513	156	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
26823401	26823401	PRJNA492406_P_NODE_18881_length_288_cov_2.088372_g18582_i0	PRJNA492406	18881	288	2.088372	6.01451136	Anaerolineales bacterium	2073117	Bacteria	Bacteria	52.8	1.96e-5	NR	NIS81359.1	2073117	g18582	i0	32.3	2.51041666666667	93	56	90.6	3	6	266	141	232	NIS81359.1 hypothetical protein [Anaerolineales bacterium]	diamond	723	52.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
27013088	27013088	PRJNA492406_P_NODE_16022_length_313_cov_1.554167_g15723_i0	PRJNA492406	16022	313	1.554167	4.86454271	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.5	0.0434	NR	MYB77721.1	2026724	g15723	i0	31.9	0.661341853035144	69	46	66.1	1	91	297	112	179	MYB77721.1 AAA family ATPase [Chloroflexota bacterium]	diamond	207	43.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27676918	27676918	PRJNA492406_P_NODE_25864_length_254_cov_1.574586_g25565_i0	PRJNA492406	25864	254	1.574586	3.99944844	Chloroflexota bacterium	2026724	Bacteria	Bacteria	56.6	7.82e-8	NR	NOZ29638.1	2026724	g25565	i0	43	3.36614173228346	79	39	92.1	4	2	235	35	108	NOZ29638.1 protease inhibitor I42 family protein [Chloroflexota bacterium]	diamond	855	56.6	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28892250	28892250	PRJNA492406_P_NODE_22928_length_269_cov_1.214286_g22629_i0	PRJNA492406	22928	269	1.214286	3.26642934	Bacteria	2	Bacteria	Bacteria	61.2	1.44e-8	NR	MBL7208645.1	2026734	g22629	i0	38.4	3.2453531598513	73	44	80.3	1	21	236	59	131	MBL7208645.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	873	61.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
30266284	30266284	PRJNA492406_P_NODE_2932_length_703_cov_3.380952_g2644_i0	PRJNA492406	2932	703	3.380952	23.76809256	Anaerolineales bacterium	2073117	Bacteria	Bacteria	286	2.0399999999999998e-94	NR	MFO3797941.1	2073117	g2644	i0	67.5	0.86628733997155	203	66	86.6	0	95	703	1	203	MFO3797941.1 hypothetical protein [Anaerolineales bacterium]	diamond	609	286	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31593626	31593626	PRJNA492406_P_NODE_31316_length_242_cov_1.366864_g31017_i0	PRJNA492406	31316	242	1.366864	3.30781088	Anaerolineae bacterium	2052143	Bacteria	Bacteria	66.2	1.29e-10	NR	MCC6614107.1	2052143	g31017	i0	49.3	8.31818181818182	71	36	88	0	27	239	121	191	MCC6614107.1 CoA ester lyase [Anaerolineae bacterium]	diamond	2013	66.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32258141	32258141	PRJNA492406_P_NODE_29978_length_245_cov_0.895349_g29679_i0	PRJNA492406	29978	245	0.895349	2.19360505	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	44.3	0.011	NR	HEX6030967.1	3022862	g29679	i0	38.3	0.73469387755102	60	37	73.5	0	201	22	83	142	HEX6030967.1 CoA transferase [Tepidiformaceae bacterium]	diamond	180	44.3	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
32699960	32699960	PRJNA492406_P_NODE_15360_length_320_cov_1.315789_g15061_i0	PRJNA492406	15360	320	1.315789	4.2105248	Chloroflexota bacterium	2026724	Bacteria	Bacteria	45.1	0.0129	NR	MFC1993675.1	2026724	g15061	i0	39.7	0.590625	63	35	58.1	2	82	267	110	170	MFC1993675.1 mandelate racemase/muconate lactonizing enzyme family protein [Chloroflexota bacterium]	diamond	189	45.1	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);;