metadata: contig_metadata: 7 rows where bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Handelsmaniibacteriota"

7 rows where bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Handelsmaniibacteriota"

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
27059686	27059686	PRJNA1148190_P_NODE_775202_length_241_cov_1.488095_g764029_i0	PRJNA1148190	775202	241	1.488095	3.58630895	Bacillati	1783272	Bacteria	Bacteria	45.1	6.79e-4	NR	OGG48561.1	1817868	g764029	i0	65.5	2.27800829875519	29	10	36.1	0	189	103	45	73	OGG48561.1 MAG: hypothetical protein A3F84_24015 [Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10]	diamond	549	45.4	0.993392070484582	Bacteria	Bacteria candidate phyla	Candidatus Handelsmaniibacteriota	Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10
29092765	29092765	PRJNA1148190_P_NODE_633368_length_249_cov_0.875000_g622195_i0	PRJNA1148190	633368	249	0.875	2.17875	Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_1	2099671	Bacteria	Bacteria	122	1.71e-31	NR	OGG48686.1	1817868	g622195	i0	67.5	0.963855421686747	80	26	96.4	0	249	10	87	166	OGG48686.1 MAG: hypothetical protein A3F84_29500 [Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10]	diamond	240	122	1	Bacteria	Bacteria candidate phyla	Candidatus Handelsmaniibacteriota	Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10
29913385	29913385	PRJNA1148190_P_NODE_421131_length_282_cov_1.368421_g409958_i0	PRJNA1148190	421131	282	1.368421	3.85894722	Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_1	2099671	Bacteria	Bacteria	58.9	1.21e-7	NR	OGG57208.1	1817868	g409958	i0	50	0.468085106382979	44	22	46.8	0	274	143	596	639	OGG57208.1 MAG: hypothetical protein A3F84_17325 [Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10]	diamond	132	58.9	1	Bacteria	Bacteria candidate phyla	Candidatus Handelsmaniibacteriota	Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10
31399236	31399236	PRJNA1148190_P_NODE_91716_length_562_cov_1.875256_g80575_i0	PRJNA1148190	91716	562	1.875256	10.53893872	Candidatus Handelsmanbacteria bacterium	2099671	Bacteria	Bacteria	163	1.38e-44	NR	MBM3280955.1	2099671	g80575	i0	46.4	0.966192170818505	181	96	96.1	1	547	8	238	418	MBM3280955.1 DUF4055 domain-containing protein [Candidatus Handelsmanbacteria bacterium]	diamond	543	163	1	Bacteria	Bacteria candidate phyla	Candidatus Handelsmaniibacteriota	Candidatus Handelsmanbacteria bacterium
31746072	31746072	PRJNA1148190_P_NODE_331777_length_307_cov_1.500000_g320604_i0	PRJNA1148190	331777	307	1.5	4.605	Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_1	2099671	Bacteria	Bacteria	87.4	1.54e-17	NR	OGG44118.1	1817868	g320604	i0	48.9	0.899022801302932	92	47	89.9	0	3	278	157	248	OGG44118.1 MAG: hypothetical protein A3F84_27800 [Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10]	diamond	276	87.4	1	Bacteria	Bacteria candidate phyla	Candidatus Handelsmaniibacteriota	Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10
32683154	32683154	PRJNA1148190_P_NODE_456980_length_275_cov_1.301980_g445807_i0	PRJNA1148190	456980	275	1.30198	3.580445	Pseudomonadati	3379134	Bacteria	Bacteria	52	2.86e-5	NR	OGG57193.1	1817868	g445807	i0	49.2	3.54545454545455	59	30	64.4	0	271	95	300	358	OGG57193.1 MAG: chemotaxis response regulator protein-glutamate methylesterase [Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10]	diamond	975	52	1	Bacteria	Bacteria candidate phyla	Candidatus Handelsmaniibacteriota	Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10
32883360	32883360	PRJNA1148190_P_NODE_254200_length_341_cov_1.436567_g243030_i0	PRJNA1148190	254200	341	1.436567	4.89869347	Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_1	2099671	Bacteria	Bacteria	56.6	1.62e-6	NR	OGG44098.1	1817868	g243030	i0	33.3	0.950146627565982	108	62	94.1	3	13	333	1093	1191	OGG44098.1 MAG: phage portal protein [Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10]	diamond	324	56.6	1	Bacteria	Bacteria candidate phyla	Candidatus Handelsmaniibacteriota	Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10

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