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

5 rows where analysis = "blastn", bioproject = "PRJNA1115053" 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
225664	225664	PRJNA1115053_S_NODE_239221_length_179_cov_1.514706_g237404_i0	PRJNA1115053	239221	179	1.514706	2.71132374	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g237404	i0	100	0.156424581005587	28	0	16	0	128	155	1687073	1687046	Synechococcus sp. CB0101 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
4055594	4055594	PRJNA1115053_S_NODE_51804_length_332_cov_4.622837_g49987_i0	PRJNA1115053	51804	332	4.622837	15.34781884	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	412	1.2499999999999997e-110	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g49987	i0	89.157	237.53313253012	332	35	100	1	1	332	2069	1739	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	78861	412	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8677827	8677827	PRJNA1115053_S_NODE_323367_length_155_cov_2.142857_g321550_i0	PRJNA1115053	323367	155	2.142857	3.32142835	Nostoc	1177	Bacteria	Bacteria	252	1.17e-62	NTclustered	gi\|427357970\|gb\|CP003548.1\|	317936	g321550	i0	96.689	228.264516129032	151	5	97	0	5	155	205616	205466	Nostoc sp. PCC 7107, complete genome	blastn	35381	254	0.992125984251969	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7107
17602480	17602480	PRJNA1115053_S_NODE_94254_length_265_cov_2.788288_g92437_i0	PRJNA1115053	94254	265	2.788288	7.3889632	Nostocaceae	1162	Bacteria	Bacteria	484	2.0199999999999998e-132	NTclustered	gi\|75699950\|gb\|CP000117.1\|	240292	g92437	i0	99.623	281.181132075472	265	1	100	0	1	265	1005778	1005514	Anabaena variabilis ATCC 29413, complete genome	blastn	74513	484	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus variabilis
18081108	18081108	PRJNA1115053_S_NODE_79255_length_284_cov_1.394191_g77438_i0	PRJNA1115053	79255	284	1.394191	3.95950244	Geminocystis sp. NIES-3708	1615909	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|770466698\|dbj\|AP014815.1\|	1615909	g77438	i0	100	0.102112676056338	29	0	10	0	178	206	1747064	1747036	Geminocystis sp. NIES-3708 DNA, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. NIES-3708

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