metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA453567" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA453567" 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
2992516	2992516	PRJNA453567_P_NODE_28503_length_164_cov_1.259843_g28266_i0	PRJNA453567	28503	164	1.259843	2.06614252	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	54.7	0.004	NTclustered	gi\|2920003456\|emb\|OZ238864.1\|	1046305	g28266	i0	96.97	5.4390243902439	33	0	20	1	3	34	15783383	15783415	Ailoscolex lacteospumosus genome assembly, chromosome: 5	blastn	892	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
9369665	9369665	PRJNA453567_P_NODE_19028_length_203_cov_1.879518_g18791_i0	PRJNA453567	19028	203	1.879518	3.81542154	Hirudo verbana	311461	Annelida	Annelida	52.8	0.018	NTclustered	gi\|2918369702\|emb\|OZ237787.1\|	311461	g18791	i0	100	0.137931034482759	28	0	14	0	173	200	10624978	10625005	Hirudo verbana genome assembly, chromosome: 9	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
13195354	13195354	PRJNA453567_P_NODE_1091_length_1126_cov_3.092746_g1001_i0	PRJNA453567	1091	1126	3.092746	34.82431996	Hirudo verbana	311461	Annelida	Annelida	62.1	1.9e-4	NTclustered	gi\|2918369706\|emb\|OZ237788.1\|	311461	g1001	i0	94.872	8.22202486678508	39	2	3	0	507	545	1124058	1124020	Hirudo verbana genome assembly, chromosome: 10	blastn	9258	62.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
14470436	14470436	PRJNA453567_P_NODE_16852_length_218_cov_1.546961_g16615_i0	PRJNA453567	16852	218	1.546961	3.37237498	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	52.8	0.019	NTclustered	gi\|2920003456\|emb\|OZ238864.1\|	1046305	g16615	i0	100	0.128440366972477	28	0	13	0	145	172	27511733	27511706	Ailoscolex lacteospumosus genome assembly, chromosome: 5	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
15744506	15744506	PRJNA453567_P_NODE_32413_length_154_cov_1.324786_g32176_i0	PRJNA453567	32413	154	1.324786	2.04017044	Hirudo verbana	311461	Annelida	Annelida	67.6	4.51e-7	NTclustered	gi\|2918369697\|emb\|OZ237786.1\|	311461	g32176	i0	91.667	7.88311688311688	48	4	31	0	1	48	7068347	7068300	Hirudo verbana genome assembly, chromosome: 8	blastn	1214	67.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
15744556	15744556	PRJNA453567_P_NODE_8873_length_322_cov_1.589474_g8636_i0	PRJNA453567	8873	322	1.589474	5.11810628	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	54.7	0.008	NTclustered	gi\|2920003418\|emb\|OZ238863.1\|	1046305	g8636	i0	100	0.698757763975155	29	0	9	0	160	188	34364019	34364047	Ailoscolex lacteospumosus genome assembly, chromosome: 4	blastn	225	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
18293381	18293381	PRJNA453567_P_NODE_11535_length_274_cov_1.295359_g11298_i0	PRJNA453567	11535	274	1.295359	3.54928366	Hirudo verbana	311461	Annelida	Annelida	58.4	5.41e-4	NTclustered	gi\|2918369714\|emb\|OZ237790.1\|	311461	g11298	i0	86.538	1.22992700729927	52	7	19	0	90	141	7493261	7493312	Hirudo verbana genome assembly, chromosome: 12	blastn	337	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
19567669	19567669	PRJNA453567_P_NODE_28336_length_164_cov_3.661417_g28099_i0	PRJNA453567	28336	164	3.661417	6.00472388	Hirudo verbana	311461	Annelida	Annelida	62.1	2.27e-5	NTclustered	gi\|2918369620\|emb\|OZ237782.1\|	311461	g28099	i0	88.462	4.95731707317073	52	5	32	1	63	114	2488215	2488165	Hirudo verbana genome assembly, chromosome: 4	blastn	813	62.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
23393972	23393972	PRJNA453567_P_NODE_12739_length_258_cov_1.601810_g12502_i0	PRJNA453567	12739	258	1.60181	4.1326698	Hirudo verbana	311461	Annelida	Annelida	65.8	3.02e-6	NTclustered	gi\|2918369620\|emb\|OZ237782.1\|	311461	g12502	i0	95.122	0.825581395348837	41	2	16	0	12	52	13314620	13314660	Hirudo verbana genome assembly, chromosome: 4	blastn	213	65.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
24667980	24667980	PRJNA453567_P_NODE_2080_length_799_cov_2.520997_g1921_i0	PRJNA453567	2080	799	2.520997	20.14276603	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	63.9	3.71e-5	NTclustered	gi\|2920003371\|emb\|OZ238862.1\|	1046305	g1921	i0	88.679	2	53	4	7	2	163	214	40401412	40401361	Ailoscolex lacteospumosus genome assembly, chromosome: 3	blastn	1598	63.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus

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