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

23 rows where analysis = "blastn", bioproject = "PRJNA193544" 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
1055251	1055251	PRJNA193544_S_NODE_1581_length_209_cov_32.500000_g1566_i0	PRJNA193544	1581	209	32.5	67.925	Woronichinia	283819	Bacteria	Bacteria	387	4.42e-103	NTclustered	gi\|82622636\|gb\|DQ264221.1\|	358565	g1566	i0	100	102.8995215311	209	0	100	0	1	209	277	485	Woronichinia naegeliana 1ES42S1 16S ribosomal RNA gene, partial sequence	blastn	21506	387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Coelosphaeriaceae	Woronichinia	Woronichinia naegeliana
1640639	1640639	PRJNA193544_S_NODE_1002_length_250_cov_2824.429864_g987_i0	PRJNA193544	1002	250	2824.429864	7061.07466	Woronichinia naegeliana	283820	Bacteria	Bacteria	379	9.139999999999998e-101	NTclustered	gi\|2307062866\|gb\|CP073041.1\|	2824559	g987	i0	99.519	130.364	208	1	83	0	43	250	3380423	3380216	MAG: Woronichinia naegeliana WA131 chromosome, complete genome	blastn	32591	379	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Coelosphaeriaceae	Woronichinia	Woronichinia naegeliana
3605691	3605691	PRJNA193544_S_NODE_1263_length_226_cov_19835.761421_g1248_i0	PRJNA193544	1263	226	19835.761421	44828.82081146	Microcystis	1125	Bacteria	Bacteria	346	8.24e-91	NTclustered	gi\|1566846205\|dbj\|LC455583.1\|	1126	g1248	i0	100	109.03982300884999	187	0	83	0	40	226	426	240	Microcystis aeruginosa NIES-3804 gene for 23S ribosomal RNA, partial sequence	blastn	24643	346	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
4883200	4883200	PRJNA193544_S_NODE_1764_length_201_cov_74.738372_g1749_i0	PRJNA193544	1764	201	74.738372	150.22412772	Cyanophyceae	3028117	Bacteria	Bacteria	337	4.309999999999999e-88	NTclustered	gi\|662702554\|gb\|CP007542.1\|	1147	g1749	i0	97	158.592039800995	200	6	99	0	1	200	1159669	1159470	Synechocystis sp. PCC 6714, complete genome	blastn	31877	337	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 6714
5469247	5469247	PRJNA193544_S_NODE_625_length_298_cov_11.360595_g610_i0	PRJNA193544	625	298	11.360595	33.8545731	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	375	1.4499999999999995e-99	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g610	i0	90.526	191.91610738255	285	25	96	2	2	286	273	555	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	57191	375	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
6157964	6157964	PRJNA193544_S_NODE_2285_length_181_cov_7.217105_g2270_i0	PRJNA193544	2285	181	7.217105	13.06296005	Oscillatoria	1158	Bacteria	Bacteria	305	1.07e-78	NTclustered	gi\|604494736\|gb\|KF029609.1\|	1211	g2270	i0	98.276	96.0055248618785	174	3	96	0	1	174	456	629	Uncultured cyanobacterium clone 10.1.11-006_Isolat_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	17377	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
8019260	8019260	PRJNA193544_S_NODE_2187_length_184_cov_9.903226_g2172_i0	PRJNA193544	2187	184	9.903226	18.22193584	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	150	5.41e-32	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g2172	i0	87.597	288.467391304348	129	16	70	0	56	184	129	1	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	53078	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
8707991	8707991	PRJNA193544_S_NODE_747_length_281_cov_9.345238_g732_i0	PRJNA193544	747	281	9.345238	26.26011878	Microcystis	1125	Bacteria	Bacteria	448	2.8299999999999996e-121	NTclustered	gi\|1861038497\|dbj\|LC557444.1\|	1126	g732	i0	95.699	152.512455516014	279	10	99	2	4	281	1123	846	Microcystis aeruginosa NIES-1356 gene for 23S rRNA, partial sequence	blastn	42856	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
9983263	9983263	PRJNA193544_S_NODE_1048_length_246_cov_17063.635945_g1033_i0	PRJNA193544	1048	246	17063.635945000002	41976.5444247	root	1	Root_unresolved	Root_unresolved	339	1.5199999999999998e-88	NTclustered	gi\|452814324\|gb\|KC492891.1\|	1211	g1033	i0	95.305	87.4837398373984	213	10	87	0	1	213	551	763	Uncultured cyanobacterium clone E30 16S ribosomal RNA gene, partial sequence	blastn	21521	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
9983287	9983287	PRJNA193544_S_NODE_2628_length_170_cov_250.212766_g2613_i0	PRJNA193544	2628	170	250.212766	425.3617022	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|104717658\|gb\|DQ512808.1\|	1211	g2613	i0	100	113	170	0	100	0	1	170	860	1029	Uncultured cyanobacterium clone GPENV18 16S ribosomal RNA gene, partial sequence	blastn	19210	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
10569977	10569977	PRJNA193544_S_NODE_3129_length_157_cov_78.304688_g3114_i0	PRJNA193544	3129	157	78.304688	122.93836016	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	257	2.5600000000000003e-64	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g3114	i0	96.178	460.388535031847	157	6	100	0	1	157	4315378	4315534	Leptolyngbya sp. 7M chromosome	blastn	72281	257	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
13119653	13119653	PRJNA193544_S_NODE_1471_length_215_cov_4.897849_g1456_i0	PRJNA193544	1471	215	4.897849	10.53037535	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	172	1.39e-38	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g1456	i0	81.193	149.693023255814	218	37	100	3	1	215	598018	598234	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	32184	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
13808638	13808638	PRJNA193544_S_NODE_1551_length_211_cov_8.774725_g1536_i0	PRJNA193544	1551	211	8.774725	18.51466975	Bacillati	1783272	Bacteria	Bacteria	335	1.6399999999999994e-87	NTclustered	gi\|662702554\|gb\|CP007542.1\|	1147	g1536	i0	95.283	166.758293838863	212	8	100	2	1	211	1158303	1158513	Synechocystis sp. PCC 6714, complete genome	blastn	35186	335	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 6714
13808641	13808641	PRJNA193544_S_NODE_1651_length_205_cov_20532.511364_g1636_i0	PRJNA193544	1651	205	20532.511364	42091.6482962	root	1	Root_unresolved	Root_unresolved	318	1.6e-82	NTclustered	gi\|786320040\|gb\|KP076568.1\|	1211	g1636	i0	100	89.7463414634146	172	0	84	0	34	205	1292	1121	Uncultured cyanobacterium clone M8UC_PoM_0m_09 16S ribosomal RNA gene, complete sequence	blastn	18398	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
17632861	17632861	PRJNA193544_S_NODE_1554_length_210_cov_22048.220994_g1539_i0	PRJNA193544	1554	210	22048.220994	46301.2640874	root	1	Root_unresolved	Root_unresolved	285	1.67e-72	NTclustered	gi\|58199876\|gb\|AY689914.1\|	1211	g1539	i0	96	84.152380952381	175	7	83	0	1	175	601	775	Uncultured cyanobacterium clone BPM3_G10 16S ribosomal RNA gene, partial sequence	blastn	17672	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
17632876	17632876	PRJNA193544_S_NODE_2994_length_160_cov_11.916031_g2979_i0	PRJNA193544	2994	160	11.916031	19.0656496	Cyanobacterium	102234	Bacteria	Bacteria	283	4.32e-72	NTclustered	gi\|192806191\|emb\|FM176595.1\|	1211	g2979	i0	100	95.63125	153	0	96	0	8	160	283	131	Uncultured cyanobacterium partial 16S rRNA gene, clone CL5.H402	blastn	15301	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
19491876	19491876	PRJNA193544_S_NODE_1956_length_193_cov_21409.018293_g1941_i0	PRJNA193544	1956	193	21409.018293	41319.40530549	Cyanobium usitatum	2304190	Bacteria	Bacteria	257	3.29e-64	NTclustered	gi\|2638501482\|emb\|OY986431.1\|	2116684	g1941	i0	95.625	129.911917098446	160	7	83	0	1	160	72810	72969	Cyanobium usitatum str. Tous isolate KAC_108 genome assembly, chromosome: 1	blastn	25073	257	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium usitatum
21457011	21457011	PRJNA193544_S_NODE_2877_length_163_cov_5.298507_g2862_i0	PRJNA193544	2877	163	5.298507	8.63656641	root	1	Root_unresolved	Root_unresolved	296	5.68e-76	NTclustered	gi\|469726262\|gb\|KC687162.1\|	1211	g2862	i0	99.387	100	163	1	100	0	1	163	520	682	Uncultured cyanobacterium clone cyE-6ic 16S ribosomal RNA gene, partial sequence	blastn	16300	296	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22042535	22042535	PRJNA193544_S_NODE_3178_length_156_cov_61.244094_g3163_i0	PRJNA193544	3178	156	61.244094	95.54078664	Chamaesiphon minutus	1173032	Bacteria	Bacteria	217	4.309999999999999e-52	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g3163	i0	91.667	439.948717948718	156	13	100	0	1	156	2449	2294	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	68632	217	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
22731995	22731995	PRJNA193544_S_NODE_1658_length_205_cov_267.500000_g1643_i0	PRJNA193544	1658	205	267.5	548.375	root	1	Root_unresolved	Root_unresolved	315	2.0699999999999998e-81	NTclustered	gi\|171221457\|gb\|EU414890.1\|	1211	g1643	i0	98.864	93.5317073170732	176	2	86	0	30	205	373	198	Uncultured cyanobacterium clone Fuku2-SW-PH49 16S ribosomal RNA gene, partial sequence	blastn	19174	316	0.996835443037975	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
24592112	24592112	PRJNA193544_S_NODE_1180_length_235_cov_54.470874_g1165_i0	PRJNA193544	1180	235	54.470874	128.0065539	Nodosilinea sp. E11	3037479	Bacteria	Bacteria	363	8.569999999999998e-96	NTclustered	gi\|2593238647\|gb\|CP136520.1\|	3037479	g1165	i0	94.468	133.510638297872	235	13	100	0	1	235	174217	174451	Nodosilinea sp. E11 chromosome	blastn	31375	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. E11
24592126	24592126	PRJNA193544_S_NODE_1860_length_197_cov_3697.071429_g1845_i0	PRJNA193544	1860	197	3697.071429	7283.23071513	Phormidium nigroviride	482564	Bacteria	Bacteria	276	9.3e-70	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g1845	i0	98.71	99.4365482233503	155	2	79	0	1	155	288	442	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	19589	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
25281331	25281331	PRJNA193544_S_NODE_560_length_305_cov_14566.007246_g545_i0	PRJNA193544	560	305	14566.007246	44426.3221003	Acaryochloris	155977	Bacteria	Bacteria	311	4.25e-80	NTclustered	gi\|470482548\|ref\|NR_076538.1\|	155978	g545	i0	87.454	157.068852459016	271	32	89	2	33	303	1366	1098	Acaryochloris marina strain MBIC11017 23S ribosomal RNA gene, complete sequence	blastn	47906	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris marina

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