metadata: contig_metadata: 10 rows where bioproject = "PRJNA1214993", tax_clade = "Bacteria candidate phyla" and tax

10 rows where bioproject = "PRJNA1214993", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"

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
16907422	16907422	PRJNA1214993_P_NODE_14734_length_289_cov_1.069444_g14548_i0	PRJNA1214993	14734	289	1.069444	3.09069316	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	363	1.09e-95	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g14548	i0	89.31	159.453287197232	290	29	100	2	1	289	161528	161816	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	46082	363	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
27186098	27186098	PRJNA1214993_P_NODE_14922_length_287_cov_1.448598_g14736_i0	PRJNA1214993	14922	287	1.448598	4.15747626	Pseudomonadati	3379134	Bacteria	Bacteria	81.3	9.55e-17	NR	MDD3497926.1	2045217	g14736	i0	56.9	2.01742160278746	65	26	65.9	1	285	97	108	172	MDD3497926.1 peptide-methionine (S)-S-oxide reductase MsrA [Candidatus Moraniibacteriota bacterium]	diamond	579	81.6	0.996323529411765	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota					Candidatus Moraniibacteriota bacterium
29314765	29314765	PRJNA1214993_P_NODE_22429_length_248_cov_0.891429_g22243_i0	PRJNA1214993	22429	248	0.891429	2.21074392	Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1	2013831	Bacteria	Bacteria	65.5	3.83e-10	NR	PKL30717.1	2013831	g22243	i0	41.5	6.83467741935484	82	45	95.6	1	10	246	332	413	PKL30717.1 MAG: hypothetical protein CVV43_05560, partial [Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1]	diamond	1695	65.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1
29472330	29472330	PRJNA1214993_P_NODE_19150_length_256_cov_1.262295_g18964_i0	PRJNA1214993	19150	256	1.262295	3.2314752	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	76.6	4.94e-14	NR	RMD63071.1	2762014	g18964	i0	50	1.6171875	70	34	82	1	239	30	308	376	RMD63071.1 MAG: hypothetical protein D6833_06050, partial [Candidatus Parcubacteria bacterium]	diamond	414	76.6	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria					Candidatus Parcubacteria bacterium
29946382	29946382	PRJNA1214993_P_NODE_15351_length_284_cov_1.109005_g15165_i0	PRJNA1214993	15351	284	1.109005	3.1495742	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	60.1	4.99e-8	NR	HEY2775004.1	2838779	g15165	i0	63.6	4.70070422535211	44	16	46.5	0	3	134	1003	1046	HEY2775004.1 thrombospondin type 3 repeat-containing protein [Candidatus Binatia bacterium]	diamond	1335	60.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
30577963	30577963	PRJNA1214993_P_NODE_9133_length_361_cov_1.656250_g8947_i0	PRJNA1214993	9133	361	1.65625	5.9790625	Sumerlaeia bacterium	3066091	Bacteria	Bacteria	90.5	2.11e-18	NR	MEQ8821692.1	3066091	g8947	i0	51.8	0.706371191135734	85	41	70.6	0	357	103	100	184	MEQ8821692.1 aspartate aminotransferase family protein [Sumerlaeia bacterium]	diamond	255	90.5	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia				Sumerlaeia bacterium
32095778	32095778	PRJNA1214993_P_NODE_8438_length_374_cov_1.488372_g8252_i0	PRJNA1214993	8438	374	1.488372	5.56651128	Candidatus Elulimicrobium humile	2802965	Bacteria	Bacteria	72	6.28e-12	NR	NBP59295.1	2802965	g8252	i0	37.8	1.42780748663102	98	58	76.2	1	286	2	39	136	NBP59295.1 hypothetical protein [Candidatus Elulimicrobium humile]	diamond	534	72	1	Bacteria	Bacteria candidate phyla	Candidatus Elulimicrobiota	Candidatus Elulimicrobia	Candidatus Elulimicrobiales	Candidatus Elulimicrobiaceae	Candidatus Elulimicrobium	Candidatus Elulimicrobium humile
32317637	32317637	PRJNA1214993_P_NODE_9979_length_347_cov_0.821168_g9793_i0	PRJNA1214993	9979	347	0.821168	2.84945296	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	229	1.58e-73	NR	HRN71286.1	2026804	g9793	i0	96.5	0.994236311239193	115	4	99.4	0	2	346	109	223	HRN71286.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	345	229	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota					Candidatus Woesebacteria bacterium
32651839	32651839	PRJNA1214993_P_NODE_17660_length_266_cov_2.424870_g17474_i0	PRJNA1214993	17660	266	2.42487	6.4501542	Bacteria	2	Bacteria	Bacteria	111	4.36e-29	NR	TSC87613.1	2017210	g17474	i0	70.7	5.13157894736842	75	22	84.6	0	262	38	79	153	TSC87613.1 MAG: Peptidylprolyl isomerase [Microgenomates group bacterium Gr01-1014_16]	diamond	1365	112	0.991071428571429	Bacteria	Bacteria candidate phyla						Microgenomates group bacterium Gr01-1014_16
32727903	32727903	PRJNA1214993_P_NODE_18260_length_262_cov_1.539683_g18074_i0	PRJNA1214993	18260	262	1.539683	4.03396946	Candidatus Kerfeldbacteria bacterium	2053565	Bacteria	Bacteria	50.4	4.16e-5	NR	MBI3120273.1	2053565	g18074	i0	55.6	1.37404580152672	36	16	41.2	0	216	109	143	178	MBI3120273.1 hypothetical protein [Candidatus Kerfeldbacteria bacterium]	diamond	360	50.4	1	Bacteria	Bacteria candidate phyla	Candidatus Kerfeldiibacteriota					Candidatus Kerfeldbacteria 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);;