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

10 rows where analysis = "diamond", bioproject = "PRJEB17675" 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
1295893	1295893	PRJEB17675_P_NODE_5402_length_413_cov_1.727513_g5103_i0	PRJEB17675	5402	413	1.727513	7.13462869	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	146	7.67e-41	NR	MEN9568196.1	2847862	g5103	i0	85.7	0.610169491525424	84	12	61	0	162	413	134	217	MEN9568196.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	252	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
22973689	22973689	PRJEB17675_P_NODE_9039_length_296_cov_1.279693_g8735_i0	PRJEB17675	9039	296	1.279693	3.78789128	Synechocystis	1142	Bacteria	Bacteria	126	1.11e-35	NR	MEB3228129.1	1143	g8735	i0	77.5	1.62162162162162	80	18	81.1	0	296	57	8	87	MEB3228129.1 peptidylprolyl isomerase [Synechocystis sp.]	diamond	480	126	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp.
27633554	27633554	PRJEB17675_P_NODE_22764_length_160_cov_1.600000_g22460_i0	PRJEB17675	22764	160	1.6	2.56	Spirulina sp. SIO3F2	2607816	Bacteria	Bacteria	57	1.08e-7	NR	NEO87708.1	2607816	g22460	i0	64.3	2.3625	42	15	78.8	0	158	33	702	743	NEO87708.1 arginine--tRNA ligase [Spirulina sp. SIO3F2]	diamond	378	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae	Spirulina	Spirulina sp. SIO3F2
28959780	28959780	PRJEB17675_P_NODE_24268_length_154_cov_1.680672_g23964_i0	PRJEB17675	24268	154	1.680672	2.58823488	Cyanobacteria bacterium M5B4	2054928	Bacteria	Bacteria	43.5	0.00581	NR	PLS68370.1	2054928	g23964	i0	51.1	0.915584415584416	47	19	91.6	1	149	9	83	125	PLS68370.1 MAG: hypothetical protein CV045_08290 [Cyanobacteria bacterium M5B4]	diamond	141	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium M5B4
29023057	29023057	PRJEB17675_P_NODE_17768_length_188_cov_1.045752_g17464_i0	PRJEB17675	17768	188	1.045752	1.96601376	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	45.4	0.00163	NR	MDY7023971.1	2847862	g17464	i0	42.6	0.973404255319149	61	34	97.3	1	184	2	84	143	MDY7023971.1 phosphate ABC transporter substrate-binding protein PstS [Cyanobacteriota bacterium]	diamond	183	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29615857	29615857	PRJEB17675_P_NODE_4610_length_453_cov_1.844498_g4313_i0	PRJEB17675	4610	453	1.844498	8.35557594	Bacteria	2	Bacteria	Bacteria	130	4.79e-34	NR	WP_023067946.1	118322	g4313	i0	43.5	9.74834437086093	147	81	97.4	1	12	452	3	147	WP_023067946.1 aldehyde dehydrogenase family protein, partial [Lyngbya aestuarii]	diamond	4416	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Lyngbya	Lyngbya aestuarii
31290539	31290539	PRJEB17675_P_NODE_5515_length_408_cov_1.501340_g5216_i0	PRJEB17675	5515	408	1.50134	6.1254672	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	117	7.21e-30	NR	WP_026135329.1	34078	g5216	i0	51.2	7.43382352941176	127	57	89.7	3	407	42	75	201	WP_026135329.1 vWA domain-containing protein [Scytonema hofmannii]	diamond	3033	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema hofmannii
31676521	31676521	PRJEB17675_P_NODE_24857_length_152_cov_1.367521_g24553_i0	PRJEB17675	24857	152	1.367521	2.07863192	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	72.4	3.03e-13	NR	MBC7996987.1	2052166	g24553	i0	70.8	2.84210526315789	48	14	94.7	0	150	7	79	126	MBC7996987.1 SDR family oxidoreductase [Candidatus Melainabacteria bacterium]	diamond	432	72.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
31866252	31866252	PRJEB17675_P_NODE_17057_length_193_cov_1.493671_g16753_i0	PRJEB17675	17057	193	1.493671	2.88278503	Leptolyngbyaceae cyanobacterium MO_188.B28	3036643	Bacteria	Bacteria	82	2.2e-16	NR	MDJ0703989.1	3036643	g16753	i0	55.7	1.89637305699482	61	27	94.8	0	183	1	155	215	MDJ0703989.1 URC4/urg3 family protein [Leptolyngbyaceae cyanobacterium MO_188.B28]	diamond	366	82	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium MO_188.B28
32845874	32845874	PRJEB17675_P_NODE_13820_length_222_cov_1.283422_g13516_i0	PRJEB17675	13820	222	1.283422	2.84919684	Floridanema aerugineum	3396169	Bacteria	Bacteria	59.3	4.14e-8	NR	WP_413273297.1	3396169	g13516	i0	55.3	2.47297297297297	47	21	63.5	0	222	82	333	379	WP_413273297.1 DnaJ domain-containing protein [Floridanema aerugineum]	diamond	549	59.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Floridanema	Floridanema aerugineum

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