contig_metadata
22 rows where bioproject = "PRJNA833575", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 824548 | 824548 | PRJNA833575_P_NODE_43201_length_230_cov_0.894410_g43064_i0 | PRJNA833575 | 43201 | 230 | 0.89441 | 2.057143 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 176 | 1.17e-39 | NTclustered | gi|2744799589|ref|XM_004205495.4| | 6087 | g43064 | i0 | 80.519 | 92.8695652173913 | 231 | 43 | 100 | 2 | 1 | 230 | 882 | 653 | PREDICTED: Hydra vulgaris polyubiquitin-B (LOC100203041), mRNA | blastn | 21360 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 5927589 | 5927589 | PRJNA833575_P_NODE_38985_length_234_cov_1.418182_g38848_i0 | PRJNA833575 | 38985 | 234 | 1.418182 | 3.31854588 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 178 | 3.31e-40 | NTclustered | gi|2729078822|ref|XM_065201785.1| | 499914 | g38848 | i0 | 80.426 | 78.4230769230769 | 235 | 44 | 100 | 2 | 1 | 234 | 832 | 599 | PREDICTED: Rhopilema esculentum polyubiquitin-C (LOC135685733), mRNA | blastn | 18351 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 21630845 | 21630845 | PRJNA833575_P_NODE_24857_length_298_cov_1.689956_g24720_i0 | PRJNA833575 | 24857 | 298 | 1.689956 | 5.03606888 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 156 | 2.05e-33 | NTclustered | gi|1524901147|ref|XM_027203078.1| | 46731 | g24720 | i0 | 79.464 | 5.85234899328859 | 224 | 42 | 74 | 4 | 26 | 247 | 365 | 144 | PREDICTED: Pocillopora damicornis ADP-ribosylation factor 4 (LOC113685554), mRNA | blastn | 1744 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 23776490 | 23776490 | PRJNA833575_P_NODE_13959_length_390_cov_1.834891_g13822_i0 | PRJNA833575 | 13959 | 390 | 1.834891 | 7.1560749 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 208 | 6.75e-67 | NR | XP_028395263.1 | 151771 | g13822 | i0 | 82.5 | 10.1538461538462 | 120 | 21 | 92.3 | 0 | 3 | 362 | 10 | 129 | XP_028395263.1 40S ribosomal protein S15a [Dendronephthya gigantea] | diamond | 3960 | 210 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 24180494 | 24180494 | PRJNA833575_P_NODE_26839_length_287_cov_1.665138_g26702_i0 | PRJNA833575 | 26839 | 287 | 1.665138 | 4.77894606 | root | 1 | Root_unresolved | Root_unresolved | 133 | 5.59e-34 | NR | XP_031573255.1 | 6105 | g26702 | i0 | 61.7 | 7.86062717770035 | 94 | 36 | 98.3 | 0 | 6 | 287 | 422 | 515 | XP_031573255.1 uncharacterized protein LOC116307235 [Actinia tenebrosa] | diamond | 2256 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 26651385 | 26651385 | PRJNA833575_P_NODE_31641_length_264_cov_1.261538_g31504_i0 | PRJNA833575 | 31641 | 264 | 1.261538 | 3.33046032 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 68.9 | 2.84e-11 | NR | XP_029213715.2 | 45264 | g31504 | i0 | 43.8 | 7.45454545454545 | 80 | 44 | 90.9 | 1 | 6 | 245 | 167 | 245 | XP_029213715.2 long-chain fatty acid transport protein 4-like [Acropora millepora] | diamond | 1968 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 26778429 | 26778429 | PRJNA833575_P_NODE_41501_length_232_cov_0.883436_g41364_i0 | PRJNA833575 | 41501 | 232 | 0.883436 | 2.04957152 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 122 | 2.21e-30 | NR | XP_028403290.1 | 151771 | g41364 | i0 | 67.5 | 12.698275862069 | 77 | 25 | 99.6 | 0 | 2 | 232 | 454 | 530 | XP_028403290.1 T-complex protein 1 subunit eta-like [Dendronephthya gigantea] | diamond | 2946 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 27054708 | 27054708 | PRJNA833575_P_NODE_20242_length_328_cov_1.444015_g20105_i0 | PRJNA833575 | 20242 | 328 | 1.444015 | 4.7363692 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 110 | 6.199999999999998e-29 | NR | XP_065654277.1 | 6087 | g20105 | i0 | 83.3 | 0.98780487804878 | 54 | 9 | 49.4 | 0 | 279 | 118 | 47 | 100 | XP_065654277.1 uncharacterized protein LOC136080866 [Hydra vulgaris] | diamond | 324 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 27244235 | 27244235 | PRJNA833575_P_NODE_39323_length_234_cov_0.872727_g39186_i0 | PRJNA833575 | 39323 | 234 | 0.872727 | 2.04218118 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 73.6 | 4.6e-13 | NR | KAK3752187.1 | 3060491 | g39186 | i0 | 47.6 | 3.20512820512821 | 82 | 36 | 98.7 | 3 | 3 | 233 | 1119 | 1198 | KAK3752187.1 hypothetical protein QZH41_007018 [Actinostola sp. cb2023] | diamond | 750 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 27623502 | 27623502 | PRJNA833575_P_NODE_28244_length_280_cov_1.355450_g28107_i0 | PRJNA833575 | 28244 | 280 | 1.35545 | 3.79526 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 98.2 | 7.899999999999999e-24 | NR | KAF1740838.1 | 59785 | g28107 | i0 | 47.8 | 0.964285714285714 | 90 | 47 | 96.4 | 0 | 274 | 5 | 29 | 118 | KAF1740838.1 hypothetical protein MXB_1553 [Myxobolus squamalis] | diamond | 270 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 27655070 | 27655070 | PRJNA833575_P_NODE_21264_length_321_cov_1.142857_g21127_i0 | PRJNA833575 | 21264 | 321 | 1.142857 | 3.66857097 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 130 | 1.05e-36 | NR | XP_068693858.1 | 591990 | g21127 | i0 | 71 | 2.60747663551402 | 93 | 27 | 86.9 | 0 | 309 | 31 | 7 | 99 | XP_068693858.1 large ribosomal subunit protein eL36-like isoform X2 [Montipora foliosa] | diamond | 837 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 28128622 | 28128622 | PRJNA833575_P_NODE_30105_length_271_cov_1.163366_g29968_i0 | PRJNA833575 | 30105 | 271 | 1.163366 | 3.15272186 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 80.9 | 1.33e-15 | NR | XP_031551543.1 | 6105 | g29968 | i0 | 50 | 0.974169741697417 | 88 | 41 | 96.3 | 2 | 3 | 263 | 99 | 184 | XP_031551543.1 nucleoside diphosphate kinase 7-like [Actinia tenebrosa] | diamond | 264 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28602199 | 28602199 | PRJNA833575_P_NODE_6127_length_572_cov_3.123260_g5990_i0 | PRJNA833575 | 6127 | 572 | 3.12326 | 17.8650472 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 135 | 7.36e-35 | NR | XP_015752283.1 | 70779 | g5990 | i0 | 54.1 | 0.63986013986014 | 122 | 50 | 60.8 | 2 | 355 | 8 | 195 | 316 | XP_015752283.1 PREDICTED: uncharacterized protein LOC107332068 [Acropora digitifera] | diamond | 366 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 28854510 | 28854510 | PRJNA833575_P_NODE_42188_length_231_cov_0.888889_g42051_i0 | PRJNA833575 | 42188 | 231 | 0.888889 | 2.05333359 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 42.4 | 0.0412 | NR | XP_046855464.1 | 2897299 | g42051 | i0 | 47.5 | 0.519480519480519 | 40 | 20 | 51.9 | 1 | 127 | 8 | 32 | 70 | XP_046855464.1 malignant fibrous histiocytoma-amplified sequence 1 homolog [Xenia sp. Carnegie-2017] | diamond | 120 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 28958146 | 28958146 | PRJNA833575_P_NODE_3388_length_751_cov_1.195015_g3272_i0 | PRJNA833575 | 3388 | 751 | 1.195015 | 8.97456265 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 101 | 9.25e-23 | NR | XP_020624691.1 | 48498 | g3272 | i0 | 49 | 1.31424766977364 | 96 | 43 | 36.4 | 2 | 478 | 750 | 6 | 100 | XP_020624691.1 uncharacterized protein LOC110062171 [Orbicella faveolata] | diamond | 987 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 31065900 | 31065900 | PRJNA833575_P_NODE_30115_length_271_cov_1.103960_g29978_i0 | PRJNA833575 | 30115 | 271 | 1.10396 | 2.9917316 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 73.6 | 5.4e-13 | NR | XP_015752283.1 | 70779 | g29978 | i0 | 45.4 | 1.07380073800738 | 97 | 43 | 99.6 | 4 | 2 | 271 | 239 | 332 | XP_015752283.1 PREDICTED: uncharacterized protein LOC107332068 [Acropora digitifera] | diamond | 291 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 31128501 | 31128501 | PRJNA833575_P_NODE_25515_length_295_cov_0.889381_g25378_i0 | PRJNA833575 | 25515 | 295 | 0.889381 | 2.62367395 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 77 | 1.5e-14 | NR | KAF0989612.1 | 69463 | g25378 | i0 | 61 | 1.13898305084746 | 59 | 23 | 60 | 0 | 177 | 1 | 18 | 76 | KAF0989612.1 hypothetical protein HZS_6945, partial [Henneguya salminicola] | diamond | 336 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 31381940 | 31381940 | PRJNA833575_P_NODE_17516_length_351_cov_1.460993_g17379_i0 | PRJNA833575 | 17516 | 351 | 1.460993 | 5.12808543 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 73.9 | 2.76e-14 | NR | XP_028401732.1 | 151771 | g17379 | i0 | 52 | 0.641025641025641 | 75 | 35 | 64.1 | 1 | 227 | 3 | 6 | 79 | XP_028401732.1 60S ribosomal protein L33-A-like [Dendronephthya gigantea] | diamond | 225 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 31453748 | 31453748 | PRJNA833575_P_NODE_37856_length_236_cov_1.431138_g37719_i0 | PRJNA833575 | 37856 | 236 | 1.431138 | 3.37748568 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 87.4 | 4.3e-18 | NR | XP_028393513.1 | 151771 | g37719 | i0 | 65.4 | 6.85169491525424 | 52 | 18 | 66.1 | 0 | 234 | 79 | 167 | 218 | XP_028393513.1 zinc finger CCCH domain-containing protein 15-like isoform X2 [Dendronephthya gigantea] | diamond | 1617 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 31706651 | 31706651 | PRJNA833575_P_NODE_19817_length_331_cov_3.160305_g19680_i0 | PRJNA833575 | 19817 | 331 | 3.160305 | 10.46060955 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 141 | 1.61e-40 | NR | KAJ7383860.1 | 174260 | g19680 | i0 | 69.2 | 3.77039274924471 | 104 | 32 | 94.3 | 0 | 16 | 327 | 1 | 104 | KAJ7383860.1 Transcription factor BTF3 4 [Desmophyllum pertusum] | diamond | 1248 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 32267745 | 32267745 | PRJNA833575_P_NODE_10418_length_445_cov_3.742021_g10281_i0 | PRJNA833575 | 10418 | 445 | 3.742021 | 16.65199345 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 177 | 7.569999999999999e-54 | NR | CAH3161462.1 | 104759 | g10281 | i0 | 67.7 | 2.62921348314607 | 130 | 42 | 87.6 | 0 | 3 | 392 | 29 | 158 | CAH3161462.1 unnamed protein product [Porites lobata] | diamond | 1170 | 177 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 32709776 | 32709776 | PRJNA833575_P_NODE_13420_length_397_cov_3.588415_g13283_i0 | PRJNA833575 | 13420 | 397 | 3.588415 | 14.24600755 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 84.3 | 5.92e-16 | NR | CAB3990039.1 | 317549 | g13283 | i0 | 47.5 | 1.49622166246851 | 99 | 45 | 69.5 | 2 | 397 | 122 | 670 | 768 | CAB3990039.1 basement membrane-specific heparan sulfate proteoglycan core -like [Paramuricea clavata] | diamond | 594 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata |
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);;