contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA669701" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3187218 | 3187218 | PRJNA669701_P_NODE_85223_length_276_cov_1.123153_g84828_i0 | PRJNA669701 | 85223 | 276 | 1.123153 | 3.09990228 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 115 | 2.08e-31 | NR | XP_001640117.2 | 45351 | g84828 | i0 | 78.5 | 2.48913043478261 | 79 | 15 | 85.9 | 1 | 260 | 24 | 22 | 98 | XP_001640117.2 60S ribosomal protein L38 [Nematostella vectensis] | diamond | 687 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 4463710 | 4463710 | PRJNA669701_P_NODE_42024_length_366_cov_1.935154_g41629_i0 | PRJNA669701 | 42024 | 366 | 1.935154 | 7.08266364 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 150 | 6.779999999999998e-42 | NR | XP_057315388.1 | 13093 | g41629 | i0 | 84.1 | 1.4672131147541 | 88 | 14 | 72.1 | 0 | 265 | 2 | 201 | 288 | XP_057315388.1 uncharacterized protein LOC130656529 isoform X1 [Hydractinia symbiolongicarpus] | diamond | 537 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 13389428 | 13389428 | PRJNA669701_P_NODE_140151_length_241_cov_1.863095_g139756_i0 | PRJNA669701 | 140151 | 241 | 1.863095 | 4.49005895 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 140 | 2.93e-39 | NR | EDO25965.1 | 45351 | g139756 | i0 | 88.2 | 1.89211618257261 | 76 | 9 | 94.6 | 0 | 6 | 233 | 12 | 87 | EDO25965.1 predicted protein, partial [Nematostella vectensis] | diamond | 456 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 26796809 | 26796809 | PRJNA669701_P_NODE_114021_length_249_cov_0.937500_g113626_i0 | PRJNA669701 | 114021 | 249 | 0.9375 | 2.334375 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 72.4 | 1.4e-14 | NR | CAH3174559.1 | 104178 | g113626 | i0 | 54.4 | 0.686746987951807 | 57 | 26 | 68.7 | 0 | 172 | 2 | 3 | 59 | CAH3174559.1 unnamed protein product [Porites evermanni] | diamond | 171 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 27334634 | 27334634 | PRJNA669701_P_NODE_104303_length_254_cov_1.701657_g103908_i0 | PRJNA669701 | 104303 | 254 | 1.701657 | 4.32220878 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 77.4 | 2.54e-14 | NR | PFX23433.1 | 50429 | g103908 | i0 | 54.8 | 1.7244094488189 | 73 | 33 | 86.2 | 0 | 254 | 36 | 395 | 467 | PFX23433.1 5'-nucleotidase domain-containing protein 2 [Stylophora pistillata] | diamond | 438 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 28123929 | 28123929 | PRJNA669701_P_NODE_123105_length_246_cov_2.358382_g122710_i0 | PRJNA669701 | 123105 | 246 | 2.358382 | 5.80161972 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 68.2 | 4.37e-11 | NR | KAK3715056.1 | 3060491 | g122710 | i0 | 42.4 | 1.03658536585366 | 85 | 45 | 100 | 2 | 1 | 246 | 77 | 160 | KAK3715056.1 hypothetical protein QZH41_012116, partial [Actinostola sp. cb2023] | diamond | 255 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 28155642 | 28155642 | PRJNA669701_P_NODE_119925_length_247_cov_1.770115_g119530_i0 | PRJNA669701 | 119925 | 247 | 1.770115 | 4.37218405 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 57.4 | 1.16e-7 | NR | XP_032240830.1 | 45351 | g119530 | i0 | 42 | 0.983805668016194 | 81 | 36 | 85 | 4 | 237 | 28 | 111 | 191 | XP_032240830.1 signal peptidase complex subunit 2 [Nematostella vectensis] | diamond | 243 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 28597615 | 28597615 | PRJNA669701_P_NODE_113527_length_249_cov_1.738636_g113132_i0 | PRJNA669701 | 113527 | 249 | 1.738636 | 4.32920364 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 65.5 | 3.86e-10 | NR | XP_046852043.1 | 2897299 | g113132 | i0 | 49.3 | 3.4578313253012 | 75 | 27 | 90.4 | 2 | 3 | 227 | 510 | 573 | XP_046852043.1 protein DD3-3-like [Xenia sp. Carnegie-2017] | diamond | 861 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 28976528 | 28976528 | PRJNA669701_P_NODE_122308_length_247_cov_0.885057_g121913_i0 | PRJNA669701 | 122308 | 247 | 0.885057 | 2.18609079 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 95.9 | 7.75e-21 | NR | XP_057305856.1 | 13093 | g121913 | i0 | 67.6 | 1.7246963562753 | 71 | 22 | 86.2 | 1 | 1 | 213 | 558 | 627 | XP_057305856.1 sulfoacetaldehyde acetyltransferase-like [Hydractinia symbiolongicarpus] | diamond | 426 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 31389395 | 31389395 | PRJNA669701_P_NODE_103036_length_255_cov_3.087912_g102641_i0 | PRJNA669701 | 103036 | 255 | 3.087912 | 7.8741756 | root | 1 | Root_unresolved | Root_unresolved | 50.4 | 5.93e-5 | NR | KII61474.1 | 669202 | g102641 | i0 | 51.3 | 2.77647058823529 | 39 | 19 | 45.9 | 0 | 249 | 133 | 165 | 203 | KII61474.1 Elongation factor 1-beta' [Thelohanellus kitauei] | diamond | 708 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 31756732 | 31756732 | PRJNA669701_P_NODE_101617_length_257_cov_1.673913_g101222_i0 | PRJNA669701 | 101617 | 257 | 1.673913 | 4.30195641 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 58.9 | 8e-8 | NR | EDO37435.1 | 45351 | g101222 | i0 | 48.1 | 6.30350194552529 | 54 | 28 | 63 | 0 | 10 | 171 | 251 | 304 | EDO37435.1 predicted protein [Nematostella vectensis] | diamond | 1620 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 32009918 | 32009918 | PRJNA669701_P_NODE_141838_length_241_cov_0.916667_g141443_i0 | PRJNA669701 | 141838 | 241 | 0.916667 | 2.20916747 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 47.4 | 8.59e-4 | NR | XP_065056271.1 | 499914 | g141443 | i0 | 100 | 0.261410788381743 | 21 | 0 | 26.1 | 0 | 63 | 1 | 640 | 660 | XP_065056271.1 intraflagellar transport protein 81 homolog [Rhopilema esculentum] | diamond | 63 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 32484649 | 32484649 | PRJNA669701_P_NODE_87859_length_272_cov_4.517588_g87464_i0 | PRJNA669701 | 87859 | 272 | 4.517588 | 12.28783936 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 58.2 | 2.5e-8 | NR | XP_048584392.1 | 45351 | g87464 | i0 | 34.1 | 2.00735294117647 | 91 | 59 | 99.3 | 1 | 270 | 1 | 4 | 94 | XP_048584392.1 glutathione S-transferase Mu 3 [Nematostella vectensis] | diamond | 546 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis |
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);;