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

4 rows where analysis = "blastn", bioproject = "PRJNA801875" 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
14829491	14829491	PRJNA801875_P_NODE_1752_length_283_cov_1.967742_g1649_i0	PRJNA801875	1752	283	1.967742	5.56870986	Stanieria cyanosphaera	102116	Bacteria	Bacteria	250	8.63e-62	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g1649	i0	83.395	50.4452296819788	271	43	95	2	3	272	492	761	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	14276	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
18652530	18652530	PRJNA801875_P_NODE_1755_length_283_cov_1.125000_g1652_i0	PRJNA801875	1755	283	1.125	3.18375	Geminocystis sp. NIES-3709	1617448	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|770470343\|dbj\|AP014821.1\|	1617448	g1652	i0	96.774	0.109540636042403	31	1	11	0	175	205	3342900	3342870	Geminocystis sp. NIES-3709 DNA, complete genome	blastn	31	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. NIES-3709
18652546	18652546	PRJNA801875_P_NODE_2995_length_193_cov_1.715190_g2892_i0	PRJNA801875	2995	193	1.71519	3.3103167	Cyanobacteria bacterium K4m	2830641	Bacteria	Bacteria	300	5.3800000000000004e-77	NTclustered	gi\|2029258269\|gb\|MZ020199.1\|	2830641	g2892	i0	95.263	189.290155440415	190	8	98	1	4	192	1280	1469	Cyanobacteria bacterium K4m 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	36533	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K4m
22478133	22478133	PRJNA801875_P_NODE_4458_length_155_cov_1.200000_g4355_i0	PRJNA801875	4458	155	1.2	1.86	Leptolyngbyales cyanobacterium LEGE 16527	3132504	Bacteria	Bacteria	248	1.51e-61	NTclustered	gi\|2697880852\|gb\|PP476853.1\|	3132504	g4355	i0	95.57	102.98064516129	158	1	98	3	4	155	1241	1084	Leptolyngbyales cyanobacterium LEGE 16527 16S ribosomal RNA gene, partial sequence	blastn	15962	248	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales			Leptolyngbyales cyanobacterium LEGE 16527

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