metadata: contig_metadata: 13 rows where bioproject = "PRJEB80557" and tax

13 rows where bioproject = "PRJEB80557" 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
11199754	11199754	PRJEB80557_S_NODE_17449_length_226_cov_1.457627_g17053_i0	PRJEB80557	17449	226	1.457627	3.29423702	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	90.1	1.78e-19	NR	HQY87905.1	2876886	g17053	i0	64.4	0.783185840707965	59	21	78.3	0	1	177	221	279	HQY87905.1 phosphatidate cytidylyltransferase [Tepidisphaeraceae bacterium]	diamond	177	90.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
15441564	15441564	PRJEB80557_S_NODE_24533_length_194_cov_1.068966_g24137_i0	PRJEB80557	24533	194	1.068966	2.07379404	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	125	8.429999999999998e-32	NR	HEV7281210.1	2699754	g24137	i0	95.3	0.989690721649485	64	3	99	0	3	194	327	390	HEV7281210.1 ribulose-phosphate 3-epimerase [Pirellulaceae bacterium]	diamond	192	125	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
16715764	16715764	PRJEB80557_S_NODE_19074_length_217_cov_1.535714_g18678_i0	PRJEB80557	19074	217	1.535714	3.33249938	Aquisphaera giovannonii	406548	Bacteria	Bacteria	307	3.7e-79	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g18678	i0	92.202	142.861751152074	218	15	100	2	1	217	9143890	9143674	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	31001	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
20540126	20540126	PRJEB80557_S_NODE_36497_length_163_cov_1.333333_g36101_i0	PRJEB80557	36497	163	1.333333	2.17333279	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	207	2.74e-49	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g36101	i0	90.625	14.4601226993865	160	10	96	4	1	157	1599306	1599149	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	2357	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
26590774	26590774	PRJEB80557_S_NODE_26341_length_188_cov_1.417266_g25945_i0	PRJEB80557	26341	188	1.417266	2.66446008	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	42	0.0341	NR	MCC7406532.1	2026777	g25945	i0	44.6	0.893617021276596	56	29	87.8	2	21	185	262	316	MCC7406532.1 hypothetical protein [Phycisphaeraceae bacterium]	diamond	168	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
27508398	27508398	PRJEB80557_S_NODE_25943_length_189_cov_1.835714_g25547_i0	PRJEB80557	25943	189	1.835714	3.46949946	Gimesia alba	2527973	Bacteria	Bacteria	47.4	4.37e-4	NR	WP_145218180.1	2527973	g25547	i0	37.3	0.936507936507937	59	36	92.1	1	13	186	456	514	WP_145218180.1 type IV secretory system conjugative DNA transfer family protein [Gimesia alba]	diamond	177	47.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia alba
27571359	27571359	PRJEB80557_S_NODE_18564_length_220_cov_0.912281_g18168_i0	PRJEB80557	18564	220	0.912281	2.0070182	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	94.4	3.2200000000000003e-21	NR	HKM56288.1	2691532	g18168	i0	58.3	4.90909090909091	72	30	98.2	0	217	2	37	108	HKM56288.1 hypothetical protein [Isosphaeraceae bacterium]	diamond	1080	94.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
27761139	27761139	PRJEB80557_S_NODE_26924_length_186_cov_1.335766_g26528_i0	PRJEB80557	26924	186	1.335766	2.48452476	Planctomycetia bacterium	2052181	Bacteria	Bacteria	42.4	0.00925	NR	NHZ84603.1	2052181	g26528	i0	60.7	0.451612903225806	28	11	45.2	0	181	98	53	80	NHZ84603.1 hypothetical protein [Planctomycetia bacterium]	diamond	84	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
27887041	27887041	PRJEB80557_S_NODE_10285_length_285_cov_2.309322_g9889_i0	PRJEB80557	10285	285	2.309322	6.5815677	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	128	2.89e-33	NR	MCA8983503.1	2026779	g9889	i0	92.8	2.17894736842105	69	5	72.6	0	23	229	178	246	MCA8983503.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	621	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30128726	30128726	PRJEB80557_S_NODE_4012_length_418_cov_1.685637_g3616_i0	PRJEB80557	4012	418	1.685637	7.04596266	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	108	1.79e-25	NR	MFO1094496.1	2026779	g3616	i0	64	0.638755980861244	89	32	63.9	0	18	284	207	295	MFO1094496.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	267	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31013679	31013679	PRJEB80557_S_NODE_15255_length_240_cov_1.319372_g14859_i0	PRJEB80557	15255	240	1.319372	3.1664928	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	89	8.87e-19	NR	HYF15161.1	2052180	g14859	i0	59.5	0.9875	79	32	98.8	0	238	2	269	347	HYF15161.1 M20/M25/M40 family metallo-hydrolase [Phycisphaerales bacterium]	diamond	237	89	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31361576	31361576	PRJEB80557_S_NODE_14176_length_248_cov_1.557789_g13780_i0	PRJEB80557	14176	248	1.557789	3.86331672	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	136	1.48e-35	NR	HEV7281210.1	2699754	g13780	i0	87.5	0.967741935483871	80	10	96.8	0	9	248	255	334	HEV7281210.1 ribulose-phosphate 3-epimerase [Pirellulaceae bacterium]	diamond	240	136	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
31519737	31519737	PRJEB80557_S_NODE_20676_length_209_cov_1.581250_g20280_i0	PRJEB80557	20676	209	1.58125	3.3048125	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.0095	NR	MCE9555703.1	2026780	g20280	i0	85.7	0.301435406698565	21	3	30.1	0	186	124	955	975	MCE9555703.1 N-6 DNA methylase [Planctomycetota bacterium]	diamond	63	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;