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

5 rows where analysis = "blastn", bioproject = "PRJNA924320" and tax_phylum = "Annelida"

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
13653082	13653082	PRJNA924320_S_NODE_58631_length_156_cov_2.542056_g58489_i0	PRJNA924320	58631	156	2.542056	3.96560736	Mesenchytraeus solifugus	223748	Annelida	Annelida	171	3.399999999999999e-38	NTclustered	gi\|1068288652\|gb\|KU728818.1\|	223748	g58489	i0	89.051	79.3974358974359	137	15	88	0	20	156	1	137	Mesenchytraeus solifugus elongation factor 1-alpha mRNA, complete cds	blastn	12386	171	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Enchytraeida	Enchytraeidae	Mesenchytraeus	Mesenchytraeus solifugus
18750809	18750809	PRJNA924320_S_NODE_32795_length_192_cov_1.426573_g32653_i0	PRJNA924320	32795	192	1.426573	2.73902016	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	56.5	0.001	NTclustered	gi\|2920003578\|emb\|OZ238870.1\|	1046305	g32653	i0	100	0.15625	30	0	16	0	1	30	10418491	10418520	Ailoscolex lacteospumosus genome assembly, chromosome: 11	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
18750917	18750917	PRJNA924320_S_NODE_47955_length_166_cov_0.871795_g47813_i0	PRJNA924320	47955	166	0.871795	1.4471797	Hirudo verbana	311461	Annelida	Annelida	52.8	0.014	NTclustered	gi\|2918369710\|emb\|OZ237789.1\|	311461	g47813	i0	96.875	0.192771084337349	32	0	19	1	4	34	667477	667446	Hirudo verbana genome assembly, chromosome: 11	blastn	32	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
21301287	21301287	PRJNA924320_S_NODE_4237_length_457_cov_3.424020_g4096_i0	PRJNA924320	4237	457	3.42402	15.6477714	Aeolosoma sp. GG-2011	1071604	Annelida	Annelida	324	8.51e-84	NTclustered	gi\|342220097\|gb\|HQ691208.1\|	1071604	g4096	i0	80.841	33.5404814004376	428	68	91	11	4	420	438	14	Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	15328	324	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Aeolosomatidae	Aeolosoma	Aeolosoma sp. GG-2011
22576400	22576400	PRJNA924320_S_NODE_47278_length_166_cov_2.615385_g47136_i0	PRJNA924320	47278	166	2.615385	4.3415391	Erpobdella octoculata	39305	Annelida	Annelida	121	3.76e-23	NTclustered	gi\|320407244\|gb\|GU592848.1\|	39305	g47136	i0	79.878	4.3855421686747	164	33	99	0	1	164	916	1079	Erpobdella octoculata ATP synthase beta subunit mRNA, partial cds	blastn	728	121	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Erpobdellidae	Erpobdella	Erpobdella octoculata

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