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

4 rows where analysis = "blastn", bioproject = "PRJNA1200128" 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
327011	327011	PRJNA1200128_S_NODE_23401_length_194_cov_1.834437_g23292_i0	PRJNA1200128	23401	194	1.834437	3.55880778	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	263	7.11e-66	NTclustered	gi\|225696216\|gb\|FJ805883.1\|	259957	g23292	i0	91.282	83.2319587628866	195	14	99	3	3	194	1806	2000	Uncultured Chroococcidiopsis sp. clone NA4_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	16147	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10530866	10530866	PRJNA1200128_S_NODE_22349_length_197_cov_1.220779_g22240_i0	PRJNA1200128	22349	197	1.220779	2.40493463	Nostoc sp. UHCC 0702	2814655	Bacteria	Bacteria	204	4.449999999999999e-48	NTclustered	gi\|1996588181\|gb\|CP071065.1\|	2814655	g22240	i0	85.279	184.238578680203	197	29	100	0	1	197	570617	570813	Nostoc sp. UHCC 0702 chromosome, complete genome	blastn	36295	204	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0702
11247990	11247990	PRJNA1200128_S_NODE_14189_length_226_cov_1.644809_g14080_i0	PRJNA1200128	14189	226	1.644809	3.71726834	Oscillatoriales	1150	Bacteria	Bacteria	412	8.01e-111	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g14080	i0	99.558	176.955752212389	226	1	100	0	1	226	811834	811609	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	39992	412	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
15629876	15629876	PRJNA1200128_S_NODE_21493_length_199_cov_2.358974_g21384_i0	PRJNA1200128	21493	199	2.358974	4.69435826	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g21384	i0	100	0.14070351758794	28	0	14	0	71	98	1687046	1687073	Synechococcus sp. CB0101 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101

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