metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA934472" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA934472" 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
15283448	15283448	PRJNA934472_P_NODE_27312_length_283_cov_1.123810_g26934_i0	PRJNA934472	27312	283	1.12381	3.1803823	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	161	3.43e-44	NR	HEY2154363.1	2691532	g26934	i0	79.6	3.9434628975265	93	19	98.6	0	3	281	143	235	HEY2154363.1 redoxin domain-containing protein [Isosphaeraceae bacterium]	diamond	1116	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
21313241	21313241	PRJNA934472_P_NODE_35297_length_251_cov_0.865169_g34919_i0	PRJNA934472	35297	251	0.865169	2.17157419	Planctomycetia	203683	Bacteria	Bacteria	146	2.63e-39	NR	OJW24469.1	1895807	g34919	i0	84.3	5.92828685258964	83	13	99.2	0	3	251	407	489	OJW24469.1 MAG: polynucleotide kinase-phosphatase, partial [Planctomycetales bacterium 71-10]	diamond	1488	146	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium 71-10
25137367	25137367	PRJNA934472_P_NODE_37060_length_246_cov_0.890173_g36682_i0	PRJNA934472	37060	246	0.890173	2.18982558	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	132	4.78e-35	NR	WZO95765.1	3139350	g36682	i0	80.5	1	82	16	100	0	1	246	34	115	WZO95765.1 phosphoglycerate kinase [Isosphaeraceae bacterium EP7]	diamond	246	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
26739645	26739645	PRJNA934472_P_NODE_37821_length_244_cov_0.900585_g37443_i0	PRJNA934472	37821	244	0.900585	2.1974274	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	131	8.84e-36	NR	MDX2037943.1	2691532	g37443	i0	76.3	2.95081967213115	80	19	98.4	0	242	3	36	115	MDX2037943.1 DedA family protein [Isosphaeraceae bacterium]	diamond	720	131	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
26866971	26866971	PRJNA934472_P_NODE_28621_length_277_cov_1.171569_g28243_i0	PRJNA934472	28621	277	1.171569	3.24524613	Gemmataceae bacterium	2052164	Bacteria	Bacteria	146	1.4e-38	NR	HEY7314674.1	2052164	g28243	i0	76.7	1.94945848375451	90	20	97.5	1	272	3	172	260	HEY7314674.1 amylo-alpha-1,6-glucosidase [Gemmataceae bacterium]	diamond	540	146	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
26961519	26961519	PRJNA934472_P_NODE_39902_length_229_cov_2.955128_g39524_i0	PRJNA934472	39902	229	2.955128	6.76724312	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	94.7	2.9300000000000004e-21	NR	HEX8200906.1	2691532	g39524	i0	59.5	2.96069868995633	74	29	96.9	1	2	223	176	248	HEX8200906.1 hypothetical protein [Isosphaeraceae bacterium]	diamond	678	94.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
28098785	28098785	PRJNA934472_P_NODE_12345_length_406_cov_1.297297_g11968_i0	PRJNA934472	12345	406	1.297297	5.26702582	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	51.2	2.32e-4	NR	HON93649.1	2813034	g11968	i0	36.8	0.923645320197044	125	74	90.1	4	366	1	86	208	HON93649.1 hypothetical protein [Sedimentisphaerales bacterium]	diamond	375	51.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
28162166	28162166	PRJNA934472_P_NODE_37665_length_244_cov_1.596491_g37287_i0	PRJNA934472	37665	244	1.596491	3.89543804	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	43.9	0.0143	NR	MCA9062209.1	2026779	g37287	i0	57.1	0.344262295081967	28	12	34.4	0	166	83	317	344	MCA9062209.1 alpha/beta fold hydrolase [Planctomycetaceae bacterium]	diamond	84	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29266909	29266909	PRJNA934472_P_NODE_21589_length_314_cov_1.879668_g21212_i0	PRJNA934472	21589	314	1.879668	5.90215752	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	102	1.05e-25	NR	MBV8077818.1	2026779	g21212	i0	73.1	0.640127388535032	67	17	64	1	202	2	1	66	MBV8077818.1 type II toxin-antitoxin system RelE/ParE family toxin [Planctomycetaceae bacterium]	diamond	201	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30088086	30088086	PRJNA934472_P_NODE_33532_length_257_cov_1.434783_g33154_i0	PRJNA934472	33532	257	1.434783	3.68739231	Gemmataceae bacterium	2052164	Bacteria	Bacteria	107	1.02e-24	NR	HXG08793.1	2052164	g33154	i0	65.1	1.93774319066148	83	29	96.9	0	8	256	346	428	HXG08793.1 asparagine synthase-related protein [Gemmataceae bacterium]	diamond	498	107	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31447083	31447083	PRJNA934472_P_NODE_33976_length_255_cov_2.241758_g33598_i0	PRJNA934472	33976	255	2.241758	5.7164829	Rhodopirellula sp. MGV	2023130	Bacteria	Bacteria	40.8	0.0442	NR	WP_094418739.1	2023130	g33598	i0	35.6	0.694117647058824	59	35	69.4	2	252	76	13	68	WP_094418739.1 hypothetical protein [Rhodopirellula sp. MGV]	diamond	177	40.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula sp. MGV
31605255	31605255	PRJNA934472_P_NODE_13416_length_390_cov_1.451104_g13039_i0	PRJNA934472	13416	390	1.451104	5.6593056	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	44.3	0.0493	NR	HUO07241.1	2026778	g13039	i0	50	0.353846153846154	46	20	35.4	3	193	330	292	334	HUO07241.1 radical SAM family heme chaperone HemW [Phycisphaerae bacterium]	diamond	138	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32617361	32617361	PRJNA934472_P_NODE_32880_length_259_cov_2.784946_g32502_i0	PRJNA934472	32880	259	2.784946	7.21301014	Lacipirellula sp.	2691419	Bacteria	Bacteria	151	3.04e-41	NR	HEX6960782.1	2691419	g32502	i0	77.6	1.96911196911197	85	19	98.5	0	3	257	14	98	HEX6960782.1 DUF6798 domain-containing protein [Lacipirellula sp.]	diamond	510	151	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula sp.

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