metadata: contig_metadata: 22 rows where bioproject = "PRJNA800090" and tax_clade = "Cyanobacteriota/Melainabacteria group"

22 rows where bioproject = "PRJNA800090" 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
1220324	1220324	PRJNA800090_P_NODE_149161_length_257_cov_1.255319_g146976_i0	PRJNA800090	149161	257	1.255319	3.22616983	Macrochaete	1844958	Bacteria	Bacteria	472	1.51e-128	NTclustered	gi\|336109608\|gb\|JN020217.1\|	1211	g146976	i0	100	99.3073929961089	255	0	99	0	3	257	809	555	Uncultured cyanobacterium clone cher4_2B_90 small subunit ribosomal RNA gene, partial sequence	blastn	25522	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2075049	2075049	PRJNA800090_P_NODE_52182_length_492_cov_7.962175_g49998_i0	PRJNA800090	52182	492	7.962175	39.173901	Wilmottia koreana	2759957	Bacteria	Bacteria	808	0	NTclustered	gi\|1743541374\|gb\|MN473879.1\|	2613809	g49998	i0	96.341	162.270325203252	492	17	100	1	1	492	1922	2412	Wilmottia koreana FBCC-A812 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	79837	808	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Wilmottiaceae	Wilmottia	Wilmottia koreana
2075380	2075380	PRJNA800090_P_NODE_67122_length_419_cov_1.420000_g64938_i0	PRJNA800090	67122	419	1.42	5.9498	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	123	6.86e-30	NR	HNN61984.1	2711154	g64938	i0	64.2	4.10262529832936	95	34	68	0	285	1	159	253	HNN61984.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	1719	123	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
8452550	8452550	PRJNA800090_P_NODE_65647_length_425_cov_1.160112_g63463_i0	PRJNA800090	65647	425	1.160112	4.930476	Crocosphaera sp.	2729996	Bacteria	Bacteria	115	1.05e-26	NR	MDJ0730457.1	2729996	g63463	i0	46.2	0.931764705882353	132	63	89.6	3	5	385	12	140	MDJ0730457.1 peroxidase family protein [Crocosphaera sp.]	diamond	396	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera sp.
9726481	9726481	PRJNA800090_P_NODE_192428_length_228_cov_0.918239_g190243_i0	PRJNA800090	192428	228	0.918239	2.09358492	Vulcanococcus	2170427	Bacteria	Bacteria	129	9.48e-34	NR	WP_411876027.1	2170428	g190243	i0	82.4	14.6184210526316	74	13	97.4	0	224	3	126	199	WP_411876027.1 transaldolase [Vulcanococcus limneticus]	diamond	3333	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Vulcanococcus	Vulcanococcus limneticus
11425360	11425360	PRJNA800090_S_NODE_21869_length_268_cov_1.793970_g21757_i0	PRJNA800090	21869	268	1.79397	4.8078396	root	1	Root_unresolved	Root_unresolved	71.3	6.77e-8	NTclustered	gi\|2751213477\|emb\|OZ001294.2\|	1007660	g21757	i0	95.455	4.23134328358209	44	2	16	0	182	225	3269540	3269497	MAG: uncultured Hormoscilla sp. isolate 8e647e88-4706-4a17-b8b9-b52c092b67df genome assembly, chromosome: 2	blastn	1134	71.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Hormoscilla	uncultured Hormoscilla sp.
12278001	12278001	PRJNA800090_P_NODE_196790_length_219_cov_4.920000_g194605_i0	PRJNA800090	196790	219	4.92	10.7748	Microcoleus sp. PCC 8701	272133	Bacteria	Bacteria	276	1.06e-69	NTclustered	gi\|46409899\|gb\|AY584524.1\|	272133	g194605	i0	89.333	164.063926940639	225	16	100	7	1	219	766	988	Microcoleus sp. PCC 8701 23S ribosomal RNA gene, partial sequence	blastn	35930	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. PCC 8701
13552881	13552881	PRJNA800090_P_NODE_52511_length_490_cov_16.323040_g50327_i0	PRJNA800090	52511	490	16.32304	79.982896	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	662	0	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g50327	i0	91.02	163.726530612245	490	44	100	0	1	490	13	502	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	80226	662	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
21199659	21199659	PRJNA800090_P_NODE_140577_length_265_cov_2.938776_g138392_i0	PRJNA800090	140577	265	2.938776	7.7877564	Euhalothece natronophila	577489	Bacteria	Bacteria	364	2.739999999999999e-96	NTclustered	gi\|1720260411\|gb\|CP042326.1\|	522448	g138392	i0	91.386	271.007547169811	267	21	100	2	1	265	427383	427649	Euhalothece natronophila Z-M001 chromosome, complete genome	blastn	71817	364	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Halothecacae	Euhalothece	Euhalothece natronophila
22898276	22898276	PRJNA800090_P_NODE_189158_length_229_cov_1.800000_g186973_i0	PRJNA800090	189158	229	1.8	4.122	root	1	Root_unresolved	Root_unresolved	418	1.7499999999999995e-112	NTclustered	gi\|892164921\|gb\|KT182535.1\|	1211	g186973	i0	99.563	99.2139737991266	229	1	100	0	1	229	1354	1126	Uncultured cyanobacterium clone MBR Ca 100ppm 6 16S ribosomal RNA gene, partial sequence	blastn	22720	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
23752637	23752637	PRJNA800090_P_NODE_85939_length_357_cov_3.930556_g83754_i0	PRJNA800090	85939	357	3.930556	14.03208492	Microcoleus vaginatus	119532	Bacteria	Bacteria	359	1.78e-94	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g83754	i0	85.124	165.747899159664	363	41	99	10	2	357	102274	101918	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	59172	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
26673928	26673928	PRJNA800090_P_NODE_37761_length_606_cov_2.126629_g35609_i0	PRJNA800090	37761	606	2.126629	12.88737174	Cyanobacteria bacterium TMED177	1986677	Bacteria	Bacteria	69.3	8.83e-10	NR	OUW30451.1	1986677	g35609	i0	40.2	0.455445544554455	92	53	45.5	1	598	323	3633	3722	OUW30451.1 MAG: hypothetical protein CBD37_01270 [Cyanobacteria bacterium TMED177]	diamond	276	69.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium TMED177
27410949	27410949	PRJNA800090_P_NODE_45603_length_537_cov_1.914530_g43430_i0	PRJNA800090	45603	537	1.91453	10.2810261	Nostocaceae	1162	Bacteria	Bacteria	72.8	1.11e-12	NR	WP_235115536.1	1179	g43430	i0	31.2	2.33519553072626	141	84	78.8	3	461	39	5	132	WP_235115536.1 RICIN domain-containing protein [Desmonostoc muscorum]	diamond	1254	73.2	0.994535519125683	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Desmonostoc	Desmonostoc muscorum
27789692	27789692	PRJNA800090_P_NODE_119704_length_292_cov_1.964126_g117519_i0	PRJNA800090	119704	292	1.964126	5.73524792	Chamaesiphon	217161	Bacteria	Bacteria	106	1.99e-24	NR	MCY7366723.1	2814140	g117519	i0	50	5.01369863013699	98	46	98.6	2	288	1	418	514	MCY7366723.1 aldehyde dehydrogenase family protein [Chamaesiphon sp.]	diamond	1464	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon sp.
27852647	27852647	PRJNA800090_P_NODE_169204_length_238_cov_1.727811_g167019_i0	PRJNA800090	169204	238	1.727811	4.11219018	Bacteria	2	Bacteria	Bacteria	71.6	2.05e-12	NR	MBY0451115.1	2847862	g167019	i0	48.6	2.8109243697479	74	37	93.3	1	236	15	242	314	MBY0451115.1 aminotransferase class V-fold PLP-dependent enzyme [Cyanobacteriota bacterium]	diamond	669	71.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28159739	28159739	PRJNA800090_P_NODE_120385_length_291_cov_1.972973_g118200_i0	PRJNA800090	120385	291	1.972973	5.74135143	Cyanobacteria bacterium UBA11366	2055775	Bacteria	Bacteria	75.5	2.04e-13	NR	HBE58662.1	2055775	g118200	i0	46.2	2.35051546391753	78	34	80.4	2	250	17	6	75	HBE58662.1 colicin uptake protein [Cyanobacteria bacterium UBA11366]	diamond	684	75.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11366
28642246	28642246	PRJNA800090_P_NODE_45507_length_537_cov_8.594017_g43335_i0	PRJNA800090	45507	537	8.594017	46.14987129	Bacillati	1783272	Bacteria	Bacteria	50.4	2.84e-4	NR	WP_235115536.1	1179	g43335	i0	26.5	2.80446927374302	147	92	82.1	4	441	1	11	141	WP_235115536.1 RICIN domain-containing protein [Desmonostoc muscorum]	diamond	1506	50.8	0.992125984251969	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Desmonostoc	Desmonostoc muscorum
29012386	29012386	PRJNA800090_P_NODE_68428_length_413_cov_3.523256_g66244_i0	PRJNA800090	68428	413	3.523256	14.55104728	Microcoleus sp. FACHB-1	2692820	Bacteria	Bacteria	44.7	0.0419	NR	MBD2129317.1	2692820	g66244	i0	35	0.74818401937046	103	50	69	3	30	314	165	258	MBD2129317.1 carboxylate-amine ligase [Microcoleus sp. FACHB-1]	diamond	309	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-1
29652049	29652049	PRJNA800090_P_NODE_124850_length_285_cov_1.347222_g122665_i0	PRJNA800090	124850	285	1.347222	3.8395827	Nostocales	1161	Bacteria	Bacteria	46.6	0.00257	NR	WP_148762140.1	1914871	g122665	i0	41.7	3.15789473684211	60	35	63.2	0	194	15	4	63	WP_148762140.1 tetratricopeptide repeat protein [Dolichospermum sp. UHCC 0315A]	diamond	900	47	0.991489361702128	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp. UHCC 0315A
31571259	31571259	PRJNA800090_P_NODE_117896_length_295_cov_1.292035_g115711_i0	PRJNA800090	117896	295	1.292035	3.81150325	Iphinoe sp. HA4291-MV1	1494767	Bacteria	Bacteria	43.9	0.0229	NR	MBW4634071.1	1494767	g115711	i0	36.6	0.722033898305085	71	43	72.2	1	83	295	57	125	MBW4634071.1 CAP domain-containing protein [Iphinoe sp. HA4291-MV1]	diamond	213	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Stigonemataceae	Iphinoe	Iphinoe sp. HA4291-MV1
31801223	31801223	PRJNA800090_P_NODE_181057_length_232_cov_1.791411_g178872_i0	PRJNA800090	181057	232	1.791411	4.15607352	Bacillati	1783272	Bacteria	Bacteria	117	1.34e-28	NR	MEB3245976.1	2692181	g178872	i0	64.9	4.97844827586207	77	27	99.6	0	232	2	51	127	MEB3245976.1 amino acid permease [Vampirovibrionales bacterium]	diamond	1155	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales			Vampirovibrionales bacterium
32552116	32552116	PRJNA800090_P_NODE_149179_length_257_cov_1.164894_g146994_i0	PRJNA800090	149179	257	1.164894	2.99377758	Coleofasciculus chthonoplastes	64178	Bacteria	Bacteria	47.8	4.38e-4	NR	MEQ9368073.1	3069539	g146994	i0	51.5	1.22568093385214	33	16	38.5	0	3	101	89	121	MEQ9368073.1 lecithin retinol acyltransferase family protein [Coleofasciculus chthonoplastes F3-SA18-01]	diamond	315	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus chthonoplastes

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