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

8 rows where bioproject = "PRJNA1004255" 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
10356432	10356432	PRJNA1004255_S_NODE_5889_length_248_cov_4.414634_g5681_i0	PRJNA1004255	5889	248	4.414634	10.94829232	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g5681	i0	99.194	72.4153225806452	248	2	100	0	1	248	906478	906725	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	17959	448	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
28739847	28739847	PRJNA1004255_S_NODE_3507_length_297_cov_1.925197_g3299_i0	PRJNA1004255	3507	297	1.925197	5.71783509	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	169	1.34e-49	NR	HXT77869.1	2212470	g3299	i0	81.8	4	99	16	100	1	1	297	209	305	HXT77869.1 diacylglycerol kinase family protein [Candidatus Eiseniibacteriota bacterium]	diamond	1188	169	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota bacterium
29434136	29434136	PRJNA1004255_S_NODE_14190_length_172_cov_3.279070_g13982_i0	PRJNA1004255	14190	172	3.27907	5.6400004	candidate division TM6 bacterium GW2	95901	Bacteria	Bacteria	53.1	3.05e-6	NR	KKP95620.1	1619081	g13982	i0	45.6	1.97093023255814	57	31	99.4	0	172	2	210	266	KKP95620.1 MAG: MATE efflux family protein [candidate division TM6 bacterium GW2011_GWF2_36_131]	diamond	339	53.1	1	Bacteria	Bacteria candidate phyla						candidate division TM6 bacterium GW2011_GWF2_36_131
29623399	29623399	PRJNA1004255_S_NODE_11230_length_191_cov_2.540541_g11022_i0	PRJNA1004255	11230	191	2.540541	4.85243331	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	42.4	0.0253	NR	HEY6736276.1	2890869	g11022	i0	42.9	0.769633507853403	49	26	77	1	6	152	229	275	HEY6736276.1 acyltransferase family protein [Candidatus Saccharimonadia bacterium]	diamond	147	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
30919311	30919311	PRJNA1004255_S_NODE_6794_length_235_cov_1.223958_g6586_i0	PRJNA1004255	6794	235	1.223958	2.8763013	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	95.5	5.4400000000000005e-21	NR	HMI51600.1	2973664	g6586	i0	67.6	0.868085106382979	68	22	86.8	0	230	27	33	100	HMI51600.1 POTRA domain-containing protein [Candidatus Saccharimonadales bacterium]	diamond	204	95.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
31171650	31171650	PRJNA1004255_S_NODE_10415_length_198_cov_1.516129_g10207_i0	PRJNA1004255	10415	198	1.516129	3.00193542	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	124	1.41e-33	NR	HMI52660.1	2973664	g10207	i0	93.8	1.96969696969697	65	4	98.5	0	2	196	97	161	HMI52660.1 pyridoxamine 5'-phosphate oxidase family protein [Candidatus Saccharimonadales bacterium]	diamond	390	124	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32595429	32595429	PRJNA1004255_S_NODE_4400_length_275_cov_3.594828_g4192_i0	PRJNA1004255	4400	275	3.594828	9.885777	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	66.2	1.95e-10	NR	HMI50288.1	2973664	g4192	i0	68.1	0.512727272727273	47	15	51.3	0	275	135	249	295	HMI50288.1 tetratricopeptide repeat protein [Candidatus Saccharimonadales bacterium]	diamond	141	66.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32713792	32713792	PRJNA1004255_S_NODE_14180_length_172_cov_3.643411_g13972_i0	PRJNA1004255	14180	172	3.643411	6.26666692	Bacteria candidate phyla	1783234	Bacteria	Bacteria	102	1.49e-24	NR	HYL63191.1	2032687	g13972	i0	87.7	4.97093023255814	57	7	99.4	0	2	172	75	131	HYL63191.1 thioredoxin-disulfide reductase [Candidatus Methylomirabilis sp.]	diamond	855	102	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.

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);;