metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA492363" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA492363" and tax_phylum = "Cyanobacteriota"

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
25625212	25625212	PRJNA492363_S_NODE_87721_length_208_cov_1.741497_g86900_i0	PRJNA492363	87721	208	1.741497	3.62231376	Acaryochloris	155977	Bacteria	Bacteria	69.4	1.81e-7	NTclustered	gi\|158311381\|gb\|CP000843.1\|	329726	g86900	i0	95.455	0.697115384615385	44	1	21	1	111	153	61481	61524	Acaryochloris marina MBIC11017 plasmid pREB6, complete sequence	blastn	145	69.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris marina
25896914	25896914	PRJNA492363_S_NODE_101035_length_201_cov_0.914286_g100214_i0	PRJNA492363	101035	201	0.914286	1.83771486	Nostoc	1177	Bacteria	Bacteria	148	2.1699999999999997e-31	NTclustered	gi\|953508392\|dbj\|AP017295.1\|	1751286	g100214	i0	80.851	1.91542288557214	188	36	94	0	13	200	2292795	2292608	Nostoc sp. NIES-3756 DNA, complete genome	blastn	385	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
25897348	25897348	PRJNA492363_S_NODE_93363_length_205_cov_0.888889_g92542_i0	PRJNA492363	93363	205	0.888889	1.82222245	Nodularia	159191	Bacteria	Bacteria	171	4.74e-38	NTclustered	gi\|2874254083\|emb\|OY970166.1\|	1211	g92542	i0	85.03	3.33170731707317	167	25	81	0	37	203	3827258	3827092	MAG: uncultured cyanobacterium isolate MFD01721.bin.c.4 genome assembly, chromosome: 1	blastn	683	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
26246195	26246195	PRJNA492363_S_NODE_100750_length_201_cov_1.371429_g99929_i0	PRJNA492363	100750	201	1.371429	2.75657229	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	206	1.27e-48	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g99929	i0	91.837	3.00497512437811	147	12	73	0	20	166	5012091	5012237	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	604	206	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
26246208	26246208	PRJNA492363_S_NODE_101022_length_201_cov_0.914286_g100201_i0	PRJNA492363	101022	201	0.914286	1.83771486	Synechococcus sp. CCFWC 5	1131	Bacteria	Bacteria	222	1.26e-53	NTclustered	gi\|2482403951\|gb\|CP114977.1\|	2978474	g100201	i0	86.869	1.8407960199005	198	26	99	0	1	198	321321	321518	Synechococcus sp. CCFWC 502 chromosome	blastn	370	222	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CCFWC 502

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