metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJEB29441" and tax

12 rows where analysis = "diamond", bioproject = "PRJEB29441" 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
21703072	21703072	PRJEB29441_P_NODE_17918_length_254_cov_1.482927_g17477_i0	PRJEB29441	17918	254	1.482927	3.76663458	Bacteria	2	Bacteria	Bacteria	148	3.61e-44	NR	MBM4098314.1	2026780	g17477	i0	92.9	12.8976377952756	84	6	99.2	0	253	2	37	120	MBM4098314.1 phosphoglycerate kinase [Planctomycetota bacterium]	diamond	3276	149	0.993288590604027	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
21703525	21703525	PRJEB29441_P_NODE_45418_length_162_cov_0.902655_g44977_i0	PRJEB29441	45418	162	0.902655	1.4623011	Singulisphaera sp. GP187	1882752	Bacteria	Bacteria	73.9	3.15e-15	NR	WP_074309795.1	1882752	g44977	i0	84.4	2.5	45	7	83.3	0	136	2	1	45	WP_074309795.1 50S ribosomal protein L18 [Singulisphaera sp. GP187]	diamond	405	73.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. GP187
26805134	26805134	PRJEB29441_P_NODE_41721_length_165_cov_0.879310_g41280_i0	PRJEB29441	41721	165	0.87931	1.4508615	Pseudomonadati	3379134	Bacteria	Bacteria	45.8	0.00108	NR	MDP7348638.1	2026777	g41280	i0	50	3.47272727272727	46	23	83.6	0	1	138	97	142	MDP7348638.1 cation:proton antiporter [Phycisphaeraceae bacterium]	diamond	573	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
28580870	28580870	PRJEB29441_P_NODE_33427_length_181_cov_1.469697_g32986_i0	PRJEB29441	33427	181	1.469697	2.66015157	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	61.2	4.75e-9	NR	MCO6455093.1	2699754	g32986	i0	55.6	1.04419889502762	63	23	97.8	2	3	179	1431	1492	MCO6455093.1 choice-of-anchor D domain-containing protein [Pirellulaceae bacterium]	diamond	189	61.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
28801585	28801585	PRJEB29441_P_NODE_41608_length_165_cov_0.879310_g41167_i0	PRJEB29441	41608	165	0.87931	1.4508615	Pirellulales bacterium	2715253	Bacteria	Bacteria	63.9	4.38e-10	NR	MEX2317847.1	2715253	g41167	i0	54.5	1	55	25	100	0	1	165	172	226	MEX2317847.1 glycosyltransferase family 39 protein [Pirellulales bacterium]	diamond	165	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
29811997	29811997	PRJEB29441_P_NODE_47631_length_161_cov_0.901786_g47190_i0	PRJEB29441	47631	161	0.901786	1.45187546	Planctomycetia bacterium	2052181	Bacteria	Bacteria	48.1	1.52e-4	NR	MBL8824214.1	2052181	g47190	i0	47.2	0.987577639751553	53	27	98.8	1	2	160	209	260	MBL8824214.1 hypothetical protein [Planctomycetia bacterium]	diamond	159	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
29907033	29907033	PRJEB29441_P_NODE_42971_length_164_cov_0.886957_g42530_i0	PRJEB29441	42971	164	0.886957	1.45460948	Pirellulales bacterium	2715253	Bacteria	Bacteria	105	7.38e-25	NR	MFO0921869.1	2715253	g42530	i0	100	0.98780487804878	54	0	98.8	0	162	1	250	303	MFO0921869.1 Gldg family protein [Pirellulales bacterium]	diamond	162	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30286442	30286442	PRJEB29441_P_NODE_45432_length_162_cov_0.902655_g44991_i0	PRJEB29441	45432	162	0.902655	1.4623011	Planctomycetota bacterium	2026780	Bacteria	Bacteria	40.8	0.0444	NR	MEO1619295.1	2026780	g44991	i0	33.3	0.944444444444444	51	34	94.4	0	156	4	81	131	MEO1619295.1 hypothetical protein [Planctomycetota bacterium]	diamond	153	40.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30823132	30823132	PRJEB29441_P_NODE_42954_length_164_cov_0.886957_g42513_i0	PRJEB29441	42954	164	0.886957	1.45460948	Planctomycetota bacterium	2026780	Bacteria	Bacteria	77.8	5.55e-15	NR	MCK4958412.1	2026780	g42513	i0	71.4	2.6890243902439	49	14	89.6	0	2	148	1	49	MCK4958412.1 hypothetical protein [Planctomycetota bacterium]	diamond	441	77.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31138766	31138766	PRJEB29441_P_NODE_33775_length_180_cov_1.450382_g33334_i0	PRJEB29441	33775	180	1.450382	2.6106876	Gemmataceae bacterium	2052164	Bacteria	Bacteria	97.8	1.78e-22	NR	MFO0936440.1	2052164	g33334	i0	71.2	0.983333333333333	59	17	98.3	0	179	3	247	305	MFO0936440.1 Ldh family oxidoreductase [Gemmataceae bacterium]	diamond	177	97.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31575477	31575477	PRJEB29441_P_NODE_47176_length_161_cov_0.910714_g46735_i0	PRJEB29441	47176	161	0.910714	1.46624954	Pirellula	123	Bacteria	Bacteria	72.4	7.38e-14	NR	MCE2753777.1	117	g46735	i0	67.3	3.83850931677019	52	17	96.9	0	156	1	93	144	MCE2753777.1 transposase [Pirellula sp.]	diamond	618	72.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
32024767	32024767	PRJEB29441_P_NODE_27838_length_199_cov_1.093333_g27397_i0	PRJEB29441	27838	199	1.093333	2.17573267	Neorhodopirellula lusitana	445327	Bacteria	Bacteria	42	0.0383	NR	WP_283435201.1	445327	g27397	i0	35.6	0.889447236180904	59	31	82.9	2	170	6	395	450	WP_283435201.1 ArnT family glycosyltransferase [Neorhodopirellula lusitana]	diamond	177	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Neorhodopirellula	Neorhodopirellula lusitana

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