metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA994052" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA994052" 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
26678009	26678009	PRJNA994052_P_NODE_64281_length_220_cov_12.374150_g63025_i0	PRJNA994052	64281	220	12.37415	27.22313	Sphaerospermopsis sp.	3100406	Bacteria	Bacteria	90.9	3.06e-19	NR	MEB3151466.1	3100406	g63025	i0	58	0.940909090909091	69	29	94.1	0	214	8	10	78	MEB3151466.1 hypothetical protein [Sphaerospermopsis sp.]	diamond	207	90.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis sp.
28889677	28889677	PRJNA994052_P_NODE_65848_length_218_cov_6.165517_g64592_i0	PRJNA994052	65848	218	6.165517	13.44082706	Hassallia byssoidea	482630	Bacteria	Bacteria	59.3	3.83e-8	NR	WP_163519298.1	482630	g64592	i0	47.8	0.922018348623853	67	27	92.2	1	7	207	145	203	WP_163519298.1 glycosyl hydrolase family 28-related protein [Hassallia byssoidea]	diamond	201	59.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia byssoidea
29331762	29331762	PRJNA994052_P_NODE_61929_length_223_cov_25.120000_g60673_i0	PRJNA994052	61929	223	25.12	56.0176	Microcystis sp. M	1127	Bacteria	Bacteria	143	6.88e-39	NR	WP_287873658.1	2771111	g60673	i0	89	0.982062780269058	73	8	98.2	0	219	1	185	257	WP_287873658.1 PBSX family phage terminase large subunit [Microcystis sp. M034S1]	diamond	219	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M034S1
30215895	30215895	PRJNA994052_P_NODE_13252_length_316_cov_18.654321_g12032_i0	PRJNA994052	13252	316	18.654321	58.94765436	Acaryochloridaceae cyanobacterium RU_4_10	2720443	Bacteria	Bacteria	104	6.569999999999999e-24	NR	NJM77419.1	2720443	g12032	i0	89.1	0.522151898734177	55	6	52.2	0	146	310	245	299	NJM77419.1 diguanylate cyclase [Acaryochloridaceae cyanobacterium RU_4_10]	diamond	165	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae		Acaryochloridaceae cyanobacterium RU_4_10
30317245	30317245	PRJNA994052_P_NODE_22972_length_301_cov_4.381579_g21743_i0	PRJNA994052	22972	301	4.381579	13.18855279	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	63.2	5.67e-10	NR	WP_036903339.1	1218	g21743	i0	39.6	2.85049833887043	96	49	95.7	2	290	3	10	96	WP_036903339.1 MULTISPECIES: LexA family protein [Prochlorococcus]	diamond	858	63.5	0.995275590551181	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus

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