contig_metadata
26 rows where bioproject = "PRJNA1174234", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10519758 | 10519758 | PRJNA1174234_P_NODE_27209_length_261_cov_1.638298_g27013_i0 | PRJNA1174234 | 27209 | 261 | 1.638298 | 4.27595778 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 107 | 1.13e-24 | NR | XP_019848677.1 | 400682 | g27013 | i0 | 57.8 | 0.954022988505747 | 83 | 34 | 95.4 | 1 | 3 | 251 | 276 | 357 | XP_019848677.1 PREDICTED: probable alpha-glucosidase Os06g0675700 [Amphimedon queenslandica] | diamond | 249 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 19442048 | 19442048 | PRJNA1174234_P_NODE_10076_length_434_cov_5.443213_g9880_i0 | PRJNA1174234 | 10076 | 434 | 5.443213 | 23.62354442 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 168 | 4.2399999999999995e-45 | NR | XP_064404248.1 | 6063 | g9880 | i0 | 63.6 | 7.5 | 140 | 49 | 96.8 | 1 | 11 | 430 | 562 | 699 | XP_064404248.1 ATP-dependent translocase ABCB1-like [Halichondria panicea] | diamond | 3255 | 168 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 20717509 | 20717509 | PRJNA1174234_P_NODE_29557_length_250_cov_1.508475_g29361_i0 | PRJNA1174234 | 29557 | 250 | 1.508475 | 3.7711875 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 132 | 2.93e-37 | NR | XP_065197478.1 | 27933 | g29361 | i0 | 73.2 | 2.964 | 82 | 22 | 98.4 | 0 | 5 | 250 | 1 | 82 | XP_065197478.1 nucleoside diphosphate kinase B-like [Sycon ciliatum] | diamond | 741 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 21992674 | 21992674 | PRJNA1174234_P_NODE_15978_length_345_cov_3.441176_g15782_i0 | PRJNA1174234 | 15978 | 345 | 3.441176 | 11.8720572 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 168 | 1.34e-51 | NR | XP_065890751.1 | 196820 | g15782 | i0 | 76 | 1.8 | 104 | 23 | 90.4 | 1 | 343 | 32 | 7 | 108 | XP_065890751.1 peptidyl-prolyl cis-trans isomerase FKBP1A-like [Dysidea avara] | diamond | 621 | 168 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 26723524 | 26723524 | PRJNA1174234_P_NODE_33841_length_244_cov_0.900585_g33645_i0 | PRJNA1174234 | 33841 | 244 | 0.900585 | 2.1974274 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 97.8 | 1.16e-21 | NR | KAI6661109.1 | 111878 | g33645 | i0 | 53.7 | 3.99590163934426 | 82 | 37 | 99.6 | 1 | 2 | 244 | 164 | 245 | KAI6661109.1 Selenium-binding protein 1-like [Oopsacas minuta] | diamond | 975 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 27028106 | 27028106 | PRJNA1174234_P_NODE_29122_length_251_cov_0.865169_g28926_i0 | PRJNA1174234 | 29122 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.5 | 6.04e-10 | NR | XP_064391336.1 | 6063 | g28926 | i0 | 42.3 | 2.83266932270916 | 71 | 40 | 83.7 | 1 | 210 | 1 | 26 | 96 | XP_064391336.1 large ribosomal subunit protein uL24m-like [Halichondria panicea] | diamond | 711 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27230150 | 27230150 | PRJNA1174234_P_NODE_26683_length_265_cov_1.046875_g26487_i0 | PRJNA1174234 | 26683 | 265 | 1.046875 | 2.77421875 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 61.6 | 1.1e-8 | NR | XP_065187724.1 | 27933 | g26487 | i0 | 41.5 | 1.9811320754717 | 82 | 44 | 92.8 | 1 | 255 | 10 | 427 | 504 | XP_065187724.1 uncharacterized protein LOC135818299 [Sycon ciliatum] | diamond | 525 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27356776 | 27356776 | PRJNA1174234_P_NODE_1923_length_892_cov_24.887668_g1775_i0 | PRJNA1174234 | 1923 | 892 | 24.887668 | 221.99799856 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 148 | 3.5899999999999998e-40 | NR | CAI8030757.1 | 519541 | g1775 | i0 | 51.8 | 0.55829596412556 | 166 | 65 | 53.5 | 6 | 290 | 766 | 18 | 175 | CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] | diamond | 498 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 27388437 | 27388437 | PRJNA1174234_P_NODE_9943_length_437_cov_1.675824_g9747_i0 | PRJNA1174234 | 9943 | 437 | 1.675824 | 7.32335088 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 63.2 | 1.99e-8 | NR | XP_065885218.1 | 196820 | g9747 | i0 | 51.7 | 1.56521739130435 | 60 | 29 | 41.2 | 0 | 359 | 180 | 354 | 413 | XP_065885218.1 testis-expressed protein 9-like [Dysidea avara] | diamond | 684 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 28019893 | 28019893 | PRJNA1174234_P_NODE_27285_length_261_cov_1.228723_g27089_i0 | PRJNA1174234 | 27285 | 261 | 1.228723 | 3.20696703 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 80.5 | 2.08e-15 | NR | XP_011410571.1 | 400682 | g27089 | i0 | 46.2 | 4.11494252873563 | 78 | 42 | 89.7 | 0 | 235 | 2 | 343 | 420 | XP_011410571.1 PREDICTED: protein dcd1B-like [Amphimedon queenslandica] | diamond | 1074 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 28544291 | 28544291 | PRJNA1174234_P_NODE_15927_length_346_cov_1.369963_g15731_i0 | PRJNA1174234 | 15927 | 346 | 1.369963 | 4.74007198 | Homosclerophorida | 81000 | Porifera | other_Eukaryota | 75.5 | 1.34e-13 | NR | XP_062511047.1 | 121492 | g15731 | i0 | 48 | 1.29190751445087 | 75 | 35 | 62.4 | 2 | 3 | 218 | 118 | 191 | XP_062511047.1 uncharacterized protein LOC134186960 [Corticium candelabrum] | diamond | 447 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 28764997 | 28764997 | PRJNA1174234_P_NODE_10087_length_434_cov_1.686981_g9891_i0 | PRJNA1174234 | 10087 | 434 | 1.686981 | 7.32149754 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 103 | 4.02e-24 | NR | XP_065844070.1 | 121494 | g9891 | i0 | 37.8 | 5.68202764976959 | 135 | 84 | 93.3 | 0 | 433 | 29 | 7 | 141 | XP_065844070.1 mRNA turnover protein 4 homolog [Oscarella lobularis] | diamond | 2466 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 28808755 | 28808755 | PRJNA1174234_P_NODE_24568_length_278_cov_0.887805_g24372_i0 | PRJNA1174234 | 24568 | 278 | 0.887805 | 2.4680979 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 47.8 | 0.00101 | NR | XP_064398953.1 | 6063 | g24372 | i0 | 47.9 | 2.12589928057554 | 48 | 23 | 50.7 | 2 | 273 | 133 | 1 | 47 | XP_064398953.1 uncharacterized protein LOC135345460 [Halichondria panicea] | diamond | 591 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28808766 | 28808766 | PRJNA1174234_P_NODE_29428_length_251_cov_0.865169_g29232_i0 | PRJNA1174234 | 29428 | 251 | 0.865169 | 2.17157419 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 72.8 | 9.86e-14 | NR | XP_065830938.1 | 121494 | g29232 | i0 | 44.7 | 0.908366533864542 | 76 | 42 | 90.8 | 0 | 5 | 232 | 60 | 135 | XP_065830938.1 uncharacterized protein [Oscarella lobularis] | diamond | 228 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 29522848 | 29522848 | PRJNA1174234_P_NODE_15190_length_354_cov_1.096085_g14994_i0 | PRJNA1174234 | 15190 | 354 | 1.096085 | 3.8801409 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 124 | 5.739999999999999e-31 | NR | XP_065191401.1 | 27933 | g14994 | i0 | 57.5 | 3.96610169491525 | 120 | 48 | 100 | 2 | 354 | 1 | 263 | 381 | XP_065191401.1 adenylyl cyclase-associated protein 1-like [Sycon ciliatum] | diamond | 1404 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 29787692 | 29787692 | PRJNA1174234_P_NODE_25131_length_274_cov_1.373134_g24935_i0 | PRJNA1174234 | 25131 | 274 | 1.373134 | 3.76238716 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 106 | 3.13e-25 | NR | XP_064392077.1 | 6063 | g24935 | i0 | 54.9 | 0.996350364963504 | 91 | 40 | 99.6 | 1 | 274 | 2 | 223 | 312 | XP_064392077.1 serine dehydratase-like [Halichondria panicea] | diamond | 273 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 30009181 | 30009181 | PRJNA1174234_P_NODE_35211_length_242_cov_0.911243_g35015_i0 | PRJNA1174234 | 35211 | 242 | 0.911243 | 2.20520806 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 49.3 | 1.68e-4 | NR | XP_062512784.1 | 121492 | g35015 | i0 | 33.9 | 0.768595041322314 | 62 | 41 | 76.9 | 0 | 18 | 203 | 232 | 293 | XP_062512784.1 uncharacterized protein LOC134188598 [Corticium candelabrum] | diamond | 186 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 30293701 | 30293701 | PRJNA1174234_P_NODE_18892_length_317_cov_2.401639_g18696_i0 | PRJNA1174234 | 18892 | 317 | 2.401639 | 7.61319563 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 60.8 | 6.4e-9 | NR | XP_065914200.1 | 196820 | g18696 | i0 | 41.3 | 1.41955835962145 | 75 | 42 | 71 | 1 | 86 | 310 | 40 | 112 | XP_065914200.1 putative phosphatidylglycerol/phosphatidylinositol transfer protein DDB_G0278295 [Dysidea avara] | diamond | 450 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 30798717 | 30798717 | PRJNA1174234_P_NODE_15354_length_352_cov_1.573477_g15158_i0 | PRJNA1174234 | 15354 | 352 | 1.573477 | 5.53863904 | Suberites domuncula | 55567 | Porifera | other_Eukaryota | 162 | 4.979999999999999e-47 | NR | Q4KTI3.1 | 55567 | g15158 | i0 | 74.3 | 2.78693181818182 | 109 | 27 | 92.9 | 1 | 25 | 351 | 1 | 108 | Q4KTI3.1 RecName: Full=Large ribosomal subunit protein uL18; AltName: Full=60S ribosomal protein L5 [Suberites domuncula] | diamond | 981 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites domuncula | |
| 30849587 | 30849587 | PRJNA1174234_P_NODE_20934_length_302_cov_1.008734_g20738_i0 | PRJNA1174234 | 20934 | 302 | 1.008734 | 3.04637668 | Porifera | 6040 | Porifera | other_Eukaryota | 54.7 | 4.64e-6 | NR | XP_065177474.1 | 27933 | g20738 | i0 | 41.5 | 1.77814569536424 | 65 | 38 | 64.6 | 0 | 197 | 3 | 163 | 227 | XP_065177474.1 uncharacterized protein LOC135808238 [Sycon ciliatum] | diamond | 537 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30957045 | 30957045 | PRJNA1174234_P_NODE_6874_length_521_cov_0.977679_g6678_i0 | PRJNA1174234 | 6874 | 521 | 0.977679 | 5.09370759 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 109 | 1.13e-26 | NR | CAI8030757.1 | 519541 | g6678 | i0 | 50 | 0.760076775431862 | 132 | 50 | 71.4 | 7 | 373 | 2 | 27 | 150 | CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] | diamond | 396 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 31241082 | 31241082 | PRJNA1174234_P_NODE_22775_length_289_cov_1.069444_g22579_i0 | PRJNA1174234 | 22775 | 289 | 1.069444 | 3.09069316 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 154 | 1.5299999999999998e-42 | NR | XP_065190867.1 | 27933 | g22579 | i0 | 64.6 | 0.996539792387543 | 96 | 34 | 99.7 | 0 | 289 | 2 | 218 | 313 | XP_065190867.1 uncharacterized protein LOC135821796 [Sycon ciliatum] | diamond | 288 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 31936949 | 31936949 | PRJNA1174234_P_NODE_18937_length_317_cov_1.262295_g18741_i0 | PRJNA1174234 | 18937 | 317 | 1.262295 | 4.00147515 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 59.7 | 3.62e-8 | NR | XP_065831288.1 | 121494 | g18741 | i0 | 32.4 | 1.72239747634069 | 102 | 67 | 94.6 | 2 | 9 | 308 | 86 | 187 | XP_065831288.1 uncharacterized protein [Oscarella lobularis] | diamond | 546 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 32146194 | 32146194 | PRJNA1174234_P_NODE_22038_length_294_cov_1.352941_g21842_i0 | PRJNA1174234 | 22038 | 294 | 1.352941 | 3.97764654 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 87 | 1.28e-17 | NR | XP_065177867.1 | 27933 | g21842 | i0 | 42.7 | 5.59183673469388 | 89 | 48 | 90.8 | 1 | 271 | 5 | 131 | 216 | XP_065177867.1 uncharacterized protein LOC135808577 [Sycon ciliatum] | diamond | 1644 | 87.8 | 0.990888382687927 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32158740 | 32158740 | PRJNA1174234_P_NODE_29038_length_251_cov_0.949438_g28842_i0 | PRJNA1174234 | 29038 | 251 | 0.949438 | 2.38308938 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 96.7 | 4.4e-21 | NR | XP_065841066.1 | 121494 | g28842 | i0 | 51.9 | 0.968127490039841 | 81 | 39 | 96.8 | 0 | 250 | 8 | 338 | 418 | XP_065841066.1 circularly permutated Ras protein 1-like [Oscarella lobularis] | diamond | 243 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 32632633 | 32632633 | PRJNA1174234_P_NODE_18560_length_320_cov_1.465587_g18364_i0 | PRJNA1174234 | 18560 | 320 | 1.465587 | 4.6898784 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 109 | 7.58e-28 | NR | XP_065897850.1 | 196820 | g18364 | i0 | 46.2 | 0.99375 | 106 | 57 | 99.4 | 0 | 320 | 3 | 23 | 128 | XP_065897850.1 uncharacterized protein [Dysidea avara] | diamond | 318 | 109 | 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);;