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

5 rows where analysis = "diamond", bioproject = "PRJNA385064" 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
27075164	27075164	PRJNA385064_P_NODE_6882_length_166_cov_0.871795_g6757_i0	PRJNA385064	6882	166	0.871795	1.4471797	Aliterella atlantica	1827278	Bacteria	Bacteria	65.9	8.74e-11	NR	WP_045053116.1	1827278	g6757	i0	87.5	0.578313253012048	32	4	57.8	0	71	166	1	32	WP_045053116.1 DUF58 domain-containing protein [Aliterella atlantica]	diamond	96	65.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
27707423	27707423	PRJNA385064_P_NODE_7524_length_163_cov_0.894737_g7399_i0	PRJNA385064	7524	163	0.894737	1.45842131	Leptolyngbyaceae cyanobacterium CSU_1_3	2720410	Bacteria	Bacteria	89	5.22e-20	NR	NJR50816.1	2720410	g7399	i0	71.7	0.975460122699387	53	15	97.5	0	159	1	67	119	NJR50816.1 alpha/beta fold hydrolase [Leptolyngbyaceae cyanobacterium CSU_1_3]	diamond	159	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium CSU_1_3
28464906	28464906	PRJNA385064_P_NODE_5666_length_179_cov_1.176923_g5541_i0	PRJNA385064	5666	179	1.176923	2.10669217	Phormidium willei BDU 13	399100	Bacteria	Bacteria	45.1	2.37e-4	NR	OAB59517.1	399101	g5541	i0	56.8	0.737430167597765	44	15	73.7	1	142	11	3	42	OAB59517.1 hypothetical protein AY600_16280 [Phormidium willei BDU 130791]	diamond	132	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium willei
32336927	32336927	PRJNA385064_P_NODE_8159_length_161_cov_0.910714_g8034_i0	PRJNA385064	8159	161	0.910714	1.46624954	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	61.6	3.88e-11	NR	WP_334821452.1	1180	g8034	i0	70	1.47204968944099	40	12	74.5	0	6	125	4	43	WP_334821452.1 tetratricopeptide repeat protein [Nostoc sp.]	diamond	237	61.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
32793060	32793060	PRJNA385064_P_NODE_6620_length_167_cov_0.864407_g6495_i0	PRJNA385064	6620	167	0.864407	1.44355969	Aliterella atlantica	1827278	Bacteria	Bacteria	103	3.12e-25	NR	WP_045057091.1	1827278	g6495	i0	96.2	0.934131736526946	52	2	93.4	0	11	166	120	171	WP_045057091.1 CPBP family intramembrane glutamic endopeptidase [Aliterella atlantica]	diamond	156	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica

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