metadata: contig_metadata: 11 rows where bioproject = "PRJNA1008624" and tax_clade = "Cyanobacteriota/Melainabacteria group"

11 rows where bioproject = "PRJNA1008624" 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
4829375	4829375	PRJNA1008624_P_NODE_8104_length_294_cov_1.130612_g7916_i0	PRJNA1008624	8104	294	1.130612	3.32399928	Oscillatoriales	1150	Bacteria	Bacteria	532	7.989999999999998e-147	NTclustered	gi\|1241187607\|dbj\|LC319764.1\|	1160	g7916	i0	99.656	113.826530612245	291	1	99	0	1	291	848	558	Planktothrix agardhii gene for 16S ribosomal RNA, partial sequence, strain: NIES-1265	blastn	33465	532	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
12908065	12908065	PRJNA1008624_P_NODE_28591_length_168_cov_0.873950_g28403_i0	PRJNA1008624	28591	168	0.87395	1.468236	Leptolyngbya sp. NK1-12	2547451	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2591945363\|gb\|CP053586.1\|	2547451	g28403	i0	100	0.166666666666667	28	0	17	0	44	71	1631016	1631043	Leptolyngbya sp. NK1-12 chromosome 1, complete sequence	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NK1-12
13754770	13754770	PRJNA1008624_P_NODE_7391_length_308_cov_3.289575_g7203_i0	PRJNA1008624	7391	308	3.289575	10.131891	Gloeocapsopsis	693222	Bacteria	Bacteria	462	1.12e-125	NTclustered	gi\|1142095202\|gb\|KU847399.1\|	1433147	g7203	i0	93.851	105.366883116883	309	15	100	2	1	308	3648	3343	Gloeocapsopsis dulcis AAB1 = 1H9 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	32453	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
16730916	16730916	PRJNA1008624_P_NODE_15734_length_213_cov_3.030488_g15546_i0	PRJNA1008624	15734	213	3.030488	6.45493944	Brasilonema sennae	1397703	Bacteria	Bacteria	327	2.78e-85	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g15546	i0	94.762	114.164319248826	210	11	99	0	1	210	1168419	1168628	Brasilonema sennae CENA114 chromosome	blastn	24317	327	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
17579225	17579225	PRJNA1008624_P_NODE_8774_length_282_cov_2.549356_g8586_i0	PRJNA1008624	8774	282	2.549356	7.18918392	root	1	Root_unresolved	Root_unresolved	512	9.93e-141	NTclustered	gi\|781846478\|emb\|LN807669.1\|	1211	g8586	i0	99.643	101.322695035461	280	1	99	0	1	280	280	1	Uncultured cyanobacterium partial 16S rRNA gene, clone FJ628262	blastn	28573	514	0.996108949416342	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
25227562	25227562	PRJNA1008624_P_NODE_24620_length_176_cov_1.614173_g24432_i0	PRJNA1008624	24620	176	1.614173	2.84094448	Planktothrix	54304	Bacteria	Bacteria	320	3.69e-83	NTclustered	gi\|2261196917\|emb\|LR882969.1\|	1160	g24432	i0	100	153.5	173	0	98	0	4	176	622157	621985	Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I	blastn	27016	320	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
27192390	27192390	PRJNA1008624_P_NODE_26382_length_171_cov_1.090164_g26194_i0	PRJNA1008624	26382	171	1.090164	1.86418044	Cyanobacteria bacterium P01_A01_bin.80	3023253	Bacteria	Bacteria	50.4	1.77e-5	NR	MEM7578254.1	3023253	g26194	i0	77.8	0.473684210526316	27	6	47.4	0	85	5	140	166	MEM7578254.1 hypothetical protein [Cyanobacteria bacterium P01_A01_bin.80]	diamond	81	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_A01_bin.80
27255703	27255703	PRJNA1008624_P_NODE_26823_length_169_cov_1.691667_g26635_i0	PRJNA1008624	26823	169	1.691667	2.85891723	Microcystis sp. 53602_E8	2904984	Bacteria	Bacteria	70.1	3.12e-12	NR	MCE2664493.1	2904984	g26635	i0	51	0.905325443786982	51	25	90.5	0	168	16	752	802	MCE2664493.1 hypothetical protein [Microcystis sp. 53602_E8]	diamond	153	70.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. 53602_E8
29465682	29465682	PRJNA1008624_P_NODE_31450_length_166_cov_0.888889_g31262_i0	PRJNA1008624	31450	166	0.888889	1.47555574	Microcystis sp. M	1127	Bacteria	Bacteria	53.9	1.44e-6	NR	WP_287729196.1	2771171	g31262	i0	57.4	0.849397590361446	47	20	84.9	0	6	146	75	121	WP_287729196.1 hypothetical protein [Microcystis sp. M061S2]	diamond	141	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M061S2
29718411	29718411	PRJNA1008624_P_NODE_31210_length_166_cov_0.888889_g31022_i0	PRJNA1008624	31210	166	0.888889	1.47555574	Sphaerospermopsis sp.	3100406	Bacteria	Bacteria	62	2.2e-10	NR	MEB3151458.1	3100406	g31022	i0	55.6	0.975903614457831	54	24	97.6	0	3	164	32	85	MEB3151458.1 hypothetical protein [Sphaerospermopsis sp.]	diamond	162	62	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis sp.
32500808	32500808	PRJNA1008624_P_NODE_33019_length_165_cov_0.896552_g32831_i0	PRJNA1008624	33019	165	0.896552	1.4793108	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	71.6	8.57e-13	NR	MEB3301968.1	2847862	g32831	i0	63.5	0.945454545454545	52	19	94.5	0	7	162	440	491	MEB3301968.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	156	71.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota 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);;