contig_metadata
12 rows where bioproject = "PRJNA1105232", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6590673 | 6590673 | PRJNA1105232_S_NODE_2166_length_364_cov_10.774603_g1950_i0 | PRJNA1105232 | 2166 | 364 | 10.774603 | 39.21955492 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 209 | 2.23e-63 | NR | XP_003382634.1 | 400682 | g1950 | i0 | 81.5 | 5.86813186813187 | 119 | 22 | 98.1 | 0 | 359 | 3 | 309 | 427 | XP_003382634.1 PREDICTED: S-adenosylmethionine synthase 1-like [Amphimedon queenslandica] | diamond | 2136 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 26710499 | 26710499 | PRJNA1105232_S_NODE_16021_length_166_cov_1.957265_g15805_i0 | PRJNA1105232 | 16021 | 166 | 1.957265 | 3.2490599 | Metazoa | 33208 | Porifera | other_Eukaryota | 79.7 | 1.22e-15 | NR | XP_065840715.1 | 121494 | g15805 | i0 | 70.9 | 14.9096385542169 | 55 | 16 | 99.4 | 0 | 165 | 1 | 652 | 706 | XP_065840715.1 elongation factor G, mitochondrial-like [Oscarella lobularis] | diamond | 2475 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 27099250 | 27099250 | PRJNA1105232_S_NODE_1922_length_382_cov_2.090090_g1706_i0 | PRJNA1105232 | 1922 | 382 | 2.09009 | 7.9841438 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 169 | 6.91e-50 | NR | XP_065832477.1 | 121494 | g1706 | i0 | 58.3 | 0.99738219895288 | 127 | 53 | 99.7 | 0 | 382 | 2 | 94 | 220 | XP_065832477.1 proteasome subunit alpha type-3-like [Oscarella lobularis] | diamond | 381 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 27194010 | 27194010 | PRJNA1105232_S_NODE_5062_length_264_cov_1.790698_g4846_i0 | PRJNA1105232 | 5062 | 264 | 1.790698 | 4.72744272 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 56.2 | 8.55e-7 | NR | XP_064392517.1 | 6063 | g4846 | i0 | 36.6 | 0.931818181818182 | 82 | 47 | 93.2 | 2 | 256 | 11 | 842 | 918 | XP_064392517.1 AP-1 complex subunit beta-1-like [Halichondria panicea] | diamond | 246 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27478488 | 27478488 | PRJNA1105232_S_NODE_3743_length_297_cov_1.782258_g3527_i0 | PRJNA1105232 | 3743 | 297 | 1.782258 | 5.29330626 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 85.5 | 1.64e-17 | NR | XP_064382477.1 | 6063 | g3527 | i0 | 44.8 | 1.93939393939394 | 96 | 53 | 97 | 0 | 1 | 288 | 177 | 272 | XP_064382477.1 sideroflexin-5-like isoform X3 [Halichondria panicea] | diamond | 576 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27573225 | 27573225 | PRJNA1105232_S_NODE_10704_length_196_cov_2.047619_g10488_i0 | PRJNA1105232 | 10704 | 196 | 2.047619 | 4.01333324 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 62.4 | 2.36e-9 | NR | CAI8000772.1 | 519541 | g10488 | i0 | 52 | 1.62244897959184 | 50 | 24 | 76.5 | 0 | 37 | 186 | 478 | 527 | CAI8000772.1 Ubiquitin-like modifier-activating enzyme 1 [Geodia barretti] | diamond | 318 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 28899146 | 28899146 | PRJNA1105232_S_NODE_5108_length_263_cov_1.696262_g4892_i0 | PRJNA1105232 | 5108 | 263 | 1.696262 | 4.46116906 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 44.7 | 0.0101 | NR | XP_065835980.1 | 121494 | g4892 | i0 | 55.9 | 0.387832699619772 | 34 | 15 | 38.8 | 0 | 32 | 133 | 11 | 44 | XP_065835980.1 uncharacterized protein [Oscarella lobularis] | diamond | 102 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 29562257 | 29562257 | PRJNA1105232_S_NODE_3630_length_301_cov_3.416667_g3414_i0 | PRJNA1105232 | 3630 | 301 | 3.416667 | 10.28416767 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 103 | 3.179999999999999e-23 | NR | XP_011403505.2 | 400682 | g3414 | i0 | 50 | 4.96345514950166 | 100 | 48 | 99.7 | 2 | 301 | 2 | 267 | 364 | XP_011403505.2 PREDICTED: carboxypeptidase A4-like [Amphimedon queenslandica] | diamond | 1494 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 29625059 | 29625059 | PRJNA1105232_S_NODE_10750_length_196_cov_1.061224_g10534_i0 | PRJNA1105232 | 10750 | 196 | 1.061224 | 2.07999904 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 48.1 | 2.41e-4 | NR | XP_062510338.1 | 121492 | g10534 | i0 | 27 | 0.964285714285714 | 63 | 46 | 96.4 | 0 | 3 | 191 | 413 | 475 | XP_062510338.1 uncharacterized protein LOC134186389 [Corticium candelabrum] | diamond | 189 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 30952556 | 30952556 | PRJNA1105232_S_NODE_8394_length_216_cov_1.245509_g8178_i0 | PRJNA1105232 | 8394 | 216 | 1.245509 | 2.69029944 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 53.1 | 5.64e-6 | NR | XP_065832591.1 | 121494 | g8178 | i0 | 43.3 | 2.02777777777778 | 67 | 36 | 91.7 | 2 | 18 | 215 | 1187 | 1252 | XP_065832591.1 ral GTPase-activating protein subunit alpha-2-like [Oscarella lobularis] | diamond | 438 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31955440 | 31955440 | PRJNA1105232_S_NODE_14797_length_171_cov_1.278689_g14581_i0 | PRJNA1105232 | 14797 | 171 | 1.278689 | 2.18655819 | Metazoa | 33208 | Porifera | other_Eukaryota | 60.5 | 2.92e-9 | NR | XP_065186628.1 | 27933 | g14581 | i0 | 47.4 | 3.91228070175439 | 57 | 29 | 100 | 1 | 171 | 1 | 121 | 176 | XP_065186628.1 ras-related protein Rab-9A-like [Sycon ciliatum] | diamond | 669 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32840024 | 32840024 | PRJNA1105232_S_NODE_9640_length_205_cov_1.333333_g9424_i0 | PRJNA1105232 | 9640 | 205 | 1.333333 | 2.73333265 | Metazoa | 33208 | Porifera | other_Eukaryota | 65.5 | 2.15e-10 | NR | XP_064405097.1 | 6063 | g9424 | i0 | 53.1 | 5.66341463414634 | 64 | 29 | 92.2 | 1 | 203 | 15 | 1446 | 1509 | XP_064405097.1 sacsin-like [Halichondria panicea] | diamond | 1161 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea |
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);;