contig_metadata
28 rows where bioproject = "PRJNA949785", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2208508 | 2208508 | PRJNA949785_P_NODE_3162_length_661_cov_2.168367_g2981_i0 | PRJNA949785 | 3162 | 661 | 2.168367 | 14.33290587 | Metazoa | 33208 | Porifera | other_Eukaryota | 322 | 1.26e-108 | NR | XP_064390446.1 | 6063 | g2981 | i0 | 79.2 | 19.6701966717095 | 197 | 41 | 89.4 | 0 | 70 | 660 | 62 | 258 | XP_064390446.1 ribosome biogenesis protein NSA2 homolog [Halichondria panicea] | diamond | 13002 | 324 | 0.993827160493827 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 20059915 | 20059915 | PRJNA949785_P_NODE_6576_length_425_cov_5.315341_g6379_i0 | PRJNA949785 | 6576 | 425 | 5.315341 | 22.59019925 | Metazoa | 33208 | Porifera | other_Eukaryota | 207 | 8.25e-64 | NR | XP_064392436.1 | 6063 | g6379 | i0 | 82.2 | 72.7482352941176 | 118 | 21 | 83.3 | 0 | 2 | 355 | 3 | 120 | XP_064392436.1 serine/threonine-protein phosphatase alpha-2 isoform [Halichondria panicea] | diamond | 30918 | 209 | 0.990430622009569 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 21335308 | 21335308 | PRJNA949785_P_NODE_437_length_1590_cov_48.446276_g386_i0 | PRJNA949785 | 437 | 1590 | 48.446276 | 770.2957884 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 550 | 2.1e-190 | NR | AQM52339.1 | 121494 | g386 | i0 | 58.6 | 25.8811320754717 | 457 | 175 | 85.8 | 5 | 1531 | 167 | 1 | 445 | AQM52339.1 elongation factor 1 alpha, partial [Oscarella lobularis] | diamond | 41151 | 555 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 25159356 | 25159356 | PRJNA949785_P_NODE_2440_length_753_cov_2.038235_g2272_i0 | PRJNA949785 | 2440 | 753 | 2.038235 | 15.34790955 | Metazoa | 33208 | Porifera | other_Eukaryota | 408 | 2.209999999999999e-138 | NR | XP_064399423.1 | 6063 | g2272 | i0 | 80.1 | 102.872509960159 | 251 | 50 | 100 | 0 | 753 | 1 | 250 | 500 | XP_064399423.1 RNA-splicing ligase RtcB homolog [Halichondria panicea] | diamond | 77463 | 412 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 26867531 | 26867531 | PRJNA949785_P_NODE_1801_length_887_cov_1.153563_g1653_i0 | PRJNA949785 | 1801 | 887 | 1.153563 | 10.23210381 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 269 | 1.42e-84 | NR | XP_019848654.1 | 400682 | g1653 | i0 | 55.4 | 11.9763246899662 | 251 | 108 | 84.2 | 3 | 833 | 87 | 114 | 362 | XP_019848654.1 PREDICTED: HIV Tat-specific factor 1-like [Amphimedon queenslandica] | diamond | 10623 | 269 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 26899056 | 26899056 | PRJNA949785_P_NODE_14501_length_262_cov_1.629630_g14304_i0 | PRJNA949785 | 14501 | 262 | 1.62963 | 4.2696306 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 78.2 | 1.5e-14 | NR | XP_065886535.1 | 196820 | g14304 | i0 | 44 | 5.80534351145038 | 84 | 47 | 96.2 | 0 | 260 | 9 | 197 | 280 | XP_065886535.1 microspherule protein 1-like [Dysidea avara] | diamond | 1521 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 27025503 | 27025503 | PRJNA949785_P_NODE_18142_length_243_cov_1.358824_g17945_i0 | PRJNA949785 | 18142 | 243 | 1.358824 | 3.30194232 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 90.5 | 2.87e-20 | NR | KAI6645729.1 | 111878 | g17945 | i0 | 66.2 | 4.97530864197531 | 68 | 23 | 84 | 0 | 205 | 2 | 140 | 207 | KAI6645729.1 polyprotein [Oopsacas minuta] | diamond | 1209 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 27499595 | 27499595 | PRJNA949785_P_NODE_11203_length_307_cov_1.064103_g11006_i0 | PRJNA949785 | 11203 | 307 | 1.064103 | 3.26679621 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 89 | 4.69e-18 | NR | XP_065183874.1 | 27933 | g11006 | i0 | 53.7 | 0.801302931596091 | 82 | 35 | 80.1 | 1 | 306 | 61 | 14 | 92 | XP_065183874.1 GMP synthase [glutamine-hydrolyzing]-like [Sycon ciliatum] | diamond | 246 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27562430 | 27562430 | PRJNA949785_P_NODE_7344_length_398_cov_1.646154_g7147_i0 | PRJNA949785 | 7344 | 398 | 1.646154 | 6.55169292 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 73.2 | 6.18e-14 | NR | XP_003383057.1 | 400682 | g7147 | i0 | 71.7 | 0.693467336683417 | 46 | 13 | 34.7 | 0 | 396 | 259 | 52 | 97 | XP_003383057.1 PREDICTED: U6 snRNA-associated Sm-like protein LSm8 [Amphimedon queenslandica] | diamond | 276 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 27721016 | 27721016 | PRJNA949785_P_NODE_2724_length_716_cov_1.769829_g2548_i0 | PRJNA949785 | 2724 | 716 | 1.769829 | 12.67197564 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 138 | 1.03e-35 | NR | XP_065919226.1 | 196820 | g2548 | i0 | 37.8 | 1.37430167597765 | 180 | 100 | 75 | 2 | 716 | 180 | 2 | 170 | XP_065919226.1 zinc finger protein-like 1 homolog [Dysidea avara] | diamond | 984 | 138 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 28067817 | 28067817 | PRJNA949785_P_NODE_5765_length_463_cov_3.158974_g5568_i0 | PRJNA949785 | 5765 | 463 | 3.158974 | 14.62604962 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 82.4 | 4.47e-15 | NR | KAI6646679.1 | 111878 | g5568 | i0 | 31.9 | 0.751619870410367 | 116 | 79 | 75.2 | 0 | 446 | 99 | 110 | 225 | KAI6646679.1 Elongation factor 1-gamma [Oopsacas minuta] | diamond | 348 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 28295362 | 28295362 | PRJNA949785_P_NODE_4866_length_512_cov_3.107062_g4669_i0 | PRJNA949785 | 4866 | 512 | 3.107062 | 15.90815744 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 149 | 2.17e-41 | NR | XP_065843941.1 | 121494 | g4669 | i0 | 51.4 | 6.205078125 | 144 | 70 | 84.4 | 0 | 2 | 433 | 82 | 225 | XP_065843941.1 adenylate kinase 2, mitochondrial-like [Oscarella lobularis] | diamond | 3177 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 28667913 | 28667913 | PRJNA949785_P_NODE_17407_length_245_cov_1.790698_g17210_i0 | PRJNA949785 | 17407 | 245 | 1.790698 | 4.3872101 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 68.9 | 2.21e-11 | NR | XP_003390083.1 | 400682 | g17210 | i0 | 49.2 | 0.771428571428571 | 63 | 31 | 75.9 | 1 | 56 | 241 | 101 | 163 | XP_003390083.1 PREDICTED: tyrosyl-DNA phosphodiesterase 1-like [Amphimedon queenslandica] | diamond | 189 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 28857025 | 28857025 | PRJNA949785_P_NODE_2208_length_795_cov_4.324100_g2044_i0 | PRJNA949785 | 2208 | 795 | 4.3241 | 34.376595 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 160 | 1.05e-44 | NR | CAI7998431.1 | 519541 | g2044 | i0 | 43.6 | 0.735849056603774 | 195 | 108 | 73.2 | 2 | 716 | 135 | 10 | 203 | CAI7998431.1 Osteoclast-stimulating factor 1 [Geodia barretti] | diamond | 585 | 160 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 29551630 | 29551630 | PRJNA949785_P_NODE_3870_length_587_cov_2.712062_g3681_i0 | PRJNA949785 | 3870 | 587 | 2.712062 | 15.91980394 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 47 | 0.0235 | NR | XP_065191333.1 | 27933 | g3681 | i0 | 27.7 | 0.608177172061329 | 119 | 76 | 59.8 | 4 | 400 | 50 | 326 | 436 | XP_065191333.1 uncharacterized protein LOC135822487 [Sycon ciliatum] | diamond | 357 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 29835944 | 29835944 | PRJNA949785_P_NODE_5831_length_460_cov_1.976744_g5634_i0 | PRJNA949785 | 5831 | 460 | 1.976744 | 9.0930224 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 126 | 3.62e-33 | NR | XP_065830052.1 | 121494 | g5634 | i0 | 41.8 | 0.952173913043478 | 146 | 83 | 95.2 | 1 | 446 | 9 | 49 | 192 | XP_065830052.1 ras-related protein Rab-7a-like [Oscarella lobularis] | diamond | 438 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30063621 | 30063621 | PRJNA949785_P_NODE_7131_length_405_cov_1.159639_g6934_i0 | PRJNA949785 | 7131 | 405 | 1.159639 | 4.69653795 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 80.1 | 1.48e-14 | NR | XP_062510380.1 | 121492 | g6934 | i0 | 36.7 | 7.3037037037037 | 109 | 69 | 80.7 | 0 | 394 | 68 | 212 | 320 | XP_062510380.1 tRNA pseudouridine(38/39) synthase-like isoform X2 [Corticium candelabrum] | diamond | 2958 | 80.9 | 0.990111248454882 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 30221620 | 30221620 | PRJNA949785_P_NODE_1172_length_1090_cov_12.201573_g1056_i0 | PRJNA949785 | 1172 | 1090 | 12.201573 | 132.9971457 | Metazoa | 33208 | Porifera | other_Eukaryota | 178 | 2.87e-49 | NR | KAI6649628.1 | 111878 | g1056 | i0 | 34.5 | 5.22660550458716 | 316 | 196 | 85.9 | 7 | 37 | 972 | 5 | 313 | KAI6649628.1 Cathepsin L [Oopsacas minuta] | diamond | 5697 | 179 | 0.994413407821229 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 30246909 | 30246909 | PRJNA949785_P_NODE_12932_length_282_cov_1.086124_g12735_i0 | PRJNA949785 | 12932 | 282 | 1.086124 | 3.06286968 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 120 | 2.83e-29 | NR | XP_065886351.1 | 196820 | g12735 | i0 | 52.7 | 2.82978723404255 | 91 | 43 | 96.8 | 0 | 3 | 275 | 305 | 395 | XP_065886351.1 ATP-dependent DNA helicase Q5-like [Dysidea avara] | diamond | 798 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 31384465 | 31384465 | PRJNA949785_P_NODE_19216_length_238_cov_2.666667_g19019_i0 | PRJNA949785 | 19216 | 238 | 2.666667 | 6.34666746 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 44.3 | 0.0105 | NR | XP_011405506.1 | 400682 | g19019 | i0 | 37.5 | 1.13445378151261 | 48 | 30 | 60.5 | 0 | 56 | 199 | 1057 | 1104 | XP_011405506.1 PREDICTED: dedicator of cytokinesis protein 7 [Amphimedon queenslandica] | diamond | 270 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 31795308 | 31795308 | PRJNA949785_P_NODE_8177_length_371_cov_1.520134_g7980_i0 | PRJNA949785 | 8177 | 371 | 1.520134 | 5.63969714 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 107 | 6.73e-26 | NR | XP_064400232.1 | 6063 | g7980 | i0 | 50.5 | 1.69811320754717 | 103 | 51 | 83.3 | 0 | 371 | 63 | 7 | 109 | XP_064400232.1 rRNA-processing protein UTP23 homolog [Halichondria panicea] | diamond | 630 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 31801936 | 31801936 | PRJNA949785_P_NODE_1537_length_961_cov_4.819820_g1401_i0 | PRJNA949785 | 1537 | 961 | 4.81982 | 46.3184702 | Metazoa | 33208 | Porifera | other_Eukaryota | 154 | 2.84e-40 | NR | XP_065891123.1 | 196820 | g1401 | i0 | 36.8 | 3.82414151925078 | 277 | 145 | 79 | 7 | 24 | 782 | 16 | 286 | XP_065891123.1 stromal membrane-associated protein 1-like [Dysidea avara] | diamond | 3675 | 155 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 31922042 | 31922042 | PRJNA949785_P_NODE_10717_length_315_cov_1.590909_g10520_i0 | PRJNA949785 | 10717 | 315 | 1.590909 | 5.01136335 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 60.1 | 6.55e-8 | NR | XP_065174425.1 | 27933 | g10520 | i0 | 39.8 | 0.79047619047619 | 83 | 50 | 79 | 0 | 314 | 66 | 287 | 369 | XP_065174425.1 RNA polymerase II-associated factor 1 homolog [Sycon ciliatum] | diamond | 249 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 31922044 | 31922044 | PRJNA949785_P_NODE_11217_length_306_cov_3.300429_g11020_i0 | PRJNA949785 | 11217 | 306 | 3.300429 | 10.09931274 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 70.5 | 1.41e-11 | NR | KAI6647973.1 | 111878 | g11020 | i0 | 38.8 | 3.50980392156863 | 85 | 52 | 83.3 | 0 | 298 | 44 | 802 | 886 | KAI6647973.1 Procollagen-lysine,2-oxoglutarate 5-dioxygenase 3 [Oopsacas minuta] | diamond | 1074 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 32333713 | 32333713 | PRJNA949785_P_NODE_6659_length_422_cov_2.825215_g6462_i0 | PRJNA949785 | 6659 | 422 | 2.825215 | 11.9224073 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 47.8 | 6.04e-4 | NR | KAI6651473.1 | 111878 | g6462 | i0 | 35.5 | 0.540284360189573 | 76 | 44 | 50.5 | 1 | 389 | 177 | 21 | 96 | KAI6651473.1 hypothetical protein LOD99_5081 [Oopsacas minuta] | diamond | 228 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 32624369 | 32624369 | PRJNA949785_P_NODE_8080_length_374_cov_1.790698_g7883_i0 | PRJNA949785 | 8080 | 374 | 1.790698 | 6.69721052 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 112 | 1.01e-26 | NR | XP_065187956.1 | 27933 | g7883 | i0 | 46.5 | 17.2941176470588 | 114 | 61 | 91.4 | 0 | 19 | 360 | 40 | 153 | XP_065187956.1 N-acetylglucosamine-6-phosphate deacetylase-like [Sycon ciliatum] | diamond | 6468 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32680631 | 32680631 | PRJNA949785_P_NODE_6180_length_444_cov_3.318059_g5983_i0 | PRJNA949785 | 6180 | 444 | 3.318059 | 14.73218196 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 152 | 1.6e-42 | NR | XP_065191053.1 | 27933 | g5983 | i0 | 47.2 | 1.91891891891892 | 142 | 73 | 94.6 | 2 | 444 | 25 | 120 | 261 | XP_065191053.1 protein SCO1 homolog, mitochondrial-like [Sycon ciliatum] | diamond | 852 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32813359 | 32813359 | PRJNA949785_P_NODE_9440_length_339_cov_1.883459_g9243_i0 | PRJNA949785 | 9440 | 339 | 1.883459 | 6.38492601 | Metazoa | 33208 | Porifera | other_Eukaryota | 123 | 2.55e-30 | NR | XP_065840527.1 | 121494 | g9243 | i0 | 52.2 | 8.83185840707965 | 113 | 54 | 100 | 0 | 1 | 339 | 283 | 395 | XP_065840527.1 5'-nucleotidase domain-containing protein 3-like [Oscarella lobularis] | diamond | 2994 | 124 | 0.991935483870968 | 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);;