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

2 rows where analysis = "diamond", bioproject = "PRJDB12578" and tax_clade = "Cyanobacteriota/Melainabacteria group"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	lowcoverage_flag	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
26715435	26715435	PRJDB12578_S_NODE_141681_length_212_cov_1.245399_g118623_i0	PRJDB12578	141681	212	1.245399	2.64024588	Pseudanabaena sp.	1153	Bacteria	Bacteria	42	0.0465		NR	MFN6068992.1	1153	g118623	i0	36	0.707547169811321	50	30	67.9	1	24	167	342	391	MFN6068992.1 leucine--tRNA ligase [Pseudanabaena sp.]	diamond	150	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
32366248	32366248	PRJDB12578_S_NODE_119039_length_245_cov_1.479592_g95981_i0	PRJDB12578	119039	245	1.479592	3.6250004	Nostoc	1177	Bacteria	Bacteria	42.4	0.0484		NR	WP_190589176.1	1162	g95981	i0	43.9	1.00408163265306	41	23	50.2	0	83	205	186	226	WP_190589176.1 MULTISPECIES: Rpn family recombination-promoting nuclease/putative transposase [Nostocaceae]	diamond	246	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae

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