metadata: contig_metadata: 20 rows where bioproject = "PRJNA591000" and tax

20 rows where bioproject = "PRJNA591000" 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
26699651	26699651	PRJNA591000_P_NODE_5941_length_590_cov_4.616756_g4688_i0	PRJNA591000	5941	590	4.616756	27.2388604	Anaerolineales bacterium	2073117	Bacteria	Bacteria	81.3	4.77e-16	NR	HNC91833.1	2073117	g4688	i0	91.7	0.183050847457627	36	3	18.3	0	16	123	83	118	HNC91833.1 hypothetical protein [Anaerolineales bacterium]	diamond	108	81.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
26826672	26826672	PRJNA591000_P_NODE_2661_length_827_cov_4.952381_g2004_i0	PRJNA591000	2661	827	4.952381	40.95619087	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	135	3.15e-32	NR	RJP53323.1	2024896	g2004	i0	64.6	0.35912938331318	99	34	35.6	1	520	813	16	114	RJP53323.1 MAG: hypothetical protein C4583_04920 [Anaerolineaceae bacterium]	diamond	297	135	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
26952964	26952964	PRJNA591000_P_NODE_14942_length_381_cov_2.633523_g13339_i0	PRJNA591000	14942	381	2.633523	10.03372263	Anaerolineae bacterium	2052143	Bacteria	Bacteria	65.5	1.86e-9	NR	MDX9955716.1	2052143	g13339	i0	94.1	0.267716535433071	34	2	26.8	0	103	2	156	189	MDX9955716.1 terminase large subunit [Anaerolineae bacterium]	diamond	102	65.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27774830	27774830	PRJNA591000_P_NODE_12784_length_409_cov_1.078947_g11196_i0	PRJNA591000	12784	409	1.078947	4.41289323	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	59.7	6.47e-8	NR	HYB97500.1	2952938	g11196	i0	65.9	0.322738386308068	44	15	32.3	0	278	409	62	105	HYB97500.1 hypothetical protein [Candidatus Limnocylindrales bacterium]	diamond	132	59.7	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
27806420	27806420	PRJNA591000_P_NODE_3204_length_780_cov_8.074567_g2462_i0	PRJNA591000	3204	780	8.074567	62.9816226	Anaerolineae bacterium	2052143	Bacteria	Bacteria	147	2.85e-36	NR	MBL8119885.1	2052143	g2462	i0	36.7	0.869230769230769	226	140	86.2	3	769	98	358	582	MBL8119885.1 hypothetical protein [Anaerolineae bacterium]	diamond	678	147	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28027341	28027341	PRJNA591000_P_NODE_1005_length_1135_cov_6.776673_g693_i0	PRJNA591000	1005	1135	6.776673	76.91523855	Chloroflexi bacterium OLB14	1617415	Bacteria	Bacteria	305	1.4399999999999995e-99	NR	KXK12069.1	1617415	g693	i0	89	0.40704845814978	154	16	40.7	1	56	517	98	250	KXK12069.1 MAG: Lysozyme M1 precursor [Chloroflexi bacterium OLB14]	diamond	462	305	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia				Chloroflexi bacterium OLB14
28248092	28248092	PRJNA591000_P_NODE_3166_length_784_cov_1.891391_g2429_i0	PRJNA591000	3166	784	1.891391	14.82850544	Chloroflexota bacterium	2026724	Bacteria	Bacteria	63.5	1.39e-7	NR	KAA0266410.1	2026724	g2429	i0	36.2	0.35969387755102	94	57	36	1	441	722	1	91	KAA0266410.1 MAG: hypothetical protein EDM79_15695 [Chloroflexota bacterium]	diamond	282	63.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28595757	28595757	PRJNA591000_P_NODE_16907_length_150_cov_2.066116_g15301_i0	PRJNA591000	16907	150	2.066116	3.099174	Chloroflexota bacterium	2026724	Bacteria	Bacteria	63.9	6.7e-12	NR	MBC8446831.1	2026724	g15301	i0	53.1	0.98	49	23	98	0	147	1	16	64	MBC8446831.1 hypothetical protein [Chloroflexota bacterium]	diamond	147	63.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28943176	28943176	PRJNA591000_P_NODE_528_length_1346_cov_4.807137_g359_i0	PRJNA591000	528	1346	4.807137	64.70406402	Anaerolineae bacterium	2052143	Bacteria	Bacteria	253	4.15e-73	NR	HQJ52287.1	2052143	g359	i0	60.8	0.534918276374443	240	68	50.8	4	14	697	75	300	HQJ52287.1 hypothetical protein [Anaerolineae bacterium]	diamond	720	253	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30142537	30142537	PRJNA591000_P_NODE_652_length_1294_cov_20.582609_g444_i0	PRJNA591000	652	1294	20.582609	266.33896046	Anaerolineae bacterium	2052143	Bacteria	Bacteria	235	1.2299999999999999e-69	NR	MFN8527294.1	2052143	g444	i0	64.2	0.41499227202473	179	64	41.5	0	602	1138	193	371	MFN8527294.1 spermidine/putrescine ABC transporter substrate-binding protein [Anaerolineae bacterium]	diamond	537	235	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30205798	30205798	PRJNA591000_P_NODE_16672_length_155_cov_2.650794_g15066_i0	PRJNA591000	16672	155	2.650794	4.1087307	Promineifilum sp.	2664178	Bacteria	Bacteria	48.5	1.73e-5	NR	MBP6786672.1	2664178	g15066	i0	100	0.387096774193548	20	0	38.7	0	23	82	83	102	MBP6786672.1 hypothetical protein [Promineifilum sp.]	diamond	60	48.5	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Promineifilum sp.
30490500	30490500	PRJNA591000_P_NODE_15493_length_305_cov_6.282609_g13887_i0	PRJNA591000	15493	305	6.282609	19.16195745	Anaerolineae bacterium	2052143	Bacteria	Bacteria	45.4	0.00841	NR	MBN8654843.1	2052143	g13887	i0	47.1	0.501639344262295	51	27	50.2	0	168	16	435	485	MBN8654843.1 recombinase family protein [Anaerolineae bacterium]	diamond	153	45.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30869526	30869526	PRJNA591000_P_NODE_12714_length_410_cov_0.931759_g11126_i0	PRJNA591000	12714	410	0.931759	3.8202119	Chloroflexota bacterium	2026724	Bacteria	Bacteria	58.2	9.26e-7	NR	MBI3763117.1	2026724	g11126	i0	75	0.263414634146341	36	9	26.3	0	408	301	212	247	MBI3763117.1 hypothetical protein [Chloroflexota bacterium]	diamond	108	58.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30901239	30901239	PRJNA591000_P_NODE_11334_length_425_cov_3.010101_g9756_i0	PRJNA591000	11334	425	3.010101	12.79292925	Chloroflexota bacterium	2026724	Bacteria	Bacteria	97.1	1.36e-20	NR	MEN8171409.1	2026724	g9756	i0	69	0.409411764705882	58	18	40.9	0	151	324	349	406	MEN8171409.1 DNA methyltransferase [Chloroflexota bacterium]	diamond	174	97.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32419351	32419351	PRJNA591000_P_NODE_5459_length_626_cov_6.348409_g4301_i0	PRJNA591000	5459	626	6.348409	39.74104034	Anaerolineae bacterium	2052143	Bacteria	Bacteria	339	1.57e-114	NR	MCI0551486.1	2052143	g4301	i0	78.7	0.968051118210863	202	43	96.8	0	616	11	35	236	MCI0551486.1 hypothetical protein [Anaerolineae bacterium]	diamond	606	339	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32640120	32640120	PRJNA591000_P_NODE_9460_length_455_cov_1.755869_g7905_i0	PRJNA591000	9460	455	1.755869	7.98920395	Anaerolineaceae bacterium 4572_78	1972460	Bacteria	Bacteria	80.5	5.07e-16	NR	OQY42286.1	1972460	g7905	i0	74.5	0.672527472527473	51	13	33.6	0	303	455	1	51	OQY42286.1 MAG: hypothetical protein B6242_16380 [Anaerolineaceae bacterium 4572_78]	diamond	306	80.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium 4572_78
32671777	32671777	PRJNA591000_P_NODE_6280_length_569_cov_2.692593_g2429_i1	PRJNA591000	6280	569	2.692593	15.32085417	Chloroflexota bacterium	2026724	Bacteria	Bacteria	63.5	3.85e-8	NR	KAA0266410.1	2026724	g2429	i1	36.2	0.495606326889279	94	57	49.6	1	226	507	1	91	KAA0266410.1 MAG: hypothetical protein EDM79_15695 [Chloroflexota bacterium]	diamond	282	63.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32716776	32716776	PRJNA591000_P_NODE_7880_length_496_cov_2.473233_g6378_i0	PRJNA591000	7880	496	2.473233	12.26723568	Chloroflexota	200795	Bacteria	Bacteria	89	4.13e-17	NR	KXK13531.1	1617415	g6378	i0	90.5	1.01612903225806	42	4	25.4	0	147	22	44	85	KXK13531.1 MAG: guanylate cyclase [Chloroflexi bacterium OLB14]	diamond	504	89	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia				Chloroflexi bacterium OLB14
32797567	32797567	PRJNA591000_P_NODE_1480_length_1001_cov_8.255144_g1058_i0	PRJNA591000	1480	1001	8.255144	82.63399144	Anaerolineae bacterium	2052143	Bacteria	Bacteria	216	2.71e-62	NR	MBN8654843.1	2052143	g1058	i0	63.8	0.521478521478521	174	61	52.1	1	467	988	49	220	MBN8654843.1 recombinase family protein [Anaerolineae bacterium]	diamond	522	216	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32829387	32829387	PRJNA591000_P_NODE_6860_length_536_cov_4.455621_g5462_i0	PRJNA591000	6860	536	4.455621	23.88212856	Anaerolineales bacterium	2073117	Bacteria	Bacteria	94.4	1.32e-20	NR	NUQ86377.1	2073117	g5462	i0	81.4	0.330223880597015	59	11	33	0	74	250	125	183	NUQ86377.1 hypothetical protein [Anaerolineales bacterium]	diamond	177	94.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales 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);;