metadata: contig_metadata: 21 rows where bioproject = "PRJNA188516" and tax_clade = "Cyanobacteriota/Melainabacteria group"

21 rows where bioproject = "PRJNA188516" 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
5469179	5469179	PRJNA188516_P_NODE_5905_length_162_cov_1.380531_g5855_i0	PRJNA188516	5905	162	1.380531	2.23646022	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	195	2.12e-45	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5855	i0	88.415	1.96296296296296	164	15	100	4	1	162	2594201	2594040	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	318	195	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
6157914	6157914	PRJNA188516_P_NODE_1145_length_350_cov_2.289037_g1095_i0	PRJNA188516	1145	350	2.289037	8.0116295	Nostocaceae	1162	Bacteria	Bacteria	630	3.3399999999999984e-176	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g1095	i0	99.145	282.274285714286	351	1	100	2	1	350	2378397	2378746	Nostoc sp. PCC 7120 DNA, complete genome	blastn	98796	630	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
8707918	8707918	PRJNA188516_P_NODE_1707_length_271_cov_1.495495_g1657_i0	PRJNA188516	1707	271	1.495495	4.05279145	Microcoleus	44471	Bacteria	Bacteria	496	9.55e-136	NTclustered	gi\|389547084\|gb\|JQ402012.1\|	1211	g1657	i0	99.631	100.007380073801	271	1	100	0	1	271	24	294	Uncultured cyanobacterium clone CNY_02268 16S ribosomal RNA gene, partial sequence	blastn	27102	496	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
8707919	8707919	PRJNA188516_P_NODE_2407_length_221_cov_1.558140_g2357_i0	PRJNA188516	2407	221	1.55814	3.4434894	Chroococcidiopsis	54298	Bacteria	Bacteria	324	3.76e-84	NTclustered	gi\|225696259\|gb\|FJ805926.1\|	259957	g2357	i0	93.213	149.085972850679	221	14	100	1	1	221	2855	3074	Uncultured Chroococcidiopsis sp. clone AS3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32948	327	0.990825688073395	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9983243	9983243	PRJNA188516_P_NODE_568_length_522_cov_1.534884_g518_i0	PRJNA188516	568	522	1.534884	8.01209448	Nostocaceae	1162	Bacteria	Bacteria	926	0	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g518	i0	98.844	303.890804597701	519	6	100	0	4	522	2378274	2377756	Nostoc sp. PCC 7120 DNA, complete genome	blastn	158631	926	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
11844376	11844376	PRJNA188516_P_NODE_370_length_666_cov_1.894652_g326_i0	PRJNA188516	370	666	1.894652	12.61838232	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	913	0	NTclustered	gi\|225696282\|gb\|FJ805949.1\|	259957	g326	i0	91.48	158.65015015015	669	50	100	7	1	666	2626	1962	Uncultured Chroococcidiopsis sp. clone AS5_7 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	105661	913	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13119557	13119557	PRJNA188516_P_NODE_2311_length_226_cov_1.395480_g2261_i0	PRJNA188516	2311	226	1.39548	3.1537848	Plectolyngbya koreana	3016458	Bacteria	Bacteria	283	6.55e-72	NTclustered	gi\|2106138547\|gb\|OK382087.1\|	2880695	g2261	i0	89.778	146.101769911504	225	18	99	5	1	223	2030	2251	Plectolyngbya koreana FBCC-A1478 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33019	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Plectolyngbya	Plectolyngbya koreana
15668560	15668560	PRJNA188516_P_NODE_1613_length_281_cov_1.512931_g1563_i0	PRJNA188516	1613	281	1.512931	4.25133611	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	453	6.08e-123	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g1563	i0	95.73	110.142348754448	281	12	100	0	1	281	3568	3848	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	30950	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20181248	20181248	PRJNA188516_P_NODE_3936_length_171_cov_0.852459_g3886_i0	PRJNA188516	3936	171	0.852459	1.45770489	root	1	Root_unresolved	Root_unresolved	311	2.14e-80	NTclustered	gi\|321140180\|gb\|GQ325743.1\|	1211	g3886	i0	99.415	102.602339181287	171	1	100	0	1	171	449	279	Uncultured cyanobacterium clone SP1_1B_34 16S ribosomal RNA gene, partial sequence	blastn	17545	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
21456968	21456968	PRJNA188516_P_NODE_577_length_518_cov_2.176972_g527_i0	PRJNA188516	577	518	2.176972	11.27671496	Nostocaceae	1162	Bacteria	Bacteria	880	0	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g527	i0	97.476	285.353281853282	515	13	100	0	1	515	2380475	2380989	Nostoc sp. PCC 7120 DNA, complete genome	blastn	147813	885	0.994350282485876	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
23317879	23317879	PRJNA188516_P_NODE_2099_length_238_cov_2.306878_g2049_i0	PRJNA188516	2099	238	2.306878	5.49036964	Oculatella lusitanica	2928764	Bacteria	Bacteria	407	3.9599999999999994e-109	NTclustered	gi\|1793889078\|gb\|MN061918.1\|	2692086	g2049	i0	97.872	148.323529411765	235	5	99	0	4	238	3223	2989	Oculatella lusitanica LEGE 161147 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	35301	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella lusitanica
27579410	27579410	PRJNA188516_P_NODE_5264_length_165_cov_0.896552_g5214_i0	PRJNA188516	5264	165	0.896552	1.4793108	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	99	9.53e-24	NR	HEY9753936.1	3088181	g5214	i0	100	0.981818181818182	54	0	98.2	0	164	3	3	56	HEY9753936.1 response regulator transcription factor [Oculatellaceae cyanobacterium]	diamond	162	99	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
28495264	28495264	PRJNA188516_P_NODE_4527_length_167_cov_1.762712_g4477_i0	PRJNA188516	4527	167	1.762712	2.94372904	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	44.3	0.00118	NR	PZM84364.1	2052166	g4477	i0	80	0.449101796407186	25	5	44.9	0	1	75	68	92	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	75	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
28621533	28621533	PRJNA188516_P_NODE_5687_length_163_cov_0.912281_g5637_i0	PRJNA188516	5687	163	0.912281	1.48701803	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	96.7	1.13e-21	NR	HEY9756923.1	3088181	g5637	i0	100	0.865030674846626	47	0	86.5	0	142	2	1	47	HEY9756923.1 SPFH domain-containing protein [Oculatellaceae cyanobacterium]	diamond	141	96.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
29000666	29000666	PRJNA188516_P_NODE_6188_length_160_cov_14.765766_g6138_i0	PRJNA188516	6188	160	14.765766	23.6252256	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	48.5	7.14e-6	NR	MBX9722867.1	2364082	g6138	i0	58.1	0.80625	43	18	80.6	0	27	155	14	56	MBX9722867.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	129	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29158348	29158348	PRJNA188516_P_NODE_4129_length_169_cov_0.866667_g4079_i0	PRJNA188516	4129	169	0.866667	1.46466723	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	115	4.61e-28	NR	HEY9760369.1	3088181	g4079	i0	96.4	0.994082840236686	56	2	99.4	0	168	1	124	179	HEY9760369.1 ATP-binding protein [Oculatellaceae cyanobacterium]	diamond	168	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
29316023	29316023	PRJNA188516_P_NODE_4029_length_169_cov_0.866667_g3979_i0	PRJNA188516	4029	169	0.866667	1.46466723	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	68.2	1.54e-12	NR	HEY9755221.1	3088181	g3979	i0	100	0.585798816568047	33	0	58.6	0	100	2	1	33	HEY9755221.1 group III truncated hemoglobin [Oculatellaceae cyanobacterium]	diamond	99	68.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
29979153	29979153	PRJNA188516_P_NODE_3671_length_176_cov_9.724409_g3621_i0	PRJNA188516	3671	176	9.724409	17.11495984	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	46.6	5.25e-5	NR	MBX9722867.1	2364082	g3621	i0	53.8	0.886363636363636	52	23	88.6	1	13	168	10	60	MBX9722867.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	156	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30579229	30579229	PRJNA188516_P_NODE_5773_length_163_cov_0.912281_g5723_i0	PRJNA188516	5773	163	0.912281	1.48701803	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	113	2.36e-28	NR	HEY9755099.1	3088181	g5723	i0	100	0.993865030674847	54	0	99.4	0	1	162	239	292	HEY9755099.1 NAD(P)-dependent alcohol dehydrogenase [Oculatellaceae cyanobacterium]	diamond	162	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
32051614	32051614	PRJNA188516_P_NODE_5378_length_164_cov_0.904348_g5328_i0	PRJNA188516	5378	164	0.904348	1.48313072	Cyanophyceae	3028117	Bacteria	Bacteria	72.8	3.21e-13	NR	WP_242578028.1	1974212	g5328	i0	66	2.94512195121951	53	18	97	0	6	164	392	444	WP_242578028.1 hypothetical protein [Chroococcus sp. FPU101]	diamond	483	72.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. FPU101
32273306	32273306	PRJNA188516_P_NODE_4198_length_169_cov_0.866667_g4148_i0	PRJNA188516	4198	169	0.866667	1.46466723	Bacillati	1783272	Bacteria	Bacteria	56.2	8.49e-9	NR	MDR3613109.1	2364082	g4148	i0	100	1.43786982248521	27	0	47.9	0	89	169	1	27	MDR3613109.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	243	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales 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);;