metadata: contig_metadata: 13 rows where bioproject = "PRJNA400391" and tax

13 rows where bioproject = "PRJNA400391" 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_species
2964777	2964777	PRJNA400391_S_NODE_183_length_613_cov_17.634948_g136_i0	PRJNA400391	183	613	17.634948	108.10223124	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	784	0	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g136	i0	89.756	901.446982055465	615	59	100	4	1	613	813981	814593	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	552587	784	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
5517886	5517886	PRJNA400391_S_NODE_6305_length_156_cov_0.933884_g6244_i0	PRJNA400391	6305	156	0.933884	1.45685904	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	152	1.23e-32	NTclustered	gi\|1958016626\|gb\|CP064968.1\|	2030810	g6244	i0	87.97	24.3589743589744	133	11	84	5	1	131	977465	977594	MAG: Candidatus Kaiserbacteria bacterium isolate Damh_18-Q3-R51-60_MAXAC.235_fly chromosome, complete genome	blastn	3800	152	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota		Candidatus Kaiserbacteria bacterium
6791810	6791810	PRJNA400391_S_NODE_3946_length_203_cov_1.357143_g3885_i0	PRJNA400391	3946	203	1.357143	2.75500029	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	265	2.09e-66	NTclustered	gi\|2893356064\|emb\|OZ220487.1\|	3036252	g3885	i0	90.547	133.073891625616	201	18	99	1	1	200	5536557	5536757	MAG: uncultured Candidatus Binatia bacterium isolate d2d8104a-f810-4fb4-bb0c-dc82b69497ba genome assembly, chromosome: 1	blastn	27014	265	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	uncultured Candidatus Binatia bacterium
10618011	10618011	PRJNA400391_S_NODE_4749_length_183_cov_1.986486_g4688_i0	PRJNA400391	4749	183	1.986486	3.63526938	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	255	1.11e-63	NTclustered	gi\|1958073143\|gb\|CP064993.1\|	2026720	g4688	i0	92.697	123.16393442623	178	12	97	1	1	178	595610	595434	Candidatus Saccharibacteria bacterium isolate Hirt_18-Q3-R61-65_MAXAC.330_cln chromosome, complete genome	blastn	22539	255	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
10618014	10618014	PRJNA400391_S_NODE_4849_length_181_cov_1.897260_g4788_i0	PRJNA400391	4849	181	1.89726	3.4340406	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	230	6.62e-56	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g4788	i0	92.5	74.6077348066298	160	12	88	0	22	181	883927	884086	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	13504	230	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
10618043	10618043	PRJNA400391_S_NODE_5849_length_162_cov_2.377953_g5788_i0	PRJNA400391	5849	162	2.377953	3.85228386	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	161	2.15e-35	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g5788	i0	88.148	397.351851851852	135	16	83	0	28	162	814123	813989	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	64371	161	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
13167902	13167902	PRJNA400391_S_NODE_6291_length_156_cov_1.264463_g6230_i0	PRJNA400391	6291	156	1.264463	1.97256228	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	195	2.02e-45	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g6230	i0	90.066	3.87179487179487	151	13	96	2	7	156	126051	125902	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	604	195	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
14443045	14443045	PRJNA400391_S_NODE_5232_length_173_cov_1.224638_g5171_i0	PRJNA400391	5232	173	1.224638	2.11862374	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	150	5.009999999999999e-32	NTclustered	gi\|2874254002\|emb\|OY970327.1\|	2890869	g5171	i0	87.218	123.947976878613	133	16	77	1	28	160	680293	680162	MAG: Candidatus Saccharimonadia bacterium isolate MFD01275.bin.c.7 genome assembly, chromosome: 1	blastn	21443	150	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadia bacterium
16991573	16991573	PRJNA400391_S_NODE_214_length_592_cov_19.938959_g165_i0	PRJNA400391	214	592	19.938959	118.03863728	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	407	1.08e-108	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g165	i0	80.501	44.7567567567568	559	86	93	20	1	548	429042	429588	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	26496	407	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
19539882	19539882	PRJNA400391_S_NODE_5156_length_174_cov_1.705036_g5095_i0	PRJNA400391	5156	174	1.705036	2.96676264	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	132	1.83e-26	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g5095	i0	84.328	0.770114942528736	134	21	77	0	2	135	123780	123913	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	134	132	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
20207261	20207261	PRJNA400391_S_NODE_6056_length_159_cov_2.282258_g5995_i0	PRJNA400391	6056	159	2.282258	3.62879022	Bacteria	2	Bacteria	Bacteria	270	3.3399999999999992e-68	NTclustered	gi\|2874253997\|emb\|OY970322.1\|	179883	g5995	i0	97.468	20.9811320754717	158	4	99	0	2	159	419203	419046	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1	blastn	3336	272	0.992647058823529	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		uncultured Candidatus Saccharibacteria bacterium
23366103	23366103	PRJNA400391_S_NODE_1419_length_317_cov_4.641844_g1358_i0	PRJNA400391	1419	317	4.641844	14.71464548	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	96.7	1.9799999999999998e-23	NR	HRN86953.1	2099670	g1358	i0	61.1	0.899053627760252	95	34	89.9	2	307	23	11	102	HRN86953.1 hypothetical protein [Candidatus Dojkabacteria bacterium]	diamond	285	96.7	1	Bacteria	Bacteria candidate phyla			Candidatus Dojkabacteria bacterium
27012098	27012098	PRJNA400391_S_NODE_4042_length_201_cov_1.596386_g3981_i0	PRJNA400391	4042	201	1.596386	3.20873586	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	52.8	4.66e-6	NR	MEN9920673.1	2762014	g3981	i0	57.1	1.73134328358209	42	18	62.7	0	135	10	18	59	MEN9920673.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	348	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria		Candidatus Parcubacteria 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);;