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

5 rows where bioproject = "PRJNA898105" 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_species
5072305	5072305	PRJNA898105_P_NODE_5844_length_256_cov_1.306011_g5644_i0	PRJNA898105	5844	256	1.306011	3.34338816	Candidatus Nanosynsacchari	2789662	Bacteria	Bacteria	169	1.98e-46	NR	TWP24531.1	713049	g5644	i0	100	1.9921875	85	0	99.6	0	2	256	293	377	TWP24531.1 tRNA guanosine(34) transglycosylase Tgt [TM7 phylum sp. oral taxon 346]	diamond	510	169	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			TM7 phylum sp. oral taxon 346
9801700	9801700	PRJNA898105_P_NODE_4128_length_287_cov_1.177570_g3928_i0	PRJNA898105	4128	287	1.17757	3.3796259	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	351	2.34e-92	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g3928	i0	88.889	332.048780487805	288	29	99	3	2	287	598603	598889	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	95298	351	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			uncultured Candidatus Saccharibacteria bacterium
27277111	27277111	PRJNA898105_P_NODE_6083_length_251_cov_0.865169_g5883_i0	PRJNA898105	6083	251	0.865169	2.17157419	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	74.7	2.1e-13	NR	HEU4831016.1	2973664	g5883	i0	69.2	1.20717131474104	52	15	62.2	1	96	251	4	54	HEU4831016.1 O-antigen ligase family protein [Candidatus Saccharimonadales bacterium]	diamond	303	74.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
28263397	28263397	PRJNA898105_P_NODE_6286_length_250_cov_1.598870_g6086_i0	PRJNA898105	6286	250	1.59887	3.997175	Bacteria	2	Bacteria	Bacteria	120	1.32e-29	NR	AHB42535.1	1394711	g6086	i0	70	2.928	80	24	96	0	242	3	965	1044	AHB42535.1 UvrD/REP helicase [Candidatus Saccharibacteria bacterium RAAC3_TM7_1]	diamond	732	120	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium RAAC3_TM7_1
30277265	30277265	PRJNA898105_P_NODE_8112_length_242_cov_0.911243_g7912_i0	PRJNA898105	8112	242	0.911243	2.20520806	Candidatus Daviesbacteria bacterium	2053542	Bacteria	Bacteria	116	3.0099999999999993e-28	NR	MBI2593518.1	2053542	g7912	i0	71.8	0.966942148760331	78	22	96.7	0	5	238	230	307	MBI2593518.1 DMT family transporter [Candidatus Daviesbacteria bacterium]	diamond	234	116	1	Bacteria	Bacteria candidate phyla	Candidatus Daviesiibacteriota			Candidatus Daviesbacteria 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);;