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

13 rows where analysis = "blastn", bioproject = "PRJNA940501" 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
2196299	2196299	PRJNA940501_S_NODE_3642_length_910_cov_27.767013_g3243_i0	PRJNA940501	3642	910	27.767013	252.6798183	Stanieria cyanosphaera	102116	Bacteria	Bacteria	414	1.0199999999999999e-110	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g3243	i0	79.895	21.7824175824176	572	110	62	4	339	906	885	315	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	19822	414	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
5086382	5086382	PRJNA940501_S_NODE_32604_length_317_cov_3.558394_g31786_i0	PRJNA940501	32604	317	3.558394	11.28010898	Cyanophyceae	3028117	Bacteria	Bacteria	63.9	1.37e-5	NTclustered	gi\|1818782735\|gb\|MT152271.1\|	2714145	g31786	i0	82.895	28.4258675078864	76	7	22	5	18	87	2044	2119	Brasilonema octagenarum Br-Kyiv-1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	9011	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema octagenarum
6022104	6022104	PRJNA940501_S_NODE_190025_length_196_cov_1.816993_g189207_i0	PRJNA940501	190025	196	1.816993	3.56130628	Kamptonema animale	92934	Bacteria	Bacteria	178	2.68e-40	NTclustered	gi\|1566846284\|dbj\|LC455664.1\|	92934	g189207	i0	83.333	95.3979591836735	198	27	100	6	1	196	402	209	Kamptonema animale NIES-206 gene for 23S ribosomal RNA, partial sequence	blastn	18698	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Kamptonema	Kamptonema animale
6025215	6025215	PRJNA940501_S_NODE_78985_length_253_cov_4.138095_g78167_i0	PRJNA940501	78985	253	4.138095	10.46938035	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	424	4.22e-114	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g78167	i0	96.85	141.758893280632	254	6	100	2	1	253	1992	1740	Uncultured Chroococcidiopsis sp. clone A1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	35865	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11124699	11124699	PRJNA940501_S_NODE_3749_length_884_cov_27.311534_g3243_i1	PRJNA940501	3749	884	27.311534	241.43396056	Stanieria cyanosphaera	102116	Bacteria	Bacteria	414	9.87e-111	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g3243	i1	79.895	22.4230769230769	572	110	64	4	313	880	885	315	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	19822	414	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
12397328	12397328	PRJNA940501_S_NODE_145930_length_213_cov_1.847059_g145112_i0	PRJNA940501	145930	213	1.847059	3.93423567	Geitlerinema sp. PCC 7407	1173025	Bacteria	Bacteria	311	2.8000000000000003e-80	NTclustered	gi\|485099144\|ref\|NR_102539.1\|	1173025	g145112	i0	92.991	152.281690140845	214	14	100	1	1	213	454	241	Geitlerinema sp. PCC 7407 strain PCC 7407 23S ribosomal RNA, complete sequence	blastn	32436	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Geitlerinematales	Geitlerinemataceae	Geitlerinema	Geitlerinema sp. PCC 7407
12737657	12737657	PRJNA940501_S_NODE_399150_length_150_cov_1.280374_g398332_i0	PRJNA940501	399150	150	1.280374	1.920561	Nostoc	1177	Bacteria	Bacteria	54.7	0.003	NTclustered	gi\|953508392\|dbj\|AP017295.1\|	1751286	g398332	i0	100	0.386666666666667	29	0	19	0	77	105	4871021	4871049	Nostoc sp. NIES-3756 DNA, complete genome	blastn	58	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
14949216	14949216	PRJNA940501_S_NODE_395952_length_150_cov_1.757009_g395134_i0	PRJNA940501	395952	150	1.757009	2.6355135	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	52.8	0.012	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g395134	i0	100	0.186666666666667	28	0	19	0	41	68	354451	354478	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
15285351	15285351	PRJNA940501_S_NODE_177552_length_200_cov_2.834395_g176734_i0	PRJNA940501	177552	200	2.834395	5.66879	Prochlorococcus	1218	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2895599909\|gb\|CP138966.1\|	1499498	g176734	i0	100	0.42	28	0	14	0	30	57	1739171	1739144	Prochlorococcus sp. MIT 0601 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus sp. MIT 0601
15286091	15286091	PRJNA940501_S_NODE_353112_length_157_cov_1.236842_g352294_i0	PRJNA940501	353112	157	1.236842	1.94184194	Nostoc	1177	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|186463002\|gb\|CP001037.1\|	63737	g352294	i0	100	0.713375796178344	28	0	18	0	30	57	7834513	7834486	Nostoc punctiforme PCC 73102 strain ATCC 29133 chromosome, complete genome	blastn	112	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
19109508	19109508	PRJNA940501_S_NODE_345275_length_158_cov_1.852174_g344457_i0	PRJNA940501	345275	158	1.852174	2.92643492	Bacillati	1783272	Bacteria	Bacteria	228	2.019999999999999e-55	NTclustered	gi\|814938258\|gb\|KP902312.1\|	1211	g344457	i0	92.949	98.7784810126582	156	11	99	0	1	156	73	228	Uncultured cyanobacterium clone OTU_953 16S ribosomal RNA gene, partial sequence	blastn	15607	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20045472	20045472	PRJNA940501_S_NODE_187576_length_197_cov_1.525974_g186758_i0	PRJNA940501	187576	197	1.525974	3.00616878	Calothrix sp. NIES-3974	2005462	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|1210184319\|dbj\|AP018254.1\|	2005462	g186758	i0	100	0.142131979695431	28	0	14	0	152	179	1275872	1275845	Calothrix sp. NIES-3974 DNA, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-3974
24209380	24209380	PRJNA940501_S_NODE_242499_length_181_cov_0.934783_g241681_i0	PRJNA940501	242499	181	0.934783	1.69195723	Drouetiella	2303513	Bacteria	Bacteria	263	6.519999999999999e-66	NTclustered	gi\|2312649311\|gb\|OP577851.1\|	2983373	g241681	i0	92.818	137.85635359116	181	13	100	0	1	181	2100	2280	Drouetiella epilithica ACKU670 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	24952	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella epilithica

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