metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA800053" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA800053" 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
13549845	13549845	PRJNA800053_P_NODE_23191_length_242_cov_0.911243_g23027_i0	PRJNA800053	23191	242	0.911243	2.20520806	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	143	2.89e-40	NR	MEY3767064.1	2847862	g23027	i0	93.4	0.942148760330578	76	5	94.2	0	238	11	209	284	MEY3767064.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	228	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27054135	27054135	PRJNA800053_P_NODE_13622_length_275_cov_1.821782_g13458_i0	PRJNA800053	13622	275	1.821782	5.0099005	Leptolyngbya sp. FACHB-36	2692808	Bacteria	Bacteria	48.9	3.05e-4	NR	WP_190340872.1	2692808	g13458	i0	35.1	0.807272727272727	74	47	80.7	1	51	272	160	232	WP_190340872.1 hypothetical protein [Leptolyngbya sp. FACHB-36]	diamond	222	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. FACHB-36
27338683	27338683	PRJNA800053_P_NODE_16763_length_254_cov_1.690608_g16599_i0	PRJNA800053	16763	254	1.6906080000000001	4.29414432	Microcoleus sp. herbarium19	3055440	Bacteria	Bacteria	107	3.93e-26	NR	WP_333272813.1	3055440	g16599	i0	51.8	0.980314960629921	83	40	98	0	251	3	167	249	WP_333272813.1 hypothetical protein [Microcoleus sp. herbarium19]	diamond	249	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. herbarium19
27749305	27749305	PRJNA800053_P_NODE_22524_length_243_cov_0.905882_g22360_i0	PRJNA800053	22524	243	0.905882	2.20129326	Stenomitos sp.	3088177	Bacteria	Bacteria	99.8	3.33e-22	NR	HEY9826360.1	3088177	g22360	i0	59.7	1.93827160493827	77	31	95.1	0	234	4	541	617	HEY9826360.1 hypothetical protein [Stenomitos sp.]	diamond	471	99.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos sp.
28064767	28064767	PRJNA800053_P_NODE_21725_length_244_cov_0.900585_g21561_i0	PRJNA800053	21725	244	0.900585	2.1974274	Desertifilum	1185872	Bacteria	Bacteria	102	9.77e-25	NR	WP_069969969.1	1185872	g21561	i0	91.1	2.75409836065574	56	5	68.9	0	240	73	158	213	WP_069969969.1 MULTISPECIES: LON peptidase substrate-binding domain-containing protein [Desertifilum]	diamond	672	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Desertifilales	Desertifilaceae	Desertifilum
28443848	28443848	PRJNA800053_P_NODE_17546_length_251_cov_0.865169_g17382_i0	PRJNA800053	17546	251	0.865169	2.17157419	Microcoleus sp. herbarium19	3055440	Bacteria	Bacteria	102	5.3999999999999985e-25	NR	WP_333272797.1	3055440	g17382	i0	68.9	0.884462151394422	74	23	88.4	0	237	16	130	203	WP_333272797.1 hypothetical protein [Microcoleus sp. herbarium19]	diamond	222	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. herbarium19
29611602	29611602	PRJNA800053_P_NODE_17510_length_251_cov_0.865169_g17346_i0	PRJNA800053	17510	251	0.865169	2.17157419	Cyanobacteria bacterium RYN_339	2812886	Bacteria	Bacteria	87.8	5.65e-18	NR	MDB5101554.1	2812886	g17346	i0	57.3	0.896414342629482	75	32	89.6	0	25	249	1	75	MDB5101554.1 Multifunctional fusion protein [Cyanobacteria bacterium RYN_339]	diamond	225	87.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium RYN_339
30307341	30307341	PRJNA800053_P_NODE_23672_length_241_cov_0.916667_g23508_i0	PRJNA800053	23672	241	0.916667	2.20916747	Spirulinaceae cyanobacterium RM2_2_10	2720437	Bacteria	Bacteria	94.4	2.51e-20	NR	NJO18761.1	2720437	g23508	i0	52.6	0.970954356846473	78	36	97.1	1	7	240	136	212	NJO18761.1 hypothetical protein [Spirulinaceae cyanobacterium RM2_2_10]	diamond	234	94.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae		Spirulinaceae cyanobacterium RM2_2_10
30970473	30970473	PRJNA800053_P_NODE_12434_length_284_cov_1.165877_g12270_i0	PRJNA800053	12434	284	1.165877	3.31109068	Parasynechococcus sp.	3101203	Bacteria	Bacteria	82	4.56e-18	NR	MFL2497155.1	3101203	g12270	i0	45.1	0.961267605633803	91	24	96.1	2	279	7	4	68	MFL2497155.1 DUF4326 domain-containing protein [Parasynechococcus sp.]	diamond	273	82	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Parasynechococcus	Parasynechococcus sp.
31665826	31665826	PRJNA800053_P_NODE_23297_length_242_cov_0.911243_g23133_i0	PRJNA800053	23297	242	0.911243	2.20520806	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	42.7	0.0132	NR	MFM1811219.1	2847862	g23133	i0	37.7	0.65702479338843	53	30	62	1	2	151	43	95	MFM1811219.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	159	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31887288	31887288	PRJNA800053_P_NODE_23677_length_241_cov_0.916667_g23513_i0	PRJNA800053	23677	241	0.916667	2.20916747	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	140	1.88e-36	NR	WP_009632565.1	927677	g23513	i0	87.3	0.983402489626556	79	10	98.3	0	2	238	310	388	WP_009632565.1 type I-D CRISPR-associated helicase Cas3' [Synechocystis sp. PCC 7509]	diamond	237	140	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
32172335	32172335	PRJNA800053_P_NODE_19178_length_248_cov_0.880000_g19014_i0	PRJNA800053	19178	248	0.88	2.1824	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	92.8	1.6e-20	NR	MEO0012009.1	2847862	g19014	i0	80.7	0.689516129032258	57	10	67.7	1	81	248	109	165	MEO0012009.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	171	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32457061	32457061	PRJNA800053_P_NODE_19519_length_248_cov_0.880000_g19355_i0	PRJNA800053	19519	248	0.88	2.1824	Microcoleus sp. herbarium19	3055440	Bacteria	Bacteria	100	2.2799999999999994e-23	NR	WP_333272779.1	3055440	g19355	i0	65.4	0.979838709677419	81	26	96.8	2	4	243	136	215	WP_333272779.1 glycoside hydrolase family 18 protein [Microcoleus sp. herbarium19]	diamond	243	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. herbarium19

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