metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA827593" and tax_clade = "Cyanobacteriota/Melainabacteria group"

20 rows where analysis = "blastn", bioproject = "PRJNA827593" 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
821050	821050	PRJNA827593_P_NODE_2661_length_1442_cov_9.834186_g2469_i0	PRJNA827593	2661	1442	9.834186	141.80896212	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1439	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2469	i0	85	95.7038834951456	1440	190	99	23	22	1442	3682424	3680992	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	138005	1439	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
5924220	5924220	PRJNA827593_P_NODE_27905_length_394_cov_1.439252_g27606_i0	PRJNA827593	27905	394	1.439252	5.67065288	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	671	0	NTclustered	gi\|1280084617\|gb\|MF574179.1\|	119533	g27606	i0	98.429	240.520304568528	382	4	96	2	15	394	2762	2381	Scytonema hyalinum rrn type 2 operon, partial sequence; precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes and 23S-5S internal transcribed spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	94765	671	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
5924619	5924619	PRJNA827593_P_NODE_50045_length_283_cov_1.314286_g49746_i0	PRJNA827593	50045	283	1.314286	3.71942938	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	235	2.4199999999999997e-57	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g49746	i0	87.624	0.876325088339223	202	25	71	0	31	232	32813	33014	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	248	235	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
5924831	5924831	PRJNA827593_P_NODE_63425_length_247_cov_2.488506_g63126_i0	PRJNA827593	63425	247	2.488506	6.14660982	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g63126	i0	91.892	0.149797570850202	37	3	15	0	211	247	872011	871975	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	37	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
7199424	7199424	PRJNA827593_P_NODE_42226_length_311_cov_2.579832_g41927_i0	PRJNA827593	42226	311	2.579832	8.02327752	Pleurocapsa sp. PCC 7327	118163	Bacteria	Bacteria	381	3.2599999999999987e-101	NTclustered	gi\|485099141\|ref\|NR_102536.1\|	118163	g41927	i0	88.818	143.659163987138	313	32	100	3	1	311	457	146	Pleurocapsa sp. PCC 7327 strain PCC 7327 23S ribosomal RNA, complete sequence	blastn	44678	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. PCC 7327
7199862	7199862	PRJNA827593_P_NODE_65766_length_244_cov_1.333333_g65467_i0	PRJNA827593	65766	244	1.333333	3.25333252	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	252	2.02e-62	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g65467	i0	85.306	1.22950819672131	245	34	100	2	1	244	3380247	3380490	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	300	252	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
8473879	8473879	PRJNA827593_P_NODE_2787_length_1403_cov_2.481955_g2591_i0	PRJNA827593	2787	1403	2.481955	34.82182865	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	392	7.459999999999999e-104	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2591	i0	84.158	25.4811119030649	404	64	29	0	1	404	4710889	4711292	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	35750	392	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
8474244	8474244	PRJNA827593_P_NODE_47467_length_291_cov_2.655963_g47168_i0	PRJNA827593	47467	291	2.655963	7.72885233	Geminocystis sp. NIES-3709	1617448	Bacteria	Bacteria	62.1	4.48e-5	NTclustered	gi\|770470343\|dbj\|AP014821.1\|	1617448	g47168	i0	94.872	0.134020618556701	39	2	13	0	130	168	511066	511028	Geminocystis sp. NIES-3709 DNA, complete genome	blastn	39	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. NIES-3709
8474316	8474316	PRJNA827593_P_NODE_51347_length_278_cov_2.424390_g51048_i0	PRJNA827593	51347	278	2.42439	6.7398042	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	189	1.87e-43	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g51048	i0	80.315	0.913669064748201	254	46	91	4	2	253	747291	747542	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	254	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
11025260	11025260	PRJNA827593_P_NODE_5669_length_949_cov_2.124429_g5419_i0	PRJNA827593	5669	949	2.124429	20.16083121	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	854	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5419	i0	83.351	2.34984193888303	937	142	98	10	3	929	384792	383860	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	2230	854	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
12300853	12300853	PRJNA827593_P_NODE_64970_length_245_cov_1.441860_g64671_i0	PRJNA827593	64970	245	1.44186	3.532557	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	148	2.74e-31	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g64671	i0	78.667	9.74285714285714	225	46	91	2	22	245	1691370	1691593	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	2387	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
13574831	13574831	PRJNA827593_P_NODE_43951_length_305_cov_0.995690_g43652_i0	PRJNA827593	43951	305	0.99569	3.0368545	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	292	1.54e-74	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g43652	i0	84.459	0.970491803278689	296	46	97	0	9	304	3380659	3380364	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	296	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
14849052	14849052	PRJNA827593_P_NODE_27892_length_394_cov_1.566978_g27593_i0	PRJNA827593	27892	394	1.566978	6.17389332	Phormidium sp. NIES-2121	2510782	Bacteria	Bacteria	665	0	NTclustered	gi\|1566846234\|dbj\|LC455612.1\|	2510782	g27593	i0	98.925	154.007614213198	372	4	94	0	23	394	886	1257	Phormidium sp. NIES-2121 gene for 23S ribosomal RNA, partial sequence	blastn	60679	665	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. NIES-2121
18673053	18673053	PRJNA827593_P_NODE_67215_length_242_cov_0.911243_g66916_i0	PRJNA827593	67215	242	0.911243	2.20520806	Picosynechococcus sp. PCC 7003	374981	Bacteria	Bacteria	278	3.3e-70	NTclustered	gi\|2275105\|emb\|X97393.1\|	374981	g66916	i0	92.746	65.202479338843	193	12	79	2	4	194	196	4	Synechococcus sp. rnpB gene, strain PCC7003	blastn	15779	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	Picosynechococcus sp. PCC 7003
21222871	21222871	PRJNA827593_P_NODE_17317_length_516_cov_1.600451_g17019_i0	PRJNA827593	17317	516	1.600451	8.25832716	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	113	2.29e-20	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g17019	i0	94.595	19.3333333333333	74	2	14	2	1	72	2664992	2664919	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	9976	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
23773437	23773437	PRJNA827593_P_NODE_27299_length_399_cov_1.346626_g27000_i0	PRJNA827593	27299	399	1.346626	5.37303774	Phormidium sp. NIES-2121	2510782	Bacteria	Bacteria	682	0	NTclustered	gi\|1566846234\|dbj\|LC455612.1\|	2510782	g27000	i0	97.5	152.734335839599	400	9	100	1	1	399	1746	1347	Phormidium sp. NIES-2121 gene for 23S ribosomal RNA, partial sequence	blastn	60941	682	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. NIES-2121
24179980	24179980	PRJNA827593_P_NODE_32639_length_360_cov_1.902439_g32340_i0	PRJNA827593	32639	360	1.902439	6.8487804	Cyanophyceae	3028117	Bacteria	Bacteria	364	3.859999999999998e-96	NTclustered	gi\|2098452651\|gb\|CP083582.1\|	2653194	g32340	i0	87.117	247.436111111111	326	37	90	5	1	325	4176302	4176623	Kovacikia minuta CCNUW1 strain CCNU0001 chromosome, complete genome	blastn	89077	366	0.994535519125683	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Kovacikia	Kovacikia minuta
24180051	24180051	PRJNA827593_P_NODE_52979_length_273_cov_1.975000_g52680_i0	PRJNA827593	52979	273	1.975	5.39175	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	60.2	1.5e-4	NTclustered	gi\|2593238647\|gb\|CP136520.1\|	3037479	g52680	i0	91.111	0.282051282051282	45	3	16	1	200	244	4845363	4845320	Nodosilinea sp. E11 chromosome	blastn	77	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. E11
25047063	25047063	PRJNA827593_P_NODE_13240_length_598_cov_2.925714_g12946_i0	PRJNA827593	13240	598	2.925714	17.49576972	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	706	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g12946	i0	88.625	152.586956521739	589	55	97	11	16	597	3682509	3681926	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	91247	706	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
25047552	25047552	PRJNA827593_P_NODE_3960_length_1156_cov_4.756233_g2469_i1	PRJNA827593	3960	1156	4.756233	54.98205348	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1223	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2469	i1	86.087	117.935121107266	1150	145	98	13	1	1138	3680992	3682138	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	136333	1223	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria 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);;