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

15 rows where analysis = "blastn", bioproject = "PRJNA666695" 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
3184392	3184392	PRJNA666695_S_NODE_90023_length_230_cov_4.571429_g88929_i0	PRJNA666695	90023	230	4.571429	10.5142867	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	224	4.11e-54	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g88929	i0	86.829	1.77391304347826	205	21	87	4	26	226	126062	125860	Leptolyngbya sp. 7M chromosome	blastn	408	224	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
4461218	4461218	PRJNA666695_S_NODE_80764_length_242_cov_1.691542_g79670_i0	PRJNA666695	80764	242	1.691542	4.09353164	Candidatus Atelocyanobacterium thalassae	713887	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2117893480\|dbj\|AP024987.1\|	1285375	g79670	i0	100	0.12396694214876	30	0	12	0	15	44	372977	372948	Cyanobacterium endosymbiont of Braarudosphaera bigelowii CPSB-1 DNA, complete genome	blastn	30	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Candidatus Atelocyanobacterium	Candidatus Atelocyanobacterium thalassae
4990931	4990931	PRJNA666695_S_NODE_148904_length_178_cov_2.328467_g147810_i0	PRJNA666695	148904	178	2.328467	4.14467126	root	1	Root_unresolved	Root_unresolved	329	6.21e-86	NTclustered	gi\|192337804\|gb\|EU751413.1\|	1211	g147810	i0	100	96.7696629213483	178	0	100	0	1	178	707	530	Uncultured cyanobacterium clone SD-G09 16S ribosomal RNA gene, partial sequence	blastn	17225	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
5734513	5734513	PRJNA666695_S_NODE_154085_length_175_cov_1.029851_g152991_i0	PRJNA666695	154085	175	1.029851	1.80223925	Microcystis aeruginosa	1126	Bacteria	Bacteria	58.4	3.17e-4	NTclustered	gi\|2719083847\|gb\|CP142375.1\|	3113711	g152991	i0	94.595	0.211428571428571	37	2	21	0	125	161	3799407	3799371	Microcystis aeruginosa 1339 chromosome, complete genome	blastn	37	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
6267242	6267242	PRJNA666695_S_NODE_89505_length_231_cov_2.363158_g88411_i0	PRJNA666695	89505	231	2.363158	5.45889498	Cyanophyceae	3028117	Bacteria	Bacteria	278	3.13e-70	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g88411	i0	88.412	221.281385281385	233	23	100	4	1	231	2005	1775	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	51116	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7008795	7008795	PRJNA666695_S_NODE_113906_length_206_cov_2.127273_g112812_i0	PRJNA666695	113906	206	2.127273	4.38218238	Nostoc flagelliforme	1306274	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|1297085450\|gb\|CP024792.1\|	2038116	g112812	i0	100	0.135922330097087	28	0	14	0	171	198	319078	319051	Nostoc flagelliforme CCNUN1 plasmid pNFSY07, complete sequence	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
8284923	8284923	PRJNA666695_S_NODE_192327_length_152_cov_1.567568_g191233_i0	PRJNA666695	192327	152	1.567568	2.38270336	Prochlorococcus marinus	1219	Bacteria	Bacteria	54.7	0.003	NTclustered	gi\|2895549752\|gb\|CP138919.1\|	1570015	g191233	i0	100	0.190789473684211	29	0	19	0	116	144	892900	892928	Prochlorococcus marinus str. MIT 1012 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
8286607	8286607	PRJNA666695_S_NODE_8427_length_584_cov_6.541436_g7441_i0	PRJNA666695	8427	584	6.541436	38.20198624	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	904	0	NTclustered	gi\|225696255\|gb\|FJ805922.1\|	259957	g7441	i0	95.13	114.871575342466	575	25	98	3	1	574	2224	2796	Uncultured Chroococcidiopsis sp. clone SA2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	67085	904	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8816246	8816246	PRJNA666695_S_NODE_70227_length_256_cov_3.209302_g69133_i0	PRJNA666695	70227	256	3.209302	8.21581312	Prochlorococcus	1218	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|33772317\|emb\|BX548174.1\|	59919	g69133	i0	100	0.546875	28	0	11	0	196	223	696222	696249	Prochlorococcus marinus MED4 complete genome	blastn	140	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
11366617	11366617	PRJNA666695_S_NODE_53469_length_286_cov_2.065306_g52375_i0	PRJNA666695	53469	286	2.065306	5.90677516	Prochlorococcus	1218	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|126542380\|gb\|CP000576.1\|	167546	g52375	i0	100	0.293706293706294	28	0	10	0	192	219	608328	608355	Prochlorococcus marinus str. MIT 9301, complete genome	blastn	84	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
12110962	12110962	PRJNA666695_S_NODE_188410_length_154_cov_1.628319_g187316_i0	PRJNA666695	188410	154	1.628319	2.50761126	Prochlorococcus marinus	1219	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2417453602\|gb\|CP114784.1\|	1570014	g187316	i0	100	0.188311688311688	29	0	19	0	47	75	1494727	1494699	Prochlorococcus marinus str. MIT 0917 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
13917048	13917048	PRJNA666695_S_NODE_47931_length_298_cov_4.396887_g46837_i0	PRJNA666695	47931	298	4.396887	13.10272326	Chroococcidiopsis	54298	Bacteria	Bacteria	433	8.47e-117	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g46837	i0	93.772	108.275167785235	289	17	97	1	6	294	794483	794196	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	32266	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
14659867	14659867	PRJNA666695_S_NODE_149352_length_178_cov_1.605839_g148258_i0	PRJNA666695	149352	178	1.605839	2.85839342	Cyanobacterium sp. DS4	2878255	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2667402313\|gb\|CP084098.1\|	2878255	g148258	i0	88.889	0.252808988764045	45	4	25	1	90	134	1744468	1744425	Cyanobacterium sp. Dongsha4 chromosome, complete genome	blastn	45	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	Cyanobacterium sp. DS4
17741106	17741106	PRJNA666695_S_NODE_60814_length_272_cov_1.393939_g59720_i0	PRJNA666695	60814	272	1.393939	3.79151408	Fischerella	1190	Bacteria	Bacteria	95.3	4.09e-15	NTclustered	gi\|2314726996\|dbj\|AP024677.1\|	1191	g59720	i0	93.75	4.75735294117647	64	3	23	1	126	188	2567179	2567116	MAG: Fischerella sp. KatS3mg066 DNA, complete genome	blastn	1294	95.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp.
21034777	21034777	PRJNA666695_S_NODE_37057_length_329_cov_4.100694_g35963_i0	PRJNA666695	37057	329	4.100694	13.49128326	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	300	1e-76	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g35963	i0	84.848	16.6170212765957	297	45	90	0	1	297	4623946	4624242	Leptolyngbya sp. 7M chromosome	blastn	5467	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M

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