contig_metadata
12 rows where bioproject = "PRJNA934332", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3807451 | 3807451 | PRJNA934332_P_NODE_2223_length_415_cov_1.315789_g2136_i0 | PRJNA934332 | 2223 | 415 | 1.315789 | 5.46052435 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 241 | 4.75e-78 | NR | EDO25965.1 | 45351 | g2136 | i0 | 90.7 | 1.01204819277108 | 140 | 11 | 99.8 | 1 | 1 | 414 | 2 | 141 | EDO25965.1 predicted protein, partial [Nematostella vectensis] | diamond | 420 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 7288751 | 7288751 | PRJNA934332_P_NODE_5366_length_288_cov_1.432558_g5279_i0 | PRJNA934332 | 5366 | 288 | 1.432558 | 4.12576704 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 95.1 | 2.48e-20 | NR | XP_028419019.1 | 151771 | g5279 | i0 | 55.8 | 4.94791666666667 | 95 | 39 | 99 | 2 | 3 | 287 | 71 | 162 | XP_028419019.1 ABC transporter G family member 9-like [Dendronephthya gigantea] | diamond | 1425 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 9838585 | 9838585 | PRJNA934332_P_NODE_2888_length_372_cov_2.060201_g2801_i0 | PRJNA934332 | 2888 | 372 | 2.060201 | 7.66394772 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 117 | 2.6e-31 | NR | EDO33935.1 | 45351 | g2801 | i0 | 61.5 | 0.983870967741935 | 122 | 36 | 98.4 | 1 | 5 | 370 | 3 | 113 | EDO33935.1 predicted protein [Nematostella vectensis] | diamond | 366 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 12389760 | 12389760 | PRJNA934332_P_NODE_3190_length_357_cov_1.355634_g3103_i0 | PRJNA934332 | 3190 | 357 | 1.355634 | 4.83961338 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 176 | 6.33e-51 | NR | XP_028395166.1 | 151771 | g3103 | i0 | 73.2 | 12.2689075630252 | 112 | 30 | 94.1 | 0 | 14 | 349 | 1 | 112 | XP_028395166.1 60S ribosomal protein L3-like [Dendronephthya gigantea] | diamond | 4380 | 177 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 12389767 | 12389767 | PRJNA934332_P_NODE_4310_length_317_cov_0.946721_g4223_i0 | PRJNA934332 | 4310 | 317 | 0.946721 | 3.00110557 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2202608321|ref|XM_046984190.1| | 2897299 | g4223 | i0 | 96.875 | 0.100946372239748 | 32 | 1 | 10 | 0 | 176 | 207 | 1373 | 1404 | PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124434301 (LOC124434301), mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 15283342 | 15283342 | PRJNA934332_P_NODE_5372_length_288_cov_1.395349_g5285_i0 | PRJNA934332 | 5372 | 288 | 1.395349 | 4.01860512 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.4 | 5.73e-4 | NTclustered | gi|2917940693|emb|OZ237556.1| | 6108 | g5285 | i0 | 100 | 26.7152777777778 | 31 | 0 | 11 | 0 | 258 | 288 | 14210844 | 14210874 | Anemonia sulcata genome assembly, chromosome: 2 | blastn | 7694 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 22587596 | 22587596 | PRJNA934332_P_NODE_4938_length_298_cov_1.604444_g4851_i0 | PRJNA934332 | 4938 | 298 | 1.604444 | 4.78124312 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 87 | 1.91e-17 | NR | XP_032238636.1 | 45351 | g4851 | i0 | 48.5 | 8.78859060402685 | 97 | 45 | 97.7 | 2 | 293 | 3 | 39 | 130 | XP_032238636.1 ABC transporter G family member 21 [Nematostella vectensis] | diamond | 2619 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 24206984 | 24206984 | PRJNA934332_P_NODE_3099_length_361_cov_2.302083_g3012_i0 | PRJNA934332 | 3099 | 361 | 2.302083 | 8.31051963 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 175 | 3.67e-48 | NR | XP_015759296.1 | 70779 | g3012 | i0 | 73.3 | 9.6398891966759 | 116 | 30 | 96.4 | 1 | 12 | 359 | 1 | 115 | XP_015759296.1 PREDICTED: elongation factor 2-like [Acropora digitifera] | diamond | 3480 | 175 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 26771787 | 26771787 | PRJNA934332_P_NODE_4241_length_319_cov_1.252033_g4154_i0 | PRJNA934332 | 4241 | 319 | 1.252033 | 3.99398527 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 65.1 | 4e-10 | NR | XP_022784565.1 | 50429 | g4154 | i0 | 39.3 | 4.12852664576802 | 89 | 52 | 81.8 | 1 | 264 | 4 | 119 | 207 | XP_022784565.1 glutathione S-transferase Mu 3-like isoform X1 [Stylophora pistillata] | diamond | 1317 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 27499063 | 27499063 | PRJNA934332_P_NODE_4923_length_299_cov_1.022124_g4836_i0 | PRJNA934332 | 4923 | 299 | 1.022124 | 3.05615076 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 70.9 | 9.59e-12 | NR | XP_057307358.1 | 13093 | g4836 | i0 | 36.5 | 1.04347826086957 | 104 | 60 | 98.3 | 2 | 297 | 4 | 469 | 572 | XP_057307358.1 PC3-like endoprotease variant B [Hydractinia symbiolongicarpus] | diamond | 312 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 28888125 | 28888125 | PRJNA934332_P_NODE_10488_length_243_cov_0.905882_g10401_i0 | PRJNA934332 | 10488 | 243 | 0.905882 | 2.20129326 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 48.1 | 4.72e-4 | NR | XP_046839094.1 | 2897299 | g10401 | i0 | 44.4 | 0.555555555555556 | 45 | 25 | 55.6 | 0 | 235 | 101 | 1020 | 1064 | XP_046839094.1 LOW QUALITY PROTEIN: uncharacterized protein LOC124433378 [Xenia sp. Carnegie-2017] | diamond | 135 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 28888130 | 28888130 | PRJNA934332_P_NODE_7828_length_250_cov_1.305085_g7741_i0 | PRJNA934332 | 7828 | 250 | 1.305085 | 3.2627125 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 45.8 | 0.00334 | NR | ALG02156.1 | 499914 | g7741 | i0 | 34.9 | 1.992 | 83 | 53 | 98.4 | 1 | 250 | 5 | 148 | 230 | ALG02156.1 MAC/Perforin domain containing protein [Rhopilema esculentum] | diamond | 498 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum |
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);;