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

5 rows where analysis = "blastn", bioproject = "PRJNA397065" 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
2355015	2355015	PRJNA397065_S_NODE_2842_length_675_cov_26.314241_g2628_i0	PRJNA397065	2842	675	26.314241	177.62112675	Oscillatoriales	1150	Bacteria	Bacteria	1247	0	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g2628	i0	100	153.90074074074101	675	0	100	0	1	675	812822	812148	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	103883	1247	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
15107085	15107085	PRJNA397065_S_NODE_14412_length_193_cov_4.286585_g14162_i0	PRJNA397065	14412	193	4.286585	8.27310905	Bacteria	2	Bacteria	Bacteria	220	4.31e-53	NTclustered	gi\|781809225\|emb\|LN799974.1\|	1211	g14162	i0	88.021	93.8704663212435	192	15	99	6	2	193	192	9	Uncultured cyanobacterium partial 16S rRNA gene, clone denovo5984	blastn	18117	220	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20205856	20205856	PRJNA397065_S_NODE_4196_length_511_cov_14.578838_g3955_i0	PRJNA397065	4196	511	14.578838	74.49786218	Oscillatoriales	1150	Bacteria	Bacteria	931	0	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g3955	i0	99.608	139.455968688845	510	2	99	0	2	511	811937	811428	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	71262	931	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
22756657	22756657	PRJNA397065_S_NODE_5058_length_441_cov_5147.361650_g4810_i0	PRJNA397065	5058	441	5147.36165	22699.8648765	Oscillatoriales	1150	Bacteria	Bacteria	566	1.2299999999999998e-156	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g4810	i0	98.742	123.043083900227	318	4	72	0	1	318	812527	812844	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	54262	566	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
22756754	22756754	PRJNA397065_S_NODE_7398_length_329_cov_506.296667_g7148_i0	PRJNA397065	7398	329	506.296667	1665.71603443	Oscillatoriales	1150	Bacteria	Bacteria	580	3.19e-161	NTclustered	gi\|1566846288\|dbj\|LC455668.1\|	118562	g7148	i0	99.375	100.373860182371	320	2	97	0	1	320	321	2	Arthrospira platensis NIES-46 gene for 16S ribosomal RNA, partial sequence	blastn	33023	580	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis

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