metadata: contig_metadata: 9 rows where bioproject = "PRJNA217180" and tax_clade = "Cyanobacteriota/Melainabacteria group"

9 rows where bioproject = "PRJNA217180" 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
27579441	27579441	PRJNA217180_P_NODE_13084_length_166_cov_0.871795_g12984_i0	PRJNA217180	13084	166	0.871795	1.4471797	Cyanobacteria bacterium J06643_5	3023227	Bacteria	Bacteria	60.5	7.07e-9	NR	MEO0844021.1	3023227	g12984	i0	54.7	0.957831325301205	53	24	95.8	0	6	164	84	136	MEO0844021.1 LAGLIDADG family homing endonuclease [Cyanobacteria bacterium J06643_5]	diamond	159	60.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06643_5
27800665	27800665	PRJNA217180_P_NODE_10204_length_185_cov_1.316176_g10104_i0	PRJNA217180	10204	185	1.316176	2.4349256	Spirulinaceae cyanobacterium RM2_2_10	2720437	Bacteria	Bacteria	71.2	1.15e-12	NR	NJO18760.1	2720437	g10104	i0	64.3	0.908108108108108	56	20	90.8	0	9	176	240	295	NJO18760.1 hypothetical protein [Spirulinaceae cyanobacterium RM2_2_10]	diamond	168	71.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae		Spirulinaceae cyanobacterium RM2_2_10
30200138	30200138	PRJNA217180_P_NODE_12312_length_167_cov_1.728814_g12212_i0	PRJNA217180	12312	167	1.728814	2.88711938	Microcoleus sp. herbarium19	3055440	Bacteria	Bacteria	98.2	3.91e-22	NR	WP_333272774.1	3055440	g12212	i0	78.2	0.988023952095808	55	12	98.8	0	1	165	985	1039	WP_333272774.1 DNA polymerase [Microcoleus sp. herbarium19]	diamond	165	98.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. herbarium19
30453378	30453378	PRJNA217180_P_NODE_6753_length_227_cov_1.067416_g6653_i0	PRJNA217180	6753	227	1.067416	2.42303432	Planktothrix sp.	3088171	Bacteria	Bacteria	43.5	0.00326	NR	WP_408975130.1	3088171	g6653	i0	47.6	1.11013215859031	42	22	55.5	0	15	140	47	88	WP_408975130.1 hypothetical protein, partial [Planktothrix sp.]	diamond	252	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix sp.
30990392	30990392	PRJNA217180_P_NODE_14434_length_163_cov_0.894737_g14334_i0	PRJNA217180	14434	163	0.894737	1.45842131	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	92.8	2.86e-20	NR	MBK7841898.1	2711154	g14334	i0	75.9	0.993865030674847	54	13	99.4	0	162	1	191	244	MBK7841898.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	162	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
31432768	31432768	PRJNA217180_P_NODE_10436_length_183_cov_1.388060_g10336_i0	PRJNA217180	10436	183	1.38806	2.5401498	Microcoleus sp. herbarium19	3055440	Bacteria	Bacteria	68.2	1.1e-11	NR	WP_333272813.1	3055440	g10336	i0	49.1	0.934426229508197	57	29	93.4	0	177	7	207	263	WP_333272813.1 hypothetical protein [Microcoleus sp. herbarium19]	diamond	171	68.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. herbarium19
32002220	32002220	PRJNA217180_P_NODE_10738_length_181_cov_1.234848_g10638_i0	PRJNA217180	10738	181	1.234848	2.23507488	Stenomitos sp.	3088177	Bacteria	Bacteria	53.1	3.44e-6	NR	HEY9826350.1	3088177	g10638	i0	47.3	0.911602209944751	55	25	91.2	1	2	166	336	386	HEY9826350.1 hypothetical protein [Stenomitos sp.]	diamond	165	53.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos sp.
32445409	32445409	PRJNA217180_P_NODE_13319_length_165_cov_0.879310_g13219_i0	PRJNA217180	13319	165	0.87931	1.4508615	Candidatus Melainabacteria bacterium RIFOXYA2_FULL_32_9	1801611	Bacteria	Bacteria	58.2	2.13e-8	NR	OGI18953.1	1801611	g13219	i0	54.7	0.963636363636364	53	24	96.4	0	3	161	46	98	OGI18953.1 MAG: hypothetical protein A2255_00090 [Candidatus Melainabacteria bacterium RIFOXYA2_FULL_32_9]	diamond	159	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFOXYA2_FULL_32_9
32476981	32476981	PRJNA217180_P_NODE_12099_length_169_cov_1.666667_g11999_i0	PRJNA217180	12099	169	1.666667	2.81666723	Pleurocapsa sp. SU_196_0	2720476	Bacteria	Bacteria	52.8	6.12e-7	NR	NJK44821.1	2720476	g11999	i0	37.5	0.994082840236686	56	35	99.4	0	2	169	10	65	NJK44821.1 hypothetical protein [Pleurocapsa sp. SU_196_0]	diamond	168	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. SU_196_0

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