metadata: contig_metadata: 25 rows where bioproject = "PRJNA721440" and tax_clade = "Cyanobacteriota/Melainabacteria group"

25 rows where bioproject = "PRJNA721440" 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
3745379	3745379	PRJNA721440_S_NODE_17803_length_167_cov_0.881356_g17677_i0	PRJNA721440	17803	167	0.881356	1.47186452	Nostocales	1161	Bacteria	Bacteria	174	2.87e-39	NTclustered	gi\|1210177014\|dbj\|AP018248.1\|	231146	g17677	i0	88.732	224.916167664671	142	16	85	0	1	142	1645247	1645106	Tolypothrix tenuis PCC 7101 DNA, nearly complete genome	blastn	37561	174	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix tenuis
7088946	7088946	PRJNA721440_S_NODE_6006_length_247_cov_2.424242_g5880_i0	PRJNA721440	6006	247	2.424242	5.98787774	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	346	9.14e-91	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g5880	i0	92.887	172.919028340081	239	16	97	1	1	239	2455	2692	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	42711	346	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8363482	8363482	PRJNA721440_S_NODE_6547_length_239_cov_3.373684_g6421_i0	PRJNA721440	6547	239	3.373684	8.06310476	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	442	1.0899999999999994e-119	NTclustered	gi\|225696182\|gb\|FJ805849.1\|	259957	g6421	i0	100	120.351464435146	239	0	100	0	1	239	3718	3480	Uncultured Chroococcidiopsis sp. clone AU1_8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28764	442	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10914176	10914176	PRJNA721440_S_NODE_2069_length_383_cov_45.727545_g1943_i0	PRJNA721440	2069	383	45.727545	175.13649735	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	240	3.8200000000000006e-79	NR	MBX9724270.1	2364082	g1943	i0	91.3	0.994778067885117	127	11	99.5	0	1	381	21	147	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	381	240	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
10914188	10914188	PRJNA721440_S_NODE_4049_length_289_cov_3.400000_g3923_i0	PRJNA721440	4049	289	3.4	9.826	Stanieria cyanosphaera PCC 7437	111780	Bacteria	Bacteria	166	2.09e-48	NR	CAC81002.1	111780	g3923	i0	78.9	0.986159169550173	95	20	98.6	0	3	287	44	138	CAC81002.1 NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating), partial [Stanieria cyanosphaera PCC 7437]	diamond	285	166	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
10914192	10914192	PRJNA721440_S_NODE_529_length_686_cov_11.480377_g432_i0	PRJNA721440	529	686	11.480377	78.75538622	Stanieria cyanosphaera	102116	Bacteria	Bacteria	329	2.82e-85	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g432	i0	79.61	26.731778425656	461	92	67	2	12	471	426	885	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	18338	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
17288202	17288202	PRJNA721440_S_NODE_5494_length_256_cov_4.251208_g5368_i0	PRJNA721440	5494	256	4.251208	10.88309248	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	459	1.1699999999999999e-124	NTclustered	gi\|225696216\|gb\|FJ805883.1\|	259957	g5368	i0	99.213	132.08984375	254	2	99	0	1	254	2605	2858	Uncultured Chroococcidiopsis sp. clone NA4_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33815	459	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19837088	19837088	PRJNA721440_S_NODE_18596_length_165_cov_0.991379_g18470_i0	PRJNA721440	18596	165	0.991379	1.63577535	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	248	1.64e-61	NTclustered	gi\|225696257\|gb\|FJ805924.1\|	259957	g18470	i0	93.939	105.50303030303	165	8	99	1	3	165	3356	3520	Uncultured Chroococcidiopsis sp. clone AS2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	17408	248	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21112744	21112744	PRJNA721440_S_NODE_1517_length_435_cov_5.173575_g1391_i0	PRJNA721440	1517	435	5.173575	22.50505125	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	638	2.54e-178	NTclustered	gi\|225696250\|gb\|FJ805917.1\|	259957	g1391	i0	93.034	115.758620689655	445	18	100	11	1	435	1811	2252	Uncultured Chroococcidiopsis sp. clone A1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	50355	638	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25420213	25420213	PRJNA721440_S_NODE_7440_length_228_cov_4.351955_g7314_i0	PRJNA721440	7440	228	4.351955	9.9224574	root	1	Root_unresolved	Root_unresolved	416	6.259999999999998e-112	NTclustered	gi\|242254648\|gb\|FJ844174.1\|	1211	g7314	i0	99.561	185	228	1	100	0	1	228	326	99	Uncultured cyanobacterium clone Cy09-12 16S ribosomal RNA gene, partial sequence	blastn	42180	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
26682550	26682550	PRJNA721440_S_NODE_3501_length_306_cov_1.319066_g3375_i0	PRJNA721440	3501	306	1.319066	4.03634196	Cyanophyceae	3028117	Bacteria	Bacteria	65.5	8.2e-10	NR	MCL1491895.1	2938918	g3375	i0	41.3	7.40196078431373	92	40	90.2	1	284	9	883	960	MCL1491895.1 PAS domain S-box protein [Pseudanabaena sp. Salubria-1]	diamond	2265	65.9	0.993930197268589	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. Salubria-1
26798831	26798831	PRJNA721440_S_NODE_5101_length_264_cov_2.483721_g4975_i0	PRJNA721440	5101	264	2.483721	6.55702344	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	150	5.17e-41	NR	MBX9694651.1	2847862	g4975	i0	85.9	0.965909090909091	85	12	96.6	0	6	260	179	263	MBX9694651.1 nicotinate phosphoribosyltransferase [Cyanobacteriota bacterium]	diamond	255	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27094091	27094091	PRJNA721440_S_NODE_15762_length_173_cov_2.290323_g15636_i0	PRJNA721440	15762	173	2.290323	3.96225879	root	1	Root_unresolved	Root_unresolved	96.3	2.01e-21	NR	MFN9176613.1	1143	g15636	i0	75.4	24.6763005780347	57	14	98.8	0	172	2	215	271	MFN9176613.1 glutamate synthase central domain-containing protein [Synechocystis sp.]	diamond	4269	97.1	0.991761071060762	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp.
27283788	27283788	PRJNA721440_S_NODE_5623_length_254_cov_1.653659_g5497_i0	PRJNA721440	5623	254	1.653659	4.20029386	Cyanophyceae	3028117	Bacteria	Bacteria	162	3.8700000000000003e-44	NR	WP_088890090.1	1962290	g5497	i0	92.9	6.94488188976378	84	6	99.2	0	3	254	988	1071	WP_088890090.1 magnesium chelatase subunit H [Leptolyngbya ohadii]	diamond	1764	162	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya ohadii
27463002	27463002	PRJNA721440_S_NODE_16643_length_170_cov_1.115702_g16517_i0	PRJNA721440	16643	170	1.115702	1.8966934	Nostoc sp. LEGE 1245	1180	Bacteria	Bacteria	51.6	1.03e-5	NR	WP_193950846.1	1828643	g16517	i0	45.6	2.98235294117647	57	26	98.8	2	170	3	182	234	WP_193950846.1 beta strand repeat-containing protein [Nostoc sp. LEGE 12450]	diamond	507	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. LEGE 12450
27526004	27526004	PRJNA721440_S_NODE_17383_length_168_cov_0.873950_g17257_i0	PRJNA721440	17383	168	0.87395	1.468236	Candidatus Gastranaerophilales bacterium HUM_13	1916221	Bacteria	Bacteria	45.4	0.00138	NR	DAB05885.1	1916221	g17257	i0	64.7	0.607142857142857	34	12	60.7	0	166	65	219	252	DAB05885.1 MAG TPA: recombinase RecA [Candidatus Gastranaerophilales bacterium HUM_13]	diamond	102	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium HUM_13
27715868	27715868	PRJNA721440_S_NODE_5664_length_253_cov_3.818627_g5538_i0	PRJNA721440	5664	253	3.818627	9.66112631	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	110	2.88e-27	NR	MBX9693408.1	2847862	g5538	i0	87.3	0.74703557312253	63	8	74.7	0	190	2	141	203	MBX9693408.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	189	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28978570	28978570	PRJNA721440_S_NODE_17128_length_168_cov_4.563025_g17002_i0	PRJNA721440	17128	168	4.563025	7.665882	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	47	4.34e-4	NR	MBX9694561.1	2847862	g17002	i0	64.1	0.696428571428571	39	10	62.5	1	114	10	15	53	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	117	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30209798	30209798	PRJNA721440_S_NODE_10092_length_204_cov_1.832258_g9966_i0	PRJNA721440	10092	204	1.832258	3.73780632	Trichodesmium erythraeum	1206	Bacteria	Bacteria	48.1	2.78e-4	NR	WP_011613745.1	1206	g9966	i0	35.6	0.867647058823529	59	37	85.3	1	193	20	347	405	WP_011613745.1 beta-galactosidase [Trichodesmium erythraeum]	diamond	177	48.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Trichodesmium	Trichodesmium erythraeum
30757669	30757669	PRJNA721440_S_NODE_13554_length_183_cov_1.507463_g13428_i0	PRJNA721440	13554	183	1.507463	2.75865729	root	1	Root_unresolved	Root_unresolved	91.3	1.32e-19	NR	WP_015191366.1	102116	g13428	i0	65	41.2950819672131	60	21	98.4	0	2	181	391	450	WP_015191366.1 isoleucine--tRNA ligase [Stanieria cyanosphaera]	diamond	7557	92	0.992391304347826	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
31189136	31189136	PRJNA721440_S_NODE_175_length_1018_cov_18.079463_g132_i0	PRJNA721440	175	1018	18.079463	184.04893334	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	439	1.3499999999999994e-151	NR	MBX9694561.1	2847862	g132	i0	76.1	2.59332023575638	276	65	81	1	2	826	47	322	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	2640	439	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31231398	31231398	PRJNA721440_S_NODE_4735_length_272_cov_1.784753_g4609_i0	PRJNA721440	4735	272	1.784753	4.85452816	root	1	Root_unresolved	Root_unresolved	48.9	3.73e-4	NR	MDV3002255.1	1521635	g4609	i0	41.5	3.65073529411765	82	38	90.4	2	27	272	1097	1168	MDV3002255.1 Tyrocidine synthase 3 [Chroococcopsis gigantea SAG 12.99]	diamond	993	49.3	0.991886409736308	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Chroococcopsis	Chroococcopsis gigantea
31821931	31821931	PRJNA721440_S_NODE_9977_length_205_cov_1.397436_g9851_i0	PRJNA721440	9977	205	1.397436	2.8647438	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	95.5	2.83e-23	NR	MBX9722668.1	2364082	g9851	i0	76.3	0.863414634146341	59	14	86.3	0	1	177	79	137	MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	177	95.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32328677	32328677	PRJNA721440_S_NODE_619_length_647_cov_2.372910_g512_i0	PRJNA721440	619	647	2.37291	15.3527277	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	192	2.13e-59	NR	MBX9692690.1	2847862	g512	i0	76.1	0.542503863987635	117	28	54.3	0	155	505	1	117	MBX9692690.1 (2Fe-2S)-binding protein [Cyanobacteriota bacterium]	diamond	351	192	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32644065	32644065	PRJNA721440_S_NODE_9400_length_209_cov_2.200000_g9274_i0	PRJNA721440	9400	209	2.2	4.598	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	125	7.97e-32	NR	MBX9694651.1	2847862	g9274	i0	88.2	0.976076555023923	68	8	97.6	0	205	2	115	182	MBX9694651.1 nicotinate phosphoribosyltransferase [Cyanobacteriota bacterium]	diamond	204	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium

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