contig_metadata
27 rows where bioproject = "PRJNA812715", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9742503 | 9742503 | PRJNA812715_P_NODE_78948_length_286_cov_1.446009_g77148_i0 | PRJNA812715 | 78948 | 286 | 1.446009 | 4.13558574 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 178 | 4.18e-40 | NTclustered | gi|2732893162|ref|XM_065342676.1| | 27933 | g77148 | i0 | 78.339 | 35.9615384615385 | 277 | 58 | 97 | 2 | 1 | 276 | 1151 | 876 | PREDICTED: Sycon ciliatum calreticulin-like (LOC135830418), mRNA | blastn | 10285 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 11015522 | 11015522 | PRJNA812715_P_NODE_100069_length_253_cov_1.561111_g98268_i0 | PRJNA812715 | 100069 | 253 | 1.561111 | 3.94961083 | Metazoa | 33208 | Porifera | other_Eukaryota | 101 | 6.59e-23 | NR | XP_064383005.1 | 6063 | g98268 | i0 | 76.7 | 6.30830039525692 | 60 | 14 | 71.1 | 0 | 251 | 72 | 388 | 447 | XP_064383005.1 elongation factor 1-alpha [Halichondria panicea] | diamond | 1596 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 13978965 | 13978965 | PRJNA812715_P_NODE_63171_length_327_cov_1.744094_g61372_i0 | PRJNA812715 | 63171 | 327 | 1.744094 | 5.70318738 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 159 | 4.99e-48 | NR | XP_065890751.1 | 196820 | g61372 | i0 | 68.9 | 0.944954128440367 | 103 | 32 | 94.5 | 0 | 309 | 1 | 3 | 105 | XP_065890751.1 peptidyl-prolyl cis-trans isomerase FKBP1A-like [Dysidea avara] | diamond | 309 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 16116542 | 16116542 | PRJNA812715_P_NODE_64053_length_324_cov_1.840637_g62254_i0 | PRJNA812715 | 64053 | 324 | 1.840637 | 5.96366388 | Chondrilla caribensis | 1336846 | Porifera | other_Eukaryota | 130 | 1.37e-25 | NTclustered | gi|512765366|gb|KC869604.1| | 1336846 | g62254 | i0 | 80.838 | 30.3148148148148 | 167 | 30 | 51 | 2 | 119 | 284 | 2836 | 3001 | Chondrilla caribensis voucher P47 28S ribosomal RNA gene, partial sequence | blastn | 9822 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Chondrillida | Chondrillidae | Chondrilla | Chondrilla caribensis | |
| 18666039 | 18666039 | PRJNA812715_P_NODE_82915_length_280_cov_1.115942_g81115_i0 | PRJNA812715 | 82915 | 280 | 1.115942 | 3.1246376 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 127 | 3.46e-32 | NR | XP_062521026.1 | 121492 | g81115 | i0 | 84.5 | 54.7821428571429 | 71 | 11 | 76.1 | 0 | 280 | 68 | 399 | 469 | XP_062521026.1 protein transport protein Sec61 subunit alpha [Corticium candelabrum] | diamond | 15339 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 21215844 | 21215844 | PRJNA812715_P_NODE_54277_length_362_cov_1.065744_g52478_i0 | PRJNA812715 | 54277 | 362 | 1.065744 | 3.85799328 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 171 | 1.13e-49 | NR | XP_065191424.1 | 27933 | g52478 | i0 | 75.7 | 2.76795580110497 | 111 | 27 | 92 | 0 | 333 | 1 | 60 | 170 | XP_065191424.1 protein arginine N-methyltransferase 1-like [Sycon ciliatum] | diamond | 1002 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27086019 | 27086019 | PRJNA812715_P_NODE_77022_length_289_cov_1.425926_g75222_i0 | PRJNA812715 | 77022 | 289 | 1.425926 | 4.12092614 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 49.3 | 3.21e-4 | NR | XP_065826096.1 | 121494 | g75222 | i0 | 32.6 | 0.892733564013841 | 86 | 56 | 87.2 | 1 | 268 | 17 | 516 | 601 | XP_065826096.1 nuclear pore complex protein Nup85-like [Oscarella lobularis] | diamond | 258 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 28515912 | 28515912 | PRJNA812715_P_NODE_110047_length_247_cov_0.885057_g108246_i0 | PRJNA812715 | 110047 | 247 | 0.885057 | 2.18609079 | Metazoa | 33208 | Porifera | other_Eukaryota | 45.8 | 0.0032 | NR | XP_064398724.1 | 6063 | g108246 | i0 | 43.1 | 4.03238866396761 | 51 | 29 | 61.9 | 0 | 246 | 94 | 237 | 287 | XP_064398724.1 digestive cysteine proteinase 1-like [Halichondria panicea] | diamond | 996 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28633564 | 28633564 | PRJNA812715_P_NODE_108947_length_247_cov_1.770115_g107146_i0 | PRJNA812715 | 108947 | 247 | 1.770115 | 4.37218405 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 49.3 | 3.12e-5 | NR | XP_065843948.1 | 121494 | g107146 | i0 | 43.8 | 1.12955465587045 | 48 | 27 | 58.3 | 0 | 247 | 104 | 22 | 69 | XP_065843948.1 large ribosomal subunit protein P1-like [Oscarella lobularis] | diamond | 279 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 28885823 | 28885823 | PRJNA812715_P_NODE_118828_length_242_cov_0.911243_g117027_i0 | PRJNA812715 | 118828 | 242 | 0.911243 | 2.20520806 | Suberites domuncula | 55567 | Porifera | other_Eukaryota | 53.1 | 4.28e-6 | NR | ABD65441.1 | 55567 | g117027 | i0 | 38.4 | 2.81404958677686 | 73 | 38 | 88 | 2 | 222 | 10 | 139 | 206 | ABD65441.1 Rab24, partial [Suberites domuncula] | diamond | 681 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites domuncula | |
| 28926223 | 28926223 | PRJNA812715_P_NODE_59188_length_342_cov_0.858736_g57389_i0 | PRJNA812715 | 59188 | 342 | 0.858736 | 2.93687712 | Metazoa | 33208 | Porifera | other_Eukaryota | 81.6 | 2.53e-15 | NR | XP_065899639.1 | 196820 | g57389 | i0 | 45.8 | 6.92105263157895 | 118 | 50 | 98.2 | 4 | 338 | 3 | 239 | 348 | XP_065899639.1 eukaryotic translation initiation factor 3 subunit D-like [Dysidea avara] | diamond | 2367 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29107053 | 29107053 | PRJNA812715_P_NODE_38708_length_458_cov_1.158442_g36917_i0 | PRJNA812715 | 38708 | 458 | 1.158442 | 5.30566436 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 92.8 | 1.02e-18 | NR | CAI8048241.1 | 519541 | g36917 | i0 | 39.7 | 2.00436681222707 | 156 | 80 | 95.6 | 5 | 3 | 440 | 241 | 392 | CAI8048241.1 E3 ubiquitin-protein ligase WAV3 [Geodia barretti] | diamond | 918 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 29210621 | 29210621 | PRJNA812715_P_NODE_115909_length_244_cov_0.900585_g114108_i0 | PRJNA812715 | 115909 | 244 | 0.900585 | 2.1974274 | Porifera | 6040 | Porifera | other_Eukaryota | 91.7 | 6.65e-20 | NR | XP_065176812.1 | 27933 | g114108 | i0 | 48.7 | 3.90983606557377 | 78 | 34 | 95.9 | 1 | 3 | 236 | 121 | 192 | XP_065176812.1 protein arginine N-methyltransferase 6-like isoform X2 [Sycon ciliatum] | diamond | 954 | 92 | 0.996739130434783 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 29273407 | 29273407 | PRJNA812715_P_NODE_115729_length_244_cov_0.900585_g113928_i0 | PRJNA812715 | 115729 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 44.7 | 0.00767 | NR | XP_019855953.1 | 400682 | g113928 | i0 | 30.2 | 1.5 | 63 | 38 | 70.1 | 1 | 4 | 174 | 306 | 368 | XP_019855953.1 PREDICTED: uncharacterized protein LOC100640001 isoform X2 [Amphimedon queenslandica] | diamond | 366 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 29422500 | 29422500 | PRJNA812715_P_NODE_58649_length_344_cov_0.970480_g56850_i0 | PRJNA812715 | 58649 | 344 | 0.97048 | 3.3384512 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 55.1 | 5.4e-6 | NR | XP_065910619.1 | 196820 | g56850 | i0 | 38.7 | 1.52616279069767 | 75 | 42 | 65.4 | 1 | 117 | 341 | 350 | 420 | XP_065910619.1 U3 small nucleolar RNA-associated protein 15 homolog [Dysidea avara] | diamond | 525 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 30117385 | 30117385 | PRJNA812715_P_NODE_29132_length_566_cov_2.166329_g27373_i0 | PRJNA812715 | 29132 | 566 | 2.166329 | 12.26142214 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 50.8 | 0.0011 | NR | XP_019849787.1 | 400682 | g27373 | i0 | 38.8 | 0.355123674911661 | 67 | 39 | 35.5 | 1 | 215 | 15 | 140 | 204 | XP_019849787.1 PREDICTED: E3 ubiquitin-protein ligase TRAF7-like [Amphimedon queenslandica] | diamond | 201 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 30307617 | 30307617 | PRJNA812715_P_NODE_90812_length_267_cov_1.587629_g89011_i0 | PRJNA812715 | 90812 | 267 | 1.587629 | 4.23896943 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 99 | 8.52e-22 | NR | XP_065826657.1 | 121494 | g89011 | i0 | 51.1 | 0.98876404494382 | 88 | 42 | 98.9 | 1 | 265 | 2 | 1242 | 1328 | XP_065826657.1 uncharacterized protein [Oscarella lobularis] | diamond | 264 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30433855 | 30433855 | PRJNA812715_P_NODE_83833_length_278_cov_1.878049_g82033_i0 | PRJNA812715 | 83833 | 278 | 1.878049 | 5.22097622 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 81.6 | 1.17e-15 | NR | XP_003386490.1 | 400682 | g82033 | i0 | 53.7 | 2.53597122302158 | 82 | 35 | 88.5 | 2 | 247 | 2 | 484 | 562 | XP_003386490.1 PREDICTED: inositol-trisphosphate 3-kinase A-like isoform X3 [Amphimedon queenslandica] | diamond | 705 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 30559602 | 30559602 | PRJNA812715_P_NODE_26433_length_610_cov_4.225326_g24703_i0 | PRJNA812715 | 26433 | 610 | 4.225326 | 25.7744886 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 124 | 4.64e-29 | NR | XP_065890435.1 | 196820 | g24703 | i0 | 38.4 | 0.870491803278688 | 177 | 104 | 84.6 | 2 | 549 | 34 | 531 | 707 | XP_065890435.1 filamin-B-like [Dysidea avara] | diamond | 531 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 30591421 | 30591421 | PRJNA812715_P_NODE_84413_length_277_cov_1.980392_g82613_i0 | PRJNA812715 | 84413 | 277 | 1.980392 | 5.48568584 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 77.4 | 3.62e-14 | NR | XP_011402819.2 | 400682 | g82613 | i0 | 42.5 | 0.942238267148014 | 87 | 48 | 92.1 | 1 | 8 | 262 | 327 | 413 | XP_011402819.2 PREDICTED: filamin-C-like [Amphimedon queenslandica] | diamond | 261 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 30631649 | 30631649 | PRJNA812715_P_NODE_107753_length_248_cov_0.880000_g105952_i0 | PRJNA812715 | 107753 | 248 | 0.88 | 2.1824 | Metazoa | 33208 | Porifera | other_Eukaryota | 55.8 | 9.42e-7 | NR | XP_065838088.1 | 121494 | g105952 | i0 | 33.3 | 3.96774193548387 | 78 | 50 | 94.4 | 1 | 242 | 9 | 464 | 539 | XP_065838088.1 poly(ADP-ribose) glycohydrolase-like isoform X3 [Oscarella lobularis] | diamond | 984 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31105591 | 31105591 | PRJNA812715_P_NODE_124355_length_226_cov_4.000000_g122554_i0 | PRJNA812715 | 124355 | 226 | 4 | 9.04 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 91.3 | 1.87e-19 | NR | CAA64439.1 | 6047 | g122554 | i0 | 56.8 | 8.86725663716814 | 74 | 29 | 98.2 | 2 | 226 | 5 | 273 | 343 | CAA64439.1 GDP-dissociation inhibitor [Geodia cydonium] | diamond | 2004 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia cydonium | |
| 31191391 | 31191391 | PRJNA812715_P_NODE_110755_length_246_cov_1.780347_g108954_i0 | PRJNA812715 | 110755 | 246 | 1.780347 | 4.37965362 | Halisarca dujardinii | 2583056 | Porifera | other_Eukaryota | 58.9 | 7.57e-8 | NR | WAQ15589.1 | 2583056 | g108954 | i0 | 47.5 | 0.74390243902439 | 61 | 29 | 74.4 | 1 | 11 | 193 | 753 | 810 | WAQ15589.1 villin [Halisarca dujardinii] | diamond | 183 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Chondrillida | Halisarcidae | Halisarca | Halisarca dujardinii | |
| 31611757 | 31611757 | PRJNA812715_P_NODE_108216_length_248_cov_0.880000_g106415_i0 | PRJNA812715 | 108216 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 55.5 | 1.28e-6 | NR | XP_065913267.1 | 196820 | g106415 | i0 | 35.1 | 2.67338709677419 | 74 | 40 | 79.8 | 1 | 233 | 36 | 424 | 497 | XP_065913267.1 adenine deaminase-like isoform X1 [Dysidea avara] | diamond | 663 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 31697785 | 31697785 | PRJNA812715_P_NODE_102617_length_251_cov_0.865169_g100816_i0 | PRJNA812715 | 102617 | 251 | 0.865169 | 2.17157419 | Halisarca dujardinii | 2583056 | Porifera | other_Eukaryota | 51.2 | 4.09e-5 | NR | AZI95673.1 | 2583056 | g100816 | i0 | 43.3 | 0.800796812749004 | 67 | 36 | 77.7 | 1 | 55 | 249 | 279 | 345 | AZI95673.1 26S proteasome non-ATPase regulatory subunit 12, partial [Halisarca dujardinii] | diamond | 201 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Chondrillida | Halisarcidae | Halisarca | Halisarca dujardinii | |
| 32299300 | 32299300 | PRJNA812715_P_NODE_70279_length_306_cov_0.991416_g68479_i0 | PRJNA812715 | 70279 | 306 | 0.991416 | 3.03373296 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 48.5 | 7.12e-4 | NR | CAI8016986.1 | 519541 | g68479 | i0 | 39.6 | 0.794117647058823 | 48 | 29 | 47.1 | 0 | 290 | 147 | 441 | 488 | CAI8016986.1 Pre-mRNA-processing factor 40 homolog A [Geodia barretti] | diamond | 243 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 32781109 | 32781109 | PRJNA812715_P_NODE_29120_length_566_cov_2.653144_g27361_i0 | PRJNA812715 | 29120 | 566 | 2.653144 | 15.01679504 | root | 1 | Root_unresolved | Root_unresolved | 65.9 | 7.65e-9 | NR | XP_062522096.1 | 121492 | g27361 | i0 | 48.5 | 11.3056537102474 | 68 | 35 | 36 | 0 | 210 | 7 | 384 | 451 | XP_062522096.1 dnaJ homolog subfamily C member 3-like [Corticium candelabrum] | diamond | 6399 | 66.2 | 0.995468277945619 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum |
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);;