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

7 rows where analysis = "diamond", bioproject = "PRJNA1198392" 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
11247056	11247056	PRJNA1198392_P_NODE_19249_length_245_cov_0.895349_g19108_i0	PRJNA1198392	19249	245	0.895349	2.19360505	Cyanophyceae	3028117	Bacteria	Bacteria	135	9.419999999999999e-35	NR	WP_250122583.1	155894	g19108	i0	82.9	3.01224489795918	82	13	99.2	1	2	244	1063	1144	WP_250122583.1 PAS domain S-box protein [Chroococcidiopsis sp. CCMEE 29]	diamond	738	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
17621500	17621500	PRJNA1198392_P_NODE_10334_length_281_cov_1.293269_g10193_i0	PRJNA1198392	10334	281	1.293269	3.63408589	Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35	2801880	Bacteria	Bacteria	135	6.47e-39	NR	MBV8888005.1	2801880	g10193	i0	73.1	0.99288256227758	93	10	99.3	1	2	280	32	109	MBV8888005.1 IS200/IS605 family accessory protein TnpB-related protein [Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35]	diamond	279	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae		Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35
27357166	27357166	PRJNA1198392_P_NODE_3183_length_423_cov_4.288571_g3042_i0	PRJNA1198392	3183	423	4.288571	18.14065533	Cyanobacteria bacterium J06582_2	3023143	Bacteria	Bacteria	56.6	3.69e-6	NR	MEL7079402.1	3023143	g3042	i0	39.1	2.22695035460993	87	46	60.3	3	384	130	214	295	MEL7079402.1 reverse transcriptase domain-containing protein [Cyanobacteria bacterium J06582_2]	diamond	942	56.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06582_2
27944334	27944334	PRJNA1198392_P_NODE_15285_length_253_cov_2.472222_g15144_i0	PRJNA1198392	15285	253	2.472222	6.25472166	Bacillati	1783272	Bacteria	Bacteria	67	1.26e-11	NR	MBA4078325.1	2067979	g15144	i0	97.1	0.8300395256917	35	1	41.5	0	106	2	1	35	MBA4078325.1 hypothetical protein [Cyanobacteria bacterium PR.023]	diamond	210	67	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023
28354675	28354675	PRJNA1198392_P_NODE_12086_length_272_cov_1.376884_g11945_i0	PRJNA1198392	12086	272	1.376884	3.74512448	Cyanophyceae	3028117	Bacteria	Bacteria	129	1.4e-32	NR	MBW4661298.1	904376	g11945	i0	68.5	14.5367647058824	89	27	98.2	1	268	2	4	91	MBW4661298.1 transketolase [Drouetiella hepatica Uher 2000/2452]	diamond	3954	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella hepatica
28702151	28702151	PRJNA1198392_P_NODE_20067_length_243_cov_0.905882_g19926_i0	PRJNA1198392	20067	243	0.905882	2.20129326	Microseira	1609595	Bacteria	Bacteria	147	5.95e-39	NR	WP_226573490.1	467598	g19926	i0	90	5.92592592592593	80	8	98.8	0	241	2	783	862	WP_226573490.1 glutamate synthase-related protein [Microseira wollei]	diamond	1440	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Microseira	Microseira wollei
29346269	29346269	PRJNA1198392_P_NODE_16849_length_249_cov_0.875000_g16708_i0	PRJNA1198392	16849	249	0.875	2.17875	Oculatellaceae cyanobacterium Prado106	2929566	Bacteria	Bacteria	63.9	1.32e-9	NR	MCU0566945.1	2929566	g16708	i0	43.2	1.78313253012048	74	36	89.2	1	233	12	215	282	MCU0566945.1 hypothetical protein [Oculatellaceae cyanobacterium Prado106]	diamond	444	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium Prado106

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