metadata: contig_metadata: 12 rows where bioproject = "PRJNA289590" and tax

12 rows where bioproject = "PRJNA289590" 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
22049061	22049061	PRJNA289590_P_NODE_26578_length_168_cov_1.168067_g26354_i0	PRJNA289590	26578	168	1.168067	1.96235256	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	78.7	2.33e-10	NTclustered	gi\|2621706248\|emb\|OY764157.1\|	2952883	g26354	i0	94.118	8.11904761904762	51	3	30	0	71	121	876665	876615	MAG: Aggregatilineales bacterium isolate e8f4d38d-de70-4490-8638-1b8803f995b9 genome assembly, chromosome: 1	blastn	1364	78.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
26743238	26743238	PRJNA289590_P_NODE_13401_length_249_cov_1.035000_g13177_i0	PRJNA289590	13401	249	1.035	2.57715	Bacteria	2	Bacteria	Bacteria	44.3	0.0114	NR	HEX8732864.1	2306968	g13177	i0	36.4	2.63855421686747	77	29	73.5	3	1	183	159	231	HEX8732864.1 sialidase family protein [Ktedonobacterales bacterium]	diamond	657	44.7	0.991051454138702	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
26902143	26902143	PRJNA289590_P_NODE_19921_length_200_cov_1.033113_g19697_i0	PRJNA289590	19921	200	1.033113	2.066226	Chloroflexota	200795	Bacteria	Bacteria	87	8.43e-19	NR	WP_135475557.1	2528176	g19697	i0	61.5	1.95	65	25	97.5	0	4	198	146	210	WP_135475557.1 APH(3') family aminoglycoside O-phosphotransferase [Candidatus Chloroploca mongolica]	diamond	390	87	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Oscillochloridaceae	Candidatus Chloroploca	Candidatus Chloroploca mongolica
28337484	28337484	PRJNA289590_P_NODE_15426_length_230_cov_1.088398_g15202_i0	PRJNA289590	15426	230	1.088398	2.5033154	Anaerolineae bacterium	2052143	Bacteria	Bacteria	45.4	0.00353	NR	MBN1219239.1	2052143	g15202	i0	40	6.79565217391304	55	27	71.7	1	223	59	269	317	MBN1219239.1 hypothetical protein [Anaerolineae bacterium]	diamond	1563	45.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28386602	28386602	PRJNA289590_P_NODE_18986_length_205_cov_1.333333_g18762_i0	PRJNA289590	18986	205	1.333333	2.73333265	Bacteria	2	Bacteria	Bacteria	50.1	5.75e-5	NR	HLF74291.1	2073117	g18762	i0	45.6	1.77073170731707	57	29	80.5	1	36	200	464	520	HLF74291.1 ABC transporter ATP-binding protein [Anaerolineales bacterium]	diamond	363	50.4	0.994047619047619	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29081368	29081368	PRJNA289590_P_NODE_8588_length_321_cov_1.139706_g8364_i0	PRJNA289590	8588	321	1.139706	3.65845626	FCB group	1783270	Bacteria	Bacteria	144	4e-41	NR	MBO9320149.1	1904827	g8364	i0	66	13.607476635514	103	35	96.3	0	317	9	42	144	MBO9320149.1 NAD-dependent epimerase/dehydratase family protein [Chloroflexus sp.]	diamond	4368	145	0.993103448275862	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus sp.
30422119	30422119	PRJNA289590_P_NODE_31373_length_162_cov_0.920354_g31149_i0	PRJNA289590	31373	162	0.920354	1.49097348	Chloroflexota bacterium	2026724	Bacteria	Bacteria	90.5	3.38e-22	NR	MBT9161361.1	2026724	g31149	i0	92	0.925925925925926	50	4	92.6	0	1	150	34	83	MBT9161361.1 hypothetical protein [Chloroflexota bacterium]	diamond	150	90.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30548075	30548075	PRJNA289590_P_NODE_5453_length_420_cov_11.288410_g5229_i0	PRJNA289590	5453	420	11.28841	47.411322	Chloroflexota bacterium	2026724	Bacteria	Bacteria	190	3.88e-58	NR	MEW6569366.1	2026724	g5229	i0	89.3	0.735714285714286	103	11	73.6	0	4	312	129	231	MEW6569366.1 hypothetical protein [Chloroflexota bacterium]	diamond	309	190	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30628694	30628694	PRJNA289590_P_NODE_26733_length_168_cov_0.873950_g26509_i0	PRJNA289590	26733	168	0.87395	1.468236	FCB group	1783270	Bacteria	Bacteria	68.9	4.42e-12	NR	MEX2227026.1	2026734	g26509	i0	58.5	9.78571428571429	53	22	94.6	0	9	167	84	136	MEX2227026.1 DMT family transporter [Dehalococcoidia bacterium]	diamond	1644	69.3	0.994227994227994	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
31134150	31134150	PRJNA289590_P_NODE_8015_length_334_cov_2.312281_g7791_i0	PRJNA289590	8015	334	2.312281	7.72301854	FCB group	1783270	Bacteria	Bacteria	55.8	1.57e-6	NR	RPJ02985.1	2026724	g7791	i0	55.8	4.76047904191617	43	19	38.6	0	131	3	20	62	RPJ02985.1 MAG: DNA-binding response regulator [Chloroflexota bacterium]	diamond	1590	56.2	0.99288256227758	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31306432	31306432	PRJNA289590_P_NODE_29115_length_165_cov_0.896552_g28891_i0	PRJNA289590	29115	165	0.896552	1.4793108	Kallotenue papyrolyticum	1325125	Bacteria	Bacteria	77.4	6.98e-16	NR	WP_026369505.1	1325125	g28891	i0	69.2	0.945454545454545	52	16	94.5	0	158	3	1	52	WP_026369505.1 DJ-1/PfpI family protein [Kallotenue papyrolyticum]	diamond	156	77.4	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Kallotenuales	Kallotenuaceae	Kallotenue	Kallotenue papyrolyticum
31324050	31324050	PRJNA289590_P_NODE_10655_length_282_cov_1.961373_g10431_i0	PRJNA289590	10655	282	1.961373	5.53107186	Bacteria	2	Bacteria	Bacteria	114	1.3e-30	NR	HID52662.1	2052143	g10431	i0	65.4	2.41489361702128	78	27	83	0	2	235	29	106	HID52662.1 type II toxin-antitoxin system HicB family antitoxin [Anaerolineae bacterium]	diamond	681	115	0.991304347826087	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae 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);;