metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA939369" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA939369" 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
27853248	27853248	PRJNA939369_S_NODE_2524_length_709_cov_1.573899_g2134_i0	PRJNA939369	2524	709	1.573899	11.15894391	root	1	Root_unresolved	Root_unresolved	138	4.15e-36	NR	MBE7708938.1	2775576	g2134	i0	33.3	2.00141043723554	240	149	99	5	6	707	24	258	MBE7708938.1 HNH endonuclease [Cyanobacteria bacterium SIG32]	diamond	1419	139	0.992805755395683	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SIG32
29204183	29204183	PRJNA939369_S_NODE_74849_length_242_cov_0.863905_g74432_i0	PRJNA939369	74849	242	0.863905	2.0906501	Prochlorococcus marinus	1219	Bacteria	Bacteria	42.7	0.0352	NR	WP_011824859.1	1219	g74432	i0	37.7	0.756198347107438	61	31	66.9	1	240	79	165	225	WP_011824859.1 carbohydrate kinase family protein [Prochlorococcus marinus]	diamond	183	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
29495169	29495169	PRJNA939369_S_NODE_14330_length_376_cov_1.089109_g13913_i0	PRJNA939369	14330	376	1.089109	4.09504984	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	45.1	0.0168	NR	MBW4622782.1	1874554	g13913	i0	53.7	3.71808510638298	41	19	32.7	0	326	204	3	43	MBW4622782.1 translation elongation factor Ts [Cyanosarcina radialis HA8281-LM2]	diamond	1398	45.4	0.993392070484582	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Cyanosarcina	Cyanosarcina radialis
31383942	31383942	PRJNA939369_S_NODE_57676_length_250_cov_0.870056_g57259_i0	PRJNA939369	57676	250	0.870056	2.17514	Synechococcaceae cyanobacterium	2588875	Bacteria	Bacteria	44.7	0.00824	NR	MFN9695637.1	2588875	g57259	i0	37.2	0.936	78	41	90	2	9	233	46	118	MFN9695637.1 NADPH-dependent assimilatory sulfite reductase hemoprotein subunit [Synechococcaceae cyanobacterium]	diamond	234	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae		Synechococcaceae cyanobacterium

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