metadata: contig_metadata: 8 rows where bioproject = "PRJNA482207" and tax

8 rows where bioproject = "PRJNA482207" 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_class	tax_order	tax_family	tax_genus	tax_species
4274992	4274992	PRJNA482207_P_NODE_22664_length_248_cov_0.880000_g22554_i0	PRJNA482207	22664	248	0.88	2.1824	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2621702180\|emb\|OY760177.1\|	2044595	g22554	i0	100	0.112903225806452	28	0	11	0	11	38	1666016	1665989	MAG: Candidatus Gracilibacteria bacterium isolate ba77f91b-d06a-446b-8ae6-f296fa1be4ef genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
17025277	17025277	PRJNA482207_P_NODE_23874_length_247_cov_0.885057_g23764_i0	PRJNA482207	23874	247	0.885057	2.18609079	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	374	4.189999999999998e-99	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g23764	i0	93.927	1	247	15	100	0	1	247	170271	170517	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	247	374	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
20849697	20849697	PRJNA482207_P_NODE_29237_length_242_cov_0.911243_g29127_i0	PRJNA482207	29237	242	0.911243	2.20520806	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	129	1.4599999999999998e-35	NR	HEX4799343.1	2053589	g29127	i0	82.1	0.966942148760331	78	14	96.7	0	240	7	38	115	HEX4799343.1 elongation factor Ts [Candidatus Paceibacterota bacterium]	diamond	234	129	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
27139091	27139091	PRJNA482207_P_NODE_21862_length_249_cov_0.875000_g21752_i0	PRJNA482207	21862	249	0.875	2.17875	Minisyncoccia bacterium	3120121	Bacteria	Bacteria	137	7.31e-39	NR	MFT5832353.1	3120121	g21752	i0	78	0.987951807228916	82	18	98.8	0	3	248	56	137	MFT5832353.1 putative alpha/beta hydrolase family esterase [Minisyncoccia bacterium]	diamond	246	137	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia				Minisyncoccia bacterium
30455762	30455762	PRJNA482207_P_NODE_23173_length_248_cov_0.880000_g23063_i0	PRJNA482207	23173	248	0.88	2.1824	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	43.1	0.0281	NR	MDR3548743.1	2053589	g23063	i0	60	0.362903225806452	30	12	36.3	0	43	132	93	122	MDR3548743.1 reverse transcriptase [Candidatus Paceibacterota bacterium]	diamond	90	43.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
30676443	30676443	PRJNA482207_P_NODE_30293_length_241_cov_0.916667_g30183_i0	PRJNA482207	30293	241	0.916667	2.20916747	Candidatus Babeliaceae bacterium	2545253	Bacteria	Bacteria	89	1.75e-18	NR	HVW99438.1	2545253	g30183	i0	52.9	0.846473029045643	68	32	84.6	0	7	210	84	151	HVW99438.1 DDE-type integrase/transposase/recombinase [Candidatus Babeliaceae bacterium]	diamond	204	89	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae		Candidatus Babeliaceae bacterium
30708131	30708131	PRJNA482207_P_NODE_28454_length_243_cov_0.905882_g28344_i0	PRJNA482207	28454	243	0.905882	2.20129326	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	107	6.47e-25	NR	MBY0537966.1	2052139	g28344	i0	58.8	0.987654320987654	80	33	98.8	0	2	241	775	854	MBY0537966.1 ATP-dependent helicase [Patescibacteria group bacterium]	diamond	240	107	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32131267	32131267	PRJNA482207_P_NODE_17278_length_266_cov_1.492228_g17168_i0	PRJNA482207	17278	266	1.492228	3.96932648	Candidatus Beckwithbacteria bacterium	2053519	Bacteria	Bacteria	65.1	2.21e-11	NR	NMC36244.1	2053519	g17168	i0	58.7	3.40601503759398	63	25	69.9	1	187	2	1	63	NMC36244.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatC [Candidatus Beckwithbacteria bacterium]	diamond	906	65.1	1	Bacteria	Bacteria candidate phyla	Candidatus Beckwithiibacteriota					Candidatus Beckwithbacteria 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);;