contig_metadata
19 rows where bioproject = "PRJNA541476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3059277 | 3059277 | PRJNA541476_P_NODE_10843_length_349_cov_2.231884_g10637_i0 | PRJNA541476 | 10843 | 349 | 2.231884 | 7.78927516 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 197 | 4.03e-59 | NR | XP_064394950.1 | 6063 | g10637 | i0 | 83.5 | 36.5759312320917 | 115 | 19 | 98.9 | 0 | 3 | 347 | 150 | 264 | XP_064394950.1 eukaryotic peptide chain release factor subunit 1 [Halichondria panicea] | diamond | 12765 | 197 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 8771556 | 8771556 | PRJNA541476_P_NODE_1987_length_837_cov_4.098168_g1817_i0 | PRJNA541476 | 1987 | 837 | 4.098168 | 34.30166616 | root | 1 | Root_unresolved | Root_unresolved | 437 | 3.559999999999999e-147 | NR | XP_065184665.1 | 27933 | g1817 | i0 | 79.9 | 160.032258064516 | 279 | 53 | 100 | 1 | 837 | 1 | 36 | 311 | XP_065184665.1 heat shock cognate 71 kDa protein [Sycon ciliatum] | diamond | 133947 | 437 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 10712722 | 10712722 | PRJNA541476_P_NODE_2229_length_790_cov_3.124128_g2052_i0 | PRJNA541476 | 2229 | 790 | 3.124128 | 24.6806112 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 66.6 | 2.77e-8 | NR | XP_065832418.1 | 121494 | g2052 | i0 | 29.6 | 1.10506329113924 | 291 | 154 | 98.4 | 16 | 12 | 788 | 6279 | 6550 | XP_065832418.1 uncharacterized protein [Oscarella lobularis] | diamond | 873 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 17085849 | 17085849 | PRJNA541476_P_NODE_1054_length_1140_cov_4.657919_g923_i0 | PRJNA541476 | 1054 | 1140 | 4.657919 | 53.1002766 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 428 | 5.499999999999998e-145 | NR | XP_065174475.1 | 27933 | g923 | i0 | 74.2 | 16.0657894736842 | 271 | 68 | 70.8 | 1 | 1 | 807 | 156 | 426 | XP_065174475.1 isocitrate dehydrogenase [NADP], mitochondrial-like [Sycon ciliatum] | diamond | 18315 | 432 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 24734750 | 24734750 | PRJNA541476_P_NODE_2960_length_679_cov_16.239274_g2769_i0 | PRJNA541476 | 2960 | 679 | 16.239274 | 110.26467046 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 152 | 3.1099999999999993e-43 | NR | XP_062513731.1 | 121492 | g2769 | i0 | 64.5 | 0.53460972017673 | 121 | 43 | 53.5 | 0 | 56 | 418 | 2 | 122 | XP_062513731.1 large ribosomal subunit protein eL31-like [Corticium candelabrum] | diamond | 363 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 26761254 | 26761254 | PRJNA541476_P_NODE_21801_length_274_cov_2.691542_g21595_i0 | PRJNA541476 | 21801 | 274 | 2.691542 | 7.37482508 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 62.4 | 6.48e-9 | NR | XP_062514930.1 | 121492 | g21595 | i0 | 39.3 | 0.974452554744526 | 89 | 54 | 97.4 | 0 | 6 | 272 | 594 | 682 | XP_062514930.1 pre-mRNA-splicing factor SYF1-like [Corticium candelabrum] | diamond | 267 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 26982905 | 26982905 | PRJNA541476_P_NODE_12442_length_331_cov_1.864341_g12236_i0 | PRJNA541476 | 12442 | 331 | 1.864341 | 6.17096871 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 88.6 | 8.71e-18 | NR | XP_062503430.1 | 121492 | g12236 | i0 | 38.6 | 0.915407854984894 | 101 | 60 | 89.7 | 1 | 2 | 298 | 381 | 481 | XP_062503430.1 uncharacterized protein LOC134180315 [Corticium candelabrum] | diamond | 303 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27077875 | 27077875 | PRJNA541476_P_NODE_20102_length_281_cov_4.312500_g19896_i0 | PRJNA541476 | 20102 | 281 | 4.3125 | 12.118125 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 89.7 | 1.77e-18 | NR | XP_065178515.1 | 27933 | g19896 | i0 | 53.1 | 1.04626334519573 | 98 | 20 | 99.3 | 2 | 280 | 2 | 24 | 100 | XP_065178515.1 protein DD3-3-like [Sycon ciliatum] | diamond | 294 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 29666916 | 29666916 | PRJNA541476_P_NODE_2050_length_824_cov_4.511318_g1877_i0 | PRJNA541476 | 2050 | 824 | 4.511318 | 37.17326032 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 74.3 | 7.04e-11 | NR | XP_065884610.1 | 196820 | g1877 | i0 | 24.1 | 0.771844660194175 | 212 | 156 | 76.5 | 3 | 2 | 631 | 384 | 592 | XP_065884610.1 von Willebrand factor A domain-containing protein 5A-like [Dysidea avara] | diamond | 636 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29713338 | 29713338 | PRJNA541476_P_NODE_3530_length_617_cov_3.205882_g3337_i0 | PRJNA541476 | 3530 | 617 | 3.205882 | 19.78029194 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 268 | 1.09e-85 | NR | XP_065187034.1 | 27933 | g3337 | i0 | 60.7 | 6.00486223662885 | 206 | 79 | 99.7 | 2 | 3 | 617 | 146 | 350 | XP_065187034.1 beta-1,3-glucan-binding protein-like [Sycon ciliatum] | diamond | 3705 | 268 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30551660 | 30551660 | PRJNA541476_P_NODE_25273_length_262_cov_1.428571_g25067_i0 | PRJNA541476 | 25273 | 262 | 1.428571 | 3.74285602 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 57 | 4.53e-7 | NR | XP_065839382.1 | 121494 | g25067 | i0 | 47.3 | 1.23664122137405 | 55 | 19 | 63 | 2 | 166 | 2 | 655 | 699 | XP_065839382.1 uncharacterized protein [Oscarella lobularis] | diamond | 324 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30773130 | 30773130 | PRJNA541476_P_NODE_454_length_1576_cov_5.186959_g389_i0 | PRJNA541476 | 454 | 1576 | 5.186959 | 81.74647384 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 142 | 2.75e-35 | NR | XP_003384181.1 | 400682 | g389 | i0 | 38 | 1.18972081218274 | 229 | 127 | 43.2 | 8 | 125 | 805 | 1 | 216 | XP_003384181.1 PREDICTED: probable GH family 25 lysozyme 2 [Amphimedon queenslandica] | diamond | 1875 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 30836145 | 30836145 | PRJNA541476_P_NODE_15534_length_306_cov_1.257511_g15328_i0 | PRJNA541476 | 15534 | 306 | 1.257511 | 3.84798366 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 61.2 | 2.48e-8 | NR | XP_003386126.1 | 400682 | g15328 | i0 | 40.5 | 0.823529411764706 | 84 | 50 | 82.4 | 0 | 300 | 49 | 92 | 175 | XP_003386126.1 PREDICTED: coiled-coil domain-containing protein 173-like [Amphimedon queenslandica] | diamond | 252 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 30882569 | 30882569 | PRJNA541476_P_NODE_10474_length_354_cov_1.092527_g10268_i0 | PRJNA541476 | 10474 | 354 | 1.092527 | 3.86754558 | Porifera | 6040 | Porifera | other_Eukaryota | 61.6 | 3.03e-8 | NR | XP_065830027.1 | 121494 | g10268 | i0 | 59 | 1.44915254237288 | 39 | 16 | 33.1 | 0 | 335 | 219 | 477 | 515 | XP_065830027.1 uncharacterized protein [Oscarella lobularis] | diamond | 513 | 62 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31278463 | 31278463 | PRJNA541476_P_NODE_28075_length_253_cov_1.383333_g27869_i0 | PRJNA541476 | 28075 | 253 | 1.383333 | 3.49983249 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 63.9 | 1.44e-9 | NR | XP_065898601.1 | 196820 | g27869 | i0 | 43.8 | 0.948616600790514 | 80 | 38 | 87.7 | 2 | 239 | 18 | 347 | 425 | XP_065898601.1 multidrug resistance-associated protein 1-like [Dysidea avara] | diamond | 240 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 31641264 | 31641264 | PRJNA541476_P_NODE_32096_length_249_cov_0.880682_g31890_i0 | PRJNA541476 | 32096 | 249 | 0.880682 | 2.19289818 | Metazoa | 33208 | Porifera | other_Eukaryota | 58.5 | 1.07e-7 | NR | XP_064389849.1 | 6063 | g31890 | i0 | 42.9 | 6.02409638554217 | 56 | 28 | 67.5 | 1 | 48 | 215 | 107 | 158 | XP_064389849.1 alpha-1,6-mannosylglycoprotein 6-beta-N-acetylglucosaminyltransferase A-like [Halichondria panicea] | diamond | 1500 | 58.9 | 0.99320882852292 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 31957631 | 31957631 | PRJNA541476_P_NODE_397_length_1651_cov_14.437262_g338_i0 | PRJNA541476 | 397 | 1651 | 14.437262 | 238.35919562 | root | 1 | Root_unresolved | Root_unresolved | 55.1 | 0.00101 | NR | XP_065189988.1 | 27933 | g338 | i0 | 33.6 | 0.913991520290733 | 116 | 72 | 20.7 | 2 | 1030 | 1371 | 1127 | 1239 | XP_065189988.1 uncharacterized protein LOC135820872 [Sycon ciliatum] | diamond | 1509 | 55.5 | 0.992792792792793 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32006153 | 32006153 | PRJNA541476_P_NODE_19098_length_286_cov_1.676056_g18892_i0 | PRJNA541476 | 19098 | 286 | 1.676056 | 4.79352016 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 69.3 | 2.84e-11 | NR | XP_065890190.1 | 196820 | g18892 | i0 | 45.2 | 3.10489510489511 | 73 | 37 | 76.6 | 1 | 279 | 61 | 671 | 740 | XP_065890190.1 neprilysin-3-like [Dysidea avara] | diamond | 888 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 32716369 | 32716369 | PRJNA541476_P_NODE_28560_length_252_cov_1.653631_g28354_i0 | PRJNA541476 | 28560 | 252 | 1.653631 | 4.16715012 | Porifera | 6040 | Porifera | other_Eukaryota | 109 | 1.53e-25 | NR | XP_065830064.1 | 121494 | g28354 | i0 | 56.1 | 1.85714285714286 | 82 | 34 | 97.6 | 1 | 251 | 6 | 175 | 254 | XP_065830064.1 protein DD3-3-like [Oscarella lobularis] | diamond | 468 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis |
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);;