metadata: contig_metadata: 8 rows where bioproject = "PRJNA689790" and tax

8 rows where bioproject = "PRJNA689790" 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
9597310	9597310	PRJNA689790_S_NODE_7428_length_217_cov_1.505556_g7313_i0	PRJNA689790	7428	217	1.505556	3.26705652	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	85.9	2.29e-18	NR	MBX9694784.1	2847862	g7313	i0	53.5	0.981566820276498	71	31	95.4	1	217	11	127	197	MBX9694784.1 protein kinase [Cyanobacteriota bacterium]	diamond	213	85.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
17755999	17755999	PRJNA689790_S_NODE_16894_length_150_cov_1.336283_g16779_i0	PRJNA689790	16894	150	1.336283	2.0044245	Cyanophyceae	3028117	Bacteria	Bacteria	215	1.47e-51	NTclustered	gi\|427998918\|gb\|CP003607.1\|	56110	g16779	i0	93.151	193.26	146	10	97	0	1	146	2199630	2199775	Oscillatoria acuminata PCC 6304, complete genome	blastn	28989	217	0.990783410138249	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata
24130038	24130038	PRJNA689790_S_NODE_16759_length_150_cov_2.398230_g16644_i0	PRJNA689790	16759	150	2.39823	3.597345	Microcystis	1125	Bacteria	Bacteria	248	1.45e-61	NTclustered	gi\|1861038541\|dbj\|LC557454.1\|	1126	g16644	i0	96.667	179.56	150	4	100	1	1	150	390	538	Microcystis aeruginosa NIES-1062 gene for 23S rRNA, partial sequence	blastn	26934	250	0.992	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
27125065	27125065	PRJNA689790_S_NODE_4502_length_286_cov_1.975904_g4387_i0	PRJNA689790	4502	286	1.975904	5.65108544	root	1	Root_unresolved	Root_unresolved	103	2.67e-23	NR	WP_015149409.1	118323	g4387	i0	56.2	5.4965034965035	89	39	93.4	0	10	276	785	873	WP_015149409.1 colicin transporter [Oscillatoria acuminata]	diamond	1572	104	0.990384615384615	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata
28262224	28262224	PRJNA689790_S_NODE_10906_length_180_cov_1.363636_g10791_i0	PRJNA689790	10906	180	1.363636	2.4545448	Nostoc	1177	Bacteria	Bacteria	56.6	2e-7	NR	WP_409881199.1	3075388	g10791	i0	54.7	1.76666666666667	53	24	88.3	0	163	5	457	509	WP_409881199.1 DUF4347 domain-containing protein, partial [Nostoc sp. DedQUE02]	diamond	318	56.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. DedQUE02
30177030	30177030	PRJNA689790_S_NODE_3512_length_332_cov_1.661017_g3397_i0	PRJNA689790	3512	332	1.661017	5.51457644	Synechococcus sp. GFB	1131	Bacteria	Bacteria	89.4	4.73e-20	NR	WP_048016504.1	1662190	g3397	i0	49.5	3.11746987951807	95	44	85.8	2	327	43	54	144	WP_048016504.1 Hsp20/alpha crystallin family protein [Synechococcus sp. GFB01]	diamond	1035	89.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. GFB01
30524647	30524647	PRJNA689790_S_NODE_3173_length_352_cov_2.342857_g3058_i0	PRJNA689790	3173	352	2.342857	8.24685664	Dolichospermum sp.	2720786	Bacteria	Bacteria	60.1	1.03e-7	NR	MBJ7298695.1	2720786	g3058	i0	24.6	0.971590909090909	114	85	96.3	1	344	6	95	208	MBJ7298695.1 hypothetical protein [Dolichospermum sp.]	diamond	342	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp.
31832042	31832042	PRJNA689790_S_NODE_12677_length_168_cov_1.778626_g12562_i0	PRJNA689790	12677	168	1.778626	2.98809168	Sphaerospermopsis	752201	Bacteria	Bacteria	41.6	0.0349	NR	MFM5988005.1	289435	g12562	i0	41.8	1.55357142857143	55	31	98.2	1	2	166	859	912	MFM5988005.1 reverse transcriptase domain-containing protein [Sphaerospermopsis kisseleviana]	diamond	261	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis kisseleviana

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