metadata: contig_metadata: 5 rows where bioproject = "PRJNA1253698" and tax

5 rows where bioproject = "PRJNA1253698" 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
4880786	4880786	PRJNA1253698_S_NODE_16864_length_173_cov_1.250000_g16498_i0	PRJNA1253698	16864	173	1.25	2.1625	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	268	1.33e-67	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g16498	i0	94.767	104.947976878613	172	9	99	0	2	173	79785	79614	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	18156	268	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
8013119	8013119	PRJNA1253698_S_NODE_24107_length_158_cov_2.275229_g23741_i0	PRJNA1253698	24107	158	2.275229	3.59486182	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	287	3.29e-73	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g23741	i0	99.367	296.006329113924	158	1	100	0	1	158	151082	150925	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	46769	287	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
15080545	15080545	PRJNA1253698_S_NODE_9552_length_223_cov_0.931034_g9186_i0	PRJNA1253698	9552	223	0.931034	2.07620582	Candidatus Saccharimonadia	2093818	Bacteria	Bacteria	313	8.23e-81	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g9186	i0	96.791	207.739910313901	187	6	84	0	2	188	906459	906645	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	46326	313	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
18904160	18904160	PRJNA1253698_S_NODE_11135_length_207_cov_1.518987_g10769_i0	PRJNA1253698	11135	207	1.518987	3.14430309	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	329	7.47e-86	NTclustered	gi\|2869833183\|gb\|CP175706.1\|	2093824	g10769	i0	97.423	217.415458937198	194	4	93	1	15	207	128282	128089	Candidatus Nanosynbacter lyticus strain BB004 chromosome, complete genome	blastn	45005	329	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
31924948	31924948	PRJNA1253698_S_NODE_23297_length_162_cov_0.920354_g22931_i0	PRJNA1253698	23297	162	0.920354	1.49097348	Pseudomonadati	3379134	Bacteria	Bacteria	52	1.61e-6	NR	MEK7446940.1	2072417	g22931	i0	54.5	8.48148148148148	44	20	81.5	0	133	2	1	44	MEK7446940.1 single-stranded DNA-binding protein [Candidatus Methylomirabilota bacterium]	diamond	1374	52.4	0.99236641221374	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota 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);;