contig_metadata
21 rows where bioproject = "PRJNA675331", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3198710 | 3198710 | PRJNA675331_P_NODE_6403_length_381_cov_1.000000_g6231_i0 | PRJNA675331 | 6403 | 381 | 1 | 3.81 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 71.3 | 1e-7 | NTclustered | gi|1270073771|ref|XM_022944138.1| | 50429 | g6231 | i0 | 86.154 | 1.68766404199475 | 65 | 9 | 17 | 0 | 128 | 192 | 1043 | 979 | PREDICTED: Stylophora pistillata luc7-like protein 3 (LOC111337776), mRNA | blastn | 643 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 8301138 | 8301138 | PRJNA675331_P_NODE_6587_length_377_cov_1.013158_g6415_i0 | PRJNA675331 | 6587 | 377 | 1.013158 | 3.81960566 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 196 | 6.0999999999999996e-58 | NR | RMX60943.1 | 46731 | g6415 | i0 | 75.4 | 41.5464190981432 | 122 | 30 | 97.1 | 0 | 12 | 377 | 42 | 163 | RMX60943.1 hypothetical protein pdam_00003459, partial [Pocillopora damicornis] | diamond | 15663 | 197 | 0.99492385786802 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 10097213 | 10097213 | PRJNA675331_P_NODE_5728_length_401_cov_1.378049_g5556_i0 | PRJNA675331 | 5728 | 401 | 1.378049 | 5.52597649 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 291 | 7.48e-74 | NTclustered | gi|1778029874|ref|XM_031696318.1| | 6105 | g5556 | i0 | 82.216 | 85.3615960099751 | 343 | 56 | 85 | 3 | 7 | 347 | 377 | 38 | PREDICTED: Actinia tenebrosa histone H2A-like (LOC116289406), mRNA | blastn | 34230 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 14676799 | 14676799 | PRJNA675331_P_NODE_13192_length_281_cov_1.850962_g13020_i0 | PRJNA675331 | 13192 | 281 | 1.850962 | 5.20120322 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 237 | 6.66e-58 | NTclustered | gi|1619665138|ref|XM_021050033.2| | 2652724 | g13020 | i0 | 83.142 | 54.3807829181495 | 261 | 42 | 93 | 2 | 1 | 260 | 178 | 437 | PREDICTED: Exaiptasia diaphana serine/threonine-protein phosphatase PP1-beta catalytic subunit (LOC110243880), mRNA | blastn | 15281 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 18500068 | 18500068 | PRJNA675331_P_NODE_6275_length_384_cov_2.257235_g6103_i0 | PRJNA675331 | 6275 | 384 | 2.257235 | 8.6677824 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 127 | 4.82e-35 | NR | XP_015753000.1 | 70779 | g6103 | i0 | 58.1 | 4.8046875 | 124 | 42 | 95.3 | 3 | 17 | 382 | 4 | 119 | XP_015753000.1 PREDICTED: 60S ribosomal protein L31-like [Acropora digitifera] | diamond | 1845 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 26701908 | 26701908 | PRJNA675331_P_NODE_9761_length_318_cov_0.942857_g9589_i0 | PRJNA675331 | 9761 | 318 | 0.942857 | 2.99828526 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 54.7 | 5.51e-6 | NR | XP_020912230.1 | 2652724 | g9589 | i0 | 25.9 | 1.54716981132075 | 85 | 63 | 80.2 | 0 | 40 | 294 | 221 | 305 | XP_020912230.1 coadhesin [Exaiptasia diaphana] | diamond | 492 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 27461275 | 27461275 | PRJNA675331_P_NODE_23043_length_243_cov_0.905882_g22871_i0 | PRJNA675331 | 23043 | 243 | 0.905882 | 2.20129326 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 49.7 | 1.26e-4 | NR | XP_065654017.1 | 6087 | g22871 | i0 | 46.8 | 1.53086419753086 | 62 | 31 | 74.1 | 1 | 182 | 3 | 41 | 102 | XP_065654017.1 V-type proton ATPase subunit C isoform X2 [Hydra vulgaris] | diamond | 372 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 27504725 | 27504725 | PRJNA675331_P_NODE_7343_length_359_cov_1.073427_g7171_i0 | PRJNA675331 | 7343 | 359 | 1.073427 | 3.85360293 | root | 1 | Root_unresolved | Root_unresolved | 91.7 | 1e-18 | NR | XP_066923084.1 | 252671 | g7171 | i0 | 41.1 | 2.87465181058496 | 112 | 63 | 93.6 | 2 | 3 | 338 | 540 | 648 | XP_066923084.1 uncharacterized protein [Clytia hemisphaerica] | diamond | 1032 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 27567553 | 27567553 | PRJNA675331_P_NODE_13224_length_281_cov_1.451923_g13052_i0 | PRJNA675331 | 13224 | 281 | 1.451923 | 4.07990363 | Montipora | 46703 | Cnidaria | other_Eukaryota | 67.8 | 9.09e-11 | NR | XP_068717865.1 | 246305 | g13052 | i0 | 41.2 | 4.53736654804271 | 85 | 49 | 90.7 | 1 | 279 | 25 | 296 | 379 | XP_068717865.1 E3 ubiquitin-protein ligase TRIM71-like isoform X2 [Montipora capricornis] | diamond | 1275 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 27587545 | 27587545 | PRJNA675331_P_NODE_5824_length_398_cov_1.480000_g5652_i0 | PRJNA675331 | 5824 | 398 | 1.48 | 5.8904 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 46.6 | 0.00967 | NR | CAH3173173.1 | 104759 | g5652 | i0 | 34.8 | 0.693467336683417 | 92 | 54 | 69.3 | 2 | 377 | 102 | 987 | 1072 | CAH3173173.1 unnamed protein product [Porites lobata] | diamond | 276 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 27777054 | 27777054 | PRJNA675331_P_NODE_18404_length_251_cov_0.865169_g18232_i0 | PRJNA675331 | 18404 | 251 | 0.865169 | 2.17157419 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 76.6 | 3.09e-14 | NR | XP_066927219.1 | 252671 | g18232 | i0 | 55.8 | 1.91235059760956 | 52 | 23 | 62.2 | 0 | 249 | 94 | 244 | 295 | XP_066927219.1 S-adenosylmethionine decarboxylase proenzyme 2-like [Clytia hemisphaerica] | diamond | 480 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 27808678 | 27808678 | PRJNA675331_P_NODE_17184_length_256_cov_1.683060_g17012_i0 | PRJNA675331 | 17184 | 256 | 1.68306 | 4.3086336 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 58.2 | 1.62e-7 | NR | XP_015778011.1 | 70779 | g17012 | i0 | 62.5 | 0.46875 | 40 | 15 | 46.9 | 0 | 253 | 134 | 28 | 67 | XP_015778011.1 PREDICTED: fibrillin-1-like [Acropora digitifera] | diamond | 120 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 27820412 | 27820412 | PRJNA675331_P_NODE_18864_length_250_cov_0.870056_g18692_i0 | PRJNA675331 | 18864 | 250 | 0.870056 | 2.17514 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 102 | 3.35e-26 | NR | XP_065682608.1 | 6087 | g18692 | i0 | 60 | 12.264 | 70 | 28 | 84 | 0 | 248 | 39 | 42 | 111 | XP_065682608.1 protein kish-B-like [Hydra vulgaris] | diamond | 3066 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29355685 | 29355685 | PRJNA675331_P_NODE_18749_length_250_cov_0.870056_g18577_i0 | PRJNA675331 | 18749 | 250 | 0.870056 | 2.17514 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 66.6 | 1.54e-10 | NR | KAF0989196.1 | 69463 | g18577 | i0 | 48.6 | 0.888 | 74 | 33 | 86.4 | 2 | 249 | 34 | 287 | 357 | KAF0989196.1 hypothetical protein HZS_4042, partial [Henneguya salminicola] | diamond | 222 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 30429853 | 30429853 | PRJNA675331_P_NODE_20653_length_247_cov_0.885057_g20481_i0 | PRJNA675331 | 20653 | 247 | 0.885057 | 2.18609079 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 59.3 | 5.57e-8 | NR | XP_028394124.1 | 151771 | g20481 | i0 | 44.7 | 0.923076923076923 | 76 | 37 | 92.3 | 2 | 245 | 18 | 780 | 850 | XP_028394124.1 coatomer subunit beta'-like [Dendronephthya gigantea] | diamond | 228 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 30536034 | 30536034 | PRJNA675331_P_NODE_22593_length_243_cov_1.347059_g22421_i0 | PRJNA675331 | 22593 | 243 | 1.347059 | 3.27335337 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 48.1 | 4.94e-4 | NR | XP_031560649.1 | 6105 | g22421 | i0 | 37.7 | 3.30864197530864 | 77 | 38 | 92.6 | 4 | 231 | 7 | 41 | 109 | XP_031560649.1 uncharacterized protein LOC116296723 [Actinia tenebrosa] | diamond | 804 | 48.5 | 0.991752577319588 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 30694024 | 30694024 | PRJNA675331_P_NODE_14313_length_275_cov_1.143564_g14141_i0 | PRJNA675331 | 14313 | 275 | 1.143564 | 3.144801 | root | 1 | Root_unresolved | Root_unresolved | 120 | 3.5400000000000003e-29 | NR | XP_031565803.1 | 6105 | g14141 | i0 | 61.5 | 24.5890909090909 | 91 | 35 | 99.3 | 0 | 2 | 274 | 83 | 173 | XP_031565803.1 pyruvate dehydrogenase phosphatase regulatory subunit, mitochondrial-like isoform X2 [Actinia tenebrosa] | diamond | 6762 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 30871764 | 30871764 | PRJNA675331_P_NODE_4474_length_448_cov_1.933333_g4302_i0 | PRJNA675331 | 4474 | 448 | 1.933333 | 8.66133184 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 90.9 | 4.98e-18 | NR | XP_048578655.1 | 45351 | g4302 | i0 | 43.4 | 5.015625 | 83 | 47 | 55.6 | 0 | 136 | 384 | 151 | 233 | XP_048578655.1 prosaposin isoform X2 [Nematostella vectensis] | diamond | 2247 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 31061640 | 31061640 | PRJNA675331_P_NODE_22755_length_243_cov_0.905882_g22583_i0 | PRJNA675331 | 22755 | 243 | 0.905882 | 2.20129326 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 80.1 | 2.36e-15 | NR | XP_065658167.1 | 6087 | g22583 | i0 | 63 | 2.83950617283951 | 54 | 20 | 66.7 | 0 | 241 | 80 | 207 | 260 | XP_065658167.1 uncharacterized protein LOC136082677 [Hydra vulgaris] | diamond | 690 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 31946695 | 31946695 | PRJNA675331_P_NODE_11277_length_300_cov_1.017621_g11105_i0 | PRJNA675331 | 11277 | 300 | 1.017621 | 3.052863 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 104 | 9.809999999999999e-24 | NR | CAB4026009.1 | 317549 | g11105 | i0 | 52 | 1.02 | 102 | 44 | 97 | 2 | 5 | 295 | 224 | 325 | CAB4026009.1 copine-3-like isoform X1, partial [Paramuricea clavata] | diamond | 306 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 32010203 | 32010203 | PRJNA675331_P_NODE_4698_length_439_cov_1.262295_g4526_i0 | PRJNA675331 | 4698 | 439 | 1.262295 | 5.54147505 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 233 | 1.9e-75 | NR | KAF0989435.1 | 69463 | g4526 | i0 | 79.7 | 14.9111617312073 | 133 | 27 | 90.9 | 0 | 404 | 6 | 3 | 135 | KAF0989435.1 hypothetical protein HZS_3178 [Henneguya salminicola] | diamond | 6546 | 233 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola |
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);;