contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA384462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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);;