metadata: contig_metadata: 10 rows where bioproject = "PRJEB12237" and tax

10 rows where bioproject = "PRJEB12237" 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
11498730	11498730	PRJEB12237_P_NODE_710_length_851_cov_2.938725_g583_i0	PRJEB12237	710	851	2.938725	25.00854975	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	381	9.949999999999999e-129	NR	MCL4419852.1	2052139	g583	i0	80.6	0.835487661574618	237	46	83.5	0	3	713	165	401	MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium]	diamond	711	381	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
24246521	24246521	PRJEB12237_P_NODE_9340_length_176_cov_2.255319_g9144_i0	PRJEB12237	9340	176	2.255319	3.96936144	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	263	6.3e-66	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g9144	i0	94.706	53.0965909090909	170	8	96	1	1	169	221390	221559	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	9345	263	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
26621431	26621431	PRJEB12237_P_NODE_6221_length_233_cov_1.818182_g6025_i0	PRJEB12237	6221	233	1.818182	4.23636406	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	61.2	4.03e-9	NR	MEX0748959.1	2973664	g6025	i0	43	2.0343347639485	79	32	95.3	3	3	224	106	176	MEX0748959.1 phosphoribosylanthranilate isomerase [Candidatus Saccharimonadales bacterium]	diamond	474	61.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
26843331	26843331	PRJEB12237_P_NODE_7301_length_208_cov_1.387283_g7105_i0	PRJEB12237	7301	208	1.387283	2.88554864	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	99	1.72e-24	NR	MBT4936660.1	2030811	g7105	i0	63.8	0.995192307692308	69	25	99.5	0	207	1	68	136	MBT4936660.1 50S ribosomal protein L15 [Candidatus Peregrinibacteria bacterium]	diamond	207	99	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota					Candidatus Peregrinibacteria bacterium
27222419	27222419	PRJEB12237_P_NODE_1043_length_718_cov_3.155198_g889_i0	PRJEB12237	1043	718	3.155198	22.65432164	Candidatus Dependentiae bacterium	2030827	Bacteria	Bacteria	82	1.41e-14	NR	RTL06913.1	2030827	g889	i0	32.5	0.693593314763231	166	107	68.1	2	8	496	63	226	RTL06913.1 MAG: hypothetical protein EKK58_03715 [Candidatus Dependentiae bacterium]	diamond	498	82	1	Bacteria	Bacteria candidate phyla						Candidatus Babelota bacterium
29180600	29180600	PRJEB12237_P_NODE_11549_length_155_cov_0.975000_g11353_i0	PRJEB12237	11549	155	0.975	1.51125	Candidatus Wolfebacteria bacterium RIFCSPLOWO2_	2030812	Bacteria	Bacteria	52.4	4.46e-6	NR	OGM91087.1	1802557	g11353	i0	91.2	5.36129032258065	34	3	65.8	0	1	102	3089	3122	OGM91087.1 MAG: hypothetical protein A3A20_00660 [Candidatus Wolfebacteria bacterium RIFCSPLOWO2_01_FULL_45_19]	diamond	831	52.4	1	Bacteria	Bacteria candidate phyla	Candidatus Wolfeibacteriota					Candidatus Wolfebacteria bacterium RIFCSPLOWO2_01_FULL_45_19
31739554	31739554	PRJEB12237_P_NODE_10057_length_168_cov_1.203008_g9861_i0	PRJEB12237	10057	168	1.203008	2.02105344	Candidatus Babeliaceae bacterium	2545253	Bacteria	Bacteria	60.5	5.47e-9	NR	HVW99154.1	2545253	g9861	i0	70	0.714285714285714	40	12	71.4	0	165	46	225	264	HVW99154.1 reverse transcriptase domain-containing protein [Candidatus Babeliaceae bacterium]	diamond	120	60.5	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae		Candidatus Babeliaceae bacterium
32277794	32277794	PRJEB12237_P_NODE_4239_length_311_cov_3.583333_g4043_i0	PRJEB12237	4239	311	3.583333	11.14416563	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	135	1.0599999999999999e-34	NR	MCL4419431.1	2052139	g4043	i0	86.7	0.723472668810289	75	9	71.4	1	10	231	513	587	MCL4419431.1 hypothetical protein [Patescibacteria group bacterium]	diamond	225	135	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32562618	32562618	PRJEB12237_P_NODE_12059_length_151_cov_1.034483_g11863_i0	PRJEB12237	12059	151	1.034483	1.56206933	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	42.7	0.0065	NR	HEV8481238.1	2212470	g11863	i0	56.3	0.635761589403974	32	14	63.6	0	110	15	120	151	HEV8481238.1 DUF177 domain-containing protein [Candidatus Eiseniibacteriota bacterium]	diamond	96	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota bacterium
32593982	32593982	PRJEB12237_P_NODE_5600_length_251_cov_2.388889_g5404_i0	PRJEB12237	5600	251	2.388889	5.99611139	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	79.7	2.32e-17	NR	MDR3572201.1	2053589	g5404	i0	85.1	0.561752988047809	47	7	56.2	0	74	214	42	88	MDR3572201.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	141	79.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota 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);;