metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA752278" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA752278" 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
727095	727095	PRJNA752278_P_NODE_22941_length_338_cov_2.905660_g22738_i0	PRJNA752278	22941	338	2.90566	9.8211308	Platynereis dumerilii	6359	Annelida	Annelida	285	2.8899999999999997e-72	NTclustered	gi\|83307109\|emb\|CT033083.1\|	6359	g22738	i0	82.515	92.2633136094675	326	55	96	2	14	338	47	371	Platynereis dumerilii EST IB0AAA27AD01EM1	blastn	31185	285	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Nereididae	Platynereis	Platynereis dumerilii
727902	727902	PRJNA752278_P_NODE_6621_length_528_cov_1.101099_g6418_i0	PRJNA752278	6621	528	1.101099	5.81380272	Aeolosoma sp. GG-2011	1071604	Annelida	Annelida	353	1.27e-92	NTclustered	gi\|342220097\|gb\|HQ691208.1\|	1071604	g6418	i0	81.034	26.4204545454545	464	71	86	12	34	485	14	472	Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	13950	353	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Aeolosomatidae	Aeolosoma	Aeolosoma sp. GG-2011
6304718	6304718	PRJNA752278_P_NODE_20425_length_352_cov_10.010753_g20222_i0	PRJNA752278	20425	352	10.010753	35.23785056	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	278	5.04e-70	NTclustered	gi\|1770649179\|gb\|MK731314.1\|	6398	g20222	i0	84.122	79.2642045454545	296	37	84	10	59	352	2	289	Lumbricus terrestris voucher LT_B_I_3 histone H3 (H3) gene, partial cds	blastn	27901	278	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Lumbricidae	Lumbricus	Lumbricus terrestris
7105806	7105806	PRJNA752278_P_NODE_21686_length_345_cov_3.834559_g21483_i0	PRJNA752278	21686	345	3.834559	13.22922855	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	54.7	0.009	NTclustered	gi\|2920003644\|emb\|OZ238875.1\|	1046305	g21483	i0	96.875	0.350724637681159	32	1	9	0	283	314	474363	474332	Ailoscolex lacteospumosus genome assembly, chromosome: 16	blastn	121	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
7579143	7579143	PRJNA752278_P_NODE_7366_length_508_cov_1.659770_g7163_i0	PRJNA752278	7366	508	1.65977	8.4316316	Pristina	150439	Annelida	Annelida	737	0	NTclustered	gi\|2169792353\|gb\|OM001222.1\|	188231	g7163	i0	96.825	64.0905511811024	441	14	87	0	68	508	1	441	Pristina longiseta voucher CW649 large subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	32558	737	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Pristina	Pristina longiseta
11404557	11404557	PRJNA752278_P_NODE_24709_length_329_cov_1.539062_g24506_i0	PRJNA752278	24709	329	1.539062	5.06351398	Metazoa	33208	Annelida	Annelida	255	2.2e-63	NTclustered	gi\|942595\|gb\|U30467.1\|UCU30467	6431	g24506	i0	91.005	53.6170212765957	189	17	57	0	141	329	1411	1223	Urechis caupo alpha-tubulin mRNA, complete cds	blastn	17640	255	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Xenopneusta	Urechidae	Urechis	Urechis caupo
12206768	12206768	PRJNA752278_P_NODE_32650_length_300_cov_1.920705_g32447_i0	PRJNA752278	32650	300	1.920705	5.762115	Dendrobaena hortensis	1302596	Annelida	Annelida	148	3.4599999999999996e-31	NTclustered	gi\|2797674201\|gb\|PQ279307.1\|	1302596	g32447	i0	77.358	78.0433333333333	265	50	87	9	8	267	4276	4017	Dendrobaena hortensis mitochondrion, partial genome	blastn	23413	148	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Lumbricidae	Dendrobaena	Dendrobaena hortensis
13482018	13482018	PRJNA752278_P_NODE_7951_length_494_cov_4.453682_g7748_i0	PRJNA752278	7951	494	4.453682	22.00118908	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	52.8	0.048	NTclustered	gi\|2920003527\|emb\|OZ238867.1\|	1046305	g7748	i0	100	0.0566801619433198	28	0	6	0	111	138	15660146	15660119	Ailoscolex lacteospumosus genome assembly, chromosome: 8	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
13955209	13955209	PRJNA752278_P_NODE_82031_length_249_cov_2.267045_g81828_i0	PRJNA752278	82031	249	2.267045	5.64494205	Metazoa	33208	Annelida	Annelida	54.7	0.006	NTclustered	gi\|2918369718\|emb\|OZ237791.1\|	311461	g81828	i0	92.308	1.62248995983936	39	1	16	1	47	85	937470	937434	Hirudo verbana genome assembly, chromosome: 13	blastn	404	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
16031098	16031098	PRJNA752278_P_NODE_96973_length_244_cov_0.900585_g96770_i0	PRJNA752278	96973	244	0.900585	2.1974274	Hirudo verbana	311461	Annelida	Annelida	54.7	0.006	NTclustered	gi\|2918369702\|emb\|OZ237787.1\|	311461	g96770	i0	100	0.118852459016393	29	0	12	0	23	51	9895823	9895795	Hirudo verbana genome assembly, chromosome: 9	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
17305966	17305966	PRJNA752278_P_NODE_60914_length_267_cov_1.309278_g60711_i0	PRJNA752278	60914	267	1.309278	3.49577226	Hirudo verbana	311461	Annelida	Annelida	54.7	0.007	NTclustered	gi\|2918369621\|emb\|OZ237783.1\|	311461	g60711	i0	100	0.108614232209738	29	0	11	0	196	224	1715822	1715794	Hirudo verbana genome assembly, chromosome: 5	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
18579308	18579308	PRJNA752278_P_NODE_45395_length_281_cov_2.865385_g45192_i0	PRJNA752278	45395	281	2.865385	8.05173185	Limnodrilus hoffmeisteri	76587	Annelida	Annelida	182	3.17e-41	NTclustered	gi\|2054262290\|gb\|MW732144.1\|	76587	g45192	i0	78.623	81.7010676156584	276	57	98	2	3	277	1972	2246	Limnodrilus hoffmeisteri mitochondrion, complete genome	blastn	22958	182	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Limnodrilus	Limnodrilus hoffmeisteri
19853952	19853952	PRJNA752278_P_NODE_12756_length_416_cov_2.285714_g12553_i0	PRJNA752278	12756	416	2.285714	9.50857024	Arenicola marina	6344	Annelida	Annelida	235	3.6999999999999994e-57	NTclustered	gi\|158187717\|gb\|EU124943.1\|	6344	g12553	i0	83.594	45.4879807692308	256	36	61	6	99	351	346	94	Arenicola marina ribosomal protein rps18 mRNA, partial cds	blastn	18923	235	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
19854131	19854131	PRJNA752278_P_NODE_21616_length_346_cov_1.410256_g21413_i0	PRJNA752278	21616	346	1.410256	4.87948576	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	65.8	4.21e-6	NTclustered	gi\|2920003484\|emb\|OZ238865.1\|	1046305	g21413	i0	95.122	5.90751445086705	41	2	12	0	146	186	25925961	25926001	Ailoscolex lacteospumosus genome assembly, chromosome: 6	blastn	2044	65.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
20327000	20327000	PRJNA752278_P_NODE_110016_length_227_cov_3.850649_g109813_i0	PRJNA752278	110016	227	3.850649	8.74097323	Metazoa	33208	Annelida	Annelida	52.8	0.02	NTclustered	gi\|2918369720\|emb\|OZ237792.1\|	311461	g109813	i0	96.774	0.259911894273128	31	1	14	0	54	84	3203237	3203267	Hirudo verbana genome assembly, chromosome: 14	blastn	59	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
20327321	20327321	PRJNA752278_P_NODE_35556_length_292_cov_1.054795_g35353_i0	PRJNA752278	35556	292	1.054795	3.0800014	Opisthokonta	33154	Annelida	Annelida	52.8	0.027	NTclustered	gi\|2918369693\|emb\|OZ237785.1\|	311461	g35353	i0	100	0.191780821917808	28	0	10	0	198	225	8184869	8184896	Hirudo verbana genome assembly, chromosome: 7	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
21131107	21131107	PRJNA752278_P_NODE_9877_length_457_cov_1.575521_g9674_i0	PRJNA752278	9877	457	1.575521	7.20013097	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	63.9	2.05e-5	NTclustered	gi\|2920003371\|emb\|OZ238862.1\|	1046305	g9674	i0	80.22	3.26695842450766	91	12	20	4	42	132	26921160	26921076	Ailoscolex lacteospumosus genome assembly, chromosome: 3	blastn	1493	63.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
22404920	22404920	PRJNA752278_P_NODE_44958_length_282_cov_1.406699_g44755_i0	PRJNA752278	44958	282	1.406699	3.96689118	Hirudo verbana	311461	Annelida	Annelida	71.3	7.18e-8	NTclustered	gi\|2918369718\|emb\|OZ237791.1\|	311461	g44755	i0	97.561	3.53191489361702	41	1	15	0	40	80	2175582	2175542	Hirudo verbana genome assembly, chromosome: 13	blastn	996	71.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
22405258	22405258	PRJNA752278_P_NODE_62398_length_265_cov_2.380208_g62195_i0	PRJNA752278	62398	265	2.380208	6.3075512	Hirudo verbana	311461	Annelida	Annelida	62.1	4.02e-5	NTclustered	gi\|2918369702\|emb\|OZ237787.1\|	311461	g62195	i0	92.857	6.36981132075472	42	3	16	0	120	161	517326	517367	Hirudo verbana genome assembly, chromosome: 9	blastn	1688	62.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana

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