metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJEB12237" and tax

8 rows where analysis = "diamond", bioproject = "PRJEB12237" and tax_phylum = "Planctomycetota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
11498729	11498729	PRJEB12237_P_NODE_6970_length_215_cov_1.777778_g6774_i0	PRJEB12237	6970	215	1.777778	3.8222227	Gemmataceae	1914233	Bacteria	Bacteria	130	1.93e-36	NR	HEY1188054.1	1914242	g6774	i0	84.5	11.8883720930233	71	11	99.1	0	215	3	80	150	HEY1188054.1 peptidylprolyl isomerase [Gemmata sp.]	diamond	2556	131	0.99236641221374	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp.
12774283	12774283	PRJEB12237_P_NODE_2151_length_485_cov_1.415556_g1962_i0	PRJEB12237	2151	485	1.415556	6.8654466	Bacteria	2	Bacteria	Bacteria	166	3.42e-45	NR	MBA3846121.1	2026780	g1962	i0	67.8	1.42268041237113	115	37	71.1	0	1	345	433	547	MBA3846121.1 glucose-6-phosphate isomerase [Planctomycetota bacterium]	diamond	690	166	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28801350	28801350	PRJEB12237_P_NODE_7408_length_205_cov_2.652941_g7212_i0	PRJEB12237	7408	205	2.652941	5.43852905	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.5	0.0125	NR	MAB79605.1	2026780	g7212	i0	43.9	1.68292682926829	57	29	83.4	1	177	7	94	147	MAB79605.1 hypothetical protein [Planctomycetota bacterium]	diamond	345	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31265314	31265314	PRJEB12237_P_NODE_10515_length_163_cov_1.875000_g10319_i0	PRJEB12237	10515	163	1.875	3.05625	Gemmata algarum	2975278	Bacteria	Bacteria	67.4	1.11e-11	NR	WP_320685713.1	2975278	g10319	i0	72.7	0.809815950920245	44	12	81	0	134	3	113	156	WP_320685713.1 glucose 1-dehydrogenase [Gemmata algarum]	diamond	132	67.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata algarum
31486913	31486913	PRJEB12237_P_NODE_4656_length_290_cov_1.113725_g4460_i0	PRJEB12237	4656	290	1.113725	3.2298025	Gemmataceae bacterium	2052164	Bacteria	Bacteria	56.2	1.18e-6	NR	MCI0456322.1	2052164	g4460	i0	53.6	0.579310344827586	56	25	57.9	1	265	98	613	667	MCI0456322.1 choice-of-anchor E domain-containing protein [Gemmataceae bacterium]	diamond	168	56.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31543736	31543736	PRJEB12237_P_NODE_4696_length_288_cov_1.173913_g4500_i0	PRJEB12237	4696	288	1.173913	3.38086944	Pseudomonadati	3379134	Bacteria	Bacteria	117	2.7699999999999997e-30	NR	MBN9117911.1	2026780	g4500	i0	65.3	3.95833333333333	95	33	99	0	286	2	17	111	MBN9117911.1 glucose 1-dehydrogenase [Planctomycetota bacterium]	diamond	1140	118	0.991525423728814	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31897887	31897887	PRJEB12237_P_NODE_3877_length_330_cov_1.149153_g3681_i0	PRJEB12237	3877	330	1.149153	3.7922049	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	50.1	2.83e-4	NR	HHM12983.1	2026779	g3681	i0	39.2	2.05454545454545	74	35	67.3	2	225	4	659	722	HHM12983.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	678	50.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32056056	32056056	PRJEB12237_P_NODE_7298_length_208_cov_1.387283_g7102_i0	PRJEB12237	7298	208	1.387283	2.88554864	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	46.2	0.00133	NR	MBX3315538.1	2026777	g7102	i0	45.8	0.850961538461538	59	26	80.8	2	194	27	268	323	MBX3315538.1 choice-of-anchor A family protein [Phycisphaeraceae bacterium]	diamond	177	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;