metadata: contig_metadata: 29 rows where bioproject = "PRJEB39643" and tax_clade = "Cyanobacteriota/Melainabacteria group"

29 rows where bioproject = "PRJEB39643" 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
5159760	5159760	PRJEB39643_P_NODE_134305_length_247_cov_0.885057_g134112_i0	PRJEB39643	134305	247	0.885057	2.18609079	Cyanobacterium sp. DS4	2878255	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2667402313\|gb\|CP084098.1\|	2878255	g134112	i0	100	0.11336032388664	28	0	11	0	195	222	4185989	4186016	Cyanobacterium sp. Dongsha4 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	Cyanobacterium sp. DS4
7367042	7367042	PRJEB39643_P_NODE_36266_length_310_cov_2.713080_g36073_i0	PRJEB39643	36266	310	2.71308	8.410548	root	1	Root_unresolved	Root_unresolved	270	7.339999999999999e-68	NTclustered	gi\|406654542\|gb\|JX463420.1\|	1211	g36073	i0	99.329	165.464516129032	149	1	96	0	161	309	405	257	Uncultured cyanobacterium clone SD-92 16S ribosomal RNA gene, partial sequence	blastn	51294	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
8984924	8984924	PRJEB39643_P_NODE_21188_length_395_cov_3.801242_g20995_i0	PRJEB39643	21188	395	3.801242	15.0149059	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	241	2.2300000000000003e-79	NR	MBX9724270.1	2364082	g20995	i0	89.3	0.994936708860759	131	14	99.5	0	2	394	20	150	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	393	241	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
11192856	11192856	PRJEB39643_P_NODE_39809_length_297_cov_5.687500_g39616_i0	PRJEB39643	39809	297	5.6875	16.891875	root	1	Root_unresolved	Root_unresolved	523	4.8599999999999986e-144	NTclustered	gi\|225420981\|gb\|FJ774032.1\|	1211	g39616	i0	98.973	109.498316498316	292	3	98	0	6	297	426	135	Uncultured cyanobacterium clone CYAVE50 16S ribosomal RNA gene, partial sequence	blastn	32521	525	0.996190476190476	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16634222	16634222	PRJEB39643_P_NODE_129254_length_248_cov_2.640000_g129061_i0	PRJEB39643	129254	248	2.64	6.5472	Geminocystis sp. NIES-3709	1617448	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|770470343\|dbj\|AP014821.1\|	1617448	g129061	i0	100	0.112903225806452	28	0	11	0	2	29	763786	763813	Geminocystis sp. NIES-3709 DNA, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. NIES-3709
20116037	20116037	PRJEB39643_P_NODE_42636_length_290_cov_1.419355_g42443_i0	PRJEB39643	42636	290	1.419355	4.1161295	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	60.2	1.6e-4	NTclustered	gi\|2395771017\|gb\|CP066886.2\|	147317	g42443	i0	100	29.851724137931	32	0	11	0	165	196	3349041	3349072	Arthrospira sp. PCC 9108 chromosome, complete genome	blastn	8657	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Arthrospira	Arthrospira sp. PCC 9108
26843692	26843692	PRJEB39643_P_NODE_140081_length_244_cov_2.900585_g139888_i0	PRJEB39643	140081	244	2.900585	7.0774274	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	75.1	1.19e-15	NR	MCX5952533.1	2847862	g139888	i0	68.8	0.590163934426229	48	15	59	0	50	193	33	80	MCX5952533.1 type II toxin-antitoxin system VapB family antitoxin [Cyanobacteriota bacterium]	diamond	144	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
26906836	26906836	PRJEB39643_P_NODE_146382_length_242_cov_1.822485_g146189_i0	PRJEB39643	146382	242	1.822485	4.4104137	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	146	1.5e-38	NR	MBX9572289.1	2364082	g146189	i0	91.3	0.991735537190083	80	7	99.2	0	1	240	691	770	MBX9572289.1 CusA/CzcA family heavy metal efflux RND transporter [Candidatus Obscuribacterales bacterium]	diamond	240	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
26994868	26994868	PRJEB39643_P_NODE_152322_length_236_cov_3.742331_g152129_i0	PRJEB39643	152322	236	3.742331	8.83190116	Nostocales	1161	Bacteria	Bacteria	47.8	5.7e-4	NR	BAY86718.1	1973488	g152129	i0	38.2	1.93220338983051	76	43	91.5	2	229	14	15	90	BAY86718.1 serine/threonine protein kinase [Calothrix parasitica NIES-267]	diamond	456	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix parasitica
27406263	27406263	PRJEB39643_P_NODE_121163_length_251_cov_4.460674_g120970_i0	PRJEB39643	121163	251	4.460674	11.19629174	root	1	Root_unresolved	Root_unresolved	111	2.56e-29	NR	MDX1919641.1	2729995	g120970	i0	57.7	1.9003984063745	78	33	93.2	0	14	247	6	83	MDX1919641.1 CoA-binding protein [Candidatus Caenarcanales bacterium]	diamond	477	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Candidatus Caenarcanales			Candidatus Caenarcanales bacterium
28423254	28423254	PRJEB39643_P_NODE_99186_length_261_cov_3.324468_g98993_i0	PRJEB39643	99186	261	3.324468	8.67686148	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	44.3	0.012	NR	HEY9814218.1	2364082	g98993	i0	36.4	1.01149425287356	88	53	98.9	2	258	1	109	195	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	264	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29086267	29086267	PRJEB39643_P_NODE_78388_length_271_cov_2.313131_g78195_i0	PRJEB39643	78388	271	2.313131	6.26858501	Leptolyngbya sp. FACHB-671	2692812	Bacteria	Bacteria	65.1	6.98e-10	NR	WP_190680589.1	2692812	g78195	i0	42.7	0.830258302583026	75	42	83	1	271	47	88	161	WP_190680589.1 MFS transporter [Leptolyngbya sp. FACHB-671]	diamond	225	65.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. FACHB-671
29306998	29306998	PRJEB39643_P_NODE_119449_length_252_cov_1.720670_g119256_i0	PRJEB39643	119449	252	1.72067	4.3360884	Aliterella atlantica	1827278	Bacteria	Bacteria	156	6.27e-44	NR	WP_045054637.1	1827278	g119256	i0	92.9	1	84	6	100	0	252	1	145	228	WP_045054637.1 MFS transporter [Aliterella atlantica]	diamond	252	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
29401771	29401771	PRJEB39643_P_NODE_113349_length_255_cov_1.692308_g113156_i0	PRJEB39643	113349	255	1.692308	4.3153854	unclassified Tolypothrix	2649714	Bacteria	Bacteria	58.5	5.32e-8	NR	WP_045872007.1	2649714	g113156	i0	37.6	2	85	49	95.3	2	245	3	29	113	WP_045872007.1 MULTISPECIES: GNAT family N-acetyltransferase [unclassified Tolypothrix]	diamond	510	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix
29433077	29433077	PRJEB39643_P_NODE_15750_length_466_cov_1.529262_g15558_i0	PRJEB39643	15750	466	1.529262	7.12636092	Trichodesmium sp. St18_bin1	2954180	Bacteria	Bacteria	46.2	0.0139	NR	MDE5083781.1	2954180	g15558	i0	43.1	0.373390557939914	58	33	37.3	0	5	178	162	219	MDE5083781.1 tetratricopeptide repeat protein [Trichodesmium sp. St18_bin1]	diamond	174	46.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Trichodesmium	Trichodesmium sp. St18_bin1
29464612	29464612	PRJEB39643_P_NODE_81470_length_270_cov_1.563452_g81277_i0	PRJEB39643	81470	270	1.563452	4.2213204	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	43.1	0.0328	NR	WP_009630551.1	927677	g81277	i0	94.7	0.211111111111111	19	1	21.1	0	76	20	237	255	WP_009630551.1 DUF6262 family protein [Synechocystis sp. PCC 7509]	diamond	57	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
29679042	29679042	PRJEB39643_P_NODE_34450_length_317_cov_2.081967_g34257_i0	PRJEB39643	34450	317	2.081967	6.59983539	Cyanophyceae	3028117	Bacteria	Bacteria	93.6	9.58e-20	NR	WP_038074680.1	1161	g34257	i0	47.3	14.1104100946372	93	46	86.1	2	44	316	367	458	WP_038074680.1 MULTISPECIES: carotenoid oxygenase family protein [Nostocales]	diamond	4473	94.4	0.991525423728813	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales
30089865	30089865	PRJEB39643_P_NODE_82592_length_269_cov_2.357143_g82399_i0	PRJEB39643	82592	269	2.357143	6.34071467	Kastovskya	1481159	Bacteria	Bacteria	129	1.84e-32	NR	MBW4649671.1	1446484	g82399	i0	62.9	5.93308550185874	89	33	99.3	0	3	269	18	106	MBW4649671.1 phosphoketolase family protein [Kastovskya adunca ATA6-11-RM4]	diamond	1596	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Kastovskya	Kastovskya adunca
30381307	30381307	PRJEB39643_P_NODE_10253_length_612_cov_2.434137_g10071_i0	PRJEB39643	10253	612	2.434137	14.89691844	Coleofasciculus sp. H7-2	3351545	Bacteria	Bacteria	57	1.37e-5	NR	WP_378174148.1	3351545	g10071	i0	28	0.647058823529412	132	81	62.3	3	595	215	459	581	WP_378174148.1 lipoxygenase family protein [Coleofasciculus sp. H7-2]	diamond	396	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. H7-2
30412897	30412897	PRJEB39643_P_NODE_89433_length_266_cov_1.595855_g89240_i0	PRJEB39643	89433	266	1.595855	4.2449743	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	50.4	7.69e-5	NR	HEY9814218.1	2364082	g89240	i0	39.3	0.947368421052632	84	39	88	5	1	234	181	258	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	252	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30760172	30760172	PRJEB39643_P_NODE_20174_length_406_cov_2.294294_g19981_i0	PRJEB39643	20174	406	2.294294	9.31483364	Planktothricoides sp. SR	1705388	Bacteria	Bacteria	92.8	2.56e-19	NR	WP_054465679.1	1705388	g19981	i0	46.4	1.38916256157635	97	52	71.7	0	392	102	263	359	WP_054465679.1 ATP-dependent 6-phosphofructokinase [Planktothricoides sp. SR001]	diamond	564	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides	Planktothricoides sp. SR001
31132319	31132319	PRJEB39643_P_NODE_50435_length_286_cov_1.446009_g50242_i0	PRJEB39643	50435	286	1.446009	4.13558574	Cyanophyceae	3028117	Bacteria	Bacteria	146	3.13e-40	NR	MDJ0598522.1	2729996	g50242	i0	68.1	7.88811188811189	94	30	98.6	0	3	284	190	283	MDJ0598522.1 alkene reductase [Crocosphaera sp.]	diamond	2256	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera sp.
31163924	31163924	PRJEB39643_P_NODE_27395_length_350_cov_3.126354_g27202_i0	PRJEB39643	27395	350	3.126354	10.942239	Bacteria	2	Bacteria	Bacteria	157	4.62e-42	NR	WP_181256584.1	292586	g27202	i0	62.1	11.8371428571429	116	44	99.4	0	2	349	454	569	WP_181256584.1 pyridoxal phosphate-dependent decarboxylase family protein [Merismopedia glauca]	diamond	4143	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Merismopedia	Merismopedia glauca
31638501	31638501	PRJEB39643_P_NODE_37456_length_306_cov_2.197425_g37263_i0	PRJEB39643	37456	306	2.197425	6.7241205	Bacteria	2	Bacteria	Bacteria	132	1.7099999999999996e-34	NR	WP_194027937.1	1983105	g37263	i0	65	4.90196078431373	100	33	98	2	6	305	247	344	WP_194027937.1 alanine--glyoxylate aminotransferase family protein [Lusitaniella coriacea]	diamond	1500	133	0.992481203007519	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Lusitaniellaceae	Lusitaniella	Lusitaniella coriacea
31828213	31828213	PRJEB39643_P_NODE_19757_length_410_cov_2.640950_g19564_i0	PRJEB39643	19757	410	2.64095	10.827895	Thermostichus	2881385	Bacteria	Bacteria	130	3.21e-32	NR	MFQ3583584.1	2847862	g19564	i0	69.7	1.11219512195122	76	23	55.6	0	409	182	662	737	MFQ3583584.1 primary-amine oxidase [Cyanobacteriota bacterium]	diamond	456	131	0.99236641221374	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32119902	32119902	PRJEB39643_P_NODE_133718_length_247_cov_1.770115_g133525_i0	PRJEB39643	133718	247	1.770115	4.37218405	unclassified Synechococcus	2626047	Bacteria	Bacteria	107	2.63e-28	NR	WP_007102718.1	2626047	g133525	i0	82	1.48178137651822	61	11	74.1	0	245	63	6	66	WP_007102718.1 MULTISPECIES: virulence factor [unclassified Synechococcus]	diamond	366	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus
32278218	32278218	PRJEB39643_P_NODE_67179_length_277_cov_1.509804_g66986_i0	PRJEB39643	67179	277	1.509804	4.18215708	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	118	2.79e-29	NR	HVO22929.1	2053573	g66986	i0	67	0.953068592057762	88	28	94.2	1	263	3	159	246	HVO22929.1 c-type cytochrome biogenesis protein CcmI [Candidatus Margulisiibacteriota bacterium]	diamond	264	118	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
32309899	32309899	PRJEB39643_P_NODE_108959_length_257_cov_1.673913_g108766_i0	PRJEB39643	108959	257	1.673913	4.30195641	Nostoc sp. NIES-2111	1973475	Bacteria	Bacteria	87	4.51e-18	NR	BAY36765.1	1973475	g108766	i0	55.2	0.782101167315175	67	30	78.2	0	56	256	265	331	BAY36765.1 oxidoreductase [Nostoc sp. NIES-2111]	diamond	201	87	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-2111
32366486	32366486	PRJEB39643_P_NODE_40339_length_296_cov_1.730942_g40146_i0	PRJEB39643	40339	296	1.730942	5.12358832	Cyanophyceae	3028117	Bacteria	Bacteria	102	1.01e-22	NR	WNZ22097.1	2547451	g40146	i0	50	5.95945945945946	98	48	99.3	1	2	295	47	143	WNZ22097.1 primary-amine oxidase [Leptolyngbya sp. NK1-12]	diamond	1764	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NK1-12

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