metadata: contig_metadata: 7 rows where bioproject = "PRJEB11523", tax_clade = "Bacteria candidate phyla" and tax

7 rows where bioproject = "PRJEB11523", tax_clade = "Bacteria candidate phyla" 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
27380603	27380603	PRJEB11523_P_NODE_6903_length_175_cov_1.214286_g6825_i0	PRJEB11523	6903	175	1.214286	2.1250005	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	115	2.26e-28	NR	MBP7806059.1	2044595	g6825	i0	91.2	2.89714285714286	57	5	97.7	0	3	173	357	413	MBP7806059.1 translation elongation factor 4 [Candidatus Altimarinota bacterium]	diamond	507	115	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
30822634	30822634	PRJEB11523_P_NODE_8194_length_163_cov_1.789474_g8116_i0	PRJEB11523	8194	163	1.789474	2.91684262	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	104	2.37e-24	NR	MBP7806059.1	2044595	g8116	i0	96.2	0.975460122699387	53	2	97.5	0	3	161	482	534	MBP7806059.1 translation elongation factor 4 [Candidatus Altimarinota bacterium]	diamond	159	104	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
31771073	31771073	PRJEB11523_P_NODE_4297_length_230_cov_1.408840_g4219_i0	PRJEB11523	4297	230	1.40884	3.240332	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	147	2.78e-39	NR	MBP7806059.1	2044595	g4219	i0	94.5	1.90434782608696	73	4	95.2	0	12	230	280	352	MBP7806059.1 translation elongation factor 4 [Candidatus Altimarinota bacterium]	diamond	438	147	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
31802573	31802573	PRJEB11523_P_NODE_8777_length_159_cov_3.027273_g8699_i0	PRJEB11523	8777	159	3.027273	4.81336407	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	107	2.53e-25	NR	MBP7806059.1	2044595	g8699	i0	98.1	1.9622641509434	52	1	98.1	0	157	2	424	475	MBP7806059.1 translation elongation factor 4 [Candidatus Altimarinota bacterium]	diamond	312	107	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
32113110	32113110	PRJEB11523_P_NODE_5678_length_195_cov_1.397260_g5600_i0	PRJEB11523	5678	195	1.39726	2.724657	Bacteria	2	Bacteria	Bacteria	107	5.36e-29	NR	MBP7823483.1	2044595	g5600	i0	89.5	2.63076923076923	57	6	87.7	0	172	2	1	57	MBP7823483.1 30S ribosomal protein S18 [Candidatus Altimarinota bacterium]	diamond	513	108	0.990740740740741	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
32277546	32277546	PRJEB11523_P_NODE_4099_length_236_cov_15.395722_g4021_i0	PRJEB11523	4099	236	15.395722	36.33390392	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	94.7	3.52e-22	NR	MBX9809192.1	2044595	g4021	i0	66.7	1.83050847457627	72	24	91.5	0	233	18	65	136	MBX9809192.1 Holliday junction branch migration protein RuvA [Candidatus Altimarinota bacterium]	diamond	432	94.7	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
32309314	32309314	PRJEB11523_P_NODE_1639_length_441_cov_23.500000_g1561_i0	PRJEB11523	1639	441	23.5	103.635	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	92.4	3.12e-19	NR	MCF7831017.1	2044595	g1561	i0	36.3	0.918367346938776	135	71	91.2	3	8	409	140	260	MCF7831017.1 pilin [Candidatus Altimarinota bacterium]	diamond	405	92.4	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);;