contig_metadata
25 rows where bioproject = "PRJNA758088", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 736235 | 736235 | PRJNA758088_P_NODE_248021_length_270_cov_1.172589_g241050_i0 | PRJNA758088 | 248021 | 270 | 1.172589 | 3.1659903 | Metazoa | 33208 | Porifera | other_Eukaryota | 136 | 1.0199999999999998e-37 | NR | XP_065836436.1 | 121494 | g241050 | i0 | 77.8 | 80.6555555555556 | 90 | 20 | 100 | 0 | 270 | 1 | 70 | 159 | XP_065836436.1 small ribosomal subunit protein eS6-like [Oscarella lobularis] | diamond | 21777 | 136 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 736394 | 736394 | PRJNA758088_P_NODE_258781_length_263_cov_1.621053_g251810_i0 | PRJNA758088 | 258781 | 263 | 1.621053 | 4.26336939 | Aiolochroia crassa | 261677 | Porifera | other_Eukaryota | 158 | 4.949999999999999e-34 | NTclustered | gi|512765256|gb|KC869494.1| | 261677 | g251810 | i0 | 89.516 | 47.3802281368821 | 124 | 13 | 47 | 0 | 136 | 259 | 1334 | 1211 | Aiolochroia crassa voucher P04 28S ribosomal RNA gene, partial sequence | blastn | 12461 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Verongiida | Aplysinidae | Aiolochroia | Aiolochroia crassa | |
| 2011698 | 2011698 | PRJNA758088_P_NODE_206982_length_296_cov_1.035874_g200011_i0 | PRJNA758088 | 206982 | 296 | 1.035874 | 3.06618704 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|2719018691|ref|XM_064543039.1| | 6063 | g200011 | i0 | 100 | 0.189189189189189 | 28 | 0 | 9 | 0 | 44 | 71 | 2086 | 2113 | PREDICTED: Halichondria panicea zinc finger protein 93-like (LOC135345617), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 13491786 | 13491786 | PRJNA758088_P_NODE_362611_length_241_cov_0.916667_g355640_i0 | PRJNA758088 | 362611 | 241 | 0.916667 | 2.20916747 | Metazoa | 33208 | Porifera | other_Eukaryota | 143 | 5.12e-39 | NR | XP_064405833.1 | 6063 | g355640 | i0 | 78.8 | 562.655601659751 | 80 | 17 | 99.6 | 0 | 2 | 241 | 118 | 197 | XP_064405833.1 casein kinase I-like isoform X2 [Halichondria panicea] | diamond | 135600 | 144 | 0.993055555555556 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 13957932 | 13957932 | PRJNA758088_P_NODE_3991_length_2416_cov_73.195476_g2931_i0 | PRJNA758088 | 3991 | 2416 | 73.195476 | 1768.40270016 | Mycale | 86015 | Porifera | other_Eukaryota | 176 | 1.42e-38 | NTclustered | gi|514227091|gb|KC961671.1| | 458504 | g2931 | i0 | 83.333 | 8.90604304635762 | 198 | 25 | 8 | 6 | 1477 | 1671 | 97 | 289 | Mycale laxissima voucher UERJ4 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 21517 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Poecilosclerida | Mycalidae | Mycale | Mycale laxissima | |
| 27053078 | 27053078 | PRJNA758088_P_NODE_311762_length_247_cov_1.327586_g304791_i0 | PRJNA758088 | 311762 | 247 | 1.327586 | 3.27913742 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 112 | 9.27e-29 | NR | XP_003383125.1 | 400682 | g304791 | i0 | 79.7 | 2.33198380566802 | 64 | 13 | 77.7 | 0 | 245 | 54 | 143 | 206 | XP_003383125.1 PREDICTED: proteasome subunit beta type-3-like [Amphimedon queenslandica] | diamond | 576 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 27115987 | 27115987 | PRJNA758088_P_NODE_331702_length_245_cov_0.895349_g324731_i0 | PRJNA758088 | 331702 | 245 | 0.895349 | 2.19360505 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 70.5 | 6.53e-12 | NR | XP_065194561.1 | 27933 | g324731 | i0 | 43.2 | 4.89795918367347 | 81 | 41 | 95.5 | 3 | 1 | 234 | 336 | 414 | XP_065194561.1 multiple C2 and transmembrane domain-containing protein 2-like isoform X4 [Sycon ciliatum] | diamond | 1200 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27505349 | 27505349 | PRJNA758088_P_NODE_337303_length_244_cov_0.900585_g330332_i0 | PRJNA758088 | 337303 | 244 | 0.900585 | 2.1974274 | Porifera | 6040 | Porifera | other_Eukaryota | 124 | 2.44e-31 | NR | XP_065183916.1 | 27933 | g330332 | i0 | 66.3 | 14.5696721311475 | 80 | 27 | 98.4 | 0 | 244 | 5 | 239 | 318 | XP_065183916.1 coronin-2B-like [Sycon ciliatum] | diamond | 3555 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27884014 | 27884014 | PRJNA758088_P_NODE_287065_length_250_cov_1.615819_g280094_i0 | PRJNA758088 | 287065 | 250 | 1.615819 | 4.0395475 | Demospongiae | 6042 | Porifera | other_Eukaryota | 98.6 | 4.66e-22 | NR | ABL85460.1 | 55567 | g280094 | i0 | 95.3 | 5.676 | 43 | 2 | 51.6 | 0 | 1 | 129 | 375 | 417 | ABL85460.1 actin related protein 3 [Suberites domuncula] | diamond | 1419 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites domuncula | |
| 28095274 | 28095274 | PRJNA758088_P_NODE_36385_length_774_cov_2.042796_g30230_i0 | PRJNA758088 | 36385 | 774 | 2.042796 | 15.81124104 | Lubomirskia baikalensis | 289074 | Porifera | other_Eukaryota | 215 | 7.28e-65 | NR | CAI91575.1 | 289074 | g30230 | i0 | 44.9 | 9.21705426356589 | 263 | 133 | 99.6 | 6 | 772 | 2 | 42 | 298 | CAI91575.1 cathepsin L2 [Lubomirskia baikalensis] | diamond | 7134 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Spongillida | Lubomirskiidae | Lubomirskia | Lubomirskia baikalensis | |
| 28663703 | 28663703 | PRJNA758088_P_NODE_333187_length_245_cov_0.895349_g326216_i0 | PRJNA758088 | 333187 | 245 | 0.895349 | 2.19360505 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 95.9 | 7.66e-21 | NR | XP_065895480.1 | 196820 | g326216 | i0 | 54.3 | 6.79591836734694 | 81 | 37 | 99.2 | 0 | 243 | 1 | 459 | 539 | XP_065895480.1 uncharacterized protein [Dysidea avara] | diamond | 1665 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29452649 | 29452649 | PRJNA758088_P_NODE_309690_length_248_cov_0.880000_g302719_i0 | PRJNA758088 | 309690 | 248 | 0.88 | 2.1824 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 51.6 | 3.11e-5 | NR | XP_065835133.1 | 121494 | g302719 | i0 | 44.3 | 0.846774193548387 | 70 | 39 | 84.7 | 0 | 9 | 218 | 3855 | 3924 | XP_065835133.1 uncharacterized protein [Oscarella lobularis] | diamond | 210 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 29515905 | 29515905 | PRJNA758088_P_NODE_154390_length_339_cov_2.210526_g147419_i0 | PRJNA758088 | 154390 | 339 | 2.210526 | 7.49368314 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 131 | 7.07e-36 | NR | XP_065178541.1 | 27933 | g147419 | i0 | 65 | 5.15929203539823 | 117 | 32 | 95.6 | 2 | 1 | 324 | 39 | 155 | XP_065178541.1 large ribosomal subunit protein eL13-like [Sycon ciliatum] | diamond | 1749 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 29547496 | 29547496 | PRJNA758088_P_NODE_291870_length_250_cov_0.870056_g284899_i0 | PRJNA758088 | 291870 | 250 | 0.870056 | 2.17514 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 50.4 | 1.46e-5 | NR | XP_065185148.1 | 27933 | g284899 | i0 | 75.9 | 0.684 | 29 | 7 | 34.8 | 0 | 2 | 88 | 86 | 114 | XP_065185148.1 probable small nuclear ribonucleoprotein Sm D2 [Sycon ciliatum] | diamond | 171 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 29683440 | 29683440 | PRJNA758088_P_NODE_277610_length_252_cov_1.536313_g270639_i0 | PRJNA758088 | 277610 | 252 | 1.536313 | 3.87150876 | Porifera | 6040 | Porifera | other_Eukaryota | 130 | 3.6e-34 | NR | XP_065182952.1 | 27933 | g270639 | i0 | 84.2 | 35 | 76 | 11 | 89.3 | 1 | 251 | 27 | 12 | 87 | XP_065182952.1 actin-related protein 2-B [Sycon ciliatum] | diamond | 8820 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30179258 | 30179258 | PRJNA758088_P_NODE_364712_length_241_cov_0.916667_g357741_i0 | PRJNA758088 | 364712 | 241 | 0.916667 | 2.20916747 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 51.2 | 3.67e-5 | NR | KAI6657771.1 | 111878 | g357741 | i0 | 64.5 | 0.385892116182573 | 31 | 11 | 38.6 | 0 | 149 | 241 | 74 | 104 | KAI6657771.1 Metallophosphoesterase domain-containing protein 1-like [Oopsacas minuta] | diamond | 93 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 30189074 | 30189074 | PRJNA758088_P_NODE_137892_length_358_cov_1.414035_g130921_i0 | PRJNA758088 | 137892 | 358 | 1.414035 | 5.0622453 | Demospongiae | 6042 | Porifera | other_Eukaryota | 109 | 7.2099999999999985e-28 | NR | XP_065920434.1 | 196820 | g130921 | i0 | 62.1 | 2.90782122905028 | 87 | 33 | 72.9 | 0 | 5 | 265 | 63 | 149 | XP_065920434.1 myosin-2 essential light chain-like [Dysidea avara] | diamond | 1041 | 110 | 0.990909090909091 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 30210718 | 30210718 | PRJNA758088_P_NODE_173532_length_322_cov_0.967871_g166561_i0 | PRJNA758088 | 173532 | 322 | 0.967871 | 3.11654462 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 147 | 1.26e-38 | NR | CAI8023617.1 | 519541 | g166561 | i0 | 61.7 | 2.99068322981366 | 107 | 41 | 99.7 | 0 | 1 | 321 | 151 | 257 | CAI8023617.1 Transposon Tf2-9 polyprotein, partial [Geodia barretti] | diamond | 963 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 30220646 | 30220646 | PRJNA758088_P_NODE_263792_length_260_cov_1.647059_g256821_i0 | PRJNA758088 | 263792 | 260 | 1.647059 | 4.2823534 | Metazoa | 33208 | Porifera | other_Eukaryota | 72.8 | 1.4e-13 | NR | XP_065896209.1 | 196820 | g256821 | i0 | 45.9 | 3.94615384615385 | 85 | 44 | 98.1 | 1 | 255 | 1 | 64 | 146 | XP_065896209.1 uncharacterized protein [Dysidea avara] | diamond | 1026 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 30590037 | 30590037 | PRJNA758088_P_NODE_37553_length_758_cov_3.489051_g31329_i0 | PRJNA758088 | 37553 | 758 | 3.489051 | 26.44700658 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 140 | 1.91e-37 | NR | CAI8030757.1 | 519541 | g31329 | i0 | 48.8 | 1.28232189973615 | 166 | 70 | 62.9 | 6 | 500 | 24 | 18 | 175 | CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] | diamond | 972 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 31064267 | 31064267 | PRJNA758088_P_NODE_245455_length_271_cov_1.595960_g238484_i0 | PRJNA758088 | 245455 | 271 | 1.59596 | 4.3250516 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 70.9 | 9.81e-13 | NR | XP_065831338.1 | 121494 | g238484 | i0 | 39.1 | 0.96309963099631 | 87 | 52 | 96.3 | 1 | 7 | 267 | 99 | 184 | XP_065831338.1 uncharacterized protein [Oscarella lobularis] | diamond | 261 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31769483 | 31769483 | PRJNA758088_P_NODE_145277_length_349_cov_1.619565_g138306_i0 | PRJNA758088 | 145277 | 349 | 1.619565 | 5.65228185 | Porifera | 6040 | Porifera | other_Eukaryota | 44.3 | 0.0261 | NR | XP_065198597.1 | 27933 | g138306 | i0 | 33 | 2.17478510028653 | 91 | 58 | 77.4 | 3 | 273 | 4 | 26 | 114 | XP_065198597.1 stAR-related lipid transfer protein 5-like [Sycon ciliatum] | diamond | 759 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 31917898 | 31917898 | PRJNA758088_P_NODE_167477_length_327_cov_1.212598_g160506_i0 | PRJNA758088 | 167477 | 327 | 1.212598 | 3.96519546 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 53.1 | 1.82e-5 | NR | KAI6651743.1 | 111878 | g160506 | i0 | 54.9 | 0.467889908256881 | 51 | 23 | 46.8 | 0 | 161 | 9 | 243 | 293 | KAI6651743.1 Leucine zipper transcription factor-like protein 1 [Oopsacas minuta] | diamond | 153 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 31927670 | 31927670 | PRJNA758088_P_NODE_169737_length_325_cov_1.222222_g162766_i0 | PRJNA758088 | 169737 | 325 | 1.222222 | 3.9722215 | Metazoa | 33208 | Porifera | other_Eukaryota | 104 | 1.87e-24 | NR | XP_062521299.1 | 121492 | g162766 | i0 | 53.2 | 6.83076923076923 | 94 | 44 | 86.8 | 0 | 2 | 283 | 225 | 318 | XP_062521299.1 annexin A7-like [Corticium candelabrum] | diamond | 2220 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 32297991 | 32297991 | PRJNA758088_P_NODE_329039_length_245_cov_0.895349_g322068_i0 | PRJNA758088 | 329039 | 245 | 0.895349 | 2.19360505 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 121 | 4.8399999999999994e-30 | NR | XP_065910166.1 | 196820 | g322068 | i0 | 76.3 | 0.979591836734694 | 80 | 19 | 98 | 0 | 2 | 241 | 405 | 484 | XP_065910166.1 T-complex protein 1 subunit beta-like [Dysidea avara] | diamond | 240 | 121 | 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);;