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

5 rows where analysis = "blastn", bioproject = "PRJEB75017" 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
4823612	4823612	PRJEB75017_P_NODE_17004_length_245_cov_1.133721_g16875_i0	PRJEB75017	17004	245	1.133721	2.77761645	Cyanophyceae	3028117	Bacteria	Bacteria	353	5.41e-93	NTclustered	gi\|1345606788\|gb\|MG968522.1\|	102128	g16875	i0	93.333	180.869387755102	240	15	98	1	1	240	386	148	Leptolyngbya sp. PCC 73110 23S ribosomal RNA gene, partial sequence	blastn	44313	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. PCC 73110
7373116	7373116	PRJEB75017_P_NODE_18246_length_242_cov_1.491124_g18117_i0	PRJEB75017	18246	242	1.491124	3.60852008	Bacteria	2	Bacteria	Bacteria	409	1.12e-109	NTclustered	gi\|238544006\|emb\|FN298071.1\|	1211	g18117	i0	97.119	100.165289256198	243	5	100	2	1	242	404	645	Uncultured cyanobacterium partial 16S rRNA gene, clone CAR-K11c-B8	blastn	24240	409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
17986876	17986876	PRJEB75017_P_NODE_10555_length_283_cov_2.085714_g10426_i0	PRJEB75017	10555	283	2.085714	5.90257062	Nostoc sp. 'Peltigera membranacea cyanobiont' N6	1261031	Bacteria	Bacteria	296	1.09e-75	NTclustered	gi\|1349664091\|gb\|CP026681.1\|	1261031	g10426	i0	85.512	1	283	41	100	0	1	283	4017490	4017208	Nostoc sp. 'Peltigera membranacea cyanobiont' N6 chromosome, complete genome	blastn	283	296	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 'Peltigera membranacea cyanobiont' N6
18847255	18847255	PRJEB75017_P_NODE_10055_length_288_cov_1.451163_g9926_i0	PRJEB75017	10055	288	1.451163	4.17934944	Cyanophyceae	3028117	Bacteria	Bacteria	422	1.76e-113	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g9926	i0	93.056	126.930555555556	288	20	100	0	1	288	1978	2265	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36556	425	0.992941176470588	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20122076	20122076	PRJEB75017_P_NODE_12696_length_262_cov_2.063492_g12567_i0	PRJEB75017	12696	262	2.063492	5.40634904	Cyanophyceae	3028117	Bacteria	Bacteria	412	9.52e-111	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g12567	i0	95.057	124.595419847328	263	11	100	2	1	262	531	270	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32644	414	0.995169082125604	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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