contig_metadata
16 rows where bioproject = "PRJNA1092581", tax_clade = "Opisthokonta" and tax_phylum = "Cnidaria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4846111 | 4846111 | PRJNA1092581_P_NODE_18944_length_639_cov_4.224382_g18427_i0 | PRJNA1092581 | 18944 | 639 | 4.224382 | 26.99380098 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 58.4 | 0.001 | NTclustered | gi|2917940744|emb|OZ237568.1| | 6108 | g18427 | i0 | 100 | 1.01408450704225 | 31 | 0 | 5 | 0 | 370 | 400 | 4588314 | 4588284 | Anemonia sulcata genome assembly, chromosome: 14 | blastn | 648 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 12949230 | 12949230 | PRJNA1092581_P_NODE_102191_length_250_cov_1.389831_g101658_i0 | PRJNA1092581 | 102191 | 250 | 1.389831 | 3.4745775 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2917940701|emb|OZ237558.1| | 6108 | g101658 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 152 | 179 | 6795959 | 6795986 | Anemonia sulcata genome assembly, chromosome: 4 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 16774433 | 16774433 | PRJNA1092581_P_NODE_58754_length_346_cov_7.633700_g58221_i0 | PRJNA1092581 | 58754 | 346 | 7.6337 | 26.412602 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 111 | 4.11e-27 | NR | CAB4035972.1 | 317549 | g58221 | i0 | 63.4 | 0.710982658959538 | 82 | 30 | 71.1 | 0 | 24 | 269 | 204 | 285 | CAB4035972.1 -L-isoaspartate(D-aspartate) O-methyltransferase [Paramuricea clavata] | diamond | 246 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 16775321 | 16775321 | PRJNA1092581_P_NODE_95354_length_260_cov_3.347594_g94821_i0 | PRJNA1092581 | 95354 | 260 | 3.347594 | 8.7037444 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 71.3 | 6.54e-8 | NTclustered | gi|1270070985|ref|XR_002695435.1| | 50429 | g94821 | i0 | 87.097 | 0.607692307692308 | 62 | 8 | 24 | 0 | 56 | 117 | 111 | 172 | PREDICTED: Stylophora pistillata uncharacterized LOC111336533 (LOC111336533), ncRNA | blastn | 158 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 18048708 | 18048708 | PRJNA1092581_P_NODE_46815_length_395_cov_2.829193_g46282_i0 | PRJNA1092581 | 46815 | 395 | 2.829193 | 11.17531235 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 166 | 4.88e-50 | NR | XP_044172593.1 | 45264 | g46282 | i0 | 73.6 | 8.43037974683544 | 106 | 28 | 80.5 | 0 | 337 | 20 | 40 | 145 | XP_044172593.1 60S ribosomal protein L44-like [Acropora millepora] | diamond | 3330 | 167 | 0.994011976047904 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 27636372 | 27636372 | PRJNA1092581_P_NODE_15744_length_697_cov_4.568910_g15248_i0 | PRJNA1092581 | 15744 | 697 | 4.56891 | 31.8453027 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 184 | 4.859999999999999e-54 | NR | XP_057289324.1 | 13093 | g15248 | i0 | 42.5 | 0.912482065997131 | 212 | 113 | 89.1 | 4 | 624 | 4 | 5 | 212 | XP_057289324.1 uncharacterized protein LOC130612052 [Hydractinia symbiolongicarpus] | diamond | 636 | 184 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 29499061 | 29499061 | PRJNA1092581_P_NODE_94630_length_261_cov_5.069149_g94097_i0 | PRJNA1092581 | 94630 | 261 | 5.069149 | 13.23047889 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 120 | 1.57e-29 | NR | XP_046851010.1 | 2897299 | g94097 | i0 | 65.4 | 2.79310344827586 | 81 | 25 | 89.7 | 1 | 254 | 21 | 1092 | 1172 | XP_046851010.1 glycogen debranching enzyme-like [Xenia sp. Carnegie-2017] | diamond | 729 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 30754090 | 30754090 | PRJNA1092581_P_NODE_104074_length_247_cov_5.149425_g103541_i0 | PRJNA1092581 | 104074 | 247 | 5.149425 | 12.71907975 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 47 | 0.00125 | NR | XP_029195905.2 | 45264 | g103541 | i0 | 33.3 | 1.15384615384615 | 54 | 36 | 65.6 | 0 | 9 | 170 | 639 | 692 | XP_029195905.2 uncharacterized protein K02A2.6-like [Acropora millepora] | diamond | 285 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 30754093 | 30754093 | PRJNA1092581_P_NODE_4854_length_1127_cov_3.967742_g4578_i0 | PRJNA1092581 | 4854 | 1127 | 3.967742 | 44.71645234 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 218 | 3.5200000000000002e-59 | NR | CAH3141875.1 | 104759 | g4578 | i0 | 44.2 | 6.72138420585626 | 260 | 129 | 65.5 | 5 | 356 | 1093 | 1217 | 1474 | CAH3141875.1 unnamed protein product [Porites lobata] | diamond | 7575 | 218 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 30912198 | 30912198 | PRJNA1092581_P_NODE_44414_length_407_cov_4.766467_g43881_i0 | PRJNA1092581 | 44414 | 407 | 4.766467 | 19.39952069 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 138 | 9.92e-39 | NR | XP_001637830.2 | 45351 | g43881 | i0 | 71.1 | 57.029484029484 | 90 | 25 | 65.6 | 1 | 31 | 297 | 79 | 168 | XP_001637830.2 40S ribosomal protein S15 [Nematostella vectensis] | diamond | 23211 | 139 | 0.992805755395683 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 31132920 | 31132920 | PRJNA1092581_P_NODE_30835_length_498_cov_6.569412_g30303_i0 | PRJNA1092581 | 30835 | 498 | 6.569412 | 32.71567176 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 169 | 1.59e-50 | NR | XP_020605211.1 | 48498 | g30303 | i0 | 63.6 | 8.75301204819277 | 132 | 48 | 79.5 | 0 | 50 | 445 | 24 | 155 | XP_020605211.1 60S ribosomal protein L32-like [Orbicella faveolata] | diamond | 4359 | 170 | 0.994117647058824 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 31481380 | 31481380 | PRJNA1092581_P_NODE_121416_length_217_cov_72.298611_g120883_i0 | PRJNA1092581 | 121416 | 217 | 72.298611 | 156.88798587 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 91.3 | 1.19e-19 | NR | XP_001627548.2 | 45351 | g120883 | i0 | 78.2 | 6.09677419354839 | 55 | 12 | 76 | 0 | 24 | 188 | 341 | 395 | XP_001627548.2 dihydroorotate dehydrogenase (quinone), mitochondrial [Nematostella vectensis] | diamond | 1323 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 31892230 | 31892230 | PRJNA1092581_P_NODE_21357_length_601_cov_11.373106_g20835_i0 | PRJNA1092581 | 21357 | 601 | 11.373106 | 68.35236706 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 166 | 4.36e-49 | NR | XP_068702776.1 | 591990 | g20835 | i0 | 65.7 | 12.0998336106489 | 134 | 45 | 66.9 | 1 | 538 | 137 | 1 | 133 | XP_068702776.1 large ribosomal subunit protein eL32-like [Montipora foliosa] | diamond | 7272 | 167 | 0.994011976047904 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 32018804 | 32018804 | PRJNA1092581_P_NODE_13878_length_739_cov_4.316817_g13391_i0 | PRJNA1092581 | 13878 | 739 | 4.316817 | 31.90127763 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 163 | 1.1099999999999999e-42 | NR | XP_048585615.1 | 45351 | g13391 | i0 | 53.6 | 3.69824086603518 | 140 | 62 | 56 | 2 | 739 | 326 | 310 | 448 | XP_048585615.1 guanine nucleotide-binding protein-like 3 homolog [Nematostella vectensis] | diamond | 2733 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 32525429 | 32525429 | PRJNA1092581_P_NODE_12399_length_777_cov_10.599432_g11930_i0 | PRJNA1092581 | 12399 | 777 | 10.599432 | 82.35758664 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 176 | 1.7199999999999998e-48 | NR | PFX18144.1 | 50429 | g11930 | i0 | 66.9 | 9.86872586872587 | 127 | 42 | 49 | 0 | 636 | 256 | 331 | 457 | PFX18144.1 60S ribosomal protein L23a [Stylophora pistillata] | diamond | 7668 | 177 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 32722833 | 32722833 | PRJNA1092581_P_NODE_70760_length_311_cov_2.214286_g70227_i0 | PRJNA1092581 | 70760 | 311 | 2.214286 | 6.88642946 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 44.3 | 0.0149 | NR | CAB4028271.1 | 317549 | g70227 | i0 | 57.1 | 0.810289389067524 | 42 | 18 | 40.5 | 0 | 311 | 186 | 148 | 189 | CAB4028271.1 60S ribosomal L26 [Paramuricea clavata] | diamond | 252 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata |
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);;