metadata: contig_metadata: 11 rows where bioproject = "PRJNA635874" and tax_clade = "Cyanobacteriota/Melainabacteria group"

11 rows where bioproject = "PRJNA635874" 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
607852	607852	PRJNA635874_P_NODE_53701_length_248_cov_0.880000_g53554_i0	PRJNA635874	53701	248	0.88	2.1824	Nodularia sphaerocarpa	137816	Bacteria	Bacteria	285	2.0299999999999997e-72	NTclustered	gi\|2198613447\|gb\|CP060140.1\|	2761619	g53554	i0	87.705	3.94758064516129	244	30	98	0	5	248	1529893	1529650	Nodularia sphaerocarpa UHCC 0038 chromosome, complete genome	blastn	979	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia sphaerocarpa
19733862	19733862	PRJNA635874_P_NODE_29096_length_306_cov_1.321888_g28949_i0	PRJNA635874	29096	306	1.321888	4.04497728	Scytonema sp. HKAR-10	2746664	Bacteria	Bacteria	560	3.84e-155	NTclustered	gi\|1859675731\|gb\|MT644506.1\|	2746664	g28949	i0	99.673	99.640522875817	306	1	100	0	1	306	715	410	Scytonema sp. HKAR-10 16S ribosomal RNA gene, partial sequence	blastn	30490	560	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. HKAR-10
23560422	23560422	PRJNA635874_P_NODE_51619_length_249_cov_0.875000_g51472_i0	PRJNA635874	51619	249	0.875	2.17875	Scytonema hofmannii	34078	Bacteria	Bacteria	379	9.1e-101	NTclustered	gi\|146740650\|emb\|AM709637.1\|	128403	g51472	i0	94.628	208.152610441767	242	12	97	1	1	241	2250	2009	Scytonema hofmanni PCC 7110 partial ribosomal RNA operon, strain PCC 7110	blastn	51830	379	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema hofmannii
24833085	24833085	PRJNA635874_P_NODE_13480_length_411_cov_1.301775_g13333_i0	PRJNA635874	13480	411	1.301775	5.35029525	Cyanophyceae	3028117	Bacteria	Bacteria	112	8.520000000000001e-29	NR	NEQ95720.1	2607797	g13333	i0	66.2	8.10948905109489	74	25	54	0	409	188	76	149	NEQ95720.1 nucleoside-diphosphate kinase [Cyanothece sp. SIO2G6]	diamond	3333	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Cyanothecaceae	Cyanothece	Cyanothece sp. SIO2G6
24834515	24834515	PRJNA635874_P_NODE_68360_length_243_cov_0.905882_g68213_i0	PRJNA635874	68360	243	0.905882	2.20129326	Leptolyngbya sp. BL0902	1115757	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1949996095\|gb\|CP046155.1\|	1115757	g68213	i0	100	0.11522633744856	28	0	12	0	36	63	3964594	3964567	Leptolyngbya sp. BL0902 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL0902
27933833	27933833	PRJNA635874_P_NODE_68605_length_243_cov_0.870588_g68458_i0	PRJNA635874	68605	243	0.870588	2.11552884	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	162	2.55e-46	NR	MBW4636849.1	2839657	g68458	i0	98.8	0.987654320987654	80	1	98.8	0	2	241	252	331	MBW4636849.1 glycosyltransferase [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	240	162	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
29165442	29165442	PRJNA635874_P_NODE_66249_length_243_cov_1.288235_g66102_i0	PRJNA635874	66249	243	1.288235	3.13041105	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	50.1	5.42e-6	NR	HEY9709204.1	3088181	g66102	i0	83.3	0.37037037037037	30	5	37	0	58	147	29	58	HEY9709204.1 hypothetical protein [Oculatellaceae cyanobacterium]	diamond	90	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
29480629	29480629	PRJNA635874_P_NODE_67550_length_243_cov_0.905882_g67403_i0	PRJNA635874	67550	243	0.905882	2.20129326	Candidatus Melainabacteria bacterium HGW-Melainabacteria-1	2013813	Bacteria	Bacteria	98.2	2.21e-24	NR	PKL76345.1	2013813	g67403	i0	63.4	0.876543209876543	71	26	87.7	0	243	31	44	114	PKL76345.1 MAG: hypothetical protein CVV27_10720, partial [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	213	98.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium HGW-Melainabacteria-1
29525107	29525107	PRJNA635874_P_NODE_70110_length_242_cov_0.911243_g69963_i0	PRJNA635874	70110	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	107	2.61e-26	NR	HEY9840541.1	2364082	g69963	i0	62.8	2.13223140495868	86	25	97.9	2	237	1	1	86	HEY9840541.1 helix-turn-helix transcriptional regulator [Candidatus Obscuribacterales bacterium]	diamond	516	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31598195	31598195	PRJNA635874_P_NODE_36936_length_278_cov_1.502439_g36789_i0	PRJNA635874	36936	278	1.502439	4.17678042	Oscillatoria laete-virens	1565316	Bacteria	Bacteria	180	3.48e-51	NR	MDL5052177.1	3051890	g36789	i0	92.4	0.992805755395683	92	7	99.3	0	3	278	399	490	MDL5052177.1 hypothetical protein [Oscillatoria laete-virens NRMC-F 0139]	diamond	276	180	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria laete-virens
32798913	32798913	PRJNA635874_P_NODE_54500_length_248_cov_0.880000_g54353_i0	PRJNA635874	54500	248	0.88	2.1824	Microcystis viridis NIES-1	44822	Bacteria	Bacteria	42.4	0.0294	NR	BBH38721.1	213615	g54353	i0	27.3	0.798387096774194	66	44	79.8	1	21	218	74	135	BBH38721.1 hypothetical protein myaer102_12260 [Microcystis viridis NIES-102]	diamond	198	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis viridis

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