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

9 rows where analysis = "diamond", bioproject = "PRJNA591127" 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
3116002	3116002	PRJNA591127_P_NODE_22903_length_182_cov_1.075862_g22734_i0	PRJNA591127	22903	182	1.075862	1.95806884	root	1	Root_unresolved	Root_unresolved	108	2.45e-28	NR	MBX9724270.1	2364082	g22734	i0	86.7	2.96703296703297	60	8	98.9	0	180	1	28	87	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	540	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
13319148	13319148	PRJNA591127_P_NODE_9231_length_242_cov_2.278049_g9063_i0	PRJNA591127	9231	242	2.278049	5.51287858	Nostocales cyanobacterium ELA608	3064516	Bacteria	Bacteria	139	1.19e-39	NR	MEI6371987.1	3064516	g9063	i0	73.8	0.991735537190083	80	21	99.2	0	1	240	58	137	MEI6371987.1 NADH-quinone oxidoreductase subunit C [Nostocales cyanobacterium ELA608]	diamond	240	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium ELA608
28121981	28121981	PRJNA591127_P_NODE_18725_length_197_cov_2.156250_g18556_i0	PRJNA591127	18725	197	2.15625	4.2478125	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	56.6	2.51e-7	NR	HEY9782502.1	3088178	g18556	i0	100	0.365482233502538	24	0	36.5	0	124	195	296	319	HEY9782502.1 aldo/keto reductase [Leptolyngbyaceae cyanobacterium]	diamond	72	56.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
28121982	28121982	PRJNA591127_P_NODE_19905_length_197_cov_1.887500_g19736_i0	PRJNA591127	19905	197	1.8875	3.718375	Pseudanabaenales cyanobacterium	2892939	Bacteria	Bacteria	82	2.9e-16	NR	MCG8365676.1	2892939	g19736	i0	69.2	1.97969543147208	65	12	99	1	1	195	813	869	MCG8365676.1 DEAD/DEAH box helicase [Pseudanabaenales cyanobacterium]	diamond	390	82	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales			Pseudanabaenales cyanobacterium
29051249	29051249	PRJNA591127_P_NODE_18068_length_197_cov_2.312500_g17899_i0	PRJNA591127	18068	197	2.3125	4.555625	Bacillati	1783272	Bacteria	Bacteria	56.2	2.76e-7	NR	MDP3507025.1	2052166	g17899	i0	100	1.14213197969543	25	0	38.1	0	1	75	167	191	MDP3507025.1 Fe-Mn family superoxide dismutase [Candidatus Melainabacteria bacterium]	diamond	225	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29808726	29808726	PRJNA591127_P_NODE_19791_length_197_cov_1.918750_g19622_i0	PRJNA591127	19791	197	1.91875	3.7799375	Bacteria	2	Bacteria	Bacteria	66.2	1.04e-10	NR	MBS1994833.1	2807731	g19622	i0	41.9	2.22335025380711	74	34	99	1	1	195	368	441	MBS1994833.1 urea transporter [Cyanobacteria bacterium SZAS LIN-2]	diamond	438	66.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-2
30788280	30788280	PRJNA591127_P_NODE_31174_length_150_cov_6.132743_g31005_i0	PRJNA591127	31174	150	6.132743	9.1991145	root	1	Root_unresolved	Root_unresolved	42	0.00701	NR	WP_353735003.1	2607787	g31005	i0	53.2	4.52	47	18	86	1	18	146	23	69	WP_353735003.1 IS200/IS605 family accessory protein TnpB-related protein [Okeania sp. SIO2C2]	diamond	678	42.4	0.990566037735849	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Okeania	Okeania sp. SIO2C2
31641654	31641654	PRJNA591127_P_NODE_31696_length_150_cov_3.495575_g31527_i0	PRJNA591127	31696	150	3.495575	5.2433625	root	1	Root_unresolved	Root_unresolved	60.5	5.43e-9	NR	OBQ41249.1	1710896	g31527	i0	51.9	3.18	79	7	96	1	149	6	105	183	OBQ41249.1 MAG: hypothetical protein AN484_21345 [Aphanizomenon flos-aquae WA102]	diamond	477	60.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
32577571	32577571	PRJNA591127_P_NODE_17399_length_197_cov_2.500000_g17230_i0	PRJNA591127	17399	197	2.5	4.925	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	92.4	3.7300000000000006e-21	NR	MBX9672374.1	2364082	g17230	i0	73.5	1.03553299492386	68	15	99	1	2	196	16	83	MBX9672374.1 cyclase family protein [Candidatus Obscuribacterales bacterium]	diamond	204	92.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium

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