contig_metadata
27 rows where bioproject = "PRJNA1011833" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2276740 | 2276740 | PRJNA1011833_S_NODE_15002_length_311_cov_12.962687_g14582_i0 | PRJNA1011833 | 15002 | 311 | 12.962687 | 40.31395657 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 183 | 4.59e-53 | NR | XP_065839423.1 | 121494 | g14582 | i0 | 82 | 11.5755627009646 | 100 | 18 | 96.5 | 0 | 309 | 10 | 428 | 527 | XP_065839423.1 aspartate--tRNA ligase, cytoplasmic-like [Oscarella lobularis] | diamond | 3600 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 2705807 | 2705807 | PRJNA1011833_S_NODE_5683_length_448_cov_7.019753_g5271_i0 | PRJNA1011833 | 5683 | 448 | 7.019753 | 31.44849344 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 73.2 | 1.32e-12 | NR | XP_011409930.1 | 400682 | g5271 | i0 | 64.3 | 1.48660714285714 | 56 | 20 | 37.5 | 0 | 446 | 279 | 54 | 109 | XP_011409930.1 PREDICTED: serine/arginine-rich splicing factor 12 [Amphimedon queenslandica] | diamond | 666 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 21832372 | 21832372 | PRJNA1011833_S_NODE_9378_length_379_cov_3.916667_g8960_i0 | PRJNA1011833 | 9378 | 379 | 3.916667 | 14.84416793 | Metazoa | 33208 | Porifera | other_Eukaryota | 219 | 1.6e-69 | NR | XP_064390446.1 | 6063 | g8960 | i0 | 85.6 | 107.445910290237 | 118 | 17 | 93.4 | 0 | 354 | 1 | 139 | 256 | XP_064390446.1 ribosome biogenesis protein NSA2 homolog [Halichondria panicea] | diamond | 40722 | 221 | 0.990950226244344 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 23107883 | 23107883 | PRJNA1011833_S_NODE_8459_length_393_cov_4.197143_g8042_i0 | PRJNA1011833 | 8459 | 393 | 4.197143 | 16.49477199 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 140 | 1.87e-36 | NR | XP_062520272.1 | 121492 | g8042 | i0 | 56.8 | 11.6564885496183 | 118 | 48 | 89.3 | 2 | 3 | 353 | 360 | 475 | XP_062520272.1 serine hydroxymethyltransferase, mitochondrial-like isoform X2 [Corticium candelabrum] | diamond | 4581 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27319301 | 27319301 | PRJNA1011833_S_NODE_33963_length_201_cov_1.215190_g33543_i0 | PRJNA1011833 | 33963 | 201 | 1.21519 | 2.4425319 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 43.1 | 0.0155 | NR | XP_019861315.1 | 400682 | g33543 | i0 | 57.1 | 1.1044776119403 | 28 | 12 | 41.8 | 0 | 108 | 191 | 539 | 566 | XP_019861315.1 PREDICTED: mitogen-activated protein kinase kinase kinase 2-like [Amphimedon queenslandica] | diamond | 222 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 27414200 | 27414200 | PRJNA1011833_S_NODE_13483_length_327_cov_5.355634_g13063_i0 | PRJNA1011833 | 13483 | 327 | 5.355634 | 17.51292318 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 85.9 | 5.29e-18 | NR | XP_062507821.1 | 121492 | g13063 | i0 | 51 | 0.880733944954128 | 96 | 46 | 87.2 | 1 | 3 | 287 | 93 | 188 | XP_062507821.1 charged multivesicular body protein 3-like [Corticium candelabrum] | diamond | 288 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27563935 | 27563935 | PRJNA1011833_S_NODE_12544_length_338_cov_2.169492_g12124_i0 | PRJNA1011833 | 12544 | 338 | 2.169492 | 7.33288296 | Metazoa | 33208 | Porifera | other_Eukaryota | 59.3 | 1.6e-7 | NR | XP_065882975.1 | 196820 | g12124 | i0 | 47.3 | 1.08284023668639 | 55 | 24 | 48.8 | 1 | 338 | 174 | 78 | 127 | XP_065882975.1 programmed cell death protein 2-like [Dysidea avara] | diamond | 366 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 27824575 | 27824575 | PRJNA1011833_S_NODE_8244_length_397_cov_1.949153_g7827_i0 | PRJNA1011833 | 8244 | 397 | 1.949153 | 7.73813741 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 56.2 | 4.19e-6 | NR | CAI8034559.1 | 519541 | g7827 | i0 | 78.4 | 4.08816120906801 | 37 | 8 | 28 | 0 | 115 | 5 | 1560 | 1596 | CAI8034559.1 Myosin-11 [Geodia barretti] | diamond | 1623 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 28037907 | 28037907 | PRJNA1011833_S_NODE_14165_length_320_cov_3.241877_g13745_i0 | PRJNA1011833 | 14165 | 320 | 3.241877 | 10.3740064 | Metazoa | 33208 | Porifera | other_Eukaryota | 63.2 | 6.13e-9 | NR | XP_064394353.1 | 6063 | g13745 | i0 | 34 | 5.925 | 106 | 63 | 96.6 | 2 | 2 | 310 | 420 | 521 | XP_064394353.1 selenocysteine insertion sequence-binding protein 2-like [Halichondria panicea] | diamond | 1896 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28550817 | 28550817 | PRJNA1011833_S_NODE_10647_length_361_cov_4.625786_g10228_i0 | PRJNA1011833 | 10647 | 361 | 4.625786 | 16.69908746 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 53.1 | 6.77e-6 | NR | XP_003389534.1 | 400682 | g10228 | i0 | 32.7 | 0.889196675900277 | 107 | 66 | 88.9 | 1 | 6 | 326 | 35 | 135 | XP_003389534.1 PREDICTED: coiled-coil domain-containing protein 58-like [Amphimedon queenslandica] | diamond | 321 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 28740082 | 28740082 | PRJNA1011833_S_NODE_19127_length_276_cov_5.257511_g18707_i0 | PRJNA1011833 | 19127 | 276 | 5.257511 | 14.51073036 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 125 | 2.22e-32 | NR | XP_065829482.1 | 121494 | g18707 | i0 | 63.3 | 1.93478260869565 | 90 | 33 | 97.8 | 0 | 271 | 2 | 261 | 350 | XP_065829482.1 glutamine synthetase-like [Oscarella lobularis] | diamond | 534 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 29813469 | 29813469 | PRJNA1011833_S_NODE_19271_length_275_cov_2.758621_g18851_i0 | PRJNA1011833 | 19271 | 275 | 2.758621 | 7.58620775 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 58.9 | 6.2e-8 | NR | CAI8012708.1 | 519541 | g18851 | i0 | 38.9 | 3.45818181818182 | 90 | 51 | 94.9 | 2 | 262 | 2 | 92 | 180 | CAI8012708.1 N-alpha-acetyltransferase 40 [Geodia barretti] | diamond | 951 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 29971496 | 29971496 | PRJNA1011833_S_NODE_42511_length_178_cov_1.777778_g42091_i0 | PRJNA1011833 | 42511 | 178 | 1.777778 | 3.16444484 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 45.1 | 0.00235 | NR | XP_065179031.1 | 27933 | g42091 | i0 | 36.7 | 2.02247191011236 | 60 | 30 | 89.3 | 2 | 164 | 6 | 947 | 1005 | XP_065179031.1 A disintegrin and metalloproteinase with thrombospondin motifs adt-2-like [Sycon ciliatum] | diamond | 360 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30003240 | 30003240 | PRJNA1011833_S_NODE_46611_length_170_cov_1.133858_g46191_i0 | PRJNA1011833 | 46611 | 170 | 1.133858 | 1.9275586 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 64.7 | 2.42e-10 | NR | XP_065827420.1 | 121494 | g46191 | i0 | 50 | 1.97647058823529 | 56 | 28 | 98.8 | 0 | 2 | 169 | 130 | 185 | XP_065827420.1 dnaJ homolog subfamily A member 2-like [Oscarella lobularis] | diamond | 336 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30382670 | 30382670 | PRJNA1011833_S_NODE_9153_length_382_cov_9.091445_g8735_i0 | PRJNA1011833 | 9153 | 382 | 9.091445 | 34.7293199 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 128 | 1.87e-33 | NR | XP_065191053.1 | 27933 | g8735 | i0 | 49.1 | 0.879581151832461 | 112 | 55 | 86.4 | 2 | 382 | 53 | 146 | 257 | XP_065191053.1 protein SCO1 homolog, mitochondrial-like [Sycon ciliatum] | diamond | 336 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30540194 | 30540194 | PRJNA1011833_S_NODE_22113_length_255_cov_2.037736_g21693_i0 | PRJNA1011833 | 22113 | 255 | 2.037736 | 5.1962268 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 82.8 | 1.72e-16 | NR | XP_065843080.1 | 121494 | g21693 | i0 | 45.7 | 14.7176470588235 | 81 | 43 | 95.3 | 1 | 12 | 254 | 253 | 332 | XP_065843080.1 L-threonine 3-dehydrogenase, mitochondrial-like isoform X1 [Oscarella lobularis] | diamond | 3753 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30982730 | 30982730 | PRJNA1011833_S_NODE_11634_length_348_cov_5.573770_g11214_i0 | PRJNA1011833 | 11634 | 348 | 5.57377 | 19.3967196 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 107 | 2.41e-25 | NR | XP_065843080.1 | 121494 | g11214 | i0 | 45 | 0.956896551724138 | 111 | 59 | 95.7 | 2 | 2 | 334 | 230 | 338 | XP_065843080.1 L-threonine 3-dehydrogenase, mitochondrial-like isoform X1 [Oscarella lobularis] | diamond | 333 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30982737 | 30982737 | PRJNA1011833_S_NODE_39934_length_184_cov_1.652482_g39514_i0 | PRJNA1011833 | 39934 | 184 | 1.652482 | 3.04056688 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 77 | 2.17e-15 | NR | XP_065834394.1 | 121494 | g39514 | i0 | 57.7 | 1.69565217391304 | 52 | 22 | 84.8 | 0 | 28 | 183 | 124 | 175 | XP_065834394.1 rRNA N6-adenosine-methyltransferase METTL5-like [Oscarella lobularis] | diamond | 312 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31646370 | 31646370 | PRJNA1011833_S_NODE_34157_length_200_cov_1.834395_g33737_i0 | PRJNA1011833 | 34157 | 200 | 1.834395 | 3.66879 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 72.4 | 2.12e-14 | NR | KAI6651684.1 | 111878 | g33737 | i0 | 52.9 | 2.91 | 68 | 29 | 97.5 | 2 | 199 | 5 | 30 | 97 | KAI6651684.1 14 kDa phosphohistidine phosphatase-like [Oopsacas minuta] | diamond | 582 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 31741279 | 31741279 | PRJNA1011833_S_NODE_37237_length_191_cov_1.472973_g36817_i0 | PRJNA1011833 | 37237 | 191 | 1.472973 | 2.81337843 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 83.6 | 7.69e-17 | NR | XP_065892899.1 | 196820 | g36817 | i0 | 68.5 | 9.32984293193717 | 54 | 17 | 84.8 | 0 | 190 | 29 | 585 | 638 | XP_065892899.1 clathrin heavy chain 1-like [Dysidea avara] | diamond | 1782 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 31836113 | 31836113 | PRJNA1011833_S_NODE_4557_length_480_cov_12.084668_g4151_i0 | PRJNA1011833 | 4557 | 480 | 12.084668 | 58.0064064 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 129 | 4.84e-34 | NR | CAI7998431.1 | 519541 | g4151 | i0 | 51.6 | 0.775 | 124 | 59 | 76.9 | 1 | 472 | 104 | 80 | 203 | CAI7998431.1 Osteoclast-stimulating factor 1 [Geodia barretti] | diamond | 372 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 31923534 | 31923534 | PRJNA1011833_S_NODE_12497_length_338_cov_6.088136_g12077_i0 | PRJNA1011833 | 12497 | 338 | 6.088136 | 20.57789968 | Metazoa | 33208 | Porifera | other_Eukaryota | 117 | 4.88e-31 | NR | XP_065890824.1 | 196820 | g12077 | i0 | 55 | 4.43786982248521 | 100 | 45 | 88.8 | 0 | 338 | 39 | 47 | 146 | XP_065890824.1 bis(5'-adenosyl)-triphosphatase-like [Dysidea avara] | diamond | 1500 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 31931144 | 31931144 | PRJNA1011833_S_NODE_23437_length_247_cov_1.372549_g23017_i0 | PRJNA1011833 | 23437 | 247 | 1.372549 | 3.39019603 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 56.6 | 5.04e-7 | NR | KAI6660428.1 | 111878 | g23017 | i0 | 36.4 | 0.935222672064777 | 77 | 38 | 93.5 | 1 | 16 | 246 | 485 | 550 | KAI6660428.1 hypothetical protein LOD99_14014 [Oopsacas minuta] | diamond | 231 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 32429935 | 32429935 | PRJNA1011833_S_NODE_19119_length_276_cov_8.467811_g18699_i0 | PRJNA1011833 | 19119 | 276 | 8.467811 | 23.37115836 | Metazoa | 33208 | Porifera | other_Eukaryota | 79 | 9.75e-15 | NR | XP_019854051.1 | 400682 | g18699 | i0 | 38.5 | 6.84782608695652 | 91 | 54 | 97.8 | 2 | 1 | 270 | 370 | 459 | XP_019854051.1 PREDICTED: LIM domain-binding protein 3-like [Amphimedon queenslandica] | diamond | 1890 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 32658172 | 32658172 | PRJNA1011833_S_NODE_18480_length_281_cov_3.735294_g18060_i0 | PRJNA1011833 | 18480 | 281 | 3.735294 | 10.49617614 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 96.3 | 2.01e-21 | NR | XP_065890762.1 | 196820 | g18060 | i0 | 47.8 | 2.96797153024911 | 92 | 47 | 98.2 | 1 | 278 | 3 | 219 | 309 | XP_065890762.1 citramalyl-CoA lyase, mitochondrial-like [Dysidea avara] | diamond | 834 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 32784339 | 32784339 | PRJNA1011833_S_NODE_45660_length_172_cov_1.069767_g45240_i0 | PRJNA1011833 | 45660 | 172 | 1.069767 | 1.83999924 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 44.7 | 0.00291 | NR | KAI6656352.1 | 111878 | g45240 | i0 | 40 | 3.80232558139535 | 55 | 32 | 95.9 | 1 | 6 | 170 | 34 | 87 | KAI6656352.1 cGMP-dependent protein kinase 1 isoform 2 [Oopsacas minuta] | diamond | 654 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 32878854 | 32878854 | PRJNA1011833_S_NODE_31420_length_209_cov_6.138554_g31000_i0 | PRJNA1011833 | 31420 | 209 | 6.138554 | 12.82957786 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 46.2 | 2.91e-4 | NR | KAI6651473.1 | 111878 | g31000 | i0 | 36.4 | 0.947368421052632 | 66 | 37 | 87.6 | 1 | 10 | 192 | 31 | 96 | KAI6651473.1 hypothetical protein LOD99_5081 [Oopsacas minuta] | diamond | 198 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta |
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);;