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

11 rows where bioproject = "PRJNA1120771" 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
10480213	10480213	PRJNA1120771_S_NODE_21969_length_252_cov_1.636364_g21569_i0	PRJNA1120771	21969	252	1.636364	4.12363728	Bacillati	1783272	Bacteria	Bacteria	87.8	3.86e-19	NR	HDQ74089.1	2026724	g21569	i0	53.8	3.44047619047619	78	36	92.9	0	3	236	128	205	HDQ74089.1 HAD family phosphatase [Chloroflexota bacterium]	diamond	867	87.8	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
11755159	11755159	PRJNA1120771_S_NODE_2610_length_556_cov_3.715400_g2248_i0	PRJNA1120771	2610	556	3.7154	20.657624	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	492	2.72e-134	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g2248	i0	84.078	100.080935251799	515	77	92	5	19	531	2201976	2202487	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	55645	492	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
13030229	13030229	PRJNA1120771_S_NODE_11831_length_317_cov_1.587591_g11431_i0	PRJNA1120771	11831	317	1.587591	5.03266347	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g11431	i0	100	0.0883280757097792	28	0	9	0	94	121	947648	947621	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
19402557	19402557	PRJNA1120771_S_NODE_37056_length_200_cov_3.707006_g36656_i0	PRJNA1120771	37056	200	3.707006	7.414012	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	204	4.53e-48	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g36656	i0	85	599.28	200	30	100	0	1	200	2827753	2827554	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	119856	204	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
26817101	26817101	PRJNA1120771_S_NODE_15641_length_286_cov_6.106996_g15241_i0	PRJNA1120771	15641	286	6.106996	17.46600856	Anaerolineaceae bacterium oral taxon 439	1889813	Bacteria	Bacteria	43.1	0.0411	NR	AOH42156.1	1889813	g15241	i0	31.9	0.755244755244755	72	46	72.4	2	18	224	239	310	AOH42156.1 branched-chain amino acid ABC transporter permease [Anaerolineaceae bacterium oral taxon 439]	diamond	216	43.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium oral taxon 439
27291416	27291416	PRJNA1120771_S_NODE_21983_length_252_cov_1.248804_g21583_i0	PRJNA1120771	21983	252	1.248804	3.14698608	Anaerolineales bacterium	2073117	Bacteria	Bacteria	54.7	2.55e-6	NR	NOR88665.1	2073117	g21583	i0	55.3	0.452380952380952	38	17	45.2	0	14	127	783	820	NOR88665.1 FAD-dependent oxidoreductase [Anaerolineales bacterium]	diamond	114	54.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
28238442	28238442	PRJNA1120771_S_NODE_14626_length_293_cov_5.916000_g14226_i0	PRJNA1120771	14626	293	5.916	17.33388	Chloroflexota bacterium	2026724	Bacteria	Bacteria	67	4.17e-11	NR	HZQ98850.1	2026724	g14226	i0	52.4	3.25597269624573	63	30	64.5	0	5	193	135	197	HZQ98850.1 dienelactone hydrolase family protein [Chloroflexota bacterium]	diamond	954	67	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28290961	28290961	PRJNA1120771_S_NODE_22906_length_248_cov_1.565854_g22506_i0	PRJNA1120771	22906	248	1.565854	3.88331792	FCB group	1783270	Bacteria	Bacteria	48.5	6.85e-5	NR	MCH7740292.1	2026724	g22506	i0	73.1	0.919354838709677	26	7	31.5	0	3	80	86	111	MCH7740292.1 L-rhamnose mutarotase [Chloroflexota bacterium]	diamond	228	48.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29028320	29028320	PRJNA1120771_S_NODE_24548_length_241_cov_2.151515_g24148_i0	PRJNA1120771	24548	241	2.151515	5.18515115	Chloroflexota bacterium	2026724	Bacteria	Bacteria	81.3	8.95e-17	NR	MEI6271679.1	2026724	g24148	i0	51.4	1.76763485477178	72	35	89.6	0	5	220	131	202	MEI6271679.1 hypothetical protein [Chloroflexota bacterium]	diamond	426	81.3	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29627474	29627474	PRJNA1120771_S_NODE_15210_length_289_cov_3.524390_g14810_i0	PRJNA1120771	15210	289	3.52439	10.1854871	Anaerolineae bacterium	2052143	Bacteria	Bacteria	86.3	9.87e-18	NR	NPV85550.1	2052143	g14810	i0	46.9	1.99307958477509	96	48	99.7	1	2	289	198	290	NPV85550.1 2-dehydropantoate 2-reductase [Anaerolineae bacterium]	diamond	576	86.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30101553	30101553	PRJNA1120771_S_NODE_25532_length_237_cov_2.788660_g25132_i0	PRJNA1120771	25532	237	2.78866	6.6091242	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	42.4	0.0446	NR	MCS7296520.1	2026734	g25132	i0	32.3	0.784810126582278	62	38	78.5	1	4	189	40	97	MCS7296520.1 enoyl-CoA hydratase-related protein [Dehalococcoidia bacterium]	diamond	186	42.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia 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);;