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

4 rows where analysis = "diamond", bioproject = "PRJNA1164198" 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
312051	312051	PRJNA1164198_P_NODE_7381_length_461_cov_2.904639_g7120_i0	PRJNA1164198	7381	461	2.904639	13.39038579	Cyanophyceae	3028117	Bacteria	Bacteria	228	2.8699999999999993e-74	NR	MBW4553369.1	2835086	g7120	i0	72.3	7.7114967462039	148	41	96.3	0	7	450	2	149	MBW4553369.1 nucleoside-diphosphate kinase [Aphanocapsa sp. GSE-SYN-MK-11-07L]	diamond	3555	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Aphanocapsa	Aphanocapsa sp. GSE-SYN-MK-11-07L
28903454	28903454	PRJNA1164198_P_NODE_15048_length_319_cov_1.097561_g14779_i0	PRJNA1164198	15048	319	1.097561	3.50121959	Coleofasciculus sp. G2-EDA-02	3069529	Bacteria	Bacteria	67.4	2.18e-11	NR	MEQ9671065.1	3069529	g14779	i0	35.7	1.84326018808777	98	62	91.2	1	15	305	8	105	MEQ9671065.1 TerB family tellurite resistance protein [Coleofasciculus sp. G2-EDA-02]	diamond	588	67.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. G2-EDA-02
28903462	28903462	PRJNA1164198_P_NODE_26748_length_249_cov_0.886364_g26479_i0	PRJNA1164198	26748	249	0.886364	2.20704636	Synechocystis sp. LKSZ1	3144951	Bacteria	Bacteria	42	0.0105	NR	BFM39746.1	3144951	g26479	i0	44.2	0.518072289156627	43	21	51.8	1	66	194	25	64	BFM39746.1 hypothetical protein OLK001_16720 [Synechocystis sp. LKSZ1]	diamond	129	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. LKSZ1
32526159	32526159	PRJNA1164198_P_NODE_18099_length_291_cov_1.284404_g17830_i0	PRJNA1164198	18099	291	1.284404	3.73761564	Nostocaceae	1162	Bacteria	Bacteria	46.6	0.00298	NR	WP_190466015.1	197653	g17830	i0	31	2.6701030927835	87	58	87.6	2	284	30	1177	1263	WP_190466015.1 GAF domain-containing protein [Anabaena azotica]	diamond	777	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena azotica

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