metadata: contig_metadata: 20 rows where bioproject = "PRJNA1046144" and tax_clade = "Cyanobacteriota/Melainabacteria group"

20 rows where bioproject = "PRJNA1046144" 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
172151	172151	PRJNA1046144_P_NODE_32421_length_297_cov_1.228070_g32126_i0	PRJNA1046144	32421	297	1.22807	3.6473679	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	278	4.18e-70	NTclustered	gi\|225696213\|gb\|FJ805880.1\|	259957	g32126	i0	84.354	115.86531986532	294	35	98	9	8	297	2986	2700	Uncultured Chroococcidiopsis sp. clone A3_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34412	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
172948	172948	PRJNA1046144_P_NODE_71281_length_216_cov_2.551020_g70986_i0	PRJNA1046144	71281	216	2.55102	5.5102032	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	202	1.7899999999999995e-47	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g70986	i0	83.636	183.435185185185	220	30	100	4	1	216	3681580	3681797	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	39622	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
1446765	1446765	PRJNA1046144_P_NODE_27742_length_317_cov_1.161290_g27447_i0	PRJNA1046144	27742	317	1.16129	3.6812893	Geminocystis sp. NIES-3708	1615909	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|770466698\|dbj\|AP014815.1\|	1615909	g27447	i0	100	0.0883280757097792	28	0	9	0	108	135	5574	5547	Geminocystis sp. NIES-3708 DNA, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. NIES-3708
5275659	5275659	PRJNA1046144_P_NODE_67005_length_228_cov_0.905660_g66710_i0	PRJNA1046144	67005	228	0.90566	2.0649048	Coleofasciculus sp. C3-bin4	2768885	Bacteria	Bacteria	133	1.73e-37	NR	MBD0362061.1	2768885	g66710	i0	93.8	0.855263157894737	65	4	85.5	0	1	195	127	191	MBD0362061.1 DUF924 domain-containing protein [Coleofasciculus sp. C3-bin4]	diamond	195	133	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. C3-bin4
7825291	7825291	PRJNA1046144_P_NODE_58147_length_234_cov_0.872727_g57852_i0	PRJNA1046144	58147	234	0.872727	2.04218118	Planktothrix agardhii	1160	Bacteria	Bacteria	303	5.24e-78	NTclustered	gi\|2261157456\|emb\|LR882949.1\|	1160	g57852	i0	90.129	0.995726495726496	233	23	99	0	2	234	931000	930768	Planktothrix agardhii strain No.758 genome assembly, chromosome: I	blastn	233	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
11650591	11650591	PRJNA1046144_P_NODE_26690_length_322_cov_1.707510_g26395_i0	PRJNA1046144	26690	322	1.70751	5.4981822	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	331	3.47e-86	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g26395	i0	87.762	20.7639751552795	286	32	88	3	1	284	2594040	2594324	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	6686	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
14201261	14201261	PRJNA1046144_P_NODE_532_length_1753_cov_12.915677_g486_i0	PRJNA1046144	532	1753	12.915677	226.41181781	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1919	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g486	i0	86.505	98.9771819737593	1771	210	100	28	1	1753	3682670	3680911	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	173507	1919	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
16749451	16749451	PRJNA1046144_P_NODE_50794_length_246_cov_1.412429_g50499_i0	PRJNA1046144	50794	246	1.412429	3.47457534	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	407	4.12e-109	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g50499	i0	97.107	148.459349593496	242	5	98	2	7	246	2219	2460	Uncultured Chroococcidiopsis sp. clone A1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36521	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21848746	21848746	PRJNA1046144_P_NODE_14218_length_425_cov_4.081461_g13923_i0	PRJNA1046144	14218	425	4.081461	17.34620925	Prochlorococcus marinus	1219	Bacteria	Bacteria	58.4	8.8e-4	NTclustered	gi\|2417453587\|gb\|CP114777.1\|	3015000	g13923	i0	97.059	0.08	34	1	8	0	3	36	405164	405131	Prochlorococcus marinus str. MIT 1214 chromosome, complete genome	blastn	34	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
28077463	28077463	PRJNA1046144_P_NODE_71745_length_212_cov_2.601399_g71450_i0	PRJNA1046144	71745	212	2.601399	5.51496588	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	63.2	1.36e-9	NR	MBX9674102.1	2364082	g71450	i0	46.9	0.905660377358491	64	34	90.6	0	212	21	273	336	MBX9674102.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	192	63.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28322049	28322049	PRJNA1046144_P_NODE_51066_length_245_cov_1.869318_g50771_i0	PRJNA1046144	51066	245	1.869318	4.5798291	Bacillati	1783272	Bacteria	Bacteria	98.6	8.63e-22	NR	WP_073601648.1	1616834	g50771	i0	79.3	2.8530612244898	58	12	71	0	175	2	1	58	WP_073601648.1 site-specific DNA-methyltransferase [Hydrococcus rivularis]	diamond	699	99.4	0.991951710261569	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hydrococcaceae	Hydrococcus	Hydrococcus rivularis
28677585	28677585	PRJNA1046144_P_NODE_51487_length_244_cov_2.371429_g51192_i0	PRJNA1046144	51487	244	2.371429	5.78628676	Nostoc sp.	1180	Bacteria	Bacteria	105	2.37e-24	NR	WP_335118582.1	1180	g51192	i0	58.3	3.09836065573771	84	31	98.4	1	2	241	968	1051	WP_335118582.1 amino acid adenylation domain-containing protein [Nostoc sp.]	diamond	756	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
29687527	29687527	PRJNA1046144_P_NODE_60470_length_232_cov_0.883436_g60175_i0	PRJNA1046144	60470	232	0.883436	2.04957152	Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40	3070899	Bacteria	Bacteria	50.8	4.25e-5	NR	MDQ5937846.1	3070899	g60175	i0	72.4	0.375	29	8	37.5	0	144	230	1	29	MDQ5937846.1 hypothetical protein [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40]	diamond	87	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40
30003757	30003757	PRJNA1046144_P_NODE_25111_length_330_cov_2.126437_g24816_i0	PRJNA1046144	25111	330	2.126437	7.0172421	Cyanobacteria bacterium PR.023	2067979	Bacteria	Bacteria	71.2	1.16e-12	NR	MBA4078367.1	2067979	g24816	i0	55.6	1.96363636363636	72	31	64.5	1	219	7	12	83	MBA4078367.1 hypothetical protein [Cyanobacteria bacterium PR.023]	diamond	648	71.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023
30161406	30161406	PRJNA1046144_P_NODE_63752_length_230_cov_0.894410_g63457_i0	PRJNA1046144	63752	230	0.89441	2.057143	Cyanobacteria bacterium SZAS LIN-5	2807734	Bacteria	Bacteria	82	1.47e-17	NR	MBS2001894.1	2807734	g63457	i0	90.9	0.573913043478261	44	3	57.4	1	229	98	121	163	MBS2001894.1 DNA repair protein RadC [Cyanobacteria bacterium SZAS LIN-5]	diamond	132	82	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-5
30375199	30375199	PRJNA1046144_P_NODE_59872_length_232_cov_1.766871_g59577_i0	PRJNA1046144	59872	232	1.766871	4.09914072	Bacillati	1783272	Bacteria	Bacteria	57.8	1.32e-7	NR	MBA4078136.1	2067979	g59577	i0	42.2	2.48275862068966	64	37	82.8	0	41	232	73	136	MBA4078136.1 hypothetical protein [Cyanobacteria bacterium PR.023]	diamond	576	58.2	0.993127147766323	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023
31868372	31868372	PRJNA1046144_P_NODE_45637_length_257_cov_2.707447_g45342_i0	PRJNA1046144	45637	257	2.707447	6.95813879	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	97.4	1.35e-21	NR	MDR3615585.1	2364082	g45342	i0	48.2	0.992217898832685	85	44	99.2	0	2	256	285	369	MDR3615585.1 HAMP domain-containing sensor histidine kinase [Candidatus Obscuribacterales bacterium]	diamond	255	97.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31995103	31995103	PRJNA1046144_P_NODE_67398_length_227_cov_1.784810_g67103_i0	PRJNA1046144	67398	227	1.78481	4.0515187	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	99.8	1.13e-22	NR	MBX9691839.1	2847862	g67103	i0	63.9	0.951541850220264	72	26	95.2	0	10	225	98	169	MBX9691839.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	216	99.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32311793	32311793	PRJNA1046144_P_NODE_51939_length_243_cov_2.258621_g51644_i0	PRJNA1046144	51939	243	2.258621	5.48844903	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	58.2	9.55e-8	NR	MFA6560206.1	2364082	g51644	i0	49.2	1.55555555555556	63	31	77.8	1	234	46	9	70	MFA6560206.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium]	diamond	378	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32879420	32879420	PRJNA1046144_P_NODE_55140_length_236_cov_2.419162_g54845_i0	PRJNA1046144	55140	236	2.419162	5.70922232	Drouetiella sp.	3088174	Bacteria	Bacteria	156	1.19e-44	NR	HEY9732185.1	3088174	g54845	i0	100	1.98305084745763	78	0	99.2	0	236	3	149	226	HEY9732185.1 SDR family NAD(P)-dependent oxidoreductase [Drouetiella sp.]	diamond	468	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella sp.

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