metadata: contig_metadata: 7 rows where bioproject = "PRJNA692200" and tax_clade = "Cyanobacteriota/Melainabacteria group"

7 rows where bioproject = "PRJNA692200" 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	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
12151837	12151837	PRJNA692200_S_NODE_15290_length_186_cov_2.934307_g15233_i0	PRJNA692200	15290	186	2.934307	5.45781102	Aliterella chasmolithica	2739056	Bacteria	Bacteria	303	3.98e-78	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g15233	i0	96.216	141.220430107527	185	7	99	2	186	2173	1989	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26267	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
18524559	18524559	PRJNA692200_S_NODE_13075_length_199_cov_2.466667_g13018_i0	PRJNA692200	13075	199	2.466667	4.90866733	Bacteria	2	Bacteria	Bacteria	67.8	2.57e-11	NR	WP_075892009.1	454133	g13018	i0	71.8	3.85929648241206	39	11	58.8	1	117	298	336	WP_075892009.1 type I glyceraldehyde-3-phosphate dehydrogenase [[Limnothrix rosea] IAM M-220]	diamond	768	67.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	[Limnothrix rosea] IAM M-220
22349861	22349861	PRJNA692200_S_NODE_10538_length_218_cov_5.958580_g10481_i0	PRJNA692200	10538	218	5.95858	12.9897044	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	379	7.779999999999999e-101	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g10481	i0	98.157	106.733944954128	217	4	99	1	217	3682467	3682683	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	23268	379	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
22350357	22350357	PRJNA692200_S_NODE_8878_length_234_cov_337.064865_g8821_i0	PRJNA692200	8878	234	337.064865	788.7317841	Synechocystis sp.	1143	Bacteria	Bacteria	81.3	4.52e-18	NR	MEB3228129.1	1143	g8821	i0	77.6	1.25641025641026	49	11	62.8	232	86	39	87	MEB3228129.1 peptidylprolyl isomerase [Synechocystis sp.]	diamond	294	81.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp.
27966913	27966913	PRJNA692200_S_NODE_7325_length_252_cov_6.073892_g7268_i0	PRJNA692200	7325	252	6.073892	15.30620784	Cuspidothrix sp.	3019649	Bacteria	Bacteria	47	0.00137	NR	MFM7408094.1	3019649	g7268	i0	65.5	1.03571428571429	29	10	34.5	3	89	728	756	MFM7408094.1 FG-GAP-like repeat-containing protein [Cuspidothrix sp.]	diamond	261	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Cuspidothrix	Cuspidothrix sp.
28736107	28736107	PRJNA692200_S_NODE_21527_length_163_cov_1.342105_g21470_i0	PRJNA692200	21527	163	1.342105	2.18763115	Bacteria	2	Bacteria	Bacteria	58.2	4.61e-8	NR	NDD45436.1	2448804	g21470	i0	50	1.84049079754601	50	25	92	159	10	180	229	NDD45436.1 translation initiation factor IF-3 [Synechococcaceae bacterium WB9_4xB_025]	diamond	300	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae		Synechococcaceae bacterium WB9_4xB_025
31789126	31789126	PRJNA692200_S_NODE_21457_length_163_cov_1.763158_g21400_i0	PRJNA692200	21457	163	1.763158	2.87394754	Synechococcus sp. CCY 9618	2815602	Bacteria	Bacteria	80.9	4.61e-17	NR	WP_216903717.1	2815602	g21400	i0	64.8	12.920245398773	54	19	99.4	2	163	151	204	WP_216903717.1 peroxiredoxin [Synechococcus sp. CCY 9618]	diamond	2106	80.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CCY 9618

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