metadata: contig_metadata: 5 rows where bioproject = "PRJNA891846" and tax_clade = "Cyanobacteriota/Melainabacteria group"

5 rows where bioproject = "PRJNA891846" 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
15271062	15271062	PRJNA891846_P_NODE_8332_length_512_cov_1.601367_g8117_i0	PRJNA891846	8332	512	1.601367	8.19899904	Chroococcidiopsis	54298	Bacteria	Bacteria	680	0	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g8117	i0	90.838	143.431640625	513	39	99	8	1	511	794379	793873	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	73437	686	0.991253644314869	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
28034882	28034882	PRJNA891846_P_NODE_45205_length_243_cov_0.905882_g44985_i0	PRJNA891846	45205	243	0.905882	2.20129326	Cyanobium sp. Aljojuca 7D2	2823698	Bacteria	Bacteria	155	2.05e-45	NR	WP_254995183.1	2823698	g44985	i0	92.6	1	81	6	100	0	1	243	108	188	WP_254995183.1 WecB/TagA/CpsF family glycosyltransferase [Cyanobium sp. Aljojuca 7D2]	diamond	243	155	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. Aljojuca 7D2
28129554	28129554	PRJNA891846_P_NODE_38285_length_250_cov_0.870056_g38065_i0	PRJNA891846	38285	250	0.870056	2.17514	Cyanobacteria bacterium K_Offshore_0m_m2_072	2775532	Bacteria	Bacteria	154	2.32e-44	NR	MBM5798812.1	2775532	g38065	i0	90.2	0.984	82	8	98.4	0	3	248	141	222	MBM5798812.1 ABC transporter ATP-binding protein [Cyanobacteria bacterium K_Offshore_0m_m2_072]	diamond	246	154	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K_Offshore_0m_m2_072
29179340	29179340	PRJNA891846_P_NODE_23109_length_317_cov_1.262295_g22890_i0	PRJNA891846	23109	317	1.262295	4.00147515	Bacillati	1783272	Bacteria	Bacteria	62.8	1.3e-9	NR	WP_272128327.1	3021716	g22890	i0	50.9	0.974763406940063	57	26	52.1	1	1	165	108	164	WP_272128327.1 molybdenum cofactor biosynthesis protein MoaE [Spirulina sp. CS-785/01]	diamond	309	62.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae	Spirulina	Spirulina sp. CS-785/01
29265937	29265937	PRJNA891846_P_NODE_27209_length_291_cov_2.417431_g26990_i0	PRJNA891846	27209	291	2.417431	7.03472421	Dolichospermum sp. ST_con	2916815	Bacteria	Bacteria	178	1.55e-51	NR	MDD1416906.1	2916815	g26990	i0	83.5	3	97	16	100	0	1	291	249	345	MDD1416906.1 ATP-binding protein [Dolichospermum sp. ST_con]	diamond	873	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp. ST_con

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