metadata: contig_metadata: 16 rows where bioproject = "PRJNA1197996" and tax_clade = "Cyanobacteriota/Melainabacteria group"

16 rows where bioproject = "PRJNA1197996" 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
1043736	1043736	PRJNA1197996_S_NODE_6861_length_376_cov_1.389439_g6807_i0	PRJNA1197996	6861	376	1.389439	5.22429064	Chroococcidiopsis	54298	Bacteria	Bacteria	507	6.36e-139	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g6807	i0	92.437	145.271276595745	357	24	95	3	17	372	1842	1488	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	54622	507	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
2874647	2874647	PRJNA1197996_S_NODE_14603_length_296_cov_4.515695_g14549_i0	PRJNA1197996	14603	296	4.515695	13.3664572	Chroococcidiopsis sp. SAG 2025	171389	Bacteria	Bacteria	525	1.35e-144	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g14549	i0	98.649	149.128378378378	296	4	100	0	1	296	2436	2141	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	44142	525	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
4871773	4871773	PRJNA1197996_S_NODE_29124_length_234_cov_2.192547_g29070_i0	PRJNA1197996	29124	234	2.192547	5.13055998	Leptolyngbya	47251	Bacteria	Bacteria	353	5.13e-93	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g29070	i0	93.991	153.65811965812	233	14	99	0	2	234	248379	248611	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	35956	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
6701839	6701839	PRJNA1197996_S_NODE_186_length_1291_cov_7.725780_g168_i0	PRJNA1197996	186	1291	7.72578	99.7398198	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	2073	0	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g168	i0	95.73	93.7335398915569	1288	53	99	2	4	1291	2152291	2151006	Leptolyngbya sp. 7M chromosome	blastn	121010	2073	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
7421563	7421563	PRJNA1197996_S_NODE_26846_length_244_cov_1.350877_g26792_i0	PRJNA1197996	26846	244	1.350877	3.29613988	Chroococcidiopsis	54298	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g26792	i0	100	112.393442622951	244	0	100	0	1	244	920	677	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	27424	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
9971660	9971660	PRJNA1197996_S_NODE_12148_length_314_cov_1.875519_g12094_i0	PRJNA1197996	12148	314	1.875519	5.88912966	Hassallia	482629	Bacteria	Bacteria	473	5.29e-129	NTclustered	gi\|1519336825\|gb\|MK211226.1\|	2489140	g12094	i0	93.949	298.407643312102	314	18	100	1	1	314	2430	2118	Hassallia byssoidea KZ-2-2-3 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	93700	473	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia byssoidea
12522287	12522287	PRJNA1197996_S_NODE_18730_length_273_cov_1.155000_g18676_i0	PRJNA1197996	18730	273	1.155	3.15315	Bacteria	2	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2080647037\|gb\|CP080598.1\|	984208	g18676	i0	100	1.03296703296703	29	0	11	0	245	273	4022497	4022525	Sphaerospermopsis torques-reginae ITEP-024 chromosome	blastn	282	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis torques-reginae
16346109	16346109	PRJNA1197996_S_NODE_12113_length_314_cov_3.788382_g12059_i0	PRJNA1197996	12113	314	3.788382	11.89551948	root	1	Root_unresolved	Root_unresolved	52.8	0.029	NTclustered	gi\|2316438351\|gb\|CP064879.1\|	1188	g12059	i0	96.774	0.277070063694268	31	1	10	0	54	84	6667619	6667589	Tolypothrix sp. PCC 7601 chromosome, complete genome	blastn	87	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. PCC 7601
16901073	16901073	PRJNA1197996_S_NODE_17814_length_278_cov_1.126829_g17760_i0	PRJNA1197996	17814	278	1.126829	3.13258462	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	475	1.2799999999999997e-129	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g17760	i0	97.482	114.58273381295	278	7	100	0	1	278	1736	2013	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	31854	475	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21445651	21445651	PRJNA1197996_S_NODE_6557_length_381_cov_1.892857_g6503_i0	PRJNA1197996	6557	381	1.892857	7.21178517	Cyanophyceae	3028117	Bacteria	Bacteria	121	9.82e-23	NTclustered	gi\|46409896\|gb\|AY584521.1\|	118166	g6503	i0	88.776	39.7244094488189	98	11	26	0	34	131	929	1026	Leptolyngbya sp. PCC 7104 23S ribosomal RNA gene, partial sequence	blastn	15135	121	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea nodulosa
22720461	22720461	PRJNA1197996_S_NODE_15938_length_288_cov_1.581395_g15884_i0	PRJNA1197996	15938	288	1.581395	4.5544176	Plectolyngbya	980548	Bacteria	Bacteria	510	3.66e-140	NTclustered	gi\|2106138546\|gb\|OK382086.1\|	2880694	g15884	i0	98.611	114.079861111111	288	4	100	0	1	288	312	25	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	32855	510	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Plectolyngbya	Plectolyngbya terrestris
23276037	23276037	PRJNA1197996_S_NODE_13439_length_304_cov_2.714286_g13385_i0	PRJNA1197996	13439	304	2.714286	8.25142944	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	416	8.719999999999999e-112	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g13385	i0	91.503	268.394736842105	306	21	100	4	1	304	1858803	1859105	Calothrix sp. PCC 7716 DNA, complete genome	blastn	81592	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
23276291	23276291	PRJNA1197996_S_NODE_23879_length_250_cov_1.305085_g23825_i0	PRJNA1197996	23879	250	1.305085	3.2627125	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	322	1.56e-83	NTclustered	gi\|225696250\|gb\|FJ805917.1\|	259957	g23825	i0	89.804	164.092	255	20	100	6	1	250	1920	1667	Uncultured Chroococcidiopsis sp. clone A1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41023	322	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23276497	23276497	PRJNA1197996_S_NODE_6179_length_388_cov_5.041270_g6125_i0	PRJNA1197996	6179	388	5.04127	19.5601276	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	601	2.9299999999999992e-167	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g6125	i0	94.602	441.103092783505	389	19	100	2	1	388	2150914	2150527	Leptolyngbya sp. 7M chromosome	blastn	171148	601	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
29491319	29491319	PRJNA1197996_S_NODE_19430_length_269_cov_1.750000_g19376_i0	PRJNA1197996	19430	269	1.75	4.7075	Cyanophyceae	3028117	Bacteria	Bacteria	157	6.02e-48	NR	CAA05951.1	324056	g19376	i0	90.9	3.92565055762082	88	8	98.1	0	2	265	8	95	CAA05951.1 phycocyanin beta subunit, partial [Microcystis aeruginosa EAWAG175]	diamond	1056	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
31526389	31526389	PRJNA1197996_S_NODE_15936_length_288_cov_1.632558_g15882_i0	PRJNA1197996	15936	288	1.632558	4.70176704	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	120	3.05e-29	NR	HEY9790360.1	2364082	g15882	i0	67.4	2.66666666666667	95	30	99	1	287	3	751	844	HEY9790360.1 ATP-dependent Clp protease ATP-binding subunit [Candidatus Obscuribacterales bacterium]	diamond	768	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales 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);;