metadata: contig_metadata: 14 rows where bioproject = "PRJNA1010662" and tax

14 rows where bioproject = "PRJNA1010662" 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
6533098	6533098	PRJNA1010662_P_NODE_406_length_772_cov_9.609959_g360_i0	PRJNA1010662	406	772	9.609959	74.18888348	Candidatus Babelota bacterium	2030827	Bacteria	Bacteria	217	3.929999999999999e-67	NR	MCA9770713.1	2030827	g360	i0	52.8	1.62823834196891	212	97	81.2	2	749	123	1	212	MCA9770713.1 ribosomal protein L13e [Candidatus Dependentiae bacterium]	diamond	1257	217	1	Bacteria	Bacteria candidate phyla			Candidatus Babelota bacterium
18006741	18006741	PRJNA1010662_S_NODE_2995_length_194_cov_1.596026_g2950_i0	PRJNA1010662	2995	194	1.596026	3.09629044	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	263	7.11e-66	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g2950	i0	91.667	1.97938144329897	192	13	98	3	1	191	891533	891344	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	384	263	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium HOT-871
26939425	26939425	PRJNA1010662_P_NODE_14722_length_165_cov_0.896552_g14663_i0	PRJNA1010662	14722	165	0.896552	1.4793108	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	41.6	0.0331	NR	MDD3645859.1	2044595	g14663	i0	50	0.618181818181818	34	17	61.8	0	103	2	149	182	MDD3645859.1 serine protease [Candidatus Altimarinota bacterium]	diamond	102	41.6	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Altimarinota bacterium
27255721	27255721	PRJNA1010662_P_NODE_13103_length_168_cov_0.865546_g13044_i0	PRJNA1010662	13103	168	0.865546	1.45411728	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	47	3.32e-4	NR	MFA5128905.1	2052139	g13044	i0	50	0.678571428571429	38	19	67.9	0	2	115	177	214	MFA5128905.1 adenylate kinase [Patescibacteria group bacterium]	diamond	114	47	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
27319146	27319146	PRJNA1010662_P_NODE_13363_length_167_cov_1.364407_g13304_i0	PRJNA1010662	13363	167	1.364407	2.27855969	Candidatus Bipolaricaulia bacterium	3121610	Bacteria	Bacteria	70.1	2.98e-12	NR	MFN4218579.1	3121610	g13304	i0	55.6	0.970059880239521	54	24	97	0	164	3	383	436	MFN4218579.1 6-bladed beta-propeller [Candidatus Bipolaricaulia bacterium]	diamond	162	70.1	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota	Candidatus Bipolaricaulia	Candidatus Bipolaricaulia bacterium
28076747	28076747	PRJNA1010662_P_NODE_445_length_738_cov_2.031930_g397_i0	PRJNA1010662	445	738	2.03193	14.9956434	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	48.9	0.0155	NR	HET9946446.1	2052139	g397	i0	28.4	0.74390243902439	183	111	71.1	6	103	627	2607	2777	HET9946446.1 DUF2341 domain-containing protein [Patescibacteria group bacterium]	diamond	549	48.9	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
29206221	29206221	PRJNA1010662_P_NODE_16009_length_163_cov_0.912281_g15950_i0	PRJNA1010662	16009	163	0.912281	1.48701803	Bacteria	2	Bacteria	Bacteria	99.8	4.029999999999999e-23	NR	OJU87817.1	1895829	g15950	i0	84.9	6.82822085889571	53	8	97.5	0	5	163	109	161	OJU87817.1 MAG: hypothetical protein BGO17_02425 [Candidatus Saccharibacteria bacterium 49-20]	diamond	1113	99.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium 49-20
29497639	29497639	PRJNA1010662_P_NODE_13710_length_167_cov_0.872881_g13651_i0	PRJNA1010662	13710	167	0.872881	1.45771127	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	49.7	4.7e-5	NR	HUU05466.1	2052139	g13651	i0	58.8	1.25748502994012	34	14	61.1	0	157	56	187	220	HUU05466.1 ankyrin repeat domain-containing protein [Patescibacteria group bacterium]	diamond	210	49.7	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
30319448	30319448	PRJNA1010662_P_NODE_8592_length_195_cov_1.397260_g8533_i0	PRJNA1010662	8592	195	1.39726	2.724657	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	57.8	9.62e-8	NR	MBC7406177.1	2053589	g8533	i0	38.7	0.953846153846154	62	38	95.4	0	8	193	248	309	MBC7406177.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	186	57.8	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
30666376	30666376	PRJNA1010662_P_NODE_12173_length_170_cov_1.702479_g12114_i0	PRJNA1010662	12173	170	1.702479	2.8942143	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	43.5	0.00738	NR	MDR3548435.1	2053589	g12114	i0	48.5	0.582352941176471	33	17	58.2	0	4	102	135	167	MDR3548435.1 HAD-IC family P-type ATPase [Candidatus Paceibacterota bacterium]	diamond	99	43.5	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
30951009	30951009	PRJNA1010662_P_NODE_7034_length_211_cov_1.179012_g6975_i0	PRJNA1010662	7034	211	1.179012	2.48771532	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	56.6	3.2e-7	NR	MBI2453117.1	2030811	g6975	i0	41.2	0.966824644549763	68	36	93.8	2	205	8	1020	1085	MBI2453117.1 carbamoyl-phosphate synthase (glutamine-hydrolyzing) large subunit [Candidatus Peregrinibacteria bacterium]	diamond	204	56.6	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota		Candidatus Peregrinibacteria bacterium
31045904	31045904	PRJNA1010662_P_NODE_14875_length_165_cov_0.887931_g14816_i0	PRJNA1010662	14875	165	0.887931	1.46508615	Candidatus Coatesbacteria bacterium	2250272	Bacteria	Bacteria	40.8	0.0387	NR	MEK7474779.1	2250272	g14816	i0	41.5	0.745454545454545	41	21	74.5	1	165	43	28	65	MEK7474779.1 cyclic nucleotide-binding domain-containing protein [Candidatus Coatesbacteria bacterium]	diamond	123	40.8	1	Bacteria	Bacteria candidate phyla	Candidatus Coatesiibacteriota		Candidatus Coatesbacteria bacterium
32121086	32121086	PRJNA1010662_P_NODE_6158_length_221_cov_1.494186_g6099_i0	PRJNA1010662	6158	221	1.494186	3.30215106	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	112	3.9300000000000005e-27	NR	MEX0597309.1	2053589	g6099	i0	63	0.990950226244344	73	27	99.1	0	2	220	384	456	MEX0597309.1 deoxyribodipyrimidine photo-lyase [Candidatus Paceibacterota bacterium]	diamond	219	112	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
32878697	32878697	PRJNA1010662_P_NODE_1440_length_425_cov_1.936170_g1381_i0	PRJNA1010662	1440	425	1.93617	8.2287225	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	107	1.9e-26	NR	MBS1226412.1	2052149	g1381	i0	42.1	1.97647058823529	140	77	98.8	1	425	6	35	170	MBS1226412.1 Lipocalin family protein [Candidatus Aminicenantes bacterium]	diamond	840	107	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota		Candidatus Aminicenantes 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);;