contig_metadata
20 rows where bioproject = "PRJNA930380" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20036092 | 20036092 | PRJNA930380_P_NODE_6556_length_289_cov_1.231481_g6503_i0 | PRJNA930380 | 6556 | 289 | 1.231481 | 3.55898009 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|2729079958|ref|XM_065202401.1| | 499914 | g6503 | i0 | 100 | 0.0968858131487889 | 28 | 0 | 10 | 0 | 244 | 271 | 181 | 208 | PREDICTED: Rhopilema esculentum uncharacterized LOC135686213 (LOC135686213), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 23861775 | 23861775 | PRJNA930380_P_NODE_6399_length_289_cov_3.004630_g6346_i0 | PRJNA930380 | 6399 | 289 | 3.00463 | 8.6833807 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2729079958|ref|XM_065202401.1| | 499914 | g6346 | i0 | 100 | 0.685121107266436 | 30 | 0 | 10 | 0 | 240 | 269 | 179 | 208 | PREDICTED: Rhopilema esculentum uncharacterized LOC135686213 (LOC135686213), mRNA | blastn | 198 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 26898483 | 26898483 | PRJNA930380_P_NODE_6781_length_288_cov_1.232558_g6728_i0 | PRJNA930380 | 6781 | 288 | 1.232558 | 3.54976704 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 59.3 | 8.12e-8 | NR | XP_022791754.1 | 50429 | g6728 | i0 | 49.1 | 1.17708333333333 | 55 | 28 | 57.3 | 0 | 251 | 87 | 259 | 313 | XP_022791754.1 uncharacterized protein LOC111330998 [Stylophora pistillata] | diamond | 339 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 27119493 | 27119493 | PRJNA930380_P_NODE_5982_length_291_cov_2.119266_g5929_i0 | PRJNA930380 | 5982 | 291 | 2.119266 | 6.16706406 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 59.7 | 1.92e-8 | NR | CAB4028506.1 | 317549 | g5929 | i0 | 45.5 | 6.36082474226804 | 66 | 36 | 68 | 0 | 258 | 61 | 7 | 72 | CAB4028506.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 1851 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 27561840 | 27561840 | PRJNA930380_P_NODE_10144_length_270_cov_0.903553_g10091_i0 | PRJNA930380 | 10144 | 270 | 0.903553 | 2.4395931 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 49.3 | 2.59e-4 | NR | XP_068689719.1 | 591990 | g10091 | i0 | 53.8 | 0.433333333333333 | 39 | 18 | 43.3 | 0 | 226 | 110 | 1327 | 1365 | XP_068689719.1 LOW QUALITY PROTEIN: sortilin-related receptor-like, partial [Montipora foliosa] | diamond | 117 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 27814906 | 27814906 | PRJNA930380_P_NODE_6724_length_288_cov_1.432558_g6671_i0 | PRJNA930380 | 6724 | 288 | 1.432558 | 4.12576704 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 64.3 | 1.65e-9 | NR | XP_066935157.1 | 252671 | g6671 | i0 | 50.8 | 2.45833333333333 | 59 | 29 | 61.5 | 0 | 288 | 112 | 317 | 375 | XP_066935157.1 uncharacterized protein [Clytia hemisphaerica] | diamond | 708 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 28074223 | 28074223 | PRJNA930380_P_NODE_6325_length_290_cov_1.221198_g6272_i0 | PRJNA930380 | 6325 | 290 | 1.221198 | 3.5414742 | Acropora | 6127 | Cnidaria | other_Eukaryota | 53.9 | 7.37e-6 | NR | KAK2552037.1 | 6130 | g6272 | i0 | 46.2 | 2.18275862068965 | 52 | 28 | 53.8 | 0 | 185 | 30 | 109 | 160 | KAK2552037.1 hypothetical protein P5673_027059 [Acropora cervicornis] | diamond | 633 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 28326748 | 28326748 | PRJNA930380_P_NODE_6426_length_289_cov_2.222222_g6373_i0 | PRJNA930380 | 6426 | 289 | 2.222222 | 6.42222158 | Montipora | 46703 | Cnidaria | other_Eukaryota | 60.8 | 2.55e-8 | NR | XP_068742301.1 | 246305 | g6373 | i0 | 35.3 | 8.01384083044983 | 85 | 53 | 86.2 | 1 | 266 | 18 | 74 | 158 | XP_068742301.1 uncharacterized protein [Montipora capricornis] | diamond | 2316 | 61.2 | 0.993464052287582 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 28446293 | 28446293 | PRJNA930380_P_NODE_6066_length_291_cov_1.412844_g6013_i0 | PRJNA930380 | 6066 | 291 | 1.412844 | 4.11137604 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 45.1 | 0.0105 | NR | KXJ11877.1 | 2652724 | g6013 | i0 | 34.2 | 0.752577319587629 | 73 | 48 | 75.3 | 0 | 70 | 288 | 747 | 819 | KXJ11877.1 Papilin [Exaiptasia diaphana] | diamond | 219 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 28477770 | 28477770 | PRJNA930380_P_NODE_9046_length_277_cov_1.308824_g8993_i0 | PRJNA930380 | 9046 | 277 | 1.308824 | 3.62544248 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 55.5 | 1.84e-6 | NR | XP_068738393.1 | 246305 | g8993 | i0 | 41.7 | 0.51985559566787 | 48 | 28 | 52 | 0 | 237 | 94 | 16 | 63 | XP_068738393.1 uncharacterized protein [Montipora capricornis] | diamond | 144 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 29204129 | 29204129 | PRJNA930380_P_NODE_9769_length_272_cov_1.939698_g9716_i0 | PRJNA930380 | 9769 | 272 | 1.939698 | 5.27597856 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 43.9 | 0.0214 | NR | XP_068689719.1 | 591990 | g9716 | i0 | 46.2 | 0.430147058823529 | 39 | 21 | 43 | 0 | 226 | 110 | 1327 | 1365 | XP_068689719.1 LOW QUALITY PROTEIN: sortilin-related receptor-like, partial [Montipora foliosa] | diamond | 117 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 29456187 | 29456187 | PRJNA930380_P_NODE_4530_length_307_cov_1.897436_g4477_i0 | PRJNA930380 | 4530 | 307 | 1.897436 | 5.82512852 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 60.8 | 1.81e-8 | NR | XP_068707553.1 | 591990 | g4477 | i0 | 48.4 | 1.19218241042345 | 62 | 32 | 60.6 | 0 | 219 | 34 | 177 | 238 | XP_068707553.1 uncharacterized protein [Montipora foliosa] | diamond | 366 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 30158148 | 30158148 | PRJNA930380_P_NODE_6032_length_291_cov_1.527523_g5979_i0 | PRJNA930380 | 6032 | 291 | 1.527523 | 4.44509193 | Acropora | 6127 | Cnidaria | other_Eukaryota | 50.1 | 1.71e-4 | NR | XP_044171962.1 | 45264 | g5979 | i0 | 44.1 | 1.31958762886598 | 68 | 31 | 68 | 2 | 290 | 93 | 290 | 352 | XP_044171962.1 uncharacterized protein LOC122956337 [Acropora millepora] | diamond | 384 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 30530388 | 30530388 | PRJNA930380_P_NODE_6413_length_289_cov_2.657407_g6360_i0 | PRJNA930380 | 6413 | 289 | 2.657407 | 7.67990623 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 51.2 | 6.18e-5 | NR | XP_068707387.1 | 591990 | g6360 | i0 | 55 | 2.42906574394464 | 40 | 18 | 41.5 | 0 | 49 | 168 | 277 | 316 | XP_068707387.1 uncharacterized protein [Montipora foliosa] | diamond | 702 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 30593562 | 30593562 | PRJNA930380_P_NODE_6253_length_290_cov_1.419355_g6200_i0 | PRJNA930380 | 6253 | 290 | 1.419355 | 4.1161295 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 80.1 | 4.95e-15 | NR | CAB3995148.1 | 317549 | g6200 | i0 | 53.8 | 0.806896551724138 | 78 | 36 | 80.7 | 0 | 4 | 237 | 751 | 828 | CAB3995148.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 234 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 30783237 | 30783237 | PRJNA930380_P_NODE_8014_length_282_cov_2.200957_g7961_i0 | PRJNA930380 | 8014 | 282 | 2.200957 | 6.20669874 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 43.5 | 0.0306 | NR | XP_068692404.1 | 591990 | g7961 | i0 | 27.4 | 0.893617021276596 | 84 | 59 | 87.2 | 1 | 33 | 278 | 260 | 343 | XP_068692404.1 uncharacterized protein [Montipora foliosa] | diamond | 252 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 31067789 | 31067789 | PRJNA930380_P_NODE_5455_length_294_cov_1.484163_g5402_i0 | PRJNA930380 | 5455 | 294 | 1.484163 | 4.36343922 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 106 | 2.41e-25 | NR | CAH3025309.1 | 104178 | g5402 | i0 | 52.6 | 1.97959183673469 | 97 | 44 | 99 | 1 | 3 | 293 | 24 | 118 | CAH3025309.1 unnamed protein product [Porites evermanni] | diamond | 582 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 31193608 | 31193608 | PRJNA930380_P_NODE_7595_length_284_cov_1.966825_g7542_i0 | PRJNA930380 | 7595 | 284 | 1.966825 | 5.585783 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 47.8 | 8.62e-4 | NR | CAB4038205.1 | 317549 | g7542 | i0 | 46 | 0.528169014084507 | 50 | 27 | 52.8 | 0 | 121 | 270 | 187 | 236 | CAB4038205.1 Transposable element Tcb2 transposase, partial [Paramuricea clavata] | diamond | 150 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 31636721 | 31636721 | PRJNA930380_P_NODE_9336_length_275_cov_1.519802_g9283_i0 | PRJNA930380 | 9336 | 275 | 1.519802 | 4.1794555 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 53.1 | 1.88e-6 | NR | CAB3979633.1 | 317549 | g9283 | i0 | 42.1 | 0.621818181818182 | 57 | 33 | 62.2 | 0 | 48 | 218 | 3 | 59 | CAB3979633.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 171 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 32743401 | 32743401 | PRJNA930380_P_NODE_6820_length_288_cov_1.037209_g6767_i0 | PRJNA930380 | 6820 | 288 | 1.037209 | 2.98716192 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 74.7 | 3.7e-13 | NR | KAK3749033.1 | 3060491 | g6767 | i0 | 51.4 | 2.22916666666667 | 70 | 33 | 71.9 | 1 | 77 | 283 | 773 | 842 | KAK3749033.1 hypothetical protein QZH41_006227 [Actinostola sp. cb2023] | diamond | 642 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 |
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);;