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

9 rows where analysis = "diamond", bioproject = "PRJNA798511" 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
27180119	27180119	PRJNA798511_P_NODE_60282_length_317_cov_0.946721_g56016_i0	PRJNA798511	60282	317	0.946721	3.00110557	Cyanobacteria bacterium J06614_10	3023159	Bacteria	Bacteria	58.9	1.74e-7	NR	MEL6606504.1	3023159	g56016	i0	40.3	1.49526813880126	67	40	63.4	0	3	203	115	181	MEL6606504.1 reverse transcriptase family protein [Cyanobacteria bacterium J06614_10]	diamond	474	58.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06614_10
27938477	27938477	PRJNA798511_P_NODE_79265_length_268_cov_1.579487_g74999_i0	PRJNA798511	79265	268	1.579487	4.23302516	Cyanobacteria bacterium J06582_2	3023143	Bacteria	Bacteria	110	5.74e-26	NR	MEL7079339.1	3023143	g74999	i0	56.3	0.973880597014925	87	38	97.4	0	8	268	105	191	MEL7079339.1 reverse transcriptase domain-containing protein [Cyanobacteria bacterium J06582_2]	diamond	261	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06582_2
29075244	29075244	PRJNA798511_P_NODE_64008_length_305_cov_1.603448_g59742_i0	PRJNA798511	64008	305	1.603448	4.8905164	Pleurocapsa sp. MO_226.B13	3036786	Bacteria	Bacteria	63.9	2.81e-9	NR	MDJ0596593.1	3036786	g59742	i0	46	0.619672131147541	63	34	62	0	80	268	832	894	MDJ0596593.1 reverse transcriptase family protein [Pleurocapsa sp. MO_226.B13]	diamond	189	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. MO_226.B13
29264261	29264261	PRJNA798511_P_NODE_21909_length_731_cov_1.480243_g17844_i0	PRJNA798511	21909	731	1.480243	10.82057633	Cyanobacteria bacterium J06582_2	3023143	Bacteria	Bacteria	48.9	0.014	NR	MEL7079323.1	3023143	g17844	i0	36.2	1.0875512995896	58	37	23.8	0	317	490	1194	1251	MEL7079323.1 hypothetical protein [Cyanobacteria bacterium J06582_2]	diamond	795	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06582_2
30749047	30749047	PRJNA798511_P_NODE_64314_length_304_cov_2.463203_g60048_i0	PRJNA798511	64314	304	2.463203	7.48813712	Microcystis sp. 53602_E8	2904984	Bacteria	Bacteria	64.3	2.05e-9	NR	MCE2664493.1	2904984	g60048	i0	54.2	0.473684210526316	48	22	47.4	0	109	252	744	791	MCE2664493.1 hypothetical protein [Microcystis sp. 53602_E8]	diamond	144	64.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. 53602_E8
30812175	30812175	PRJNA798511_P_NODE_71334_length_286_cov_1.084507_g67068_i0	PRJNA798511	71334	286	1.084507	3.10169002	Cyanobacteria bacterium J06553_1	3023125	Bacteria	Bacteria	47.4	0.00141	NR	MEL7522491.1	3023125	g67068	i0	38.6	0.734265734265734	70	40	72.4	2	19	225	322	389	MEL7522491.1 ribonuclease H family protein [Cyanobacteria bacterium J06553_1]	diamond	210	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06553_1
31737938	31737938	PRJNA798511_P_NODE_53977_length_339_cov_1.323308_g49711_i0	PRJNA798511	53977	339	1.323308	4.48601412	Dolichospermum	748770	Bacteria	Bacteria	43.5	0.0418	NR	WP_137906556.1	136072	g49711	i0	45.2	0.743362831858407	42	23	37.2	0	144	19	125	166	WP_137906556.1 (2Fe-2S) ferredoxin domain-containing protein [Dolichospermum planctonicum]	diamond	252	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum planctonicum
31760668	31760668	PRJNA798511_P_NODE_80257_length_266_cov_1.440415_g75991_i0	PRJNA798511	80257	266	1.440415	3.8315039	Microcoleus sp. herbarium14	3055439	Bacteria	Bacteria	44.3	0.0135	NR	WP_333365481.1	3055439	g75991	i0	25.6	0.924812030075188	82	56	86.8	1	239	9	266	347	WP_333365481.1 SDR family NAD(P)-dependent oxidoreductase [Microcoleus sp. herbarium14]	diamond	246	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. herbarium14
32140407	32140407	PRJNA798511_P_NODE_19458_length_826_cov_2.253652_g15539_i0	PRJNA798511	19458	826	2.253652	18.61516552	Pleurocapsa sp. MO_226.B13	3036786	Bacteria	Bacteria	68.9	4.69e-9	NR	MDJ0596593.1	3036786	g15539	i0	53.4	1.12227602905569	58	27	21.1	0	51	224	837	894	MDJ0596593.1 reverse transcriptase family protein [Pleurocapsa sp. MO_226.B13]	diamond	927	68.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. MO_226.B13

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