contig_metadata
26 rows where bioproject = "PRJNA770361", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3297622 | 3297622 | PRJNA770361_P_NODE_2623_length_583_cov_8.305882_g2529_i0 | PRJNA770361 | 2623 | 583 | 8.305882 | 48.42329206 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 249 | 4.83e-81 | NR | XP_065898136.1 | 196820 | g2529 | i0 | 70.3 | 9.26243567753002 | 182 | 50 | 91.6 | 1 | 537 | 4 | 1 | 182 | XP_065898136.1 small ribosomal subunit protein eS8-like [Dysidea avara] | diamond | 5400 | 249 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 10950496 | 10950496 | PRJNA770361_P_NODE_269_length_1551_cov_71.614344_g246_i0 | PRJNA770361 | 269 | 1551 | 71.614344 | 1110.73847544 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 551 | 9.56e-191 | NR | AQM52339.1 | 121494 | g246 | i0 | 58.6 | 25.6499032882012 | 457 | 175 | 88 | 5 | 1512 | 148 | 1 | 445 | AQM52339.1 elongation factor 1 alpha, partial [Oscarella lobularis] | diamond | 39783 | 556 | 0.991007194244604 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 17324838 | 17324838 | PRJNA770361_P_NODE_8774_length_318_cov_1.591837_g8679_i0 | PRJNA770361 | 8774 | 318 | 1.591837 | 5.06204166 | Metazoa | 33208 | Porifera | other_Eukaryota | 60.5 | 5.04e-8 | NR | XP_065827923.1 | 121494 | g8679 | i0 | 66 | 1.52830188679245 | 50 | 16 | 46.2 | 1 | 284 | 138 | 71 | 120 | XP_065827923.1 programmed cell death protein 4-like [Oscarella lobularis] | diamond | 486 | 60.8 | 0.995065789473684 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 19873207 | 19873207 | PRJNA770361_P_NODE_3496_length_503_cov_2.860465_g3401_i0 | PRJNA770361 | 3496 | 503 | 2.860465 | 14.38813895 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 127 | 2.01e-33 | NR | XP_011409930.1 | 400682 | g3401 | i0 | 59.6 | 1.16898608349901 | 99 | 40 | 59 | 0 | 503 | 207 | 11 | 109 | XP_011409930.1 PREDICTED: serine/arginine-rich splicing factor 12 [Amphimedon queenslandica] | diamond | 588 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 19873246 | 19873246 | PRJNA770361_P_NODE_5816_length_390_cov_1.476341_g5721_i0 | PRJNA770361 | 5816 | 390 | 1.476341 | 5.7577299 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 198 | 3e-61 | NR | XP_062521049.1 | 121492 | g5721 | i0 | 74.6 | 26.9923076923077 | 130 | 33 | 100 | 0 | 1 | 390 | 119 | 248 | XP_062521049.1 large ribosomal subunit protein uL30-like [Corticium candelabrum] | diamond | 10527 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 26904720 | 26904720 | PRJNA770361_P_NODE_2961_length_549_cov_2.361345_g2867_i0 | PRJNA770361 | 2961 | 549 | 2.361345 | 12.96378405 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 159 | 2.23e-44 | NR | XP_065191053.1 | 27933 | g2867 | i0 | 41.8 | 5.26229508196721 | 177 | 100 | 95.1 | 3 | 6 | 527 | 105 | 281 | XP_065191053.1 protein SCO1 homolog, mitochondrial-like [Sycon ciliatum] | diamond | 2889 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 26958121 | 26958121 | PRJNA770361_P_NODE_3202_length_526_cov_1.364238_g3107_i0 | PRJNA770361 | 3202 | 526 | 1.364238 | 7.17589188 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 104 | 9.36e-24 | NR | XP_064396407.1 | 6063 | g3107 | i0 | 40.3 | 5.82889733840304 | 124 | 68 | 67.3 | 1 | 508 | 155 | 70 | 193 | XP_064396407.1 autophagy protein 5-like [Halichondria panicea] | diamond | 3066 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27125630 | 27125630 | PRJNA770361_P_NODE_13022_length_258_cov_2.529730_g12927_i0 | PRJNA770361 | 13022 | 258 | 2.52973 | 6.5267034 | Suberitida | 1779162 | Porifera | other_Eukaryota | 124 | 1.24e-33 | NR | XP_064383570.1 | 6063 | g12927 | i0 | 75.9 | 1.83720930232558 | 79 | 19 | 91.9 | 0 | 238 | 2 | 1 | 79 | XP_064383570.1 small ribosomal subunit protein eS8-like [Halichondria panicea] | diamond | 474 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27125633 | 27125633 | PRJNA770361_P_NODE_18982_length_242_cov_0.923077_g18887_i0 | PRJNA770361 | 18982 | 242 | 0.923077 | 2.23384634 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.2 | 2.97e-14 | NR | CAI8034823.1 | 519541 | g18887 | i0 | 45.3 | 6.55785123966942 | 75 | 41 | 93 | 0 | 5 | 229 | 15 | 89 | CAI8034823.1 RAC serine/threonine-protein kinase [Geodia barretti] | diamond | 1587 | 73.9 | 0.990527740189445 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 27442377 | 27442377 | PRJNA770361_P_NODE_10683_length_289_cov_1.078704_g10588_i0 | PRJNA770361 | 10683 | 289 | 1.078704 | 3.11745456 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 89.7 | 1.98e-18 | NR | BAA34307.1 | 31330 | g10588 | i0 | 44.3 | 3.88235294117647 | 97 | 52 | 98.6 | 1 | 286 | 2 | 238 | 334 | BAA34307.1 EFPDE1 [Ephydatia fluviatilis] | diamond | 1122 | 90.1 | 0.995560488346282 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Spongillida | Spongillidae | Ephydatia | Ephydatia fluviatilis | |
| 27874471 | 27874471 | PRJNA770361_P_NODE_13365_length_254_cov_1.723757_g13270_i0 | PRJNA770361 | 13365 | 254 | 1.723757 | 4.37834278 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 83.6 | 1.81e-16 | NR | XP_064401775.1 | 6063 | g13270 | i0 | 51.9 | 0.933070866141732 | 79 | 38 | 93.3 | 0 | 238 | 2 | 372 | 450 | XP_064401775.1 cleavage stimulation factor subunit 3-like [Halichondria panicea] | diamond | 237 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27978789 | 27978789 | PRJNA770361_P_NODE_7485_length_343_cov_1.662963_g7390_i0 | PRJNA770361 | 7485 | 343 | 1.662963 | 5.70396309 | Metazoa | 33208 | Porifera | other_Eukaryota | 114 | 5.16e-28 | NR | XP_064398316.1 | 6063 | g7390 | i0 | 55.1 | 18.4723032069971 | 107 | 48 | 93.6 | 0 | 22 | 342 | 2 | 108 | XP_064398316.1 IST1 homolog [Halichondria panicea] | diamond | 6336 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28610348 | 28610348 | PRJNA770361_P_NODE_747_length_1054_cov_15.286442_g686_i0 | PRJNA770361 | 747 | 1054 | 15.286442 | 161.11909868 | Metazoa | 33208 | Porifera | other_Eukaryota | 180 | 3.72e-50 | NR | KAI6649628.1 | 111878 | g686 | i0 | 34.4 | 6.50948766603416 | 317 | 197 | 89.1 | 7 | 996 | 58 | 4 | 313 | KAI6649628.1 Cathepsin L [Oopsacas minuta] | diamond | 6861 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 29011540 | 29011540 | PRJNA770361_P_NODE_9028_length_314_cov_1.290456_g8933_i0 | PRJNA770361 | 9028 | 314 | 1.290456 | 4.05203184 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 53.5 | 1.42e-5 | NR | XP_062509285.1 | 121492 | g8933 | i0 | 52.8 | 0.506369426751592 | 53 | 25 | 50.6 | 0 | 3 | 161 | 41 | 93 | XP_062509285.1 epidermal growth factor receptor substrate 15-like [Corticium candelabrum] | diamond | 159 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 29052475 | 29052475 | PRJNA770361_P_NODE_10708_length_288_cov_1.479070_g10613_i0 | PRJNA770361 | 10708 | 288 | 1.47907 | 4.2597216 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 90.5 | 1.09e-18 | NR | XP_065884633.1 | 196820 | g10613 | i0 | 43 | 3.76041666666667 | 107 | 46 | 95.8 | 2 | 4 | 279 | 45 | 151 | XP_065884633.1 filamin-C-like [Dysidea avara] | diamond | 1083 | 91.3 | 0.991237677984666 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29304846 | 29304846 | PRJNA770361_P_NODE_809_length_1013_cov_2.957447_g747_i0 | PRJNA770361 | 809 | 1013 | 2.957447 | 29.95893811 | Metazoa | 33208 | Porifera | other_Eukaryota | 156 | 8.57e-41 | NR | XP_065891123.1 | 196820 | g747 | i0 | 36.7 | 3.74037512339585 | 289 | 152 | 78.2 | 8 | 35 | 826 | 4 | 286 | XP_065891123.1 stromal membrane-associated protein 1-like [Dysidea avara] | diamond | 3789 | 157 | 0.993630573248408 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29705378 | 29705378 | PRJNA770361_P_NODE_6270_length_374_cov_1.554817_g6175_i0 | PRJNA770361 | 6270 | 374 | 1.554817 | 5.81501558 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 79 | 3.49e-14 | NR | XP_062508940.1 | 121492 | g6175 | i0 | 38.2 | 4.20320855614973 | 110 | 67 | 88.2 | 1 | 21 | 350 | 10 | 118 | XP_062508940.1 transportin-1-like [Corticium candelabrum] | diamond | 1572 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 30211021 | 30211021 | PRJNA770361_P_NODE_8292_length_326_cov_2.158103_g8197_i0 | PRJNA770361 | 8292 | 326 | 2.158103 | 7.03541578 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 48.9 | 5.32e-4 | NR | XP_065892257.1 | 196820 | g8197 | i0 | 36 | 0.819018404907976 | 89 | 53 | 79.1 | 2 | 69 | 326 | 56 | 143 | XP_065892257.1 uroporphyrinogen-III synthase-like [Dysidea avara] | diamond | 267 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 30338052 | 30338052 | PRJNA770361_P_NODE_16212_length_248_cov_0.891429_g16117_i0 | PRJNA770361 | 16212 | 248 | 0.891429 | 2.21074392 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 64.7 | 7.14e-10 | NR | XP_065905281.1 | 196820 | g16117 | i0 | 54.9 | 1.97177419354839 | 51 | 23 | 61.7 | 0 | 25 | 177 | 78 | 128 | XP_065905281.1 poly(A)-specific ribonuclease PARN-like [Dysidea avara] | diamond | 489 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 30947707 | 30947707 | PRJNA770361_P_NODE_4174_length_461_cov_1.641753_g4079_i0 | PRJNA770361 | 4174 | 461 | 1.641753 | 7.56848133 | Metazoa | 33208 | Porifera | other_Eukaryota | 162 | 6.959999999999999e-46 | NR | XP_064404203.1 | 6063 | g4079 | i0 | 57.7 | 3.20824295010846 | 123 | 51 | 80 | 1 | 1 | 369 | 93 | 214 | XP_064404203.1 GDP-L-fucose synthase-like [Halichondria panicea] | diamond | 1479 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 31001199 | 31001199 | PRJNA770361_P_NODE_5774_length_391_cov_2.487421_g5679_i0 | PRJNA770361 | 5774 | 391 | 2.487421 | 9.72581611 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 96.3 | 3.41e-20 | NR | XP_003389492.1 | 400682 | g5679 | i0 | 48.6 | 0.805626598465473 | 105 | 54 | 80.6 | 0 | 52 | 366 | 21 | 125 | XP_003389492.1 PREDICTED: GTP-binding protein 2-like isoform X2 [Amphimedon queenslandica] | diamond | 315 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 31443673 | 31443673 | PRJNA770361_P_NODE_5736_length_393_cov_1.653125_g5641_i0 | PRJNA770361 | 5736 | 393 | 1.653125 | 6.49678125 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 176 | 1.72e-51 | NR | XP_065829482.1 | 121494 | g5641 | i0 | 60.8 | 1.98473282442748 | 130 | 51 | 99.2 | 0 | 391 | 2 | 206 | 335 | XP_065829482.1 glutamine synthetase-like [Oscarella lobularis] | diamond | 780 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31475439 | 31475439 | PRJNA770361_P_NODE_4476_length_445_cov_1.255376_g4381_i0 | PRJNA770361 | 4476 | 445 | 1.255376 | 5.5864232 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 82 | 5.88e-15 | NR | XP_062516310.1 | 121492 | g4381 | i0 | 47.4 | 0.512359550561798 | 76 | 40 | 51.2 | 0 | 209 | 436 | 210 | 285 | XP_062516310.1 actin nucleation-promoting factor WASL-like [Corticium candelabrum] | diamond | 228 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 32519612 | 32519612 | PRJNA770361_P_NODE_2839_length_562_cov_3.347648_g2745_i0 | PRJNA770361 | 2839 | 562 | 3.347648 | 18.81378176 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 157 | 6.469999999999999e-45 | NR | CAI7998431.1 | 519541 | g2745 | i0 | 46.4 | 0.955516014234875 | 179 | 94 | 95 | 2 | 534 | 1 | 10 | 187 | CAI7998431.1 Osteoclast-stimulating factor 1 [Geodia barretti] | diamond | 537 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 32686398 | 32686398 | PRJNA770361_P_NODE_4920_length_424_cov_1.555556_g4825_i0 | PRJNA770361 | 4920 | 424 | 1.555556 | 6.59555744 | Metazoa | 33208 | Porifera | other_Eukaryota | 78.6 | 7.76e-14 | NR | XP_065185315.1 | 27933 | g4825 | i0 | 34.1 | 10.2665094339623 | 138 | 90 | 97.6 | 1 | 415 | 2 | 47 | 183 | XP_065185315.1 polypyrimidine tract-binding protein 2-like [Sycon ciliatum] | diamond | 4353 | 79 | 0.994936708860759 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32897226 | 32897226 | PRJNA770361_P_NODE_1240_length_837_cov_1.395288_g1158_i0 | PRJNA770361 | 1240 | 837 | 1.395288 | 11.67856056 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 307 | 3.67e-97 | NR | XP_065906435.1 | 196820 | g1158 | i0 | 63.8 | 7.89605734767025 | 224 | 79 | 79.9 | 2 | 736 | 68 | 4 | 226 | XP_065906435.1 CTP synthase 1-like isoform X2 [Dysidea avara] | diamond | 6609 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara |
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);;