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

4 rows where analysis = "blastn", bioproject = "PRJNA1253698" 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
359598	359598	PRJNA1253698_S_NODE_6001_length_280_cov_2.428571_g5635_i0	PRJNA1253698	6001	280	2.428571	6.7999988	Nostoc sp. PCC 7524	28072	Bacteria	Bacteria	294	3.88e-75	NTclustered	gi\|427363208\|gb\|CP003552.1\|	28072	g5635	i0	88.889	44.3821428571429	243	22	86	3	15	254	5042385	5042625	Nostoc sp. PCC 7524, complete genome	blastn	12427	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
5463022	5463022	PRJNA1253698_S_NODE_6665_length_266_cov_2.373272_g6299_i0	PRJNA1253698	6665	266	2.373272	6.31290352	Halotia branconii	1620816	Bacteria	Bacteria	309	1.31e-79	NTclustered	gi\|2500982325\|gb\|CP124543.1\|	1539056	g6299	i0	90.909	69.6842105263158	231	19	86	2	37	265	3508430	3508200	Halotia branconii CENA392 chromosome, complete genome	blastn	18536	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Halotia	Halotia branconii
20761228	20761228	PRJNA1253698_S_NODE_19297_length_167_cov_0.881356_g18931_i0	PRJNA1253698	19297	167	0.881356	1.47186452	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	191	2.85e-44	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g18931	i0	88.125	0.958083832335329	160	19	96	0	4	163	1448726	1448885	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	160	191	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
23311850	23311850	PRJNA1253698_S_NODE_14719_length_183_cov_2.373134_g14353_i0	PRJNA1253698	14719	183	2.373134	4.34283522	Aliterella chasmolithica	2739056	Bacteria	Bacteria	289	1.0899999999999998e-73	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g14353	i0	95.082	126.469945355191	183	9	100	0	1	183	2171	1989	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	23144	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica

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