metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA438572" and tax_clade = "Cyanobacteriota/Melainabacteria group"

12 rows where analysis = "blastn", bioproject = "PRJNA438572" 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
434972	434972	PRJNA438572_P_NODE_19041_length_250_cov_0.881356_g18922_i0	PRJNA438572	19041	250	0.881356	2.20339	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	383	7.07e-102	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g18922	i0	94.4	138.996	250	13	100	1	1	250	1858908	1859156	Calothrix sp. PCC 7716 DNA, complete genome	blastn	34749	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
1709837	1709837	PRJNA438572_P_NODE_17442_length_252_cov_0.871508_g17323_i0	PRJNA438572	17442	252	0.871508	2.19620016	Gloeotrichia echinulata	212360	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2813986847\|gb\|CP170511.1\|	3350243	g17323	i0	100	0.115079365079365	29	0	12	0	209	237	6353633	6353661	MAG: Gloeotrichia echinulata GP01 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Gloeotrichiaceae	Gloeotrichia	Gloeotrichia echinulata
5538892	5538892	PRJNA438572_P_NODE_7365_length_373_cov_0.870000_g7246_i0	PRJNA438572	7365	373	0.87	3.2451	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	595	1.3099999999999996e-165	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g7246	i0	95.442	240.844504021448	373	17	100	0	1	373	1857519	1857891	Calothrix sp. PCC 7716 DNA, complete genome	blastn	89835	595	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
6812794	6812794	PRJNA438572_P_NODE_21086_length_247_cov_0.896552_g20967_i0	PRJNA438572	21086	247	0.896552	2.21448344	Planktothrix agardhii	1160	Bacteria	Bacteria	285	2.02e-72	NTclustered	gi\|2261157456\|emb\|LR882949.1\|	1160	g20967	i0	87.449	12	247	31	100	0	1	247	2122074	2122320	Planktothrix agardhii strain No.758 genome assembly, chromosome: I	blastn	2964	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
7468970	7468970	PRJNA438572_P_NODE_16026_length_259_cov_1.677419_g15907_i0	PRJNA438572	16026	259	1.677419	4.34451521	Leptolyngbya	47251	Bacteria	Bacteria	169	2.24e-37	NTclustered	gi\|2591945363\|gb\|CP053586.1\|	2547451	g15907	i0	85.629	33.4787644787645	167	17	64	5	91	256	1245909	1246069	Leptolyngbya sp. NK1-12 chromosome 1, complete sequence	blastn	8671	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NK1-12
14463623	14463623	PRJNA438572_P_NODE_14292_length_275_cov_2.202970_g14173_i0	PRJNA438572	14292	275	2.20297	6.0581675	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	429	9.989999999999999e-116	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g14173	i0	95.238	119.603636363636	273	9	99	2	3	275	2546	2814	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32891	429	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17668659	17668659	PRJNA438572_P_NODE_15694_length_262_cov_2.306878_g15575_i0	PRJNA438572	15694	262	2.306878	6.04402036	Chroococcidiopsis	54298	Bacteria	Bacteria	418	2.0499999999999995e-112	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g15575	i0	95.455	145.568702290076	264	8	100	3	1	262	3128	2867	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	38139	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
19560995	19560995	PRJNA438572_P_NODE_23736_length_243_cov_0.917647_g23617_i0	PRJNA438572	23736	243	0.917647	2.22988221	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	263	9.3e-66	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g23617	i0	91.192	5.76131687242798	193	17	95	0	40	232	27639	27447	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	1400	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
22111536	22111536	PRJNA438572_P_NODE_14298_length_275_cov_1.900990_g14179_i0	PRJNA438572	14298	275	1.90099	5.2277225	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	401	2.1799999999999995e-107	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g14179	i0	93.066	149.850909090909	274	19	99	0	2	275	3395	3122	Uncultured Chroococcidiopsis sp. clone AR1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41209	401	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22111605	22111605	PRJNA438572_P_NODE_17738_length_252_cov_0.871508_g17619_i0	PRJNA438572	17738	252	0.871508	2.19620016	Stanieria sp. NIES-3757	1807358	Bacteria	Bacteria	172	1.68e-38	NTclustered	gi\|1003382826\|dbj\|AP017375.1\|	1807358	g17619	i0	79.051	1.00396825396825	253	51	100	2	1	252	1181156	1180905	Stanieria sp. NIES-3757 DNA, complete genome	blastn	253	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria sp. NIES-3757
24661199	24661199	PRJNA438572_P_NODE_15560_length_264_cov_1.225131_g15441_i0	PRJNA438572	15560	264	1.225131	3.23434584	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	311	3.6e-80	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g15441	i0	87.97	157.443181818182	266	28	100	4	1	264	3146	2883	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41565	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25317206	25317206	PRJNA438572_P_NODE_21200_length_247_cov_0.896552_g21081_i0	PRJNA438572	21200	247	0.896552	2.21448344	Microcystis	1125	Bacteria	Bacteria	440	4.079999999999999e-119	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g21081	i0	98.79	85.2348178137652	248	2	100	1	1	247	1039681	1039434	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	21053	440	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa

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