metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA293022" and tax_clade = "Cyanobacteriota/Melainabacteria group"

6 rows where analysis = "diamond", bioproject = "PRJNA293022" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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
26599048	26599048	PRJNA293022_P_NODE_48721_length_200_cov_1.000000_g47984_i0	PRJNA293022	48721	200	1	2	Microcystis sp. 53602_E8	2904984	Bacteria	Bacteria	56.6	2.7e-7	NR	MCE2664493.1	2904984	g47984	i0	53.5	0.645	43	20	64.5	0	1	129	756	798	MCE2664493.1 hypothetical protein [Microcystis sp. 53602_E8]	diamond	129	56.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. 53602_E8
27769420	27769420	PRJNA293022_P_NODE_74084_length_165_cov_0.896552_g73347_i0	PRJNA293022	74084	165	0.896552	1.4793108	Candidatus Synechococcus calcipolaris	1522304	Bacteria	Bacteria	84.3	4.25e-18	NR	WP_277865483.1	1522304	g73347	i0	75.9	0.981818181818182	54	13	98.2	0	162	1	89	142	WP_277865483.1 formyltransferase family protein [Candidatus Synechococcus calcipolaris]	diamond	162	84.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Candidatus Synechococcus calcipolaris
27990292	27990292	PRJNA293022_P_NODE_63525_length_174_cov_1.536000_g62788_i0	PRJNA293022	63525	174	1.536	2.67264	Planktothrix serta	1678310	Bacteria	Bacteria	42	0.0214	NR	WP_083625296.1	1678310	g62788	i0	50	0.586206896551724	34	17	58.6	0	133	32	35	68	WP_083625296.1 Uma2 family endonuclease [Planktothrix serta]	diamond	102	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix serta
30516512	30516512	PRJNA293022_P_NODE_52153_length_193_cov_1.326389_g51416_i0	PRJNA293022	52153	193	1.326389	2.55993077	Microcoleus sp. Co-bin12	2769070	Bacteria	Bacteria	59.3	7.26e-10	NR	MBD0342798.1	2769070	g51416	i0	45.2	0.963730569948187	62	34	96.4	0	7	192	2	63	MBD0342798.1 hypothetical protein [Microcoleus sp. Co-bin12]	diamond	186	59.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. Co-bin12
30990614	30990614	PRJNA293022_P_NODE_79114_length_162_cov_0.920354_g78377_i0	PRJNA293022	79114	162	0.920354	1.49097348	candidate division WOR-1 bacterium RIFOXYA2_FULL_41_14	1802574	Bacteria	Bacteria	42.7	0.00516	NR	OGC23231.1	1802574	g78377	i0	53.7	3.01851851851852	41	18	75.9	1	125	3	1	40	OGC23231.1 MAG: 30S ribosomal protein S12 [candidate division WOR-1 bacterium RIFOXYA2_FULL_41_14]	diamond	489	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati						candidate division WOR-1 bacterium RIFOXYA2_FULL_41_14
31229030	31229030	PRJNA293022_P_NODE_48175_length_201_cov_1.289474_g47438_i0	PRJNA293022	48175	201	1.289474	2.59184274	Cyanophyceae	3028117	Bacteria	Bacteria	65.1	2.72e-10	NR	WP_019499601.1	118173	g47438	i0	44.6	4.82089552238806	65	36	97	0	200	6	298	362	WP_019499601.1 fatty acid desaturase [Pseudanabaena sp. PCC 6802]	diamond	969	65.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. PCC 6802

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