contig_metadata
23 rows where bioproject = "PRJNA1174234", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1040957 | 1040957 | PRJNA1174234_P_NODE_8581_length_471_cov_0.773869_g8385_i0 | PRJNA1174234 | 8581 | 471 | 0.773869 | 3.64492299 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 205 | 5.41e-58 | NR | CAD5123301.1 | 2664684 | g8385 | i0 | 61.5 | 2.98089171974522 | 156 | 58 | 99.4 | 1 | 470 | 3 | 592 | 745 | CAD5123301.1 DgyrCDS11658 [Dimorphilus gyrociliatus] | diamond | 1404 | 205 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 2316211 | 2316211 | PRJNA1174234_P_NODE_11582_length_405_cov_1.388554_g11386_i0 | PRJNA1174234 | 11582 | 405 | 1.388554 | 5.6236437 | Metazoa | 33208 | Annelida | Annelida | 56.5 | 0.003 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g11386 | i0 | 100 | 0.439506172839506 | 30 | 0 | 7 | 0 | 375 | 404 | 2511527 | 2511498 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 178 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 2867009 | 2867009 | PRJNA1174234_P_NODE_35863_length_241_cov_0.916667_g35667_i0 | PRJNA1174234 | 35863 | 241 | 0.916667 | 2.20916747 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 62.1 | 3.6e-5 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g35667 | i0 | 100 | 0.655601659751037 | 33 | 0 | 14 | 0 | 31 | 63 | 21175661 | 21175693 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 158 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 2867065 | 2867065 | PRJNA1174234_P_NODE_9343_length_451_cov_1.248677_g9147_i0 | PRJNA1174234 | 9343 | 451 | 1.248677 | 5.63153327 | Opisthokonta | 33154 | Annelida | Annelida | 219 | 5.38e-70 | NR | ABW23174.1 | 6344 | g9147 | i0 | 73.2 | 41.5809312638581 | 149 | 40 | 99.1 | 0 | 3 | 449 | 15 | 163 | ABW23174.1 ribosomal protein rpl19 [Arenicola marina] | diamond | 18753 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 4142995 | 4142995 | PRJNA1174234_P_NODE_16844_length_336_cov_1.452471_g16648_i0 | PRJNA1174234 | 16844 | 336 | 1.452471 | 4.88030256 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g16648 | i0 | 100 | 0.62202380952381 | 30 | 0 | 9 | 0 | 155 | 184 | 11520570 | 11520541 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 209 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7969510 | 7969510 | PRJNA1174234_P_NODE_927_length_1178_cov_5.344796_g826_i0 | PRJNA1174234 | 927 | 1178 | 5.344796 | 62.96169688 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 0.003 | NTclustered | gi|2920003578|emb|OZ238870.1| | 1046305 | g826 | i0 | 97.059 | 0.0288624787775891 | 34 | 1 | 3 | 0 | 207 | 240 | 19772328 | 19772295 | Ailoscolex lacteospumosus genome assembly, chromosome: 11 | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9243969 | 9243969 | PRJNA1174234_P_NODE_10648_length_423_cov_1.097143_g10452_i0 | PRJNA1174234 | 10648 | 423 | 1.097143 | 4.64091489 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.011 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g10452 | i0 | 100 | 0.0685579196217494 | 29 | 0 | 7 | 0 | 175 | 203 | 24335647 | 24335675 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 13069723 | 13069723 | PRJNA1174234_P_NODE_26491_length_266_cov_1.196891_g26295_i0 | PRJNA1174234 | 26491 | 266 | 1.196891 | 3.18373006 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 1.45e-4 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g26295 | i0 | 100 | 3.36466165413534 | 32 | 0 | 12 | 0 | 34 | 65 | 3144797 | 3144828 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 895 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 13069762 | 13069762 | PRJNA1174234_P_NODE_33131_length_245_cov_0.895349_g32935_i0 | PRJNA1174234 | 33131 | 245 | 0.895349 | 2.19360505 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 80.9 | 1.36e-16 | NR | KAK2142995.1 | 53620 | g32935 | i0 | 52.6 | 0.955102040816327 | 78 | 36 | 95.5 | 1 | 235 | 2 | 22 | 98 | KAK2142995.1 hypothetical protein LSH36_888g00068 [Paralvinella palmiformis] | diamond | 234 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 16893114 | 16893114 | PRJNA1174234_P_NODE_10474_length_426_cov_1.441926_g10278_i0 | PRJNA1174234 | 10474 | 426 | 1.441926 | 6.14260476 | Metazoa | 33208 | Annelida | Annelida | 191 | 4.69e-58 | NR | CAH1799511.1 | 6347 | g10278 | i0 | 63.1 | 13.8943661971831 | 141 | 52 | 99.3 | 0 | 424 | 2 | 113 | 253 | CAH1799511.1 unnamed protein product [Owenia fusiformis] | diamond | 5919 | 192 | 0.994791666666667 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 18167691 | 18167691 | PRJNA1174234_P_NODE_17655_length_328_cov_1.207843_g17459_i0 | PRJNA1174234 | 17655 | 328 | 1.207843 | 3.96172504 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.009 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g17459 | i0 | 100 | 3.42682926829268 | 29 | 0 | 9 | 0 | 208 | 236 | 11328182 | 11328210 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 1124 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 18167724 | 18167724 | PRJNA1174234_P_NODE_23055_length_287_cov_1.350467_g22859_i0 | PRJNA1174234 | 23055 | 287 | 1.350467 | 3.87584029 | Helobdella robusta | 6412 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|675864289|ref|XM_009019457.1| | 6412 | g22859 | i0 | 100 | 0.668989547038328 | 29 | 0 | 10 | 0 | 73 | 101 | 888 | 860 | Helobdella robusta hypothetical protein partial mRNA | blastn | 192 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 20167249 | 20167249 | PRJNA1174234_P_NODE_17016_length_334_cov_1.877395_g16820_i0 | PRJNA1174234 | 17016 | 334 | 1.877395 | 6.2704993 | Metazoa | 33208 | Annelida | Annelida | 206 | 2.2799999999999998e-48 | NTclustered | gi|83307523|emb|CT033497.1| | 6359 | g16820 | i0 | 79.514 | 7.63173652694611 | 288 | 59 | 86 | 0 | 47 | 334 | 201 | 488 | Platynereis dumerilii EST IB0AAA19BC04FM1 | blastn | 2549 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 20717409 | 20717409 | PRJNA1174234_P_NODE_1217_length_1063_cov_3.601010_g1098_i0 | PRJNA1174234 | 1217 | 1063 | 3.60101 | 38.2787363 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 276 | 3.739999999999999e-87 | NR | AAN28680.1 | 13286 | g1098 | i0 | 48.6 | 3.61523988711195 | 348 | 144 | 90 | 13 | 997 | 41 | 10 | 351 | AAN28680.1 cathepsin L [Theromyzon tessulatum] | diamond | 3843 | 278 | 0.992805755395683 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Theromyzon | Theromyzon tessulatum | |
| 28051264 | 28051264 | PRJNA1174234_P_NODE_26785_length_264_cov_1.209424_g26589_i0 | PRJNA1174234 | 26785 | 264 | 1.209424 | 3.19287936 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 50.8 | 6.76e-5 | NR | KAK2145522.1 | 53620 | g26589 | i0 | 46 | 0.715909090909091 | 63 | 29 | 67 | 3 | 57 | 233 | 287 | 348 | KAK2145522.1 hypothetical protein LSH36_676g00014 [Paralvinella palmiformis] | diamond | 189 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28228091 | 28228091 | PRJNA1174234_P_NODE_16586_length_339_cov_1.154135_g16390_i0 | PRJNA1174234 | 16586 | 339 | 1.154135 | 3.91251765 | Metazoa | 33208 | Annelida | Annelida | 99 | 3.85e-23 | NR | CCD27771.1 | 6446 | g16390 | i0 | 53.1 | 1.95575221238938 | 113 | 45 | 99.1 | 2 | 339 | 4 | 63 | 168 | CCD27771.1 ribosomal protein l13, partial [Sipunculus nudus] | diamond | 663 | 99.4 | 0.995975855130785 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 28556619 | 28556619 | PRJNA1174234_P_NODE_14407_length_363_cov_1.020690_g14211_i0 | PRJNA1174234 | 14407 | 363 | 1.02069 | 3.7051047 | Owenia fusiformis | 6347 | Annelida | Annelida | 90.9 | 2.06e-18 | NR | CAH1792746.1 | 6347 | g14211 | i0 | 48 | 0.809917355371901 | 98 | 50 | 81 | 1 | 296 | 3 | 1443 | 1539 | CAH1792746.1 unnamed protein product [Owenia fusiformis] | diamond | 294 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30009146 | 30009146 | PRJNA1174234_P_NODE_21231_length_300_cov_1.013216_g21035_i0 | PRJNA1174234 | 21231 | 300 | 1.013216 | 3.039648 | Owenia fusiformis | 6347 | Annelida | Annelida | 107 | 5.6799999999999995e-25 | NR | CAH1794275.1 | 6347 | g21035 | i0 | 53.8 | 0.91 | 91 | 42 | 91 | 0 | 2 | 274 | 50 | 140 | CAH1794275.1 unnamed protein product [Owenia fusiformis] | diamond | 273 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30577468 | 30577468 | PRJNA1174234_P_NODE_3733_length_686_cov_2.119086_g3548_i0 | PRJNA1174234 | 3733 | 686 | 2.119086 | 14.53692996 | Eisenia fetida | 6396 | Annelida | Annelida | 89.4 | 7.24e-18 | NR | AUS83917.1 | 6396 | g3548 | i0 | 36 | 0.813411078717201 | 186 | 104 | 78.7 | 6 | 23 | 562 | 1 | 177 | AUS83917.1 glutathion S-transferase pi [Eisenia fetida] | diamond | 558 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 31177723 | 31177723 | PRJNA1174234_P_NODE_28415_length_254_cov_1.917127_g28219_i0 | PRJNA1174234 | 28415 | 254 | 1.917127 | 4.86950258 | Owenia fusiformis | 6347 | Annelida | Annelida | 69.3 | 8.99e-13 | NR | CAH1789242.1 | 6347 | g28219 | i0 | 45.5 | 1.2992125984252 | 55 | 30 | 65 | 0 | 208 | 44 | 76 | 130 | CAH1789242.1 unnamed protein product [Owenia fusiformis] | diamond | 330 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32158736 | 32158736 | PRJNA1174234_P_NODE_27458_length_260_cov_1.229947_g27262_i0 | PRJNA1174234 | 27458 | 260 | 1.229947 | 3.1978622 | Ridgeia piscesae | 27915 | Annelida | Annelida | 43.9 | 0.0173 | NR | KAK2158995.1 | 27915 | g27262 | i0 | 46.8 | 2.14615384615385 | 47 | 25 | 54.2 | 0 | 259 | 119 | 326 | 372 | KAK2158995.1 hypothetical protein NP493_1748g00001 [Ridgeia piscesae] | diamond | 558 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32304652 | 32304652 | PRJNA1174234_P_NODE_7379_length_504_cov_2.670534_g7183_i0 | PRJNA1174234 | 7379 | 504 | 2.670534 | 13.45949136 | Metazoa | 33208 | Annelida | Annelida | 167 | 1.29e-48 | NR | WXB48350.1 | 6390 | g7183 | i0 | 64.3 | 3.53571428571429 | 112 | 39 | 66.1 | 1 | 107 | 439 | 111 | 222 | WXB48350.1 destabilase-lysozyme 2 [Enchytraeus albidus] | diamond | 1782 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Enchytraeus | Enchytraeus albidus | |
| 32821796 | 32821796 | PRJNA1174234_P_NODE_32980_length_245_cov_0.895349_g32784_i0 | PRJNA1174234 | 32980 | 245 | 0.895349 | 2.19360505 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 53.5 | 6.2e-6 | NR | CAD5118963.1 | 2664684 | g32784 | i0 | 50 | 1.64081632653061 | 48 | 22 | 58.8 | 1 | 172 | 29 | 869 | 914 | CAD5118963.1 DgyrCDS7634 [Dimorphilus gyrociliatus] | diamond | 402 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus |
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);;