metadata: contig_metadata: 21 rows where bioproject = "PRJNA615175", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

21 rows where bioproject = "PRJNA615175", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Cyanobacteriota"

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
594877	594877	PRJNA615175_P_NODE_19861_length_312_cov_1.184100_g19693_i0	PRJNA615175	19861	312	1.1841	3.694392	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	444	4.12e-120	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g19693	i0	92.308	2.40384615384615	312	24	100	0	1	312	1574733	1574422	Calothrix sp. PCC 7716 DNA, complete genome	blastn	750	444	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
2425003	2425003	PRJNA615175_P_NODE_1362_length_1268_cov_2.365690_g1269_i0	PRJNA615175	1362	1268	2.36569	29.9969492	Thermoleptolyngbya	2303528	Bacteria	Bacteria	1866	0	NTclustered	gi\|2592622306\|gb\|CP053540.1\|	2547457	g1269	i0	93.182	181.070189274448	1276	77	100	10	1	1268	312079	313352	Thermoleptolyngbya oregonensis NK1-22 chromosome, complete genome	blastn	229597	1882	0.991498405951116	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya oregonensis
5698333	5698333	PRJNA615175_P_NODE_13985_length_380_cov_2.869707_g13817_i0	PRJNA615175	13985	380	2.869707	10.9048866	Aliterella chasmolithica	2739056	Bacteria	Bacteria	603	7.969999999999999e-168	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g13817	i0	95.263	185.976315789474	380	18	100	0	1	380	2084	2463	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	70671	603	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
12074040	12074040	PRJNA615175_P_NODE_10550_length_450_cov_3.671088_g10382_i0	PRJNA615175	10550	450	3.671088	16.519896	Fortiea sp. LEGE XX443	1828611	Bacteria	Bacteria	89.7	9.55e-18	NR	WP_193885198.1	1828611	g10382	i0	34.9	4.52666666666667	149	94	98	2	449	9	213	360	WP_193885198.1 FAD-dependent oxidoreductase [Fortiea sp. LEGE XX443]	diamond	2037	89.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Fortieaceae	Fortiea	Fortiea sp. LEGE XX443
12074178	12074178	PRJNA615175_P_NODE_19850_length_312_cov_1.280335_g19682_i0	PRJNA615175	19850	312	1.280335	3.9946452	Kovacikia minuta	2931930	Bacteria	Bacteria	355	1.99e-93	NTclustered	gi\|2098452651\|gb\|CP083582.1\|	2653194	g19682	i0	89.68	234.294871794872	281	25	89	4	34	312	4176606	4176328	Kovacikia minuta CCNUW1 strain CCNU0001 chromosome, complete genome	blastn	73100	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Kovacikia	Kovacikia minuta
14623825	14623825	PRJNA615175_P_NODE_24192_length_277_cov_2.264706_g24024_i0	PRJNA615175	24192	277	2.264706	6.27323562	cyanobacterium NIES-2125	2510788	Bacteria	Bacteria	239	1.82e-58	NTclustered	gi\|1566846232\|dbj\|LC455610.1\|	2510788	g24024	i0	82.31	149.736462093863	277	47	100	2	1	277	476	202	Cyanobacterium NIES-2125 gene for 23S ribosomal RNA, partial sequence	blastn	41477	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-2125
16452588	16452588	PRJNA615175_P_NODE_24553_length_274_cov_3.313433_g24385_i0	PRJNA615175	24553	274	3.313433	9.07880642	Nostocales	1161	Bacteria	Bacteria	403	6.03e-108	NTclustered	gi\|333109175\|gb\|JF768745.1\|	1029747	g24385	i0	93.704	305.554744525547	270	15	98	2	1	269	2104	2372	Aphanizomenon ovalisporum ILC-164 rDNA type 2 operon, complete sequence	blastn	83722	407	0.99017199017199	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Umezakia	Umezakia ovalisporum
18446719	18446719	PRJNA615175_P_NODE_10975_length_439_cov_1.893443_g10807_i0	PRJNA615175	10975	439	1.893443	8.31221477	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	654	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g10807	i0	95.813	271.911161731207	406	15	92	2	6	410	9969228	9968824	Calothrix sp. PCC 7716 DNA, complete genome	blastn	119369	654	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
21551764	21551764	PRJNA615175_P_NODE_7057_length_569_cov_5.038306_g6892_i0	PRJNA615175	7057	569	5.038306	28.66796114	Prochlorococcus	1218	Bacteria	Bacteria	555	3.509999999999999e-153	NTclustered	gi\|2895571264\|gb\|CP138937.1\|	59922	g6892	i0	84.441	168.95957820738101	572	80	100	7	1	569	1333	768	Prochlorococcus marinus str. MIT 9303 chromosome, complete genome	blastn	96138	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
23547298	23547298	PRJNA615175_P_NODE_14599_length_371_cov_1.033557_g14431_i0	PRJNA615175	14599	371	1.033557	3.83449647	Brasilonema sennae	1397703	Bacteria	Bacteria	228	5.459999999999999e-55	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g14431	i0	82.331	27.9676549865229	266	43	71	4	1	264	1575312	1575575	Brasilonema sennae CENA114 chromosome	blastn	10376	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
25376142	25376142	PRJNA615175_P_NODE_14380_length_374_cov_2.558140_g14212_i0	PRJNA615175	14380	374	2.55814	9.5674436	Leptolyngbya	47251	Bacteria	Bacteria	603	7.829999999999997e-168	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g14212	i0	95.733	181.991978609626	375	14	100	2	1	374	248179	248552	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	68065	608	0.991776315789474	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
27649086	27649086	PRJNA615175_P_NODE_36124_length_226_cov_3.895425_g35956_i0	PRJNA615175	36124	226	3.895425	8.8036605	Thermoleptolyngbya sp. C42_A2	3100228	Bacteria	Bacteria	139	2.4999999999999996e-38	NR	WP_297084203.1	2747799	g35956	i0	91.9	0.982300884955752	74	6	98.2	0	224	3	75	148	WP_297084203.1 AraC family transcriptional regulator [Thermoleptolyngbya sp. C42_A2020_037]	diamond	222	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya sp. C42_A2020_037
27680862	27680862	PRJNA615175_P_NODE_19844_length_312_cov_1.288703_g19676_i0	PRJNA615175	19844	312	1.288703	4.02075336	Phormidium tenue	126344	Bacteria	Bacteria	149	4.42e-42	NR	MBD3883789.1	2692911	g19676	i0	94.7	0.721153846153846	75	4	72.1	0	1	225	211	285	MBD3883789.1 aldose epimerase [Phormidium tenue FACHB-886]	diamond	225	149	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium tenue
28324937	28324937	PRJNA615175_P_NODE_4666_length_716_cov_3.928460_g4506_i0	PRJNA615175	4666	716	3.92846	28.1277736	Bacteria	2	Bacteria	Bacteria	86.3	3.13e-15	NR	NET09805.1	2607785	g4506	i0	32.5	4.55446927374302	169	86	70.4	4	26	529	825	966	NET09805.1 response regulator [Symploca sp. SIO2B6]	diamond	3261	86.7	0.995386389850058	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Symploca	Symploca sp. SIO2B6
29700906	29700906	PRJNA615175_P_NODE_24870_length_272_cov_1.547739_g24702_i0	PRJNA615175	24870	272	1.547739	4.20985008	Aliterella atlantica	1827278	Bacteria	Bacteria	134	1.2699999999999998e-35	NR	WP_045056602.1	1827278	g24702	i0	100	0.738970588235294	67	0	73.9	0	270	70	332	398	WP_045056602.1 response regulator [Aliterella atlantica]	diamond	201	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
31060066	31060066	PRJNA615175_P_NODE_16455_length_347_cov_1.058394_g16287_i0	PRJNA615175	16455	347	1.058394	3.67262718	Synechococcales cyanobacterium T60_A2020_003	2774349	Bacteria	Bacteria	48.5	0.00112	NR	MBF2080596.1	2774349	g16287	i0	38.2	1.57348703170029	76	40	65.7	2	229	2	489	557	MBF2080596.1 SBBP repeat-containing protein [Synechococcales cyanobacterium T60_A2020_003]	diamond	546	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales			Synechococcales cyanobacterium T60_A2020_003
31249322	31249322	PRJNA615175_P_NODE_21615_length_297_cov_1.191964_g21447_i0	PRJNA615175	21615	297	1.191964	3.54013308	Dulcicalothrix desertica	32056	Bacteria	Bacteria	117	9.69e-29	NR	WP_127084487.1	32056	g21447	i0	52.4	6.34343434343434	103	44	99	1	294	1	7	109	WP_127084487.1 threonine--tRNA ligase [Dulcicalothrix desertica]	diamond	1884	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
31312611	31312611	PRJNA615175_P_NODE_415_length_1862_cov_5.830632_g378_i0	PRJNA615175	415	1862	5.830632	108.56636784	Leptolyngbyaceae cyanobacterium M33_DOE_097	2747805	Bacteria	Bacteria	153	9.56e-35	NR	HIK14036.1	2747805	g378	i0	38.2	1.98657357679914	220	126	33.8	4	630	1	1492	1711	HIK14036.1 AAA family ATPase [Leptolyngbyaceae cyanobacterium M33_DOE_097]	diamond	3699	153	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium M33_DOE_097
31768412	31768412	PRJNA615175_P_NODE_117_length_2642_cov_3.584274_g109_i0	PRJNA615175	117	2642	3.584274	94.69651908	Scytonema	1203	Bacteria	Bacteria	551	5.829999999999998e-178	NR	WP_190767560.1	3028117	g109	i0	37.9	7.34784254352763	934	485	99.8	20	5	2641	83	976	WP_190767560.1 MULTISPECIES: ATP-binding protein [Cyanophyceae]	diamond	19413	551	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
31850285	31850285	PRJNA615175_P_NODE_2117_length_1052_cov_1.977528_g2001_i0	PRJNA615175	2117	1052	1.977528	20.80359456	Fischerella sp. PCC 96	1191	Bacteria	Bacteria	50.1	0.0155	NR	WP_026735542.1	1173024	g2001	i0	47.5	0.114068441064639	40	21	11.4	0	10	129	622	661	WP_026735542.1 NB-ARC domain-containing protein [Fischerella sp. PCC 9605]	diamond	120	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp. PCC 9605
32591112	32591112	PRJNA615175_P_NODE_2879_length_915_cov_9.035629_g2746_i0	PRJNA615175	2879	915	9.035629	82.67600535	Cyanophyceae	3028117	Bacteria	Bacteria	182	3.71e-50	NR	MBW4538789.1	1601998	g2746	i0	44	3.21967213114754	248	104	69.8	8	3	641	45	292	MBW4538789.1 erythromycin esterase family protein [Myxacorys chilensis ATA2-1-KO14]	diamond	2946	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Myxacorys	Myxacorys chilensis

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