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

25 rows where bioproject = "PRJNA283169" 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
2334237	2334237	PRJNA283169_S_NODE_302_length_452_cov_0.223325_g288_i0	PRJNA283169	302	452	0.223325	1.009429	root	1	Root_unresolved	Root_unresolved	804	0	NTclustered	gi\|166164465\|gb\|EU240730.1\|	1211	g288	i0	99.546	103.389380530973	441	2	98	0	1	441	290	730	Uncultured cyanobacterium clone CYN-2-4 16S ribosomal RNA gene, partial sequence	blastn	46732	809	0.993819530284302	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
5475202	5475202	PRJNA283169_P_NODE_6865_length_167_cov_0.864407_g6802_i0	PRJNA283169	6865	167	0.864407	1.44355969	Woronichinia naegeliana	283820	Bacteria	Bacteria	281	1.64e-71	NTclustered	gi\|2307062866\|gb\|CP073041.1\|	2824559	g6802	i0	97.006	1	167	5	100	0	1	167	5275967	5275801	MAG: Woronichinia naegeliana WA131 chromosome, complete genome	blastn	167	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Coelosphaeriaceae	Woronichinia	Woronichinia naegeliana
6749513	6749513	PRJNA283169_S_NODE_1266_length_241_cov_0.239583_g1252_i0	PRJNA283169	1266	241	0.239583	0.57739503	Chroococcidiopsis sp. CCMEE 010	2941234	Bacteria	Bacteria	302	1.95e-77	NTclustered	gi\|2594665719\|gb\|OR413562.1\|	2941234	g1252	i0	89.344	129.240663900415	244	21	100	3	1	241	2505	2264	Chroococcidiopsis sp. CCMEE 010 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31147	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 010
9299900	9299900	PRJNA283169_S_NODE_588_length_332_cov_0.159011_g574_i0	PRJNA283169	588	332	0.159011	0.52791652	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	603	6.889999999999997e-168	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g574	i0	99.398	121.192771084337	332	2	100	0	1	332	510	179	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	40236	603	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15086617	15086617	PRJNA283169_S_NODE_2972_length_169_cov_0.125000_g2958_i0	PRJNA283169	2972	169	0.125	0.21125	Bacteria	2	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|199584189\|gb\|FJ028681.1\|	1211	g2958	i0	100	99.9704142011834	169	0	100	0	1	169	617	449	Uncultured cyanobacterium clone SSB-11 16S ribosomal RNA gene, partial sequence	blastn	16895	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
15674539	15674539	PRJNA283169_S_NODE_733_length_301_cov_0.174603_g719_i0	PRJNA283169	733	301	0.174603	0.52555503	Nostoc sp. NIES-4103	2005458	Bacteria	Bacteria	366	8.81e-97	NTclustered	gi\|1210228378\|dbj\|AP018288.1\|	2005458	g719	i0	89.655	168.65780730897	290	26	96	4	13	301	4389758	4390044	Nostoc sp. NIES-4103 DNA, nearly complete genome	blastn	50766	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
16949139	16949139	PRJNA283169_P_NODE_3274_length_229_cov_1.388889_g3211_i0	PRJNA283169	3274	229	1.388889	3.18055581	Woronichinia naegeliana	283820	Bacteria	Bacteria	370	4.97e-98	NTclustered	gi\|2307062866\|gb\|CP073041.1\|	2824559	g3211	i0	97.248	48.0698689956332	218	6	97	0	12	229	41236	41019	MAG: Woronichinia naegeliana WA131 chromosome, complete genome	blastn	11008	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Coelosphaeriaceae	Woronichinia	Woronichinia naegeliana
17636618	17636618	PRJNA283169_P_NODE_1194_length_361_cov_3.391026_g1132_i0	PRJNA283169	1194	361	3.391026	12.24160386	Cyanophyceae	3028117	Bacteria	Bacteria	165	4.21e-36	NTclustered	gi\|1992526127\|gb\|CP070366.1\|	2811482	g1132	i0	85.625	90.8781163434903	160	19	44	4	204	361	4261257	4261100	Thermoleptolyngbya sp. PKUAC-SCTB121 chromosome, complete genome	blastn	32807	165	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya sp. PKUAC-SCTB121
20185045	20185045	PRJNA283169_P_NODE_2756_length_249_cov_2.155000_g2693_i0	PRJNA283169	2756	249	2.155	5.36595	Prochlorococcus	1218	Bacteria	Bacteria	180	9.91e-41	NTclustered	gi\|154949252\|gb\|CP000095.2\|	59920	g2693	i0	85.227	220.835341365462	176	24	70	2	57	231	374568	374742	Prochlorococcus marinus str. NATL2A, complete genome	blastn	54988	180	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
20773239	20773239	PRJNA283169_P_NODE_2037_length_286_cov_1.894515_g1975_i0	PRJNA283169	2037	286	1.894515	5.4183129	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	217	8.859999999999999e-52	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g1975	i0	83.065	35.9090909090909	248	32	85	10	9	251	4828971	4829213	Leptolyngbya sp. 7M chromosome	blastn	10270	217	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
20773318	20773318	PRJNA283169_S_NODE_1777_length_209_cov_0.062500_g1763_i0	PRJNA283169	1777	209	0.0625	0.130625	Woronichinia naegeliana	283820	Bacteria	Bacteria	375	9.57e-100	NTclustered	gi\|2307062866\|gb\|CP073041.1\|	2824559	g1763	i0	99.043	41.7751196172249	209	2	100	0	1	209	40898	41106	MAG: Woronichinia naegeliana WA131 chromosome, complete genome	blastn	8731	375	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Coelosphaeriaceae	Woronichinia	Woronichinia naegeliana
22048304	22048304	PRJNA283169_S_NODE_1078_length_256_cov_0.183575_g1064_i0	PRJNA283169	1078	256	0.183575	0.469952	Woronichinia naegeliana	283820	Bacteria	Bacteria	418	1.9899999999999994e-112	NTclustered	gi\|2307062866\|gb\|CP073041.1\|	2824559	g1064	i0	96.094	139.9375	256	10	100	0	1	256	3380992	3381247	MAG: Woronichinia naegeliana WA131 chromosome, complete genome	blastn	35824	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Coelosphaeriaceae	Woronichinia	Woronichinia naegeliana
24597856	24597856	PRJNA283169_P_NODE_1820_length_303_cov_1.192913_g1758_i0	PRJNA283169	1820	303	1.192913	3.61452639	Moorena producens	1155739	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|1082408432\|gb\|CP017599.1\|	1458985	g1758	i0	100	0.0924092409240924	28	0	9	0	110	137	3756954	3756927	Moorena producens PAL-8-15-08-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
27010745	27010745	PRJNA283169_P_NODE_8102_length_162_cov_0.911504_g8039_i0	PRJNA283169	8102	162	0.911504	1.47663648	Vampirovibrionales bacterium	2692181	Bacteria	Bacteria	104	2.5699999999999997e-24	NR	MEB3244940.1	2692181	g8039	i0	88.9	5	54	6	100	0	162	1	283	336	MEB3244940.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Vampirovibrionales bacterium]	diamond	810	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales			Vampirovibrionales bacterium
28400585	28400585	PRJNA283169_P_NODE_3886_length_212_cov_1.245399_g3823_i0	PRJNA283169	3886	212	1.245399	2.64024588	Chroococcales cyanobacterium	3088180	Bacteria	Bacteria	42.4	0.0346	NR	HEY9712213.1	3088180	g3823	i0	49.1	0.806603773584906	57	25	80.7	2	14	184	657	709	HEY9712213.1 fibronectin type III domain-containing protein [Chroococcales cyanobacterium]	diamond	171	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales			Chroococcales cyanobacterium
28481397	28481397	PRJNA283169_P_NODE_6406_length_169_cov_1.300000_g6343_i0	PRJNA283169	6406	169	1.3	2.197	Acaryochloris	155977	Bacteria	Bacteria	42.7	0.0036	NR	PZD74015.1	1764569	g6343	i0	43.6	1.95266272189349	55	29	94.1	2	162	4	35	89	PZD74015.1 hypothetical protein C1752_01762 [Acaryochloris thomasi RCC1774]	diamond	330	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris thomasi
29000832	29000832	PRJNA283169_P_NODE_5828_length_177_cov_1.625000_g5765_i0	PRJNA283169	5828	177	1.625	2.87625	Cyanobacteria bacterium J149	2420335	Bacteria	Bacteria	43.5	0.00432	NR	RMD72956.1	2420335	g5765	i0	70.4	0.457627118644068	27	8	45.8	0	95	175	3	29	RMD72956.1 MAG: hypothetical protein D6822_00435, partial [Cyanobacteria bacterium J149]	diamond	81	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J149
29239234	29239234	PRJNA283169_P_NODE_6249_length_171_cov_1.745902_g6186_i0	PRJNA283169	6249	171	1.745902	2.98549242	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	57	1.28e-7	NR	MFN7464261.1	1153	g6186	i0	48.1	1.89473684210526	54	28	94.7	0	5	166	290	343	MFN7464261.1 phage terminase large subunit [Pseudanabaena sp.]	diamond	324	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
29442250	29442250	PRJNA283169_S_NODE_2890_length_171_cov_0.139344_g2876_i0	PRJNA283169	2890	171	0.139344	0.23827824	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	55.8	3.43e-7	NR	MSR88993.1	2053573	g2876	i0	69.4	0.631578947368421	36	11	63.2	0	64	171	270	305	MSR88993.1 DUF229 domain-containing protein [Candidatus Margulisiibacteriota bacterium]	diamond	108	55.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
29979343	29979343	PRJNA283169_S_NODE_2491_length_182_cov_0.060150_g2477_i0	PRJNA283169	2491	182	0.06015	0.109473	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	108	7.69e-26	NR	MDD9898265.1	2052166	g2477	i0	85	0.989010989010989	60	9	98.9	0	182	3	481	540	MDD9898265.1 ribonucleoside-diphosphate reductase subunit alpha [Candidatus Melainabacteria bacterium]	diamond	180	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
31147936	31147936	PRJNA283169_P_NODE_2835_length_246_cov_2.091371_g2772_i0	PRJNA283169	2835	246	2.091371	5.14477266	Trichocoleus desertorum	1481672	Bacteria	Bacteria	53.5	4.98e-6	NR	MBW4487535.1	1382647	g2772	i0	43.8	0.780487804878049	64	31	75.6	2	239	54	160	220	MBW4487535.1 methyltransferase, TIGR04325 family [Trichocoleus desertorum ATA4-8-CV12]	diamond	192	53.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus desertorum
31717633	31717633	PRJNA283169_P_NODE_737_length_447_cov_1.565327_g675_i0	PRJNA283169	737	447	1.565327	6.99701169	Microcystis sp. M	1127	Bacteria	Bacteria	108	4.68e-24	NR	WP_287729196.1	2771171	g675	i0	41.7	0.932885906040268	139	78	93.3	1	420	4	7	142	WP_287729196.1 hypothetical protein [Microcystis sp. M061S2]	diamond	417	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M061S2
32065556	32065556	PRJNA283169_P_NODE_8198_length_162_cov_0.876106_g8135_i0	PRJNA283169	8198	162	0.876106	1.41929172	Planktothrix agardhii	1160	Bacteria	Bacteria	48.9	7.77e-5	NR	WP_071782872.1	1160	g8135	i0	52.5	0.740740740740741	40	19	74.1	0	5	124	184	223	WP_071782872.1 glycoside hydrolase family protein [Planktothrix agardhii]	diamond	120	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
32209910	32209910	PRJNA283169_P_NODE_6958_length_166_cov_1.230769_g6895_i0	PRJNA283169	6958	166	1.230769	2.04307654	Symploca	105591	Bacteria	Bacteria	60.5	1.37e-9	NR	HBL58647.1	2055779	g6895	i0	41.3	7.69879518072289	63	29	99.4	2	166	2	21	83	HBL58647.1 hypothetical protein [Cyanobacteria bacterium UBA8803]	diamond	1278	60.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA8803
32792052	32792052	PRJNA283169_P_NODE_7080_length_166_cov_0.880342_g7017_i0	PRJNA283169	7080	166	0.880342	1.46136772	Synechococcus lacustris	2116544	Bacteria	Bacteria	110	3.53e-29	NR	WP_353078761.1	2116544	g7017	i0	92.7	0.993975903614458	55	4	99.4	0	2	166	73	127	WP_353078761.1 hypothetical protein [Synechococcus lacustris]	diamond	165	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus lacustris

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