metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA897077" and tax_clade = "Cyanobacteriota/Melainabacteria group"

9 rows where analysis = "blastn", 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
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

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