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

8 rows where bioproject = "PRJNA390533" and tax_phylum = "Candidatus Saccharimonadota"

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
4236804	4236804	PRJNA390533_P_NODE_31524_length_236_cov_6.771574_g30497_i0	PRJNA390533	31524	236	6.771574	15.98091464	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	281	2.48e-71	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g30497	i0	90.323	68.0720338983051	217	18	92	3	1	216	668127	668341	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	16065	281	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
8730961	8730961	PRJNA390533_P_NODE_8707_length_667_cov_2.694268_g7894_i0	PRJNA390533	8707	667	2.694268	17.97076756	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	531	6.999999999999998e-146	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g7894	i0	96.296	64.0254872563718	324	11	81	1	331	654	696089	696411	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	42705	536	0.990671641791045	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
9337698	9337698	PRJNA390533_P_NODE_20468_length_378_cov_1.870206_g19444_i0	PRJNA390533	20468	378	1.870206	7.06937868	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	654	0	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g19444	i0	99.444	76.6798941798942	360	2	95	0	19	378	545002	544643	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	28985	654	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1
15712174	15712174	PRJNA390533_P_NODE_12413_length_547_cov_3.183071_g11472_i0	PRJNA390533	12413	547	3.183071	17.41139837	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	488	3.459999999999999e-133	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g11472	i0	84.158	14.9360146252285	505	78	92	2	23	526	473677	473174	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	8170	488	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22086209	22086209	PRJNA390533_P_NODE_3558_length_992_cov_12.804827_g3050_i0	PRJNA390533	3558	992	12.804827	127.02388384	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	1755	0	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g3050	i0	99.895	139.664314516129	953	1	96	0	15	967	543272	544224	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	138547	1755	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1
27629372	27629372	PRJNA390533_P_NODE_30684_length_245_cov_1.577670_g29657_i0	PRJNA390533	30684	245	1.57767	3.8652915	Bacteria	2	Bacteria	Bacteria	117	6.329999999999999e-31	NR	MCA9342090.1	2026720	g29657	i0	70	1.9469387755102	80	24	98	0	243	4	21	100	MCA9342090.1 VIT1/CCC1 transporter family protein [Candidatus Saccharibacteria bacterium]	diamond	477	117	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27818825	27818825	PRJNA390533_P_NODE_38044_length_190_cov_1.331126_g37017_i0	PRJNA390533	38044	190	1.331126	2.5291394	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	99.8	1.52e-22	NR	RKW02814.1	1917697	g37017	i0	94.8	1.83157894736842	58	3	91.6	0	188	15	407	464	RKW02814.1 MAG: hypothetical protein D8B38_02535 [Candidatus Saccharimonas sp.]	diamond	348	99.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
30106736	30106736	PRJNA390533_P_NODE_132_length_2709_cov_5.586142_g104_i0	PRJNA390533	132	2709	5.586142	151.32858678	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	412	3.85e-133	NR	HBO64817.1	2026720	g104	i0	62.6	0.355481727574751	321	120	35.5	0	953	1915	8	328	HBO64817.1 glycosyl transferase family 2 [Candidatus Saccharibacteria bacterium]	diamond	963	412	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota 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);;