metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA613025" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA613025" 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
29272018	29272018	PRJNA613025_S_NODE_15189_length_276_cov_1.678414_g15035_i0	PRJNA613025	15189	276	1.678414	4.63242264	Bacteria	2	Bacteria	Bacteria	44.3	0.0158	NR	PHX78409.1	2026779	g15035	i0	64	1.08695652173913	25	9	27.2	0	92	18	547	571	PHX78409.1 MAG: hypothetical protein CK544_02960 [Planctomycetaceae bacterium]	diamond	300	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29953927	29953927	PRJNA613025_S_NODE_17811_length_241_cov_1.328125_g17657_i0	PRJNA613025	17811	241	1.328125	3.20078125	Rhodopirellula sp. TMED11	1986614	Bacteria	Bacteria	122	5.399999999999999e-31	NR	OUT58717.1	1986614	g17657	i0	74.7	0.983402489626556	79	20	98.3	0	3	239	366	444	OUT58717.1 MAG: adenosylhomocysteinase [Rhodopirellula sp. TMED11]	diamond	237	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula sp. TMED11
30491065	30491065	PRJNA613025_S_NODE_29513_length_169_cov_1.133333_g29359_i0	PRJNA613025	29513	169	1.133333	1.91533277	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	72	6.58e-13	NR	HMN42288.1	2052180	g29359	i0	60.7	0.994082840236686	56	21	99.4	1	169	2	1362	1416	HMN42288.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium]	diamond	168	72	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30522555	30522555	PRJNA613025_S_NODE_20053_length_219_cov_2.147059_g19899_i0	PRJNA613025	20053	219	2.147059	4.70205921	Limnoglobus roseus	2598579	Bacteria	Bacteria	63.5	1.3e-9	NR	WP_149113609.1	2598579	g19899	i0	49.2	0.89041095890411	65	27	89	3	195	1	799	857	WP_149113609.1 FAD-binding protein [Limnoglobus roseus]	diamond	195	63.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
30996606	30996606	PRJNA613025_S_NODE_26294_length_182_cov_1.360902_g26140_i0	PRJNA613025	26294	182	1.360902	2.47684164	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	63.2	1.02e-9	NR	NUQ35036.1	2026779	g26140	i0	63	1.63186813186813	46	17	75.8	0	180	43	118	163	NUQ35036.1 adenosylhomocysteinase [Planctomycetaceae bacterium]	diamond	297	63.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31375979	31375979	PRJNA613025_S_NODE_16356_length_258_cov_2.234450_g16202_i0	PRJNA613025	16356	258	2.23445	5.764881	Planctomycetia bacterium	2052181	Bacteria	Bacteria	161	2.3099999999999994e-48	NR	NCX99838.1	2052181	g16202	i0	98.8	0.988372093023256	85	1	98.8	0	257	3	92	176	NCX99838.1 TetR family transcriptional regulator [Planctomycetia bacterium]	diamond	255	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
31534213	31534213	PRJNA613025_S_NODE_33776_length_161_cov_0.910714_g33622_i0	PRJNA613025	33776	161	0.910714	1.46624954	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	55.5	3.94e-7	NR	MFQ5463581.1	2026778	g33622	i0	71.9	0.596273291925466	32	9	59.6	0	14	109	325	356	MFQ5463581.1 hypothetical protein [Phycisphaerae bacterium]	diamond	96	55.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31945061	31945061	PRJNA613025_S_NODE_23817_length_195_cov_0.972603_g23663_i0	PRJNA613025	23817	195	0.972603	1.89657585	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.2	0.0438	NR	NBU73603.1	2026780	g23663	i0	46.5	0.661538461538462	43	23	66.2	0	44	172	49	91	NBU73603.1 DUF1080 domain-containing protein [Planctomycetota bacterium]	diamond	129	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31945066	31945066	PRJNA613025_S_NODE_27077_length_178_cov_9.372093_g26923_i0	PRJNA613025	27077	178	9.372093	16.68232554	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0159	NR	MCZ7647757.1	2026780	g26923	i0	56.3	0.539325842696629	32	14	53.9	0	52	147	70	101	MCZ7647757.1 ThuA domain-containing protein [Planctomycetota bacterium]	diamond	96	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32356832	32356832	PRJNA613025_S_NODE_17979_length_239_cov_1.505263_g17825_i0	PRJNA613025	17979	239	1.505263	3.59757857	Rubripirellula tenax	2528015	Bacteria	Bacteria	81.3	9.7e-16	NR	WP_146456240.1	2528015	g17825	i0	55.6	0.903765690376569	72	32	90.4	0	218	3	415	486	WP_146456240.1 FAD-binding protein [Rubripirellula tenax]	diamond	216	81.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rubripirellula	Rubripirellula tenax

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