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

14 rows where bioproject = "PRJEB36940" 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_order	tax_family	tax_genus	tax_species
6434948	6434948	PRJEB36940_P_NODE_15346_length_243_cov_1.829412_g15217_i0	PRJEB36940	15346	243	1.829412	4.44547116	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	320	5.44e-83	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g15217	i0	90.535	471.329218106996	243	22	100	1	1	243	884091	883850	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	114533	320	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
14085154	14085154	PRJEB36940_P_NODE_8872_length_291_cov_2.348624_g8743_i0	PRJEB36940	8872	291	2.348624	6.83449584	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	388	1.81e-103	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g8743	i0	90.753	121.742268041237	292	25	100	2	1	291	138396	138106	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	35427	388	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
14085165	14085165	PRJEB36940_P_NODE_9372_length_284_cov_3.957346_g9243_i0	PRJEB36940	9372	284	3.957346	11.23886264	Candidatus Rifleibacteriota bacterium	2053586	Bacteria	Bacteria	132	1.76e-33	NR	MBF0407784.1	2053586	g9243	i0	65.6	0.982394366197183	93	32	98.2	0	6	284	236	328	MBF0407784.1 NADP-dependent isocitrate dehydrogenase [Candidatus Rifleibacteriota bacterium]	diamond	279	132	1	Bacteria	Bacteria candidate phyla	Candidatus Rifleibacteriota					Candidatus Rifleibacteriota bacterium
17908405	17908405	PRJEB36940_P_NODE_315_length_1309_cov_2.476537_g253_i0	PRJEB36940	315	1309	2.476537	32.41786933	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	662	5.3e-237	NR	MCL4419852.1	2052139	g253	i0	81.6	0.907563025210084	396	73	90.8	0	3	1190	6	401	MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium]	diamond	1188	662	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
23941328	23941328	PRJEB36940_P_NODE_11659_length_258_cov_1.908108_g11530_i0	PRJEB36940	11659	258	1.908108	4.92291864	Candidatus Mycosynbacter	2831665	Bacteria	Bacteria	370	5.71e-98	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g11530	i0	92.664	58.2015503875969	259	16	100	3	1	258	143733	143989	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	15016	372	0.99462365591397806	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
26589852	26589852	PRJEB36940_P_NODE_9801_length_279_cov_1.500000_g9672_i0	PRJEB36940	9801	279	1.5	4.185	Candidatus Dependentiae bacterium	2030827	Bacteria	Bacteria	55.8	7.68e-8	NR	RTL06915.1	2030827	g9672	i0	62.5	0.43010752688172	40	15	43	0	121	2	37	76	RTL06915.1 MAG: hypothetical protein EKK58_03725 [Candidatus Dependentiae bacterium]	diamond	120	55.8	1	Bacteria	Bacteria candidate phyla						Candidatus Babelota bacterium
26716379	26716379	PRJEB36940_P_NODE_5221_length_374_cov_1.235880_g5092_i0	PRJEB36940	5221	374	1.23588	4.6221912	Candidatus Yanofskybacteria bacterium	2052154	Bacteria	Bacteria	62	5.06e-9	NR	MBX4211668.1	2052154	g5092	i0	35	0.802139037433155	100	51	69	4	296	39	66	165	MBX4211668.1 hypothetical protein [Candidatus Yanofskybacteria bacterium]	diamond	300	62	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota					Candidatus Yanofskybacteria bacterium
27096487	27096487	PRJEB36940_P_NODE_582_length_1074_cov_4.162837_g491_i0	PRJEB36940	582	1074	4.162837	44.70886938	Candidatus Dependentiae bacterium	2030827	Bacteria	Bacteria	100	1.46e-20	NR	RTL06913.1	2030827	g491	i0	33.7	0.564245810055866	202	129	55.6	2	790	194	27	226	RTL06913.1 MAG: hypothetical protein EKK58_03715 [Candidatus Dependentiae bacterium]	diamond	606	100	1	Bacteria	Bacteria candidate phyla						Candidatus Babelota bacterium
28423143	28423143	PRJEB36940_P_NODE_15986_length_242_cov_0.911243_g15857_i0	PRJEB36940	15986	242	0.911243	2.20520806	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	61.2	1.12e-8	NR	HPB31192.1	2107588	g15857	i0	49.3	0.929752066115702	75	35	89.3	1	10	225	248	322	HPB31192.1 NHL repeat-containing protein [Candidatus Sumerlaeota bacterium]	diamond	225	61.2	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota					Candidatus Sumerlaeota bacterium
28864935	28864935	PRJEB36940_P_NODE_13268_length_249_cov_1.727273_g13139_i0	PRJEB36940	13268	249	1.727273	4.30090977	Candidatus Saccharimonadaceae bacterium	2830836	Bacteria	Bacteria	63.5	1.86e-9	NR	HTK32460.1	2830836	g13139	i0	63.5	0.626506024096386	52	19	62.7	0	156	1	280	331	HTK32460.1 MBL fold metallo-hydrolase [Candidatus Saccharimonadaceae bacterium]	diamond	156	63.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae		Candidatus Saccharimonadaceae bacterium
29843789	29843789	PRJEB36940_P_NODE_11011_length_265_cov_1.697917_g10882_i0	PRJEB36940	11011	265	1.697917	4.49948005	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	45.1	0.00748	NR	MFA6050302.1	2053589	g10882	i0	38.2	1.82264150943396	55	27	62.3	2	70	234	83	130	MFA6050302.1 peptidoglycan-binding protein [Candidatus Paceibacterota bacterium]	diamond	483	45.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
30374759	30374759	PRJEB36940_P_NODE_12932_length_250_cov_1.531073_g12803_i0	PRJEB36940	12932	250	1.531073	3.8276825	Bacteria	2	Bacteria	Bacteria	47	0.00137	NR	HRY36901.1	2026717	g12803	i0	38.6	1.632	70	40	81.6	2	204	1	2272	2340	HRY36901.1 hypothetical protein [Candidatus Magasanikiibacteriota bacterium]	diamond	408	47.4	0.991561181434599	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota					Candidatus Magasanikiibacteriota bacterium
31233795	31233795	PRJEB36940_P_NODE_7935_length_307_cov_1.824786_g7806_i0	PRJEB36940	7935	307	1.824786	5.60209302	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	91.7	4.98e-19	NR	MCL4419431.1	2052139	g7806	i0	85.4	0.469055374592834	48	6	45.9	1	3	143	540	587	MCL4419431.1 hypothetical protein [Patescibacteria group bacterium]	diamond	144	91.7	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32688526	32688526	PRJEB36940_P_NODE_7480_length_316_cov_1.761317_g7351_i0	PRJEB36940	7480	316	1.761317	5.56576172	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	47.4	0.00182	NR	MCL4419489.1	2052139	g7351	i0	70.8	0.227848101265823	24	7	22.8	0	244	315	225	248	MCL4419489.1 hypothetical protein [Patescibacteria group bacterium]	diamond	72	47.4	1	Bacteria	Bacteria candidate phyla						Patescibacteria group 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);;