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

8 rows where analysis = "blastn", bioproject = "PRJNA758398" 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
4567914	4567914	PRJNA758398_S_NODE_144_length_1664_cov_4.434056_g117_i0	PRJNA758398	144	1664	4.434056	73.78269184	Phormidium nigroviride	482564	Bacteria	Bacteria	2974	0	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g117	i0	98.919	149.919471153846	1665	17	100	1	1	1664	1691	27	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	249466	2974	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
5843420	5843420	PRJNA758398_S_NODE_44445_length_166_cov_0.871795_g44304_i0	PRJNA758398	44445	166	0.871795	1.4471797	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	219	1.3e-52	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g44304	i0	90.798	1.96385542168675	163	15	98	0	1	163	4789460	4789622	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	326	219	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
5843505	5843505	PRJNA758398_S_NODE_53705_length_161_cov_0.910714_g53564_i0	PRJNA758398	53705	161	0.910714	1.46624954	Microcoleus vaginatus	119532	Bacteria	Bacteria	276	7.29e-70	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g53564	i0	97.516	4	161	4	100	0	1	161	2007673	2007513	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	644	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
7118448	7118448	PRJNA758398_S_NODE_22946_length_215_cov_1.686747_g22805_i0	PRJNA758398	22946	215	1.686747	3.62650605	Microcoleus vaginatus	119532	Bacteria	Bacteria	69.4	1.88e-7	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g22805	i0	95.455	3.29767441860465	44	1	20	1	138	180	4925807	4925850	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	709	69.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
10944080	10944080	PRJNA758398_S_NODE_49609_length_163_cov_0.894737_g49468_i0	PRJNA758398	49609	163	0.894737	1.45842131	Phormidium nigroviride	482564	Bacteria	Bacteria	189	9.92e-44	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g49468	i0	88.05	3.90184049079755	159	19	98	0	3	161	7080166	7080008	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	636	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
15232901	15232901	PRJNA758398_S_NODE_28912_length_197_cov_1.290541_g28771_i0	PRJNA758398	28912	197	1.290541	2.54236577	Leptolyngbya	47251	Bacteria	Bacteria	84.2	6.05e-12	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g28771	i0	92.982	19.8426395939086	57	4	29	0	141	197	2984485	2984541	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	3909	84.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
21606569	21606569	PRJNA758398_S_NODE_54137_length_161_cov_0.910714_g53996_i0	PRJNA758398	54137	161	0.910714	1.46624954	Nostocales	1161	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1883611395\|gb\|CP054698.1\|	1472755	g53996	i0	100	0.540372670807453	29	0	18	0	49	77	4198647	4198675	Nostoc edaphicum CCNP1411 chromosome, complete genome	blastn	87	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc edaphicum
24966589	24966589	PRJNA758398_S_NODE_8560_length_329_cov_2.185714_g8419_i0	PRJNA758398	8560	329	2.185714	7.19099906	Crocosphaera subtropica	2546360	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|171696371\|gb\|CP000806.1\|	43989	g8419	i0	97.059	0.279635258358663	34	0	10	1	288	320	4179554	4179521	Cyanothece sp. ATCC 51142 circular chromosome, complete sequence	blastn	92	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera subtropica

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