metadata: contig_metadata: 15 rows where bioproject = "PRJEB11523" and tax

15 rows where bioproject = "PRJEB11523" and tax_phylum = "Candidatus Nomuraibacteriota"

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
11491744	11491744	PRJEB11523_P_NODE_670_length_738_cov_37.985486_g607_i0	PRJEB11523	670	738	37.985486	280.33288668	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	876	0	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g607	i0	89.971	0.91869918699187	678	68	92	0	36	713	74085	74762	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	678	876	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
16590636	16590636	PRJEB11523_P_NODE_6834_length_175_cov_14.142857_g6756_i0	PRJEB11523	6834	175	14.142857	24.74999975	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	228	2.2799999999999996e-55	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g6756	i0	93.464	49.5828571428571	153	10	87	0	23	175	964795	964643	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	8677	228	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
17865527	17865527	PRJEB11523_P_NODE_6915_length_174_cov_15.312000_g6837_i0	PRJEB11523	6915	174	15.312	26.64288	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	202	1.3699999999999998e-47	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g6837	i0	90.728	0.867816091954023	151	14	87	0	3	153	163970	164120	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	151	202	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
24239625	24239625	PRJEB11523_P_NODE_2060_length_378_cov_5.650456_g1982_i0	PRJEB11523	2060	378	5.650456	21.35872368	Bacteria	2	Bacteria	Bacteria	121	3.98e-29	NR	OGI88118.1	1801776	g1982	i0	87.9	4.54761904761905	66	8	52.4	0	149	346	3	68	OGI88118.1 MAG: elongation factor 4 [Candidatus Nomurabacteria bacterium RIFCSPLOWO2_01_FULL_41_21]	diamond	1719	122	0.991803278688525	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFCSPLOWO2_01_FULL_41_21
27127138	27127138	PRJEB11523_P_NODE_2402_length_339_cov_45.903448_g2324_i0	PRJEB11523	2402	339	45.903448	155.61268872	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	158	1.31e-45	NR	MCX6753849.1	2052152	g2324	i0	73.8	0.911504424778761	103	27	91.2	0	6	314	13	115	MCX6753849.1 prepilin peptidase [Candidatus Nomurabacteria bacterium]	diamond	309	158	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
27506925	27506925	PRJEB11523_P_NODE_1683_length_433_cov_3.085938_g1605_i0	PRJEB11523	1683	433	3.085938	13.36211154	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	162	2.9299999999999993e-43	NR	USN97565.1	2052152	g1605	i0	60.1	0.956120092378753	138	50	94.9	3	430	20	506	639	USN97565.1 MAG: hypothetical protein H6799_00445 [Candidatus Nomurabacteria bacterium]	diamond	414	162	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
27563488	27563488	PRJEB11523_P_NODE_2384_length_341_cov_4.332192_g2306_i0	PRJEB11523	2384	341	4.332192	14.77277472	Bacteria	2	Bacteria	Bacteria	159	4.82e-48	NR	OGI47002.1	1801727	g2306	i0	67.9	2.80645161290323	106	34	93.3	0	322	5	1	106	OGI47002.1 MAG: mannose-6-phosphate isomerase [Candidatus Nomurabacteria bacterium GWB1_40_6]	diamond	957	160	0.99375	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium GWB1_40_6
28169778	28169778	PRJEB11523_P_NODE_586_length_790_cov_11.012146_g524_i0	PRJEB11523	586	790	11.012146	86.9959534	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	115	5.58e-28	NR	MDB5254802.1	2052152	g524	i0	47.5	0.934177215189873	118	62	44.8	0	46	399	33	150	MDB5254802.1 protein of unknown function with transrane region [Candidatus Nomurabacteria bacterium]	diamond	738	115	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
28895852	28895852	PRJEB11523_P_NODE_5128_length_206_cov_9.242038_g5050_i0	PRJEB11523	5128	206	9.242038	19.03859828	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	132	7.729999999999999e-38	NR	MCC6323321.1	2052152	g5050	i0	94	0.975728155339806	67	4	97.6	0	202	2	69	135	MCC6323321.1 50S ribosomal protein L16 [Candidatus Nomurabacteria bacterium]	diamond	201	132	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
29047874	29047874	PRJEB11523_P_NODE_8608_length_161_cov_1.321429_g8530_i0	PRJEB11523	8608	161	1.321429	2.12750069	Bacteria	2	Bacteria	Bacteria	95.1	1.6e-21	NR	MBI2631123.1	2052152	g8530	i0	81.1	9.85714285714286	53	10	98.8	0	159	1	228	280	MBI2631123.1 DNA polymerase III subunit beta [Candidatus Nomurabacteria bacterium]	diamond	1587	95.9	0.991657977059437	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
29805434	29805434	PRJEB11523_P_NODE_2151_length_367_cov_3.103774_g2073_i0	PRJEB11523	2151	367	3.103774	11.39085058	Bacteria	2	Bacteria	Bacteria	82.8	1.01e-15	NR	HCC06264.1	2052152	g2073	i0	92.5	0.670299727520436	40	3	32.7	0	356	237	363	402	HCC06264.1 hypothetical protein [Candidatus Nomurabacteria bacterium]	diamond	246	83.6	0.990430622009569	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
29874904	29874904	PRJEB11523_P_NODE_5551_length_197_cov_6.114865_g5473_i0	PRJEB11523	5551	197	6.114865	12.04628405	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	81.3	3.84e-18	NR	MBI3305994.1	2052152	g5473	i0	88.1	1.27918781725888	42	5	64	0	46	171	58	99	MBI3305994.1 winged helix-turn-helix transcriptional regulator [Candidatus Nomurabacteria bacterium]	diamond	252	81.3	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
31391721	31391721	PRJEB11523_P_NODE_836_length_659_cov_26.849180_g765_i0	PRJEB11523	836	659	26.84918	176.9360962	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	238	4.33e-75	NR	MCX6754458.1	2052152	g765	i0	60.2	1.77541729893778	196	74	88.8	2	75	659	1	193	MCX6754458.1 alpha-1,2-fucosyltransferase [Candidatus Nomurabacteria bacterium]	diamond	1170	238	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
31423160	31423160	PRJEB11523_P_NODE_1636_length_442_cov_25.829517_g1558_i0	PRJEB11523	1636	442	25.829517	114.16646514	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	116	2.79e-29	NR	MBI2627485.1	2052152	g1558	i0	62.2	1.65610859728507	82	31	55.7	0	174	419	2	83	MBI2627485.1 transposase [Candidatus Nomurabacteria bacterium]	diamond	732	116	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
32049669	32049669	PRJEB11523_P_NODE_3198_length_278_cov_19.506550_g3120_i0	PRJEB11523	3198	278	19.50655	54.228209	Bacteria	2	Bacteria	Bacteria	114	2.27e-28	NR	OGJ14388.1	1801811	g3120	i0	66.7	2.71942446043165	84	26	90.6	1	27	278	147	228	OGJ14388.1 MAG: D-alanine--D-alanine ligase A [Candidatus Nomurabacteria bacterium RIFOXYD1_FULL_42_14]	diamond	756	114	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFOXYD1_FULL_42_14

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);;