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

5 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax_phylum = "Priapulida"

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
5715217	5715217	PRJNA641707_P_NODE_135685_length_243_cov_4.036082_g133022_i0	PRJNA641707	135685	243	4.036082	9.80767926	Priapulus caudatus	37621	Priapulida	other_Eukaryota	110	1.28e-19	NTclustered	gi\|957828419\|ref\|XM_014808600.1\|	37621	g133022	i0	86.275	1.06995884773663	102	12	42	2	1	101	918	818	PREDICTED: Priapulus caudatus superkiller viralicidic activity 2-like 2 (LOC106806605), mRNA	blastn	260	110	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
10816610	10816610	PRJNA641707_P_NODE_171409_length_201_cov_6.177632_g168746_i0	PRJNA641707	171409	201	6.177632	12.41704032	Priapulus caudatus	37621	Priapulida	other_Eukaryota	87.9	4.79e-13	NTclustered	gi\|957837283\|ref\|XM_014813356.1\|	37621	g168746	i0	90.769	12.9402985074627	65	6	32	0	100	164	423	359	PREDICTED: Priapulus caudatus plasma membrane calcium-transporting ATPase 3-like (LOC106810082), mRNA	blastn	2601	87.9	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
15914722	15914722	PRJNA641707_P_NODE_146833_length_239_cov_19.068421_g144170_i0	PRJNA641707	146833	239	19.068421	45.57352619	Priapulus caudatus	37621	Priapulida	other_Eukaryota	100	7.56e-17	NTclustered	gi\|957821877\|ref\|XM_014825788.1\|	37621	g144170	i0	86.022	8.89539748953975	93	13	39	0	146	238	203	111	PREDICTED: Priapulus caudatus potassium voltage-gated channel protein Shaker-like (LOC106821113), mRNA	blastn	2126	100	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
18463717	18463717	PRJNA641707_P_NODE_138235_length_242_cov_6.564767_g135572_i0	PRJNA641707	138235	242	6.564767	15.88673614	Priapulus caudatus	37621	Priapulida	other_Eukaryota	73.1	1.67e-8	NTclustered	gi\|957843788\|ref\|XM_014816787.1\|	37621	g135572	i0	95.652	7.01239669421488	46	1	19	1	164	209	754	710	PREDICTED: Priapulus caudatus high mobility group protein DSP1-like (LOC106812809), mRNA	blastn	1697	73.1	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
18466424	18466424	PRJNA641707_P_NODE_254375_length_180_cov_7.030534_g251712_i0	PRJNA641707	254375	180	7.030534	12.6549612	Priapulus caudatus	37621	Priapulida	other_Eukaryota	180	6.71e-41	NTclustered	gi\|957845512\|ref\|XM_014817702.1\|	37621	g251712	i0	85.227	63.7166666666667	176	24	98	2	1	176	1322	1149	PREDICTED: Priapulus caudatus protein transport protein Sec61 subunit alpha isoform B-like (LOC106813540), mRNA	blastn	11469	180	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus

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