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

6 rows where analysis = "blastn", bioproject = "PRJNA407886" 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
418014	418014	PRJNA407886_P_NODE_73921_length_247_cov_2.114943_g72227_i0	PRJNA407886	73921	247	2.114943	5.22390921	Halothece sp. PCC 7418	65093	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|428688965\|gb\|CP003945.1\|	65093	g72227	i0	92.308	1.07287449392713	39	3	16	0	140	178	4008612	4008650	Halothece sp. PCC 7418 chromosome, complete genome	blastn	265	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Halothecacae	Halothece	Halothece sp. PCC 7418
6795748	6795748	PRJNA407886_P_NODE_69786_length_251_cov_0.865169_g68092_i0	PRJNA407886	69786	251	0.865169	2.17157419	Nostoc flagelliforme	1306274	Bacteria	Bacteria	392	1.18e-104	NTclustered	gi\|1297075411\|gb\|CP024785.1\|	2038116	g68092	i0	95.51	13.8605577689243	245	11	98	0	1	245	2819684	2819928	Nostoc flagelliforme CCNUN1 chromosome, complete genome	blastn	3479	392	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
10621874	10621874	PRJNA407886_P_NODE_69329_length_251_cov_2.140449_g67635_i0	PRJNA407886	69329	251	2.140449	5.37252699	Nostoc sp. MS1	2764711	Bacteria	Bacteria	58.4	4.89e-4	NTclustered	gi\|2093825993\|dbj\|AP023441.1\|	2764711	g67635	i0	100	0.123505976095618	31	0	12	0	129	159	4614885	4614855	Nostoc sp. MS1 DNA, complete genome	blastn	31	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. MS1
11896937	11896937	PRJNA407886_P_NODE_74510_length_247_cov_0.885057_g72816_i0	PRJNA407886	74510	247	0.885057	2.18609079	Nostoc sp. NIES-4103	2005458	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|1210228378\|dbj\|AP018288.1\|	2005458	g72816	i0	99.595	3.79352226720648	247	1	100	0	1	247	4944189	4943943	Nostoc sp. NIES-4103 DNA, nearly complete genome	blastn	937	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
13835558	13835558	PRJNA407886_P_NODE_33791_length_386_cov_0.984026_g32097_i0	PRJNA407886	33791	386	0.984026	3.79834036	Microcystis	1125	Bacteria	Bacteria	60.2	2.2e-4	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g32097	i0	97.222	73.7512953367876	36	0	10	1	85	119	4650599	4650634	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	28468	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
14446473	14446473	PRJNA407886_P_NODE_49492_length_306_cov_1.369099_g47798_i0	PRJNA407886	49492	306	1.369099	4.18944294	Stanieria cyanosphaera	102116	Bacteria	Bacteria	283	9.3e-72	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g47798	i0	83.553	52.8235294117647	304	48	99	2	1	303	432	734	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	16164	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera

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