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

18 rows where analysis = "blastn", bioproject = "PRJNA527965" 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
3665602	3665602	PRJNA527965_S_NODE_5523_length_159_cov_3.959677_g5440_i0	PRJNA527965	5523	159	3.959677	6.29588643	Cyanophyceae	3028117	Bacteria	Bacteria	219	1.23e-52	NTclustered	gi\|745734093\|gb\|KM458399.1\|	156210	g5440	i0	91.72	115.603773584906	157	13	99	0	1	157	220	376	Uncultured Oscillatoriales cyanobacterium isolate OTU 00162 23S ribosomal RNA gene, partial sequence	blastn	18381	219	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			uncultured Oscillatoriales cyanobacterium
3665603	3665603	PRJNA527965_S_NODE_5643_length_157_cov_54.090164_g5560_i0	PRJNA527965	5643	157	54.090164	84.92155748	root	1	Root_unresolved	Root_unresolved	291	2.52e-74	NTclustered	gi\|192763991\|gb\|EU780332.1\|	1211	g5560	i0	100	103	157	0	100	0	1	157	737	581	Uncultured cyanobacterium clone 1DP2-B8 16S ribosomal RNA gene, partial sequence	blastn	16171	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
4323877	4323877	PRJNA527965_S_NODE_964_length_372_cov_3.225519_g881_i0	PRJNA527965	964	372	3.225519	11.99893068	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	529	1.3399999999999997e-145	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g881	i0	94	181.698924731183	350	20	94	1	21	369	3669913	3669564	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	67592	529	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
6874555	6874555	PRJNA527965_S_NODE_3946_length_191_cov_4.230769_g3863_i0	PRJNA527965	3946	191	4.230769	8.08076879	Acaryochloris sp. 'Moss Beach'	2740837	Bacteria	Bacteria	235	1.52e-57	NTclustered	gi\|2179753748\|gb\|CP071717.1\|	2740837	g3863	i0	89.362	172.560209424084	188	19	100	1	4	191	5143146	5142960	Acaryochloris sp. 'Moss Beach' chromosome, complete genome	blastn	32959	235	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris sp. 'Moss Beach'
10042858	10042858	PRJNA527965_S_NODE_5248_length_163_cov_3.296875_g5165_i0	PRJNA527965	5248	163	3.296875	5.37390625	Cyanophyceae	3028117	Bacteria	Bacteria	263	5.77e-66	NTclustered	gi\|225696213\|gb\|FJ805880.1\|	259957	g5165	i0	95.706	117.171779141104	163	7	100	0	1	163	2893	3055	Uncultured Chroococcidiopsis sp. clone A3_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	19099	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10700825	10700825	PRJNA527965_S_NODE_1629_length_303_cov_1.847015_g1546_i0	PRJNA527965	1629	303	1.847015	5.59645545	Chamaesiphon minutus	1173032	Bacteria	Bacteria	377	4.0999999999999994e-100	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g1546	i0	91.912	134.237623762376	272	18	89	4	1	271	1153	1421	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	40674	377	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
14525715	14525715	PRJNA527965_S_NODE_1092_length_356_cov_52.682243_g1009_i0	PRJNA527965	1092	356	52.682243	187.54878508	Chamaesiphon minutus	1173032	Bacteria	Bacteria	566	9.729999999999999e-157	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g1009	i0	95.48	155.542134831461	354	16	99	0	1	354	2272	1919	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	55373	566	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
15142404	15142404	PRJNA527965_S_NODE_3752_length_196_cov_8.571429_g3669_i0	PRJNA527965	3752	196	8.571429	16.80000084	Nostocaceae	1162	Bacteria	Bacteria	346	6.94e-91	NTclustered	gi\|46409894\|gb\|AY584519.1\|	63737	g3669	i0	98.469	294.44387755102	196	3	100	0	1	196	640	445	Nostoc punctiforme PCC 73102 23S ribosomal RNA gene, partial sequence	blastn	57711	346	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
15142422	15142422	PRJNA527965_S_NODE_5232_length_163_cov_32.218750_g5149_i0	PRJNA527965	5232	163	32.21875	52.5165625	root	1	Root_unresolved	Root_unresolved	302	1.22e-77	NTclustered	gi\|83284904\|gb\|DQ289925.1\|	1211	g5149	i0	100	106	163	0	100	0	1	163	882	720	Uncultured cyanobacterium clone SC3-15 16S ribosomal RNA gene, partial sequence	blastn	17278	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
17692187	17692187	PRJNA527965_S_NODE_4234_length_184_cov_1.369128_g4151_i0	PRJNA527965	4234	184	1.369128	2.51919552	Cyanophyceae	3028117	Bacteria	Bacteria	213	6.8e-51	NTclustered	gi\|984535223\|dbj\|AP017367.1\|	1080068	g4151	i0	88.268	128.315217391304	179	19	97	2	4	181	281984	281807	Leptolyngbya sp. O-77 DNA, complete genome	blastn	23610	215	0.990697674418605	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. O-77
18348388	18348388	PRJNA527965_S_NODE_2055_length_272_cov_1.561181_g1972_i0	PRJNA527965	2055	272	1.561181	4.24641232	Chamaesiphon minutus	1173032	Bacteria	Bacteria	481	2.69e-131	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g1972	i0	98.529	144.297794117647	272	4	100	0	1	272	1692	1421	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	39249	481	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
20898993	20898993	PRJNA527965_S_NODE_2477_length_245_cov_2.938095_g2394_i0	PRJNA527965	2477	245	2.938095	7.19833275	Synechocystis pevalekii	1392622	Bacteria	Bacteria	320	5.49e-83	NTclustered	gi\|1035493918\|gb\|KT354206.1\|	1858734	g2394	i0	90.833	278.714285714286	240	20	98	2	1	239	1023	785	Synechocystis pevalekii SAG 91.79 clone e 16S ribosomal RNA gene, partial sequence; tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	68285	320	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis pevalekii
21516262	21516262	PRJNA527965_S_NODE_1877_length_285_cov_6.120000_g1794_i0	PRJNA527965	1877	285	6.12	17.442	Aerosakkonema	1246629	Bacteria	Bacteria	455	1.72e-123	NTclustered	gi\|389547523\|gb\|JQ402451.1\|	1211	g1794	i0	95.455	100.575438596491	286	11	100	2	1	285	731	447	Uncultured cyanobacterium clone CNY_02799 16S ribosomal RNA gene, partial sequence	blastn	28664	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22173648	22173648	PRJNA527965_S_NODE_2758_length_230_cov_39.051282_g2675_i0	PRJNA527965	2758	230	39.051282	89.8179486	Acaryochloris sp. 'Moss Beach'	2740837	Bacteria	Bacteria	359	1.0799999999999999e-94	NTclustered	gi\|2179753748\|gb\|CP071717.1\|	2740837	g2675	i0	94.783	173.013043478261	230	12	100	0	1	230	5144117	5144346	Acaryochloris sp. 'Moss Beach' chromosome, complete genome	blastn	39793	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris sp. 'Moss Beach'
22791461	22791461	PRJNA527965_S_NODE_798_length_400_cov_6.564384_g715_i0	PRJNA527965	798	400	6.564384	26.257536	Nostocales	1161	Bacteria	Bacteria	457	6.95e-124	NTclustered	gi\|1796909370\|gb\|CP046703.1\|	76335	g715	i0	92.26	242.4725	323	23	80	1	80	400	3059017	3058695	Nostoc sp. ATCC 53789 chromosome, complete genome	blastn	96989	457	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 53789
23449302	23449302	PRJNA527965_S_NODE_5499_length_160_cov_1.168000_g5416_i0	PRJNA527965	5499	160	1.168	1.8688	Nostoc longstaffi	2094034	Bacteria	Bacteria	60.2	7.93e-5	NTclustered	gi\|1358126406\|gb\|KY963604.1\|	2094035	g5416	i0	77.228	0.825	101	23	63	0	38	138	532	432	Nostoc longstaffi UTEX LB 1626 23S ribosomal RNA gene, partial sequence	blastn	132	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc longstaffi
24066202	24066202	PRJNA527965_S_NODE_1339_length_328_cov_151.583618_g1256_i0	PRJNA527965	1339	328	151.583618	497.19426704	root	1	Root_unresolved	Root_unresolved	568	2.4799999999999995e-157	NTclustered	gi\|332656092\|gb\|JF733401.1\|	751952	g1256	i0	98.746	111.17987804878	319	4	97	0	10	328	1	319	Uncultured Cyanobacterium sp. clone LI07st1 16S ribosomal RNA gene, partial sequence	blastn	36467	573	0.991273996509599	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	uncultured Cyanobacterium sp.
24722904	24722904	PRJNA527965_S_NODE_2620_length_237_cov_3.757426_g2537_i0	PRJNA527965	2620	237	3.757426	8.90509962	Synechocystis pevalekii	1392622	Bacteria	Bacteria	359	1.12e-94	NTclustered	gi\|1035493918\|gb\|KT354206.1\|	1858734	g2537	i0	95.536	144.502109704641	224	10	95	0	14	237	967	744	Synechocystis pevalekii SAG 91.79 clone e 16S ribosomal RNA gene, partial sequence; tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34247	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis pevalekii

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