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

20 rows where analysis = "blastn", bioproject = "PRJNA572587" 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
559190	559190	PRJNA572587_P_NODE_6241_length_494_cov_123.004494_g5920_i0	PRJNA572587	6241	494	123.004494	607.64220036	Nostoc flagelliforme	1306274	Bacteria	Bacteria	752	0	NTclustered	gi\|1297075411\|gb\|CP024785.1\|	2038116	g5920	i0	98.144	36.7267206477733	431	8	87	0	46	476	5007068	5007498	Nostoc flagelliforme CCNUN1 chromosome, complete genome	blastn	18143	752	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
2411287	2411287	PRJNA572587_P_NODE_10102_length_373_cov_186.212963_g9775_i0	PRJNA572587	10102	373	186.212963	694.57435199	Bacteria	2	Bacteria	Bacteria	627	4.639999999999999e-175	NTclustered	gi\|296881316\|gb\|GU120573.1\|	1211	g9775	i0	98.86	94.0777479892761	351	4	94	0	1	351	846	496	Uncultured cyanobacterium clone OP1_8_2_E06 16S ribosomal RNA gene, partial sequence	blastn	35091	627	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2411367	2411367	PRJNA572587_P_NODE_24902_length_225_cov_4.653409_g24574_i0	PRJNA572587	24902	225	4.653409	10.47017025	Cyanophyceae	3028117	Bacteria	Bacteria	220	5.18e-53	NTclustered	gi\|1861038541\|dbj\|LC557454.1\|	1126	g24574	i0	88.827	137.457777777778	179	20	80	0	1	179	485	307	Microcystis aeruginosa NIES-1062 gene for 23S rRNA, partial sequence	blastn	30928	220	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
5662493	5662493	PRJNA572587_P_NODE_1685_length_983_cov_26.640257_g1525_i0	PRJNA572587	1685	983	26.640257	261.87372631	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	656	0	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g1525	i0	90.726	112.787385554425	496	41	98	4	5	497	2098	1605	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	110870	656	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5662717	5662717	PRJNA572587_P_NODE_31845_length_196_cov_28.666667_g31517_i0	PRJNA572587	31845	196	28.666667	56.18666732	Euhalothece natronophila	577489	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1720260411\|gb\|CP042326.1\|	522448	g31517	i0	88.636	0.224489795918367	44	5	22	0	81	124	159905	159948	Euhalothece natronophila Z-M001 chromosome, complete genome	blastn	44	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Halothecacae	Euhalothece	Euhalothece natronophila
8212123	8212123	PRJNA572587_P_NODE_41007_length_171_cov_1.147541_g40679_i0	PRJNA572587	41007	171	1.147541	1.96229511	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	193	8.089999999999999e-45	NTclustered	gi\|225696177\|gb\|FJ805844.1\|	259957	g40679	i0	88.608	352.40350877193	158	18	92	0	4	161	2063	1906	Uncultured Chroococcidiopsis sp. clone AU1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	60261	193	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9487155	9487155	PRJNA572587_P_NODE_19188_length_259_cov_25.104762_g18860_i0	PRJNA572587	19188	259	25.104762	65.02133358	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	267	7.739999999999999e-67	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g18860	i0	89.041	25.8146718146718	219	19	86	5	16	232	1859066	1858851	Calothrix sp. PCC 7716 DNA, complete genome	blastn	6686	267	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
9487480	9487480	PRJNA572587_P_NODE_45668_length_163_cov_0.894737_g45340_i0	PRJNA572587	45668	163	0.894737	1.45842131	Nostoc flagelliforme	1306274	Bacteria	Bacteria	263	5.77e-66	NTclustered	gi\|1297075411\|gb\|CP024785.1\|	2038116	g45340	i0	95.706	15.8650306748466	163	7	100	0	1	163	6547025	6547187	Nostoc flagelliforme CCNUN1 chromosome, complete genome	blastn	2586	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
12038036	12038036	PRJNA572587_P_NODE_31450_length_198_cov_2.248322_g31122_i0	PRJNA572587	31450	198	2.248322	4.45167756	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	311	2.5600000000000003e-80	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g31122	i0	97.778	135.555555555556	180	4	91	0	1	180	3670031	3670210	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	26840	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
12038289	12038289	PRJNA572587_P_NODE_8630_length_410_cov_314.606648_g8304_i0	PRJNA572587	8630	410	314.606648	1289.8872568	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	178	6.23e-40	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g8304	i0	85	77.7048780487805	180	21	43	6	215	391	3682353	3682177	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	31859	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
13312786	13312786	PRJNA572587_P_NODE_22931_length_235_cov_32.801075_g22603_i0	PRJNA572587	22931	235	32.801075	77.08252625	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	366	6.62e-97	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g22603	i0	99.502	129.651063829787	201	1	86	0	35	235	298	498	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	30468	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
14587635	14587635	PRJNA572587_P_NODE_22972_length_235_cov_16.940860_g22644_i0	PRJNA572587	22972	235	16.94086	39.811021	Okeanomitos corallinicola	3231550	Bacteria	Bacteria	178	3.3299999999999993e-40	NTclustered	gi\|2715121997\|gb\|CP150887.1\|	3133117	g22644	i0	87.261	9.65531914893617	157	18	66	2	52	206	159953	160109	Okeanomitos corallinicola TIOX110 plasmid unnamed, complete sequence	blastn	2269	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Okeanomitos	Okeanomitos corallinicola
17136803	17136803	PRJNA572587_P_NODE_5734_length_521_cov_133.889831_g5414_i0	PRJNA572587	5734	521	133.889831	697.56601951	Aliterella chasmolithica	2739056	Bacteria	Bacteria	804	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g5414	i0	96.509	111.222648752399	487	16	93	1	1	486	2451	1965	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	57947	804	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
19685362	19685362	PRJNA572587_P_NODE_25596_length_221_cov_25.709302_g25268_i0	PRJNA572587	25596	221	25.709302	56.81755742	Pleurocapsa concharum	980867	Bacteria	Bacteria	342	1.0399999999999997e-89	NTclustered	gi\|322504116\|emb\|FR798927.1\|	980868	g25268	i0	97.98	89.0633484162896	198	3	89	1	23	219	496	693	Pleurocapsa concharum VP3-02 partial 16S rRNA gene, strain VP3-02	blastn	19683	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa concharum
19685602	19685602	PRJNA572587_P_NODE_4656_length_591_cov_5.924354_g4344_i0	PRJNA572587	4656	591	5.924354	35.01293214	Thermosynechococcus sp. NK55a	1394889	Bacteria	Bacteria	119	5.68e-22	NTclustered	gi\|564736995\|gb\|CP006735.1\|	1394889	g4344	i0	94.805	0.768189509306261	77	3	17	1	91	166	893718	893794	Thermosynechococcus sp. NK55 genome	blastn	454	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Thermosynechococcus	Thermosynechococcus sp. NK55a
20961040	20961040	PRJNA572587_P_NODE_25757_length_220_cov_71.988304_g25429_i0	PRJNA572587	25757	220	71.988304	158.3742688	Anthocerotibacter panamensis	2857077	Bacteria	Bacteria	145	3.12e-30	NTclustered	gi\|2040348944\|gb\|CP062698.1\|	2778476	g25429	i0	82.857	1.86818181818182	175	16	79	9	28	200	374593	374431	Anthocerotibacter panamensis C109 chromosome, complete genome	blastn	411	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales	Anthocerotibacteraceae	Anthocerotibacter	Anthocerotibacter panamensis
22236195	22236195	PRJNA572587_P_NODE_5338_length_545_cov_144.018145_g5018_i0	PRJNA572587	5338	545	144.018145	784.89889025	Chondrocystis sp. NIES-4102	2005460	Bacteria	Bacteria	828	0	NTclustered	gi\|1210223977\|dbj\|AP018281.1\|	2005460	g5018	i0	96.957	163.521100917431	493	15	90	0	24	516	1933913	1934405	Chondrocystis sp. NIES-4102 DNA, complete genome	blastn	89119	828	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
22236260	22236260	PRJNA572587_P_NODE_8478_length_415_cov_17.724044_g8152_i0	PRJNA572587	8478	415	17.724044	73.5547826	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	375	2.08e-99	NTclustered	gi\|225696214\|gb\|FJ805881.1\|	259957	g8152	i0	90.136	129.489156626506	294	22	87	4	1	290	2101	1811	Uncultured Chroococcidiopsis sp. clone A3_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	53738	375	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24785054	24785054	PRJNA572587_P_NODE_24900_length_225_cov_4.750000_g24572_i0	PRJNA572587	24900	225	4.75	10.6875	Chondrocystis sp. NIES-4102	2005460	Bacteria	Bacteria	353	4.9e-93	NTclustered	gi\|1210223977\|dbj\|AP018281.1\|	2005460	g24572	i0	98.03	155.671111111111	203	4	90	0	1	203	1935198	1934996	Chondrocystis sp. NIES-4102 DNA, complete genome	blastn	35026	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
24785093	24785093	PRJNA572587_P_NODE_27160_length_214_cov_11.818182_g26832_i0	PRJNA572587	27160	214	11.818182	25.29090948	uncultured cyanobacterium	1211	Bacteria	Bacteria	187	4.9499999999999984e-43	NTclustered	gi\|2874253781\|emb\|OY969765.1\|	1211	g26832	i0	95.69	120.401869158879	116	5	87	0	23	138	2239374	2239259	MAG: uncultured cyanobacterium isolate MFD03250.bin.1.145 genome assembly, chromosome: 1	blastn	25766	187	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium

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