metadata: contig_metadata: 10 rows where bioproject = "PRJEB7799" and tax

10 rows where bioproject = "PRJEB7799" and tax_clade = "Bacteria candidate phyla"

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_phylum	tax_species
25936566	25936566	PRJEB7799m_S_NODE_316_length_285_cov_5.236000_g311_i0	PRJEB7799	316	285	5.236	14.9226	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	257	5.2e-64	NTclustered	gi\|2874253756\|emb\|OY969696.1\|	2052149	g311	i0	85.433	108.736842105263	254	29	87	5	19	265	971491	971239	MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.1.14 genome assembly, chromosome: 1	blastn	30990	257	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota	Candidatus Aminicenantes bacterium
25936646	25936646	PRJEB7799n_S_NODE_1604_length_332_cov_8.898990_g1567_i0	PRJEB7799	1604	332	8.89899	29.5446468	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	257	6.18e-64	NTclustered	gi\|2874253756\|emb\|OY969696.1\|	2052149	g1567	i0	85.433	99.6174698795181	254	29	74	5	45	291	971491	971239	MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.1.14 genome assembly, chromosome: 1	blastn	33073	257	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota	Candidatus Aminicenantes bacterium
26070877	26070877	PRJEB7799c_S_NODE_29613_length_155_cov_1.791667_g29590_i0	PRJEB7799	29613	155	1.791667	2.77708385	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	74.7	5.82e-14	NR	TXG76615.1	2052139	g29590	i0	78	0.967741935483871	50	11	96.8	0	5	154	127	176	TXG76615.1 MAG: mannose-1-phosphate guanylyltransferase/mannose-6-phosphate isomerase [Patescibacteria group bacterium]	diamond	150	74.7	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
26072945	26072945	PRJEB7799o_S_NODE_4541_length_155_cov_1.391667_g4533_i0	PRJEB7799	4541	155	1.391667	2.15708385	uncultured Candidatus Dependentiae bacterium	171954	Bacteria	Bacteria	217	4.2699999999999996e-52	NTclustered	gi\|22267331\|gb\|AY043958.1\|	171954	g4533	i0	97.619	80.9096774193548	126	3	81	0	1	126	1160	1285	Uncultured division TM6 bacterium clone NMW3.210WL 16S ribosomal RNA gene, partial sequence	blastn	12541	217	1	Bacteria	Bacteria candidate phyla		uncultured Candidatus Babelota bacterium
26345017	26345017	PRJEB7799o_S_NODE_3903_length_162_cov_2.425197_g3895_i0	PRJEB7799	3903	162	2.425197	3.92881914	uncultured Candidatus Dependentiae bacterium	171954	Bacteria	Bacteria	283	4.39e-72	NTclustered	gi\|22267112\|gb\|AY043739.1\|	171954	g3895	i0	98.148	98.8024691358025	162	3	100	0	1	162	743	904	Uncultured division TM6 bacterium clone NOS7.2WL 16S ribosomal RNA gene, partial sequence	blastn	16006	283	1	Bacteria	Bacteria candidate phyla		uncultured Candidatus Babelota bacterium
26478498	26478498	PRJEB7799a_S_NODE_14160_length_167_cov_3.643939_g14125_i0	PRJEB7799	14160	167	3.643939	6.08537813	uncultured Candidatus Dependentiae bacterium	171954	Bacteria	Bacteria	283	4.56e-72	NTclustered	gi\|22267331\|gb\|AY043958.1\|	171954	g14125	i0	98.742	93.502994011976	159	2	95	0	9	167	1240	1082	Uncultured division TM6 bacterium clone NMW3.210WL 16S ribosomal RNA gene, partial sequence	blastn	15615	283	1	Bacteria	Bacteria candidate phyla		uncultured Candidatus Babelota bacterium
33050288	33050288	PRJEB7799o_S_NODE_2101_length_187_cov_2.421053_g2093_i0	PRJEB7799	2101	187	2.421053	4.52736911	Candidatus Dependentiae bacterium	2030827	Bacteria	Bacteria	46.2	0.00108	NR	RTL04733.1	2030827	g2093	i0	45.3	0.850267379679144	53	26	81.8	2	157	5	743	794	RTL04733.1 MAG: hypothetical protein EKK58_09785 [Candidatus Dependentiae bacterium]	diamond	159	46.2	1	Bacteria	Bacteria candidate phyla		Candidatus Babelota bacterium
33100622	33100622	PRJEB7799a_S_NODE_918_length_384_cov_4.922636_g883_i0	PRJEB7799	918	384	4.922636	18.90292224	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	129	1.92e-35	NR	TXG78926.1	2099670	g883	i0	82.3	0.6171875	79	14	61.7	0	382	146	51	129	TXG78926.1 MAG: XRE family transcriptional regulator [Candidatus Dojkabacteria bacterium]	diamond	237	129	1	Bacteria	Bacteria candidate phyla		Candidatus Dojkabacteria bacterium
33134682	33134682	PRJEB7799a_S_NODE_12791_length_172_cov_1.992701_g12756_i0	PRJEB7799	12791	172	1.992701	3.42744572	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	41.6	0.0377	NR	MCC6350294.1	2212470	g12756	i0	56.8	0.645348837209302	37	14	64.5	1	13	123	454	488	MCC6350294.1 GWxTD domain-containing protein [Candidatus Eiseniibacteriota bacterium]	diamond	111	41.6	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota	Candidatus Eiseniibacteriota bacterium
33162151	33162151	PRJEB7799e_S_NODE_25176_length_150_cov_1.043478_g25099_i0	PRJEB7799	25176	150	1.043478	1.565217	Bacteria	2	Bacteria	Bacteria	62	1.62e-9	NR	MEZ0286299.1	2053589	g25099	i0	66	1.88	47	16	94	0	2	142	517	563	MEZ0286299.1 ABC transporter transmembrane domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	282	62	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota 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);;