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

14 rows where analysis = "blastn", bioproject = "PRJNA781196" 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
759353	759353	PRJNA781196_P_NODE_44161_length_269_cov_2.040816_g43784_i0	PRJNA781196	44161	269	2.040816	5.48979504	Pleurocapsa minor	54308	Bacteria	Bacteria	477	3.4299999999999985e-130	NTclustered	gi\|2717502817\|gb\|PP667998.1\|	3139816	g43784	i0	98.876	126.35687732342	267	3	99	0	1	267	2252	2518	Pleurocapsa minor SAG 4.99 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33990	477	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa minor
2035004	2035004	PRJNA781196_P_NODE_16882_length_405_cov_1.292169_g16505_i0	PRJNA781196	16882	405	1.292169	5.23328445	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	466	1.17e-126	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g16505	i0	87.438	197.130864197531	406	49	100	2	1	405	2034	1630	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	79838	466	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3310525	3310525	PRJNA781196_P_NODE_38063_length_289_cov_1.310185_g37686_i0	PRJNA781196	38063	289	1.310185	3.78643465	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	451	2.26e-122	NTclustered	gi\|225696180\|gb\|FJ805847.1\|	259957	g37686	i0	96.679	98.681660899654	271	9	94	0	1	271	2473	2743	Uncultured Chroococcidiopsis sp. clone AU1_6 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28519	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5863067	5863067	PRJNA781196_P_NODE_60145_length_246_cov_1.352601_g59768_i0	PRJNA781196	60145	246	1.352601	3.32739846	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	231	2.6599999999999996e-56	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g59768	i0	96.429	85.4390243902439	140	5	72	0	38	177	1753	1614	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	21018	231	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6315387	6315387	PRJNA781196_P_NODE_57225_length_248_cov_0.914286_g56848_i0	PRJNA781196	57225	248	0.914286	2.26742928	Nostoc	1177	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|586962788\|gb\|KF921498.1\|	1464557	g56848	i0	99.597	112.987903225806	248	1	100	0	1	248	1225	978	Nostoc sp. PAN-549 16S ribosomal RNA gene, partial sequence	blastn	28021	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PAN-549
7138030	7138030	PRJNA781196_P_NODE_44006_length_270_cov_1.187817_g43629_i0	PRJNA781196	44006	270	1.187817	3.2071059	uncultured cyanobacterium	1211	Bacteria	Bacteria	383	7.73e-102	NTclustered	gi\|2874253781\|emb\|OY969765.1\|	1211	g43629	i0	92.222	135.151851851852	270	21	100	0	1	270	2239543	2239274	MAG: uncultured cyanobacterium isolate MFD03250.bin.1.145 genome assembly, chromosome: 1	blastn	36491	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
7138057	7138057	PRJNA781196_P_NODE_45666_length_265_cov_1.312500_g45289_i0	PRJNA781196	45666	265	1.3125	3.478125	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	479	9.38e-131	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g45289	i0	99.245	166.932075471698	265	2	100	0	1	265	1244607	1244343	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	44237	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
7589367	7589367	PRJNA781196_P_NODE_56946_length_248_cov_2.045714_g56569_i0	PRJNA781196	56946	248	2.045714	5.07337072	Myxosarcina	52605	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|321271924\|gb\|HQ419021.1\|	1211	g56569	i0	99.597	100.673387096774	248	1	100	0	1	248	678	431	Uncultured cyanobacterium clone AL66_2CY_12 16S ribosomal RNA gene, partial sequence	blastn	24967	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
9687935	9687935	PRJNA781196_P_NODE_47828_length_258_cov_1.881081_g47451_i0	PRJNA781196	47828	258	1.881081	4.85318898	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	436	5.549999999999999e-118	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g47451	i0	97.287	217.496124031008	258	6	100	1	1	258	1857871	1857615	Calothrix sp. PCC 7716 DNA, complete genome	blastn	56114	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
11415168	11415168	PRJNA781196_P_NODE_39489_length_284_cov_3.109005_g39112_i0	PRJNA781196	39489	284	3.109005	8.8295742	Oscillatoriales	1150	Bacteria	Bacteria	505	1.67e-138	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g39112	i0	98.601	152.18661971831	286	2	100	2	1	284	1467	1182	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	43221	505	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
19062847	19062847	PRJNA781196_P_NODE_14375_length_433_cov_1.586111_g13998_i0	PRJNA781196	14375	433	1.586111	6.86786063	Cyanophyceae	3028117	Bacteria	Bacteria	717	0	NTclustered	gi\|385721928\|gb\|JQ253477.1\|	1211	g13998	i0	96.536	102.069284064665	433	15	100	0	1	433	318	750	Uncultured cyanobacterium clone QULP1F4 16S ribosomal RNA gene, partial sequence	blastn	44196	717	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20337704	20337704	PRJNA781196_P_NODE_49836_length_253_cov_1.250000_g49459_i0	PRJNA781196	49836	253	1.25	3.1625	Cyanophyceae	3028117	Bacteria	Bacteria	368	2.01e-97	NTclustered	gi\|146740647\|emb\|AM709634.1\|	372780	g49459	i0	92.941	158.418972332016	255	14	100	4	1	253	2629	2881	Fischerella muscicola SAG 2027 partial ribosomal RNA operon, strain SAG 2027	blastn	40080	368	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella muscicola
22436893	22436893	PRJNA781196_P_NODE_55878_length_249_cov_0.886364_g55501_i0	PRJNA781196	55878	249	0.886364	2.20704636	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont'	1618022	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1349670869\|gb\|CP026692.1\|	1618022	g55501	i0	100	0.112449799196787	28	0	11	0	85	112	998391	998418	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont' strain 5183 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont'
23711795	23711795	PRJNA781196_P_NODE_13359_length_447_cov_1.593583_g12982_i0	PRJNA781196	13359	447	1.593583	7.12331601	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	658	0	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g12982	i0	93.289	226.695749440716	447	29	100	1	1	447	3669738	3669293	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	101333	658	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1

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