contig_metadata
21 rows where bioproject = "PRJNA681822", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 652993 | 652993 | PRJNA681822_P_NODE_21741_length_815_cov_4.628032_g20506_i0 | PRJNA681822 | 21741 | 815 | 4.628032 | 37.7184608 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 58.4 | 0.002 | NTclustered | gi|2812114944|ref|XM_068870257.1| | 246305 | g20506 | i0 | 97.059 | 0.0417177914110429 | 34 | 1 | 4 | 0 | 40 | 73 | 145 | 178 | PREDICTED: Montipora capricornis nucleolar transcription factor 1-A-like (LOC138023236), mRNA | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 9582568 | 9582568 | PRJNA681822_P_NODE_298028_length_275_cov_0.792079_g296539_i0 | PRJNA681822 | 298028 | 275 | 0.792079 | 2.17821725 | Malacalcyonacea | 3028843 | Cnidaria | other_Eukaryota | 163 | 2.02e-45 | NR | CAB4008863.1 | 317549 | g296539 | i0 | 89 | 11.9127272727273 | 91 | 10 | 99.3 | 0 | 274 | 2 | 299 | 389 | CAB4008863.1 inositol-3-phosphate synthase-like [Paramuricea clavata] | diamond | 3276 | 164 | 0.99390243902439 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 9584031 | 9584031 | PRJNA681822_P_NODE_422368_length_247_cov_0.885057_g420879_i0 | PRJNA681822 | 422368 | 247 | 0.885057 | 2.18609079 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 99 | 4.37e-22 | NR | XP_031550458.1 | 6105 | g420879 | i0 | 54.4 | 9.64372469635627 | 79 | 36 | 96 | 0 | 2 | 238 | 217 | 295 | XP_031550458.1 ornithine decarboxylase-like [Actinia tenebrosa] | diamond | 2382 | 100 | 0.99 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 11374516 | 11374516 | PRJNA681822_P_NODE_440249_length_245_cov_1.343023_g438760_i0 | PRJNA681822 | 440249 | 245 | 1.343023 | 3.29040635 | root | 1 | Root_unresolved | Root_unresolved | 145 | 4.359999999999999e-42 | NR | XP_057303614.1 | 13093 | g438760 | i0 | 84 | 59.4857142857143 | 81 | 13 | 99.2 | 0 | 3 | 245 | 57 | 137 | XP_057303614.1 60S ribosomal protein L11-like [Hydractinia symbiolongicarpus] | diamond | 14574 | 146 | 0.993150684931507 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 13410361 | 13410361 | PRJNA681822_P_NODE_494431_length_206_cov_5.015038_g492941_i0 | PRJNA681822 | 494431 | 206 | 5.015038 | 10.33097828 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|1778066149|ref|XM_031714699.1| | 6105 | g492941 | i0 | 100 | 0.140776699029126 | 29 | 0 | 14 | 0 | 108 | 136 | 2513 | 2541 | PREDICTED: Actinia tenebrosa uncharacterized LOC116304906 (LOC116304906), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 15955822 | 15955822 | PRJNA681822_P_NODE_215673_length_299_cov_1.703540_g214185_i0 | PRJNA681822 | 215673 | 299 | 1.70354 | 5.0935846 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 174 | 1.21e-53 | NR | XP_065051429.1 | 499914 | g214185 | i0 | 77.8 | 29.7993311036789 | 99 | 22 | 99.3 | 0 | 3 | 299 | 41 | 139 | XP_065051429.1 small ribosomal subunit protein uS17-like [Rhopilema esculentum] | diamond | 8910 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 15959694 | 15959694 | PRJNA681822_P_NODE_68193_length_455_cov_1.712042_g66719_i0 | PRJNA681822 | 68193 | 455 | 1.712042 | 7.7897911 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 305 | 3.07e-78 | NTclustered | gi|2812115753|ref|XM_068870713.1| | 246305 | g66719 | i0 | 80.542 | 35.2131868131868 | 406 | 71 | 88 | 8 | 5 | 406 | 1460 | 1861 | PREDICTED: Montipora capricornis transitional endoplasmic reticulum ATPase (LOC138023670), mRNA | blastn | 16022 | 305 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 17234051 | 17234051 | PRJNA681822_P_NODE_463214_length_243_cov_0.905882_g461724_i0 | PRJNA681822 | 463214 | 243 | 0.905882 | 2.20129326 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 62.1 | 3.64e-5 | NTclustered | gi|1603779642|ref|XR_003686383.1| | 151771 | g461724 | i0 | 100 | 0.135802469135802 | 33 | 0 | 14 | 0 | 43 | 75 | 74 | 106 | PREDICTED: Dendronephthya gigantea uncharacterized LOC114517436 (LOC114517436), ncRNA | blastn | 33 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 22329813 | 22329813 | PRJNA681822_P_NODE_171678_length_326_cov_1.217391_g170190_i0 | PRJNA681822 | 171678 | 326 | 1.217391 | 3.96869466 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 142 | 2.7e-41 | NR | EDO33935.1 | 45351 | g170190 | i0 | 76.9 | 0.993865030674847 | 108 | 25 | 99.4 | 0 | 326 | 3 | 7 | 114 | EDO33935.1 predicted protein [Nematostella vectensis] | diamond | 324 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 27113407 | 27113407 | PRJNA681822_P_NODE_126022_length_362_cov_1.550173_g124535_i0 | PRJNA681822 | 126022 | 362 | 1.550173 | 5.61162626 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 73.9 | 1.74e-12 | NR | XP_028513246.1 | 2652724 | g124535 | i0 | 38.5 | 2.9171270718232 | 117 | 69 | 97 | 1 | 11 | 361 | 974 | 1087 | XP_028513246.1 uncharacterized protein LOC110233539 [Exaiptasia diaphana] | diamond | 1056 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 27682575 | 27682575 | PRJNA681822_P_NODE_247544_length_287_cov_1.397196_g246055_i0 | PRJNA681822 | 247544 | 287 | 1.397196 | 4.00995252 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 51.2 | 6.51e-5 | NR | XP_065056710.1 | 499914 | g246055 | i0 | 33 | 1.01393728222997 | 97 | 62 | 99.3 | 2 | 2 | 286 | 198 | 293 | XP_065056710.1 regulatory factor X 4-like [Rhopilema esculentum] | diamond | 291 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 28503197 | 28503197 | PRJNA681822_P_NODE_431907_length_246_cov_0.890173_g430418_i0 | PRJNA681822 | 431907 | 246 | 0.890173 | 2.18982558 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 88.2 | 1.8e-18 | NR | XP_068746076.1 | 246305 | g430418 | i0 | 63.9 | 0.74390243902439 | 61 | 22 | 74.4 | 0 | 51 | 233 | 64 | 124 | XP_068746076.1 4-hydroxy-2-oxoglutarate aldolase, mitochondrial-like [Montipora capricornis] | diamond | 183 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 29324015 | 29324015 | PRJNA681822_P_NODE_397969_length_250_cov_0.870056_g396480_i0 | PRJNA681822 | 397969 | 250 | 0.870056 | 2.17514 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 72 | 2.01e-12 | NR | XP_028399577.1 | 151771 | g396480 | i0 | 66 | 2.352 | 50 | 17 | 60 | 0 | 151 | 2 | 5 | 54 | XP_028399577.1 kinesin-II 95 kDa subunit-like [Dendronephthya gigantea] | diamond | 588 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 29525408 | 29525408 | PRJNA681822_P_NODE_404790_length_249_cov_0.875000_g403301_i0 | PRJNA681822 | 404790 | 249 | 0.875 | 2.17875 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 137 | 4.72e-37 | NR | XP_031564938.1 | 6105 | g403301 | i0 | 72 | 7.90361445783132 | 82 | 23 | 98.8 | 0 | 2 | 247 | 49 | 130 | XP_031564938.1 gelsolin-like protein 1 isoform X2 [Actinia tenebrosa] | diamond | 1968 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 29765984 | 29765984 | PRJNA681822_P_NODE_318551_length_269_cov_1.571429_g317062_i0 | PRJNA681822 | 318551 | 269 | 1.571429 | 4.22714401 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 57.8 | 2.43e-7 | NR | CAB3997860.1 | 317549 | g317062 | i0 | 40.6 | 1.55018587360595 | 69 | 38 | 77 | 1 | 263 | 57 | 25 | 90 | CAB3997860.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 417 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 30030654 | 30030654 | PRJNA681822_P_NODE_444911_length_245_cov_0.895349_g443422_i0 | PRJNA681822 | 444911 | 245 | 0.895349 | 2.19360505 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 54.3 | 3.2e-6 | NR | XP_027057116.1 | 46731 | g443422 | i0 | 32.4 | 2.71836734693878 | 74 | 50 | 90.6 | 0 | 21 | 242 | 517 | 590 | XP_027057116.1 exocyst complex component 5-like [Pocillopora damicornis] | diamond | 666 | 54.7 | 0.992687385740402 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 30725591 | 30725591 | PRJNA681822_P_NODE_240254_length_289_cov_1.106481_g238765_i0 | PRJNA681822 | 240254 | 289 | 1.106481 | 3.19773009 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 111 | 3.71e-26 | NR | XP_029196374.1 | 45264 | g238765 | i0 | 56.1 | 5.04498269896194 | 98 | 40 | 98.6 | 1 | 3 | 287 | 541 | 638 | XP_029196374.1 crooked neck-like protein 1 [Acropora millepora] | diamond | 1458 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 31504289 | 31504289 | PRJNA681822_P_NODE_316236_length_270_cov_1.248731_g314747_i0 | PRJNA681822 | 316236 | 270 | 1.248731 | 3.3715737 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 85.5 | 1.06e-18 | NR | XP_057292340.1 | 13093 | g314747 | i0 | 53.2 | 8.11111111111111 | 79 | 32 | 87.8 | 2 | 241 | 5 | 76 | 149 | XP_057292340.1 S-phase kinase-associated protein 1 [Hydractinia symbiolongicarpus] | diamond | 2190 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 31990277 | 31990277 | PRJNA681822_P_NODE_454658_length_244_cov_0.900585_g453168_i0 | PRJNA681822 | 454658 | 244 | 0.900585 | 2.1974274 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 63.5 | 1.76e-9 | NR | XP_044183319.1 | 45264 | g453168 | i0 | 45.2 | 7.05737704918033 | 73 | 39 | 89.8 | 1 | 26 | 244 | 21 | 92 | XP_044183319.1 uncharacterized protein LOC122963992 [Acropora millepora] | diamond | 1722 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 32073565 | 32073565 | PRJNA681822_P_NODE_394178_length_250_cov_0.870056_g392689_i0 | PRJNA681822 | 394178 | 250 | 0.870056 | 2.17514 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 73.6 | 2.76e-13 | NR | XP_066916511.1 | 252671 | g392689 | i0 | 68.7 | 2.412 | 67 | 20 | 80.4 | 1 | 250 | 50 | 106 | 171 | XP_066916511.1 protein MAK16 homolog [Clytia hemisphaerica] | diamond | 603 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 32465126 | 32465126 | PRJNA681822_P_NODE_390179_length_250_cov_1.740113_g388690_i0 | PRJNA681822 | 390179 | 250 | 1.740113 | 4.3502825 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 113 | 2.81e-27 | NR | XP_031549422.1 | 6105 | g388690 | i0 | 65.4 | 44.856 | 78 | 27 | 93.6 | 0 | 3 | 236 | 27 | 104 | XP_031549422.1 cleavage stimulation factor subunit 2-like [Actinia tenebrosa] | diamond | 11214 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa |
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);;