contig_metadata
11 rows where bioproject = "PRJNA812715", tax_kingdom = "Metazoa" and tax_phylum = "Annelida"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2087477 | 2087477 | PRJNA812715_P_NODE_105002_length_249_cov_1.750000_g103201_i0 | PRJNA812715 | 105002 | 249 | 1.75 | 4.3575 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g103201 | i0 | 96.97 | 1.03212851405622 | 33 | 0 | 13 | 1 | 77 | 109 | 48472430 | 48472399 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 257 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 2500377 | 2500377 | PRJNA812715_P_NODE_27562_length_591_cov_2.063707_g25814_i0 | PRJNA812715 | 27562 | 591 | 2.063707 | 12.19650837 | Opisthokonta | 33154 | Annelida | Annelida | 125 | 6.0399999999999995e-30 | NR | KAK2191890.1 | 27915 | g25814 | i0 | 50.4 | 6.42131979695431 | 141 | 55 | 66.5 | 2 | 159 | 551 | 317 | 452 | KAK2191890.1 hypothetical protein NP493_43g03001 [Ridgeia piscesae] | diamond | 3795 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 3365229 | 3365229 | PRJNA812715_P_NODE_7543_length_1543_cov_7.972109_g6722_i0 | PRJNA812715 | 7543 | 1543 | 7.972109 | 123.00964187 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 65.8 | 2.04e-5 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g6722 | i0 | 95.122 | 0.499027867790019 | 41 | 2 | 3 | 0 | 679 | 719 | 37222131 | 37222091 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 770 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 7602771 | 7602771 | PRJNA812715_P_NODE_105166_length_249_cov_1.687500_g103365_i0 | PRJNA812715 | 105166 | 249 | 1.6875 | 4.201875 | Clitellata | 42113 | Annelida | Annelida | 63.9 | 1.04e-5 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g103365 | i0 | 100 | 207.409638554217 | 34 | 0 | 15 | 0 | 74 | 107 | 9403248 | 9403215 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 51645 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 13566594 | 13566594 | PRJNA812715_P_NODE_32371_length_523_cov_1.395556_g30598_i0 | PRJNA812715 | 32371 | 523 | 1.395556 | 7.29875788 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.014 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g30598 | i0 | 100 | 0.110898661567878 | 29 | 0 | 6 | 0 | 2 | 30 | 1291666 | 1291694 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 27749545 | 27749545 | PRJNA812715_P_NODE_61264_length_334_cov_1.475096_g59465_i0 | PRJNA812715 | 61264 | 334 | 1.475096 | 4.92682064 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 105 | 1.59e-25 | NR | KAK2143286.1 | 53620 | g59465 | i0 | 53.1 | 0.727544910179641 | 81 | 38 | 72.8 | 0 | 23 | 265 | 138 | 218 | KAK2143286.1 hypothetical protein LSH36_857g00134 [Paralvinella palmiformis] | diamond | 243 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 27884329 | 27884329 | PRJNA812715_P_NODE_43065_length_424_cov_1.752137_g41270_i0 | PRJNA812715 | 43065 | 424 | 1.752137 | 7.42906088 | Metazoa | 33208 | Annelida | Annelida | 170 | 1.34e-49 | NR | CAH1786460.1 | 6347 | g41270 | i0 | 61.8 | 33.5306603773585 | 144 | 50 | 99.1 | 2 | 5 | 424 | 80 | 222 | CAH1786460.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 14217 | 170 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28326230 | 28326230 | PRJNA812715_P_NODE_49086_length_387_cov_2.697452_g47289_i0 | PRJNA812715 | 49086 | 387 | 2.697452 | 10.43913924 | Metazoa | 33208 | Annelida | Annelida | 79 | 3.8e-15 | NR | ADV57678.1 | 6396 | g47289 | i0 | 37 | 2.62790697674419 | 127 | 72 | 95.3 | 3 | 386 | 18 | 13 | 135 | ADV57678.1 glutathione S-transferase [Eisenia fetida] | diamond | 1017 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 28444100 | 28444100 | PRJNA812715_P_NODE_92486_length_264_cov_3.157068_g90685_i0 | PRJNA812715 | 92486 | 264 | 3.157068 | 8.33465952 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 82 | 7.28e-16 | NR | CAD5123944.1 | 2664684 | g90685 | i0 | 52.1 | 8.48863636363636 | 71 | 34 | 80.7 | 0 | 18 | 230 | 760 | 830 | CAD5123944.1 DgyrCDS12251 [Dimorphilus gyrociliatus] | diamond | 2241 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 29738213 | 29738213 | PRJNA812715_P_NODE_81990_length_281_cov_1.480769_g80190_i0 | PRJNA812715 | 81990 | 281 | 1.480769 | 4.16096089 | Owenia fusiformis | 6347 | Annelida | Annelida | 72.8 | 3.17e-13 | NR | CAH1790910.1 | 6347 | g80190 | i0 | 41.9 | 0.918149466192171 | 86 | 50 | 91.8 | 0 | 9 | 266 | 114 | 199 | CAH1790910.1 unnamed protein product [Owenia fusiformis] | diamond | 258 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31444757 | 31444757 | PRJNA812715_P_NODE_109916_length_247_cov_0.885057_g108115_i0 | PRJNA812715 | 109916 | 247 | 0.885057 | 2.18609079 | Ridgeia piscesae | 27915 | Annelida | Annelida | 43.9 | 0.0156 | NR | KAK2185544.1 | 27915 | g108115 | i0 | 32.9 | 4.73684210526316 | 70 | 42 | 85 | 2 | 17 | 226 | 380 | 444 | KAK2185544.1 hypothetical protein NP493_231g03069 [Ridgeia piscesae] | diamond | 1170 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae |
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);;