metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1226487" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1226487" and tax_phylum = "Cyanobacteriota"

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
10538772	10538772	PRJNA1226487_P_NODE_269_length_1443_cov_16.469343_g234_i0	PRJNA1226487	269	1443	16.469343	237.65261949	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	295	1.29e-94	NR	WP_190487424.1	2692827	g234	i0	82.9	0.461538461538462	222	15	41.4	1	1285	689	1	222	WP_190487424.1 hypothetical protein [Microcoleus sp. FACHB-831]	diamond	666	295	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831
27154300	27154300	PRJNA1226487_P_NODE_52262_length_269_cov_1.571429_g52160_i0	PRJNA1226487	52262	269	1.571429	4.22714401	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	105	5.13e-24	NR	WP_094533621.1	1980935	g52160	i0	55.2	2.82156133828996	87	39	97	0	264	4	407	493	WP_094533621.1 glycosyltransferase [Pseudanabaena sp. SR411]	diamond	759	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. SR411
28525667	28525667	PRJNA1226487_P_NODE_64447_length_251_cov_0.865169_g64345_i0	PRJNA1226487	64447	251	0.865169	2.17157419	Myxacorys chilensis	2594884	Bacteria	Bacteria	171	3.66e-49	NR	MBW4542269.1	1601998	g64345	i0	97.6	0.99203187250996006	83	2	99.2	0	1	249	153	235	MBW4542269.1 IctB family putative bicarbonate transporter [Myxacorys chilensis ATA2-1-KO14]	diamond	249	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Myxacorys	Myxacorys chilensis
28777942	28777942	PRJNA1226487_P_NODE_2087_length_744_cov_4.038748_g2000_i0	PRJNA1226487	2087	744	4.038748	30.04828512	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	464	5.17e-147	NR	WP_190484093.1	2692827	g2000	i0	90.2	1.98387096774194	246	24	99.2	0	740	3	1567	1812	WP_190484093.1 PAS domain S-box protein [Microcoleus sp. FACHB-831]	diamond	1476	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831
29870363	29870363	PRJNA1226487_P_NODE_16891_length_379_cov_7.192810_g16789_i0	PRJNA1226487	16891	379	7.19281	27.2607499	Bacteria	2	Bacteria	Bacteria	105	1.1199999999999999e-23	NR	WP_002806085.1	1219	g16789	i0	60.5	10.9630606860158	81	31	63.3	1	374	135	405	485	WP_002806085.1 PLP-dependent transferase [Prochlorococcus marinus]	diamond	4155	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
30344835	30344835	PRJNA1226487_P_NODE_25232_length_335_cov_15.206107_g25130_i0	PRJNA1226487	25232	335	15.206107	50.94045845	Planktothrix	54304	Bacteria	Bacteria	107	5.0399999999999995e-25	NR	MBS1994928.1	2807731	g25130	i0	56.1	1.60298507462687	82	36	73.4	0	247	2	54	135	MBS1994928.1 patatin-like phospholipase family protein [Cyanobacteria bacterium SZAS LIN-2]	diamond	537	108	0.990740740740741	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-2
31969248	31969248	PRJNA1226487_P_NODE_52578_length_268_cov_5.558974_g52476_i0	PRJNA1226487	52578	268	5.558974	14.89805032	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	45.4	0.00545	NR	MBX9691382.1	2847862	g52476	i0	51.3	0.436567164179104	39	19	43.7	0	151	35	1	39	MBX9691382.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	117	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32412426	32412426	PRJNA1226487_P_NODE_14579_length_397_cov_4.074074_g14477_i0	PRJNA1226487	14579	397	4.074074	16.17407378	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	228	3.46e-66	NR	WP_190484093.1	2692827	g14477	i0	93.8	0.982367758186398	130	8	98.2	0	395	6	1801	1930	WP_190484093.1 PAS domain S-box protein [Microcoleus sp. FACHB-831]	diamond	390	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831
32633214	32633214	PRJNA1226487_P_NODE_540_length_1166_cov_4.419945_g490_i0	PRJNA1226487	540	1166	4.419945	51.5365587	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	399	2.46e-135	NR	WP_190490872.1	2692827	g490	i0	92	0.576329331046312	224	18	57.6	0	676	5	1	224	WP_190490872.1 DUF2382 domain-containing protein [Microcoleus sp. FACHB-831]	diamond	672	399	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831

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