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

25 rows where bioproject = "PRJNA797475" 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
2057267	2057267	PRJNA797475_P_NODE_22562_length_250_cov_0.870056_g22463_i0	PRJNA797475	22562	250	0.870056	2.17514	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	396	9.079999999999996e-106	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g22463	i0	95.547	138.828	247	11	99	0	4	250	3679982	3679736	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	34707	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
2492372	2492372	PRJNA797475_P_NODE_2302_length_641_cov_2.125000_g2204_i0	PRJNA797475	2302	641	2.125	13.62125	root	1	Root_unresolved	Root_unresolved	1177	0	NTclustered	gi\|47594\|emb\|X53842.1\|	1148	g2204	i0	99.844	104.630265210608	641	0	100	1	1	641	263	902	Synechocystis sp. ndhE gene (partial), psaC gene for photosystem I iron-sulfur protein and ndhD-like ORF	blastn	67068	1184	0.994087837837838	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 6803
3768650	3768650	PRJNA797475_P_NODE_21823_length_251_cov_0.865169_g21724_i0	PRJNA797475	21823	251	0.865169	2.17157419	Oscillatoriales	1150	Bacteria	Bacteria	324	4.37e-84	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g21724	i0	90	5.97609561752988	250	25	99	0	1	250	938738	938987	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	1500	324	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
7159896	7159896	PRJNA797475_P_NODE_3206_length_546_cov_0.902748_g3108_i0	PRJNA797475	3206	546	0.902748	4.92900408	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	924	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g3108	i0	97.248	313.677655677656	545	15	99	0	2	546	1858739	1859283	Calothrix sp. PCC 7716 DNA, complete genome	blastn	171268	924	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
9709683	9709683	PRJNA797475_P_NODE_24388_length_248_cov_0.880000_g24289_i0	PRJNA797475	24388	248	0.88	2.1824	Leptolyngbya sp. LEGE 18517	3132512	Bacteria	Bacteria	440	4.0999999999999997e-119	NTclustered	gi\|2697880845\|gb\|PP476846.1\|	3132512	g24289	i0	98.785	107.661290322581	247	3	99	0	1	247	469	715	Leptolyngbya sp. LEGE 18517 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	26700	440	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. LEGE 18517
10985360	10985360	PRJNA797475_P_NODE_19929_length_258_cov_1.308108_g19830_i0	PRJNA797475	19929	258	1.308108	3.37491864	Spirirestis rafaelensis	293980	Bacteria	Bacteria	466	7.08e-127	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g19830	i0	99.225	167.693798449612	258	2	100	0	1	258	520	777	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	43265	466	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
10985375	10985375	PRJNA797475_P_NODE_21029_length_252_cov_1.720670_g20930_i0	PRJNA797475	21029	252	1.72067	4.3360884	Nostoc sp. C117	3349875	Bacteria	Bacteria	250	7.55e-62	NTclustered	gi\|2831016856\|gb\|CP170991.1\|	3349875	g20930	i0	90.909	24.0952380952381	187	16	74	1	2	188	6456313	6456498	Nostoc sp. C117 chromosome, complete genome	blastn	6072	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C117
12261044	12261044	PRJNA797475_P_NODE_750_length_1061_cov_4.505061_g684_i0	PRJNA797475	750	1061	4.505061	47.79869721	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1125	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g684	i0	85.968	94.3053722902922	1069	130	99	19	4	1059	3682661	3681600	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	100058	1125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
13534948	13534948	PRJNA797475_P_NODE_10231_length_328_cov_2.949020_g10132_i0	PRJNA797475	10231	328	2.94902	9.6727856	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	207	6.22e-49	NTclustered	gi\|2557660174\|gb\|OR395668.1\|	2053573	g10132	i0	79.605	71.8384146341463	304	50	91	11	4	302	1496	1200	Candidatus Margulisiibacteriota bacterium clone Gx481_unbinned&&k119_1959521 16S ribosomal RNA gene, partial sequence	blastn	23563	207	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
16084059	16084059	PRJNA797475_P_NODE_30853_length_233_cov_2.656250_g30754_i0	PRJNA797475	30853	233	2.65625	6.1890625	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	313	8.66e-81	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g30754	i0	91.342	114.188841201717	231	16	98	3	5	233	3669365	3669593	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	26606	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
20343433	20343433	PRJNA797475_P_NODE_9516_length_338_cov_1.845283_g9417_i0	PRJNA797475	9516	338	1.845283	6.23705654	Chroococcidiopsis	54298	Bacteria	Bacteria	553	7.179999999999998e-153	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g9417	i0	96.165	129.023668639053	339	12	100	1	1	338	794982	794644	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	43610	558	0.991039426523297	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
23734102	23734102	PRJNA797475_P_NODE_14099_length_288_cov_2.055814_g14000_i0	PRJNA797475	14099	288	2.055814	5.92074432	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	228	4.119999999999999e-55	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g14000	i0	92.453	279.71875	159	12	55	0	129	287	597324	597482	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	80559	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
23734296	23734296	PRJNA797475_P_NODE_29719_length_241_cov_2.654762_g29620_i0	PRJNA797475	29719	241	2.654762	6.39797642	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	418	1.8599999999999995e-112	NTclustered	gi\|225696218\|gb\|FJ805885.1\|	259957	g29620	i0	97.934	105.680497925311	242	3	99	2	1	240	3153	3394	Uncultured Chroococcidiopsis sp. clone NA4_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	25469	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
26895912	26895912	PRJNA797475_P_NODE_14301_length_287_cov_1.607477_g14202_i0	PRJNA797475	14301	287	1.607477	4.61345899	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	189	4.3e-58	NR	MBK8224185.1	2711154	g14202	i0	98.9	0.993031358885017	95	1	99.3	0	286	2	60	154	MBK8224185.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	285	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
26990361	26990361	PRJNA797475_P_NODE_2242_length_650_cov_1.906412_g2145_i0	PRJNA797475	2242	650	1.906412	12.391678	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	49.7	0.00288	NR	MBI3591571.1	2052166	g2145	i0	43.9	0.304615384615385	66	26	27.7	3	410	231	195	255	MBI3591571.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	198	49.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27085580	27085580	PRJNA797475_P_NODE_5262_length_438_cov_1.265753_g5164_i0	PRJNA797475	5262	438	1.265753	5.54399814	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	170	2.49e-49	NR	MBX9722485.1	2364082	g5164	i0	55.5	1	146	64	99.3	1	436	2	81	226	MBX9722485.1 pirin family protein [Candidatus Obscuribacterales bacterium]	diamond	438	170	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27116895	27116895	PRJNA797475_P_NODE_26542_length_245_cov_0.895349_g26443_i0	PRJNA797475	26542	245	0.895349	2.19360505	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	155	4.64e-45	NR	HIN65143.1	2364082	g26443	i0	98.8	0.991836734693878	81	1	99.2	0	2	244	129	209	HIN65143.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	243	155	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27717711	27717711	PRJNA797475_P_NODE_16224_length_277_cov_1.509804_g16125_i0	PRJNA797475	16224	277	1.509804	4.18215708	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	44.7	0.0125	NR	MEB3260244.1	2847862	g16125	i0	36.8	0.823104693140794	76	44	80.1	2	55	276	2404	2477	MEB3260244.1 amino acid adenylation domain-containing protein [Cyanobacteriota bacterium]	diamond	228	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29138383	29138383	PRJNA797475_P_NODE_23809_length_248_cov_1.760000_g23710_i0	PRJNA797475	23809	248	1.76	4.3648	Pseudanabaena cinerea	2661616	Bacteria	Bacteria	50.4	4.65e-6	NR	WP_199302249.1	2661616	g23710	i0	36.5	0.762096774193548	63	40	76.2	0	246	58	6	68	WP_199302249.1 tetratricopeptide repeat protein [Pseudanabaena cinerea]	diamond	189	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena cinerea
29485180	29485180	PRJNA797475_P_NODE_25910_length_246_cov_0.890173_g25811_i0	PRJNA797475	25910	246	0.890173	2.18982558	Coleofasciculus sp. LEGE	3100458	Bacteria	Bacteria	116	1.18e-28	NR	WP_193933289.1	2777969	g25811	i0	68.2	2.08536585365854	85	23	98.8	1	2	244	196	280	WP_193933289.1 MFS transporter, partial [Coleofasciculus sp. LEGE 07092]	diamond	513	116	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. LEGE 07092
29611420	29611420	PRJNA797475_P_NODE_25210_length_247_cov_0.885057_g25111_i0	PRJNA797475	25210	247	0.885057	2.18609079	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	147	3.909999999999999e-41	NR	WP_250125609.1	155894	g25111	i0	95.1	9.95951417004049	82	4	99.6	0	2	247	55	136	WP_250125609.1 aspartate carbamoyltransferase catalytic subunit [Chroococcidiopsis sp. CCMEE 29]	diamond	2460	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
31476121	31476121	PRJNA797475_P_NODE_21596_length_251_cov_0.865169_g21497_i0	PRJNA797475	21596	251	0.865169	2.17157419	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	58.2	9.17e-8	NR	MBX9950823.1	2364082	g21497	i0	87.5	0.764940239043825	32	4	38.2	0	9	104	212	243	MBX9950823.1 HAD family phosphatase [Candidatus Obscuribacterales bacterium]	diamond	192	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31485309	31485309	PRJNA797475_P_NODE_30996_length_228_cov_4.232258_g30897_i0	PRJNA797475	30996	228	4.232258	9.64954824	Bacteria	2	Bacteria	Bacteria	63.2	1.93e-9	NR	WP_124971646.1	1122	g30897	i0	50.9	1.89473684210526	57	28	75	0	56	226	16	72	WP_124971646.1 aminomethyl-transferring glycine dehydrogenase [Aphanothece sacrum]	diamond	432	63.5	0.995275590551181	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Aphanothece	Aphanothece sacrum
31887132	31887132	PRJNA797475_P_NODE_29377_length_242_cov_0.911243_g29278_i0	PRJNA797475	29377	242	0.911243	2.20520806	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	92.8	8.76e-20	NR	MBX9685384.1	2364082	g29278	i0	62	0.979338842975207	79	30	97.9	0	1	237	397	475	MBX9685384.1 AAA family ATPase [Candidatus Obscuribacterales bacterium]	diamond	237	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32709067	32709067	PRJNA797475_P_NODE_29960_length_241_cov_0.916667_g29861_i0	PRJNA797475	29960	241	0.916667	2.20916747	Acaryochloris sp. IP29b_bin.148	2969218	Bacteria	Bacteria	125	3.7099999999999997e-34	NR	WP_299411010.1	2969218	g29861	i0	73.4	0.983402489626556	79	21	98.3	0	3	239	83	161	WP_299411010.1 RICIN domain-containing protein [Acaryochloris sp. IP29b_bin.148]	diamond	237	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris sp. IP29b_bin.148

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