metadata: contig_metadata: 18 rows where bioproject = "PRJNA864829" and tax_clade = "Cyanobacteriota/Melainabacteria group"

18 rows where bioproject = "PRJNA864829" 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
1236867	1236867	PRJNA864829_S_NODE_14861_length_168_cov_2.655462_g14775_i0	PRJNA864829	14861	168	2.655462	4.46117616	Bacteria	2	Bacteria	Bacteria	278	2.14e-70	NTclustered	gi\|429732865\|gb\|JX887884.1\|	1211	g14775	i0	96.429	101.47619047619	168	6	100	0	1	168	212	45	Uncultured cyanobacterium clone Emix2.2 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, and tRNA-Ile gene, partial sequence	blastn	17048	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
1236881	1236881	PRJNA864829_S_NODE_8121_length_217_cov_3.107143_g8035_i0	PRJNA864829	8121	217	3.107143	6.74250031	Bacteria	2	Bacteria	Bacteria	385	1.66e-102	NTclustered	gi\|336109608\|gb\|JN020217.1\|	1211	g8035	i0	98.618	101.981566820276	217	3	100	0	1	217	486	702	Uncultured cyanobacterium clone cher4_2B_90 small subunit ribosomal RNA gene, partial sequence	blastn	22130	385	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2122684	2122684	PRJNA864829_S_NODE_9622_length_202_cov_3.267974_g9536_i0	PRJNA864829	9622	202	3.267974	6.60130748	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	254	4.4900000000000003e-63	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g9536	i0	95.031	168.242574257426	161	8	80	0	24	184	3679884	3680044	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	33985	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
11440644	11440644	PRJNA864829_S_NODE_6369_length_241_cov_2.130208_g6283_i0	PRJNA864829	6369	241	2.130208	5.13380128	Bacteria	2	Bacteria	Bacteria	77.8	2.35e-16	NR	HVO24894.1	2053573	g6283	i0	86.7	1.6804979253112	45	6	56	0	107	241	1	45	HVO24894.1 50S ribosomal protein L22 [Candidatus Margulisiibacteriota bacterium]	diamond	405	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
13600964	13600964	PRJNA864829_S_NODE_3011_length_316_cov_5.898876_g2925_i0	PRJNA864829	3011	316	5.898876	18.64044816	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	518	2.4299999999999998e-142	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2925	i0	96.203	285.623417721519	316	12	100	0	1	316	3682184	3682499	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	90257	518	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
17814318	17814318	PRJNA864829_S_NODE_11514_length_188_cov_0.978417_g11428_i0	PRJNA864829	11514	188	0.978417	1.83942396	Cyanophyceae	3028117	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|169884305\|gb\|CP000951.1\|	32049	g11428	i0	100	3.98936170212766	30	0	16	0	26	55	1464721	1464750	Synechococcus sp. PCC 7002, complete genome	blastn	750	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	Picosynechococcus sp. PCC 7002
21638902	21638902	PRJNA864829_S_NODE_13617_length_174_cov_1.528000_g13531_i0	PRJNA864829	13617	174	1.528	2.65872	Bacteria	2	Bacteria	Bacteria	257	2.89e-64	NTclustered	gi\|429732865\|gb\|JX887884.1\|	1211	g13531	i0	97.351	87.2298850574713	151	4	87	0	24	174	582	732	Uncultured cyanobacterium clone Emix2.2 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, and tRNA-Ile gene, partial sequence	blastn	15178	257	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
23799547	23799547	PRJNA864829_S_NODE_5559_length_253_cov_3.078431_g5473_i0	PRJNA864829	5559	253	3.078431	7.78843043	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	353	5.62e-93	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5473	i0	94.348	105.256916996047	230	13	91	0	1	230	3682456	3682685	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	26630	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26611769	26611769	PRJNA864829_S_NODE_6721_length_236_cov_1.433155_g6635_i0	PRJNA864829	6721	236	1.433155	3.3822458	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	95.1	2.54e-21	NR	HEY9650264.1	3081323	g6635	i0	67.6	2.89830508474576	74	24	94.1	0	222	1	41	114	HEY9650264.1 choice-of-anchor A family protein [Coleofasciculaceae cyanobacterium]	diamond	684	95.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
27276477	27276477	PRJNA864829_S_NODE_14443_length_170_cov_1.768595_g14357_i0	PRJNA864829	14443	170	1.768595	3.0066115	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	109	4.11e-26	NR	WP_106370030.1	2107693	g14357	i0	98.2	0.988235294117647	56	1	98.8	0	3	170	250	305	WP_106370030.1 efflux RND transporter periplasmic adaptor subunit [Chlorogloea sp. CCALA 695]	diamond	168	109	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
27442765	27442765	PRJNA864829_S_NODE_4063_length_285_cov_1.771186_g3977_i0	PRJNA864829	4063	285	1.771186	5.0478801	Bacteria	2	Bacteria	Bacteria	57	4.22e-7	NR	HVO27643.1	2053573	g3977	i0	48.4	2.02105263157895	64	33	67.4	0	88	279	1	64	HVO27643.1 type II CAAX endopeptidase family protein [Candidatus Margulisiibacteriota bacterium]	diamond	576	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
27781792	27781792	PRJNA864829_S_NODE_2704_length_328_cov_2.225806_g2618_i0	PRJNA864829	2704	328	2.225806	7.30064368	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	233	6.130000000000001e-73	NR	MFN8658798.1	2364082	g2618	i0	99.1	0.996951219512195	109	1	99.7	0	327	1	331	439	MFN8658798.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	327	233	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28129100	28129100	PRJNA864829_S_NODE_11945_length_185_cov_1.558824_g11859_i0	PRJNA864829	11945	185	1.558824	2.8838244	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	62.4	1.99e-9	NR	WP_106370030.1	2107693	g11859	i0	100	0.567567567567568	35	0	56.8	0	185	81	189	223	WP_106370030.1 efflux RND transporter periplasmic adaptor subunit [Chlorogloea sp. CCALA 695]	diamond	105	62.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
28223544	28223544	PRJNA864829_S_NODE_10946_length_192_cov_1.503497_g10860_i0	PRJNA864829	10946	192	1.503497	2.88671424	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	108	2.89e-28	NR	HVO26040.1	2053573	g10860	i0	92.2	1	64	5	100	0	1	192	84	147	HVO26040.1 50S ribosomal protein L11 [Candidatus Margulisiibacteriota bacterium]	diamond	192	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
28823332	28823332	PRJNA864829_S_NODE_7968_length_219_cov_1.664706_g7882_i0	PRJNA864829	7968	219	1.664706	3.64570614	Nostoc sp. NMS8	2815392	Bacteria	Bacteria	63.9	2.91e-10	NR	WP_292846863.1	2815392	g7882	i0	64.6	1.31506849315068	48	12	65.8	1	1	144	1	43	WP_292846863.1 WD40 repeat domain-containing protein, partial [Nostoc sp. NMS8]	diamond	288	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NMS8
29423291	29423291	PRJNA864829_S_NODE_12109_length_184_cov_1.185185_g12023_i0	PRJNA864829	12109	184	1.185185	2.1807404	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	120	4.43e-30	NR	MBX9666291.1	2364082	g12023	i0	91.7	0.978260869565217	60	5	97.8	0	183	4	30	89	MBX9666291.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	180	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30655336	30655336	PRJNA864829_S_NODE_14693_length_169_cov_1.341667_g14607_i0	PRJNA864829	14693	169	1.341667	2.26741723	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	105	3.79e-25	NR	MBX9671452.1	2364082	g14607	i0	89.1	0.976331360946746	55	6	97.6	0	3	167	31	85	MBX9671452.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium]	diamond	165	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32742020	32742020	PRJNA864829_S_NODE_4820_length_268_cov_2.091324_g4734_i0	PRJNA864829	4820	268	2.091324	5.60474832	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	100	7.44e-23	NR	MBX9667389.1	2364082	g4734	i0	100	0.548507462686567	49	0	54.9	0	267	121	356	404	MBX9667389.1 ATP-grasp domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	147	100	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);;