contig_metadata
15 rows where bioproject = "PRJNA1196384", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1043146 | 1043146 | PRJNA1196384_S_NODE_1781_length_293_cov_6.484375_g1717_i0 | PRJNA1196384 | 1781 | 293 | 6.484375 | 18.99921875 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 170 | 3.29e-52 | NR | XP_057312441.1 | 13093 | g1717 | i0 | 80.4 | 7.82252559726962 | 97 | 19 | 99.3 | 0 | 292 | 2 | 33 | 129 | XP_057312441.1 uncharacterized protein LOC130653961 [Hydractinia symbiolongicarpus] | diamond | 2292 | 170 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 2873435 | 2873435 | PRJNA1196384_S_NODE_1383_length_330_cov_3.027304_g1319_i0 | PRJNA1196384 | 1383 | 330 | 3.027304 | 9.9901032 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 108 | 4.1e-27 | NR | XP_028412222.1 | 151771 | g1319 | i0 | 65.9 | 2.18181818181818 | 85 | 29 | 77.3 | 0 | 324 | 70 | 116 | 200 | XP_028412222.1 60S ribosomal protein L13a-like [Dendronephthya gigantea] | diamond | 720 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 2873547 | 2873547 | PRJNA1196384_S_NODE_963_length_390_cov_4.988669_g899_i0 | PRJNA1196384 | 963 | 390 | 4.988669 | 19.4558091 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 134 | 5.43e-38 | NR | XP_068693858.1 | 591990 | g899 | i0 | 72.3 | 2.16923076923077 | 94 | 26 | 72.3 | 0 | 7 | 288 | 7 | 100 | XP_068693858.1 large ribosomal subunit protein eL36-like isoform X2 [Montipora foliosa] | diamond | 846 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 9250621 | 9250621 | PRJNA1196384_S_NODE_528_length_510_cov_3.961945_g466_i0 | PRJNA1196384 | 528 | 510 | 3.961945 | 20.2059195 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 253 | 1.5e-81 | NR | XP_001626294.2 | 45351 | g466 | i0 | 73.9 | 4.88823529411765 | 165 | 43 | 97.1 | 0 | 9 | 503 | 23 | 187 | XP_001626294.2 60S acidic ribosomal protein P0 [Nematostella vectensis] | diamond | 2493 | 253 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 9971272 | 9971272 | PRJNA1196384_S_NODE_388_length_591_cov_3.676895_g331_i0 | PRJNA1196384 | 388 | 591 | 3.676895 | 21.73044945 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 201 | 2.7399999999999998e-62 | NR | XP_068679419.1 | 591990 | g331 | i0 | 61.7 | 2.72081218274112 | 180 | 63 | 90.4 | 4 | 585 | 52 | 14 | 189 | XP_068679419.1 small ribosomal subunit protein eS7-like [Montipora foliosa] | diamond | 1608 | 201 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 18174312 | 18174312 | PRJNA1196384_S_NODE_4555_length_188_cov_2.291391_g4491_i0 | PRJNA1196384 | 4555 | 188 | 2.291391 | 4.30781508 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 99 | 1.9699999999999998e-23 | NR | PFX25614.1 | 50429 | g4491 | i0 | 78.7 | 3.90957446808511 | 61 | 13 | 97.3 | 0 | 3 | 185 | 197 | 257 | PFX25614.1 GTP-binding nuclear protein Ran [Stylophora pistillata] | diamond | 735 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 18174392 | 18174392 | PRJNA1196384_S_NODE_935_length_396_cov_4.119777_g871_i0 | PRJNA1196384 | 935 | 396 | 4.119777 | 16.31431692 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 129 | 7.67e-36 | NR | XP_031548864.1 | 6105 | g871 | i0 | 66.3 | 18.1439393939394 | 92 | 31 | 69.7 | 0 | 394 | 119 | 18 | 109 | XP_031548864.1 60S ribosomal protein L34-like [Actinia tenebrosa] | diamond | 7185 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 21445107 | 21445107 | PRJNA1196384_S_NODE_797_length_430_cov_5.048346_g733_i0 | PRJNA1196384 | 797 | 430 | 5.0483459999999996 | 21.7078878 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 164 | 2.24e-49 | NR | XP_020604647.1 | 48498 | g733 | i0 | 67.5 | 15.7255813953488 | 117 | 38 | 81.6 | 0 | 16 | 366 | 7 | 123 | XP_020604647.1 60S ribosomal protein L31-like isoform X2 [Orbicella faveolata] | diamond | 6762 | 164 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 25269359 | 25269359 | PRJNA1196384_S_NODE_4100_length_196_cov_1.792453_g4036_i0 | PRJNA1196384 | 4100 | 196 | 1.792453 | 3.51320788 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 128 | 2.74e-25 | NTclustered | gi|2088706012|gb|MW618869.1| | 264068 | g4036 | i0 | 78.947 | 27.5612244897959 | 190 | 38 | 96 | 2 | 7 | 195 | 164 | 352 | Pennaria disticha voucher KA160 histone 3 (H3) gene, partial cds | blastn | 5402 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Pennariidae | Pennaria | Pennaria disticha | |
| 27912480 | 27912480 | PRJNA1196384_S_NODE_785_length_433_cov_3.616162_g721_i0 | PRJNA1196384 | 785 | 433 | 3.616162 | 15.65798146 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 150 | 9.88e-44 | NR | XP_020604647.1 | 48498 | g721 | i0 | 68.6 | 6.03464203233256 | 105 | 33 | 72.7 | 0 | 375 | 61 | 18 | 122 | XP_020604647.1 60S ribosomal protein L31-like isoform X2 [Orbicella faveolata] | diamond | 2613 | 151 | 0.993377483443709 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 28051563 | 28051563 | PRJNA1196384_S_NODE_5785_length_172_cov_1.429630_g5721_i0 | PRJNA1196384 | 5785 | 172 | 1.42963 | 2.4589636 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 58.5 | 3.68e-8 | NR | KXJ15459.1 | 2652724 | g5721 | i0 | 50 | 0.976744186046512 | 56 | 26 | 97.7 | 1 | 3 | 170 | 612 | 665 | KXJ15459.1 1-phosphatidylinositol 4,5-bisphosphate phosphodiesterase delta-4 [Exaiptasia diaphana] | diamond | 168 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 29062089 | 29062089 | PRJNA1196384_S_NODE_3348_length_214_cov_1.152542_g3284_i0 | PRJNA1196384 | 3348 | 214 | 1.152542 | 2.46643988 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 43.9 | 0.00892 | NR | EDO49081.1 | 45351 | g3284 | i0 | 55.9 | 0.476635514018692 | 34 | 15 | 47.7 | 0 | 211 | 110 | 88 | 121 | EDO49081.1 predicted protein [Nematostella vectensis] | diamond | 102 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 30988840 | 30988840 | PRJNA1196384_S_NODE_3374_length_213_cov_3.028409_g3310_i0 | PRJNA1196384 | 3374 | 213 | 3.028409 | 6.45051117 | Acropora cervicornis | 6130 | Cnidaria | other_Eukaryota | 72.8 | 3.57e-13 | NR | KAK2554731.1 | 6130 | g3310 | i0 | 52.4 | 2.63380281690141 | 63 | 30 | 88.7 | 0 | 189 | 1 | 23 | 85 | KAK2554731.1 Cathepsin L [Acropora cervicornis] | diamond | 561 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 31052186 | 31052186 | PRJNA1196384_S_NODE_5875_length_171_cov_1.455224_g5811_i0 | PRJNA1196384 | 5875 | 171 | 1.455224 | 2.48843304 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 46.6 | 6.14e-4 | NR | CAB4011232.1 | 317549 | g5811 | i0 | 52.8 | 0.929824561403509 | 53 | 18 | 93 | 1 | 161 | 3 | 1069 | 1114 | CAB4011232.1 Hypothetical predicted protein, partial [Paramuricea clavata] | diamond | 159 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 32032378 | 32032378 | PRJNA1196384_S_NODE_298_length_649_cov_3.807190_g246_i0 | PRJNA1196384 | 298 | 649 | 3.80719 | 24.7086631 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 239 | 1.45e-75 | NR | XP_020917422.1 | 2652724 | g246 | i0 | 63 | 0.873651771956857 | 189 | 69 | 87.4 | 1 | 2 | 568 | 104 | 291 | XP_020917422.1 60S ribosomal protein L5 [Exaiptasia diaphana] | diamond | 567 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana |
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);;