metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA565778" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA565778" 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
5661990	5661990	PRJNA565778_S_NODE_23485_length_228_cov_6.591623_g23189_i0	PRJNA565778	23485	228	6.591623	15.02890044	Microcystis	1125	Bacteria	Bacteria	65.5	2.53e-10	NR	WP_216645762.1	1126	g23189	i0	55.4	6.73684210526316	65	23	82.9	3	1	189	134	194	WP_216645762.1 DNA cytosine methyltransferase [Microcystis aeruginosa]	diamond	1536	65.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
26730919	26730919	PRJNA565778_S_NODE_37921_length_175_cov_3.963768_g37625_i0	PRJNA565778	37921	175	3.963768	6.936594	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	79	1.13e-16	NR	WP_106370034.1	2107693	g37625	i0	94.9	0.668571428571429	39	2	66.9	0	143	27	58	96	WP_106370034.1 hypothetical protein [Chlorogloea sp. CCALA 695]	diamond	117	79	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
27079492	27079492	PRJNA565778_S_NODE_40602_length_162_cov_1.872000_g40306_i0	PRJNA565778	40602	162	1.872	3.03264	Limnospira platensis	118562	Bacteria	Bacteria	57	1.74e-8	NR	MDV7394826.1	3080829	g40306	i0	55.8	0.796296296296296	43	19	79.6	0	131	3	67	109	MDV7394826.1 hypothetical protein [Arthrospira platensis SPKY1]	diamond	129	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
29227080	29227080	PRJNA565778_S_NODE_18849_length_255_cov_10.899083_g18553_i0	PRJNA565778	18849	255	10.899083	27.79266165	Microcystis sp. M020S1	2771109	Bacteria	Bacteria	132	1.29e-33	NR	MCA2924656.1	2771109	g18553	i0	82.4	0.870588235294118	74	13	87.1	0	34	255	523	596	MCA2924656.1 N-6 DNA methylase [Microcystis sp. M020S1]	diamond	222	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M020S1
30742970	30742970	PRJNA565778_S_NODE_15874_length_277_cov_289.770833_g15578_i0	PRJNA565778	15874	277	289.770833	802.66520741	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	165	6.429999999999999e-47	NR	RYY00122.1	2847862	g15578	i0	96.4	1.8194945848375501	84	3	91	0	2	253	67	150	RYY00122.1 MAG: hypothetical protein EOO35_00540, partial [Cyanobacteriota bacterium]	diamond	504	165	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31501794	31501794	PRJNA565778_S_NODE_40356_length_163_cov_2.476190_g40060_i0	PRJNA565778	40356	163	2.47619	4.0361897	Hydrocoleum sp. CS-953	1671698	Bacteria	Bacteria	71.2	1.61e-13	NR	WP_094672650.1	1671698	g40060	i0	56.6	3.90184049079755	53	23	97.5	0	161	3	5	57	WP_094672650.1 hypothetical protein [Hydrocoleum sp. CS-953]	diamond	636	71.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Hydrocoleum	Hydrocoleum sp. CS-953
31628061	31628061	PRJNA565778_S_NODE_11356_length_324_cov_17.275261_g11060_i0	PRJNA565778	11356	324	17.275261	55.97184564	Microcystis	1125	Bacteria	Bacteria	72	2.98e-12	NR	WP_185237217.1	1125	g11060	i0	53.3	0.694444444444444	75	33	67.6	2	101	319	193	267	WP_185237217.1 MULTISPECIES: tail fiber domain-containing protein [Microcystis]	diamond	225	72	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis
32292889	32292889	PRJNA565778_S_NODE_5059_length_461_cov_6.804245_g4822_i0	PRJNA565778	5059	461	6.804245	31.36756945	Nostoc sp. CHAB 5834	2780403	Bacteria	Bacteria	162	1.64e-44	NR	MCC5612505.1	2780403	g4822	i0	66.4	0.754880694143167	116	39	75.5	0	411	64	306	421	MCC5612505.1 AAA family ATPase [Nostoc sp. CHAB 5834]	diamond	348	162	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CHAB 5834
32559511	32559511	PRJNA565778_S_NODE_33419_length_189_cov_2.052632_g33123_i0	PRJNA565778	33419	189	2.052632	3.87947448	Oscillatoriales	1150	Bacteria	Bacteria	102	2.11e-26	NR	WP_254565713.1	2954806	g33123	i0	85.5	1.74603174603175	55	8	87.3	0	165	1	40	94	WP_254565713.1 J domain-containing protein [Oscillatoria sp. HE19RPO]	diamond	330	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. HE19RPO
32874106	32874106	PRJNA565778_S_NODE_18840_length_255_cov_30.536697_g18544_i0	PRJNA565778	18840	255	30.536697	77.86857735	Nostoc	1177	Bacteria	Bacteria	60.8	1.75e-8	NR	MEM6448518.1	3023271	g18544	i0	57.4	3.18823529411765	54	22	63.5	1	38	199	146	198	MEM6448518.1 thioesterase domain-containing protein [Cyanobacteria bacterium P01_D01_bin.123]	diamond	813	61.2	0.993464052287582	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_D01_bin.123

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