metadata: contig_metadata: 14 rows where bioproject = "PRJNA897077" and tax_clade = "Cyanobacteriota/Melainabacteria group"

14 rows where bioproject = "PRJNA897077" 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
2519813	2519813	PRJNA897077_P_NODE_19902_length_242_cov_0.923077_g19775_i0	PRJNA897077	19902	242	0.923077	2.23384634	Synechococcus	1129	Bacteria	Bacteria	193	1.23e-44	NTclustered	gi\|1940477070\|gb\|CP060398.1\|	1353134	g19775	i0	93.182	44.5289256198347	132	7	54	2	1	130	1786064	1786195	Synechococcus sp. CBW1002 chromosome, complete genome	blastn	10776	193	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1002
3796089	3796089	PRJNA897077_P_NODE_20263_length_227_cov_2.025974_g20136_i0	PRJNA897077	20263	227	2.025974	4.59896098	Cyanophyceae	3028117	Bacteria	Bacteria	420	4.81e-113	NTclustered	gi\|453199517\|gb\|JQ997497.1\|	259957	g20136	i0	100	150.748898678414	227	0	100	0	1	227	297	71	Uncultured Chroococcidiopsis sp. clone GKJWQY101AZKND 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34220	420	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7251693	7251693	PRJNA897077_P_NODE_13386_length_271_cov_1.575758_g13259_i0	PRJNA897077	13386	271	1.575758	4.27030418	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	484	2.07e-132	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g13259	i0	98.893	134.774907749077	271	3	100	0	1	271	1803	1533	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	36524	484	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
8526404	8526404	PRJNA897077_P_NODE_16087_length_251_cov_0.876404_g15960_i0	PRJNA897077	16087	251	0.876404	2.19977404	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	79.7	3.93e-15	NR	MEB3305071.1	2847862	g15960	i0	97.4	0.466135458167331	39	1	46.6	0	133	249	1	39	MEB3305071.1 polyphosphate kinase 1 [Cyanobacteriota bacterium]	diamond	117	79.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
11077135	11077135	PRJNA897077_P_NODE_18049_length_246_cov_0.947977_g17922_i0	PRJNA897077	18049	246	0.947977	2.33202342	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	342	1.1799999999999997e-89	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g17922	i0	91.87	155.723577235772	246	19	100	1	1	246	45	289	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	38308	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
17451899	17451899	PRJNA897077_P_NODE_4154_length_474_cov_2.882793_g4027_i0	PRJNA897077	4154	474	2.882793	13.66443882	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	795	0	NTclustered	gi\|1280084617\|gb\|MF574179.1\|	119533	g4027	i0	96.849	278.848101265823	476	13	100	2	1	474	2356	2831	Scytonema hyalinum rrn type 2 operon, partial sequence; precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes and 23S-5S internal transcribed spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	132174	795	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
18725051	18725051	PRJNA897077_P_NODE_15395_length_253_cov_0.866667_g15268_i0	PRJNA897077	15395	253	0.866667	2.19266751	Synechococcus sp. A15-62	1050657	Bacteria	Bacteria	171	6.07e-38	NTclustered	gi\|1895797625\|gb\|CP047950.1\|	1050657	g15268	i0	87.333	55.2766798418972	150	17	59	2	105	253	161187	161335	Synechococcus sp. A15-62 chromosome, complete genome	blastn	13985	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. A15-62
23825739	23825739	PRJNA897077_P_NODE_1539_length_770_cov_2.794835_g1426_i0	PRJNA897077	1539	770	2.794835	21.5202295	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	1118	0	NTclustered	gi\|1280084616\|gb\|MF574178.1\|	119533	g1426	i0	93.203	180.992207792208	765	45	99	7	9	770	3959	3199	Scytonema hyalinum rrn type 2 operon, precursor RNA, transcribed leader region, and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes, 23S-5S internal transcribed spacer, and 5S ribosomal RNA gene, complete sequence	blastn	139364	1118	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
23825823	23825823	PRJNA897077_P_NODE_20119_length_237_cov_2.274390_g19992_i0	PRJNA897077	20119	237	2.27439	5.3903043	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	438	1.4e-118	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g19992	i0	100	117.092827004219	237	0	100	0	1	237	1050	814	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	27751	438	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
24195644	24195644	PRJNA897077_P_NODE_12359_length_282_cov_1.421053_g12232_i0	PRJNA897077	12359	282	1.421053	4.00736946	Nostocaceae	1162	Bacteria	Bacteria	455	1.7e-123	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g12232	i0	95.745	254.450354609929	282	12	100	0	1	282	2378336	2378055	Nostoc sp. PCC 7120 DNA, complete genome	blastn	71755	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
27150108	27150108	PRJNA897077_P_NODE_19802_length_242_cov_0.923077_g19675_i0	PRJNA897077	19802	242	0.923077	2.23384634	Tolypothrix carrinoi	1874533	Bacteria	Bacteria	72.4	1.25e-12	NR	MBW4570784.1	1874569	g19675	i0	45	0.991735537190083	80	44	99.2	0	1	240	18	97	MBW4570784.1 S8 family serine peptidase [Tolypothrix carrinoi HA7290-LM1]	diamond	240	72.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix carrinoi
29140191	29140191	PRJNA897077_P_NODE_16109_length_251_cov_0.876404_g15982_i0	PRJNA897077	16109	251	0.876404	2.19977404	Cyanobium gracile	59930	Bacteria	Bacteria	79.7	3.99e-15	NR	WP_015110162.1	59930	g15982	i0	50.6	0.99203187250996006	83	41	99.2	0	1	249	478	560	WP_015110162.1 hypothetical protein [Cyanobium gracile]	diamond	249	79.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium gracile
29960914	29960914	PRJNA897077_P_NODE_19551_length_243_cov_0.917647_g19424_i0	PRJNA897077	19551	243	0.917647	2.22988221	Chroococcus sp. FPU1	1974212	Bacteria	Bacteria	90.1	8.07e-19	NR	WP_206815285.1	1974212	g19424	i0	92.3	0.641975308641975	52	4	64.2	0	243	88	673	724	WP_206815285.1 PAS domain-containing hybrid sensor histidine kinase/response regulator [Chroococcus sp. FPU101]	diamond	156	90.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. FPU101
32047268	32047268	PRJNA897077_P_NODE_16018_length_251_cov_0.876404_g15891_i0	PRJNA897077	16018	251	0.876404	2.19977404	Microcystis aeruginosa	1126	Bacteria	Bacteria	56.2	7.27e-7	NR	WP_185240507.1	1126	g15891	i0	51	1.82868525896414	51	25	61	0	23	175	543	593	WP_185240507.1 serine/threonine-protein kinase [Microcystis aeruginosa]	diamond	459	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa

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