metadata: contig_metadata: 16 rows where bioproject = "PRJNA630162" and tax

16 rows where bioproject = "PRJNA630162" and tax_phylum = "Candidatus Altimarinota"

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_species
601695	601695	PRJNA630162_P_NODE_141721_length_166_cov_2.299145_g140198_i0	PRJNA630162	141721	166	2.299145	3.8165807	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	135	1.34e-27	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g140198	i0	84.672	128.831325301205	137	20	82	1	6	141	1251496	1251360	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	21386	135	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium 28_42_T64
602527	602527	PRJNA630162_P_NODE_68621_length_214_cov_1.157576_g67098_i0	PRJNA630162	68621	214	1.157576	2.47721264	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	130	8.47e-26	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g67098	i0	80.663	23.8084112149533	181	23	84	9	2	181	1250187	1250356	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	5095	130	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium 28_42_T64
6980739	6980739	PRJNA630162_P_NODE_36566_length_295_cov_466.243902_g35043_i0	PRJNA630162	36566	295	466.243902	1375.4195109	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	372	1.8499999999999998e-98	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g35043	i0	89.865	347.698305084746	296	20	99	8	1	291	1251395	1251685	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	102571	372	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium 28_42_T64
12082089	12082089	PRJNA630162_P_NODE_79150_length_202_cov_2.274510_g77627_i0	PRJNA630162	79150	202	2.27451	4.5945102	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	307	3.4e-79	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g77627	i0	94.089	93.7178217821782	203	11	100	1	1	202	1249666	1249868	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	18931	307	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium 28_42_T64
12630322	12630322	PRJNA630162_P_NODE_14990_length_487_cov_2.287671_g13498_i0	PRJNA630162	14990	487	2.287671	11.14095777	Bacteria	2	Bacteria	Bacteria	163	2.1e-35	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g13498	i0	89.764	1.18275154004107	127	13	26	0	10	136	1250825	1250699	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	576	163	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium 28_42_T64
15904365	15904365	PRJNA630162_P_NODE_114253_length_177_cov_2.351562_g112730_i0	PRJNA630162	114253	177	2.351562	4.16226474	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	115	2.36e-28	NR	MBX9808915.1	2044595	g112730	i0	100	3.84745762711864	57	0	96.6	0	6	176	159	215	MBX9808915.1 molecular chaperone DnaK [Candidatus Altimarinota bacterium]	diamond	681	115	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
18454818	18454818	PRJNA630162_P_NODE_88515_length_193_cov_1.361111_g86992_i0	PRJNA630162	88515	193	1.361111	2.62694423	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	231	1.9900000000000002e-56	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g86992	i0	88.265	5.61658031088083	196	20	100	2	1	193	1250587	1250392	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	1084	231	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium 28_42_T64
21004526	21004526	PRJNA630162_P_NODE_25917_length_358_cov_7.957929_g24396_i0	PRJNA630162	25917	358	7.957929	28.48938582	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	390	6.33e-104	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g24396	i0	86.895	249.667597765363	351	42	98	3	1	351	890475	890129	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	89381	390	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium HOT-871
21553382	21553382	PRJNA630162_P_NODE_38957_length_285_cov_5.296610_g37434_i0	PRJNA630162	38957	285	5.29661	15.0953385	Bacteria	2	Bacteria	Bacteria	202	2.4699999999999997e-47	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g37434	i0	85.024	76.7508771929825	207	22	71	8	78	280	1249343	1249544	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	21874	202	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium 28_42_T64
23554811	23554811	PRJNA630162_P_NODE_36359_length_296_cov_8.728745_g34836_i0	PRJNA630162	36359	296	8.728745	25.8370852	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	169	2.62e-37	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g34836	i0	89.552	2.70608108108108	134	13	45	1	138	271	1250498	1250366	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	801	169	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium 28_42_T64
23555335	23555335	PRJNA630162_P_NODE_87179_length_194_cov_1.524138_g85656_i0	PRJNA630162	87179	194	1.524138	2.95682772	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	110	9.8e-20	NTclustered	gi\|2621704339\|emb\|OY760935.1\|	2044595	g85656	i0	85.047	20.7113402061856	107	16	55	0	6	112	1136610	1136716	MAG: Candidatus Gracilibacteria bacterium isolate 3c0776cb-dd52-49a3-965b-30fb91b92491 genome assembly, chromosome: 1	blastn	4018	110	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
27302215	27302215	PRJNA630162_P_NODE_88883_length_192_cov_3.195804_g87360_i0	PRJNA630162	88883	192	3.195804	6.13594368	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	65.9	1.52e-11	NR	MBX9808780.1	2044595	g87360	i0	81.6	0.59375	38	7	59.4	0	77	190	1	38	MBX9808780.1 50S ribosomal protein L15 [Candidatus Altimarinota bacterium]	diamond	114	65.9	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
29133517	29133517	PRJNA630162_P_NODE_141209_length_166_cov_3.786325_g139686_i0	PRJNA630162	141209	166	3.786325	6.2852995	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	41.2	0.0469	NR	MDD5213827.1	2044595	g139686	i0	90.5	0.379518072289157	21	2	38	0	104	166	210	230	MDD5213827.1 NADP-dependent malic enzyme [Candidatus Altimarinota bacterium]	diamond	63	41.2	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
29354510	29354510	PRJNA630162_P_NODE_160929_length_162_cov_0.920354_g159406_i0	PRJNA630162	160929	162	0.920354	1.49097348	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	89.4	4.21e-19	NR	MCF7843868.1	2044595	g159406	i0	75	0.962962962962963	52	13	96.3	0	157	2	40	91	MCF7843868.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	156	89.4	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
30491523	30491523	PRJNA630162_P_NODE_163193_length_161_cov_2.116071_g161670_i0	PRJNA630162	163193	161	2.116071	3.40687431	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	50.4	2.34e-5	NR	MDD5377176.1	2044595	g161670	i0	88	0.46583850931677	25	3	46.6	0	11	85	2759	2783	MDD5377176.1 Ig-like domain-containing protein [Candidatus Altimarinota bacterium]	diamond	75	50.4	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
31850657	31850657	PRJNA630162_P_NODE_159777_length_162_cov_1.442478_g158254_i0	PRJNA630162	159777	162	1.442478	2.33681436	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	74.7	6.45e-14	NR	MCD5375397.1	2044595	g158254	i0	97.2	10.6666666666667	36	1	66.7	0	112	5	3	38	MCD5375397.1 molecular chaperone DnaK [Candidatus Altimarinota bacterium]	diamond	1728	74.7	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota 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);;