contig_metadata
19 rows where bioproject = "PRJNA384462", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 405326 | 405326 | PRJNA384462_S_NODE_15281_length_161_cov_1.267857_g15165_i0 | PRJNA384462 | 15281 | 161 | 1.267857 | 2.04124977 | Lubomirskia baikalensis | 289074 | Porifera | other_Eukaryota | 71.3 | 3.69e-8 | NTclustered | gi|84660245|emb|AJ872184.1| | 289074 | g15165 | i0 | 93.617 | 1.11180124223602 | 47 | 3 | 29 | 0 | 106 | 152 | 1028 | 982 | Lubomirskia baicalensis mRNA for cathepsin L (catl2 gene) | blastn | 179 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Spongillida | Lubomirskiidae | Lubomirskia | Lubomirskia baikalensis | |
| 13159076 | 13159076 | PRJNA384462_S_NODE_7731_length_202_cov_2.666667_g7615_i0 | PRJNA384462 | 7731 | 202 | 2.666667 | 5.38666734 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 176 | 1e-39 | NTclustered | gi|1133449879|ref|XM_003383054.3| | 400682 | g7615 | i0 | 84.324 | 8.58415841584158 | 185 | 23 | 90 | 6 | 15 | 196 | 366 | 185 | PREDICTED: Amphimedon queenslandica 40S ribosomal protein S14 (LOC100636138), mRNA | blastn | 1734 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 18256826 | 18256826 | PRJNA384462_S_NODE_1435_length_435_cov_3.106218_g1319_i0 | PRJNA384462 | 1435 | 435 | 3.106218 | 13.5120483 | root | 1 | Root_unresolved | Root_unresolved | 149 | 1.97e-41 | NR | XP_003382782.1 | 400682 | g1319 | i0 | 73.7 | 7.37931034482759 | 95 | 25 | 65.5 | 0 | 286 | 2 | 38 | 132 | XP_003382782.1 PREDICTED: 40S ribosomal protein S2 [Amphimedon queenslandica] | diamond | 3210 | 150 | 0.993333333333333 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 24631695 | 24631695 | PRJNA384462_S_NODE_1240_length_467_cov_1.854067_g1124_i0 | PRJNA384462 | 1240 | 467 | 1.854067 | 8.65849289 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 97.1 | 2.07e-15 | NTclustered | gi|2732903977|ref|XM_065339978.1| | 27933 | g1124 | i0 | 84.536 | 1.8865096359743 | 97 | 15 | 23 | 0 | 178 | 274 | 655 | 559 | PREDICTED: Sycon ciliatum uncharacterized LOC135827489 (LOC135827489), mRNA | blastn | 881 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 26617244 | 26617244 | PRJNA384462_S_NODE_6521_length_216_cov_0.904192_g6405_i0 | PRJNA384462 | 6521 | 216 | 0.904192 | 1.95305472 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 45.4 | 0.00311 | NR | XP_019854153.1 | 400682 | g6405 | i0 | 36.6 | 1.80555555555556 | 71 | 40 | 94.4 | 2 | 207 | 4 | 1888 | 1956 | XP_019854153.1 PREDICTED: E3 ubiquitin-protein ligase RNF213-like [Amphimedon queenslandica] | diamond | 390 | 45.8 | 0.991266375545852 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 26790452 | 26790452 | PRJNA384462_S_NODE_2801_length_310_cov_1.712644_g2685_i0 | PRJNA384462 | 2801 | 310 | 1.712644 | 5.3091964 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 139 | 4.19e-40 | NR | XP_065844091.1 | 121494 | g2685 | i0 | 68.8 | 2.68064516129032 | 93 | 29 | 90 | 0 | 1 | 279 | 20 | 112 | XP_065844091.1 large ribosomal subunit protein eL30-like [Oscarella lobularis] | diamond | 831 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 27597755 | 27597755 | PRJNA384462_S_NODE_1284_length_461_cov_1.589806_g1168_i0 | PRJNA384462 | 1284 | 461 | 1.589806 | 7.32900566 | root | 1 | Root_unresolved | Root_unresolved | 88.2 | 3.08e-17 | NR | XP_062504150.1 | 121492 | g1168 | i0 | 35.7 | 4.48373101952278 | 140 | 89 | 90.5 | 1 | 445 | 29 | 79 | 218 | XP_062504150.1 SH3 domain-containing YSC84-like protein 1 [Corticium candelabrum] | diamond | 2067 | 88.6 | 0.99548532731377 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27660871 | 27660871 | PRJNA384462_S_NODE_1344_length_451_cov_4.865672_g1228_i0 | PRJNA384462 | 1344 | 451 | 4.865672 | 21.94418072 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 113 | 9.879999999999999e-29 | NR | XP_064393387.1 | 6063 | g1228 | i0 | 48.5 | 11.1485587583149 | 132 | 66 | 87.8 | 1 | 441 | 46 | 6 | 135 | XP_064393387.1 uncharacterized protein LOC135340900 [Halichondria panicea] | diamond | 5028 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27755723 | 27755723 | PRJNA384462_S_NODE_6684_length_214_cov_1.236364_g6568_i0 | PRJNA384462 | 6684 | 214 | 1.236364 | 2.64581896 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 61.2 | 6.09e-9 | NR | XP_011408974.2 | 400682 | g6568 | i0 | 52.1 | 2.66355140186916 | 48 | 23 | 67.3 | 0 | 186 | 43 | 249 | 296 | XP_011408974.2 PREDICTED: probable cytosolic iron-sulfur protein assembly protein CIAO1 homolog [Amphimedon queenslandica] | diamond | 570 | 61.6 | 0.993506493506494 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 27896322 | 27896322 | PRJNA384462_S_NODE_5365_length_233_cov_1.385870_g5249_i0 | PRJNA384462 | 5365 | 233 | 1.38587 | 3.2290771 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 114 | 2.42e-29 | NR | XP_064383121.1 | 6063 | g5249 | i0 | 90.2 | 1.58369098712446 | 61 | 6 | 78.5 | 0 | 231 | 49 | 176 | 236 | XP_064383121.1 14-3-3-like protein 1 [Halichondria panicea] | diamond | 369 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28811741 | 28811741 | PRJNA384462_S_NODE_13348_length_166_cov_0.871795_g13232_i0 | PRJNA384462 | 13348 | 166 | 0.871795 | 1.4471797 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 58.5 | 3.49e-8 | NR | XP_064393833.1 | 6063 | g13232 | i0 | 44 | 2.71084337349398 | 50 | 23 | 90.4 | 1 | 150 | 1 | 339 | 383 | XP_064393833.1 uncharacterized protein LOC135341252 [Halichondria panicea] | diamond | 450 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 29208043 | 29208043 | PRJNA384462_S_NODE_15689_length_159_cov_2.454545_g15573_i0 | PRJNA384462 | 15689 | 159 | 2.454545 | 3.90272655 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 59.7 | 1.02e-8 | NR | XP_062522605.1 | 121492 | g15573 | i0 | 52.9 | 2.84905660377358 | 51 | 24 | 96.2 | 0 | 3 | 155 | 215 | 265 | XP_062522605.1 uncharacterized protein LOC134197326 [Corticium candelabrum] | diamond | 453 | 60.1 | 0.993344425956739 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 29302568 | 29302568 | PRJNA384462_S_NODE_10509_length_180_cov_1.557252_g10393_i0 | PRJNA384462 | 10509 | 180 | 1.557252 | 2.8030536 | Homosclerophorida | 81000 | Porifera | other_Eukaryota | 55.8 | 3.47e-7 | NR | XP_062514276.1 | 121492 | g10393 | i0 | 48.2 | 2.73333333333333 | 56 | 29 | 93.3 | 0 | 177 | 10 | 215 | 270 | XP_062514276.1 uncharacterized protein LOC134189897 isoform X2 [Corticium candelabrum] | diamond | 492 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 29491978 | 29491978 | PRJNA384462_S_NODE_3890_length_267_cov_2.536697_g3774_i0 | PRJNA384462 | 3890 | 267 | 2.536697 | 6.77298099 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.2 | 8.92e-7 | NR | XP_019851753.1 | 400682 | g3774 | i0 | 41.8 | 2.98876404494382 | 67 | 38 | 75.3 | 1 | 265 | 65 | 955 | 1020 | XP_019851753.1 PREDICTED: ABC transporter A family member 9-like [Amphimedon queenslandica] | diamond | 798 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 29822220 | 29822220 | PRJNA384462_S_NODE_12211_length_170_cov_1.619835_g12095_i0 | PRJNA384462 | 12211 | 170 | 1.619835 | 2.7537195 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 55.8 | 3.28e-7 | NR | XP_064400040.1 | 6063 | g12095 | i0 | 53.8 | 4.67647058823529 | 52 | 24 | 91.8 | 0 | 170 | 15 | 181 | 232 | XP_064400040.1 guanine nucleotide-binding protein-like 3 homolog [Halichondria panicea] | diamond | 795 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 30485964 | 30485964 | PRJNA384462_S_NODE_9553_length_187_cov_1.036232_g9437_i0 | PRJNA384462 | 9553 | 187 | 1.036232 | 1.93775384 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 44.7 | 0.00357 | NR | XP_003384332.2 | 400682 | g9437 | i0 | 47.7 | 0.705882352941177 | 44 | 21 | 67.4 | 1 | 15 | 140 | 149 | 192 | XP_003384332.2 PREDICTED: probable G-protein coupled receptor 157 [Amphimedon queenslandica] | diamond | 132 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 31845105 | 31845105 | PRJNA384462_S_NODE_597_length_637_cov_3.180272_g505_i0 | PRJNA384462 | 597 | 637 | 3.180272 | 20.25833264 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 52 | 7.61e-4 | NR | XP_019855983.1 | 400682 | g505 | i0 | 36.9 | 0.395604395604396 | 84 | 52 | 39.1 | 1 | 623 | 375 | 793 | 876 | XP_019855983.1 PREDICTED: uncharacterized protein LOC109584611 [Amphimedon queenslandica] | diamond | 252 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 31908473 | 31908473 | PRJNA384462_S_NODE_13417_length_166_cov_0.863248_g13301_i0 | PRJNA384462 | 13417 | 166 | 0.863248 | 1.43299168 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 61.6 | 4.99e-10 | NR | XP_019854112.1 | 400682 | g13301 | i0 | 54.5 | 0.993975903614458 | 55 | 25 | 99.4 | 0 | 2 | 166 | 76 | 130 | XP_019854112.1 PREDICTED: uncharacterized protein LOC109583283 [Amphimedon queenslandica] | diamond | 165 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 32242099 | 32242099 | PRJNA384462_S_NODE_5938_length_224_cov_0.977143_g5822_i0 | PRJNA384462 | 5938 | 224 | 0.977143 | 2.18880032 | Metazoa | 33208 | Porifera | other_Eukaryota | 83.6 | 1.21e-16 | NR | XP_065838139.1 | 121494 | g5822 | i0 | 56.7 | 1.60714285714286 | 60 | 26 | 80.4 | 0 | 224 | 45 | 565 | 624 | XP_065838139.1 uncharacterized protein [Oscarella lobularis] | diamond | 360 | 83.6 | 1 | 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);;