metadata: contig_metadata: 23 rows where bioproject = "PRJNA758087" and tax

23 rows where bioproject = "PRJNA758087" 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
733570	733570	PRJNA758087_P_NODE_36401_length_317_cov_1.299180_g35081_i0	PRJNA758087	36401	317	1.29918	4.1184006	Plectolyngbya terrestris	3016457	Bacteria	Bacteria	472	1.92e-128	NTclustered	gi\|2106138546\|gb\|OK382086.1\|	2880694	g35081	i0	95.593	150.173501577287	295	12	93	1	2	295	2282	1988	Plectolyngbya terrestris FBCC-A1479 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	47605	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Plectolyngbya	Plectolyngbya terrestris
4561799	4561799	PRJNA758087_P_NODE_25084_length_500_cov_13.014052_g23764_i0	PRJNA758087	25084	500	13.014052	65.07026	Aliterella chasmolithica	2739056	Bacteria	Bacteria	562	1.8299999999999997e-155	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g23764	i0	90.255	117.42	431	40	86	2	42	471	2394	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	58710	562	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
9662067	9662067	PRJNA758087_P_NODE_36388_length_317_cov_1.774590_g35068_i0	PRJNA758087	36388	317	1.77459	5.6254503	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	466	8.95e-127	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g35068	i0	95.833	214.785488958991	288	12	94	0	30	317	1859336	1859049	Calothrix sp. PCC 7716 DNA, complete genome	blastn	68087	466	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
10131455	10131455	PRJNA758087_P_NODE_41608_length_251_cov_1.129213_g40288_i0	PRJNA758087	41608	251	1.129213	2.83432463	Leptolyngbya	47251	Bacteria	Bacteria	326	1.21e-84	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g40288	i0	95.567	118.195219123506	203	9	82	0	27	229	247327	247125	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	29667	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
11406528	11406528	PRJNA758087_P_NODE_35029_length_336_cov_1.463878_g33709_i0	PRJNA758087	35029	336	1.463878	4.91863008	Leptolyngbya	47251	Bacteria	Bacteria	292	1.72e-74	NTclustered	gi\|2198507406\|gb\|CP092420.1\|	462680	g33709	i0	86.245	1.60119047619048	269	37	80	0	50	318	355477	355209	Leptolyngbya boryana IU 594 plasmid p1, complete sequence	blastn	538	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
12212728	12212728	PRJNA758087_P_NODE_18990_length_639_cov_24.434629_g17693_i0	PRJNA758087	18990	639	24.434629	156.13727931	Anabaena azotica	197653	Bacteria	Bacteria	54.7	0.018	NTclustered	gi\|2894833396\|gb\|CP178454.1\|	3392114	g17693	i0	100	0.0453834115805947	29	0	5	0	426	454	4088887	4088859	Anabaena azotica SJ-1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena azotica
12213534	12213534	PRJNA758087_P_NODE_9230_length_1073_cov_74.860000_g8211_i0	PRJNA758087	9230	1073	74.86	803.2478	Chondrocystis sp. NIES-4102	2005460	Bacteria	Bacteria	512	4.16e-140	NTclustered	gi\|1210227864\|dbj\|AP018282.1\|	2005460	g8211	i0	96.743	0.447343895619758	307	10	29	0	26	332	66206	66512	Chondrocystis sp. NIES-4102 plasmid plasmid1 DNA, complete genome	blastn	480	512	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
12682479	12682479	PRJNA758087_P_NODE_39190_length_282_cov_2.459330_g37870_i0	PRJNA758087	39190	282	2.45933	6.9353106	Drouetiella sp.	3088174	Bacteria	Bacteria	110	2.53e-26	NR	HEY9732054.1	3088174	g37870	i0	100	0.531914893617021	50	0	53.2	0	131	280	1	50	HEY9732054.1 MFS transporter [Drouetiella sp.]	diamond	150	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella sp.
13487466	13487466	PRJNA758087_P_NODE_37071_length_308_cov_1.800000_g35751_i0	PRJNA758087	37071	308	1.8	5.544	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	401	2.4799999999999992e-107	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g35751	i0	92.254	93.224025974026	284	20	92	2	2	284	3033	2751	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28713	401	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13956737	13956737	PRJNA758087_P_NODE_38191_length_294_cov_1.742081_g36871_i0	PRJNA758087	38191	294	1.742081	5.12171814	Cyanophyceae	3028117	Bacteria	Bacteria	342	1.45e-89	NTclustered	gi\|664803803\|gb\|KM019916.1\|	1521500	g36871	i0	100	66.7585034013605	185	0	63	0	24	208	1086	1270	Plectonema sp. SAG 38.90 16S ribosomal RNA gene, partial sequence	blastn	19627	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Plectonema	Plectonema sp. SAG 38.90
16036291	16036291	PRJNA758087_P_NODE_36473_length_316_cov_1.296296_g35153_i0	PRJNA758087	36473	316	1.296296	4.09629536	Cyanobacteria bacterium RM1_2_2	2720432	Bacteria	Bacteria	167	1.42e-45	NR	NJO77397.1	2720432	g35153	i0	94.2	5.71518987341772	86	5	81.6	0	2	259	228	313	NJO77397.1 TIGR03960 family B12-binding radical SAM protein [Cyanobacteria bacterium RM1_2_2]	diamond	1806	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium RM1_2_2
16505642	16505642	PRJNA758087_P_NODE_29053_length_427_cov_3.923729_g27733_i0	PRJNA758087	29053	427	3.923729	16.75432283	Nostocaceae	1162	Bacteria	Bacteria	525	2.0199999999999998e-144	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g27733	i0	90.148	182.332552693208	406	37	95	3	1	404	2378140	2377736	Nostoc sp. PCC 7120 DNA, complete genome	blastn	77856	525	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
18585757	18585757	PRJNA758087_P_NODE_7475_length_1218_cov_4.045415_g6558_i0	PRJNA758087	7475	1218	4.045415	49.2731547	unclassified Leptolyngbya	2650499	Bacteria	Bacteria	427	6.019999999999998e-145	NR	WP_190379852.1	2650499	g6558	i0	94.1	1.6256157635468	220	13	54.2	0	1185	526	126	345	WP_190379852.1 MULTISPECIES: zinc-dependent alcohol dehydrogenase [unclassified Leptolyngbya]	diamond	1980	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya
21604854	21604854	PRJNA758087_P_NODE_13257_length_836_cov_68.372215_g12068_i0	PRJNA758087	13257	836	68.372215	571.5917174	Cyanophyceae	3028117	Bacteria	Bacteria	77	8.34e-12	NR	WP_190763162.1	3028117	g12068	i0	41.1	0.566985645933014	158	80	53.8	8	796	347	262	414	WP_190763162.1 MULTISPECIES: SBBP repeat-containing protein [Cyanophyceae]	diamond	474	77	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
22410685	22410685	PRJNA758087_P_NODE_24638_length_509_cov_19.823394_g23318_i0	PRJNA758087	24638	509	19.823394	100.90107546	Cyanophyceae	3028117	Bacteria	Bacteria	236	4.77e-77	NR	WP_179046445.1	2576904	g23318	i0	80	8.63457760314342	145	29	85.5	0	5	439	13	157	WP_179046445.1 GNAT family N-acetyltransferase [Nostoc sp. TCL26-01]	diamond	4395	237	0.9957805907173	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL26-01
23686538	23686538	PRJNA758087_P_NODE_30539_length_402_cov_6.534954_g29219_i0	PRJNA758087	30539	402	6.534954	26.27051508	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	464	4.179999999999999e-126	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g29219	i0	91.667	126.174129353234	336	26	83	2	43	377	2089	1755	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	50722	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23686828	23686828	PRJNA758087_P_NODE_42379_length_248_cov_0.708571_g41059_i0	PRJNA758087	42379	248	0.708571	1.75725608	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	348	2.55e-91	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g41059	i0	97.537	93.4959677419355	203	5	82	0	1	203	2862	3064	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	23187	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
27716742	27716742	PRJNA758087_P_NODE_13484_length_827_cov_2.259947_g12290_i0	PRJNA758087	13484	827	2.259947	18.68976169	Leptolyngbya sp. ERB_1_1	2083155	Bacteria	Bacteria	366	9.2e-125	NR	MER3435257.1	2083155	g12290	i0	93.2	0.696493349455865	192	13	69.6	0	804	229	77	268	MER3435257.1 hypothetical protein [Leptolyngbya sp. ERB_1_1]	diamond	576	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. ERB_1_1
27905541	27905541	PRJNA758087_P_NODE_23265_length_539_cov_1.156652_g21948_i0	PRJNA758087	23265	539	1.156652	6.23435428	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	202	9.84e-61	NR	HEY9781437.1	3088178	g21948	i0	66.1	0.951762523191095	171	52	92.4	4	36	533	3	172	HEY9781437.1 FAD-dependent oxidoreductase [Leptolyngbyaceae cyanobacterium]	diamond	513	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
28347818	28347818	PRJNA758087_P_NODE_15566_length_747_cov_3.488131_g14322_i0	PRJNA758087	15566	747	3.488131	26.05633857	Drouetiella sp.	3088174	Bacteria	Bacteria	444	2.4899999999999993e-152	NR	HEY9730898.1	3088174	g14322	i0	99.6	0.943775100401606	235	1	94.4	0	727	23	49	283	HEY9730898.1 hypothetical protein [Drouetiella sp.]	diamond	705	444	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella sp.
29011284	29011284	PRJNA758087_P_NODE_42888_length_245_cov_1.343023_g41568_i0	PRJNA758087	42888	245	1.343023	3.29040635	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	88.6	2.77e-18	NR	WP_202807234.1	927677	g41568	i0	58.7	1.99591836734694	92	26	99.2	2	3	245	320	410	WP_202807234.1 DUF1565 domain-containing protein [Synechocystis sp. PCC 7509]	diamond	489	88.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
30526825	30526825	PRJNA758087_P_NODE_41733_length_251_cov_0.865169_g40413_i0	PRJNA758087	41733	251	0.865169	2.17157419	Trichocoleus sp. Lan	2933927	Bacteria	Bacteria	167	4.66e-50	NR	WP_348239706.1	2933927	g40413	i0	91.1	7.58964143426295	79	7	94.4	0	13	249	110	188	WP_348239706.1 IS1 family transposase [Trichocoleus sp. Lan]	diamond	1905	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus sp. Lan
32739830	32739830	PRJNA758087_P_NODE_7580_length_1208_cov_22.822907_g6656_i0	PRJNA758087	7580	1208	22.822907	275.70071656	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	166	6.79e-41	NR	MBX9696243.1	2847862	g6656	i0	46.7	0.824503311258278	332	167	81.7	6	151	1137	90	414	MBX9696243.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	996	166	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota 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);;