contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA816047" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25600262 | 25600262 | PRJNA816047b_S_NODE_55689_length_231_cov_2.664557_g53377_i0 | PRJNA816047 | 55689 | 231 | 2.664557 | 6.15512667 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 93.5 | 1.22e-14 | NTclustered | gi|1603784861|ref|XM_028539964.1| | 151771 | g53377 | i0 | 78.986 | 0.818181818181818 | 138 | 27 | 59 | 2 | 8 | 144 | 335 | 471 | PREDICTED: Dendronephthya gigantea zinc finger protein 271-like (LOC114519787), mRNA | blastn | 189 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 25606771 | 25606771 | PRJNA816047d_S_NODE_9921_length_803_cov_6.660000_g8541_i0 | PRJNA816047 | 9921 | 803 | 6.66 | 53.4798 | Bivalvulida gen. n. sp. a JO-2 | 3073449 | Cnidaria | other_Eukaryota | 265 | 9.519999999999998e-66 | NTclustered | gi|2572825558|gb|OR509833.1| | 3073449 | g8541 | i0 | 81.609 | 30.6338729763387 | 348 | 38 | 43 | 18 | 6 | 352 | 293 | 615 | Bivalvulida gen. n. sp. a JO-2023 isolate BM_02 large subunit ribosomal RNA gene, partial sequence | blastn | 24599 | 265 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Bivalvulida gen. n. sp. a JO-2023 | |||
| 25738099 | 25738099 | PRJNA816047d_S_NODE_14226_length_613_cov_22.932143_g12591_i0 | PRJNA816047 | 14226 | 613 | 22.932143 | 140.57403659 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 933 | 0 | NTclustered | gi|681870005|gb|KM001688.1| | 1542451 | g12591 | i0 | 99.416 | 33.2446982055465 | 514 | 3 | 84 | 0 | 96 | 609 | 2351 | 1838 | Myxidium streisingeri clone ZF10 18S small subunit ribosomal RNA gene, partial sequence | blastn | 20379 | 933 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 25739218 | 25739218 | PRJNA816047d_S_NODE_23298_length_447_cov_3.515228_g21472_i0 | PRJNA816047 | 23298 | 447 | 3.515228 | 15.71306916 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 311 | 6.47e-80 | NTclustered | gi|2918369558|emb|OZ237728.1| | 317547 | g21472 | i0 | 81.25 | 25.6957494407159 | 384 | 72 | 86 | 0 | 64 | 447 | 3379075 | 3378692 | Eunicella cavolini genome assembly, chromosome: 12 | blastn | 11486 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 25874263 | 25874263 | PRJNA816047d_S_NODE_16579_length_555_cov_5.185259_g14864_i0 | PRJNA816047 | 16579 | 555 | 5.185259 | 28.77818745 | Zschokkella nova | 371529 | Cnidaria | other_Eukaryota | 106 | 4.14e-18 | NTclustered | gi|312184073|gb|GU471279.1| | 371529 | g14864 | i0 | 94.203 | 9.58018018018018 | 69 | 4 | 12 | 0 | 422 | 490 | 740 | 808 | Zschokkella nova isolate 170 28S ribosomal RNA gene, partial sequence | blastn | 5317 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Zschokkella | Zschokkella nova | |
| 25876617 | 25876617 | PRJNA816047d_S_NODE_50115_length_312_cov_1.729730_g48280_i0 | PRJNA816047 | 50115 | 312 | 1.72973 | 5.3967576 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 58.4 | 6.27e-4 | NTclustered | gi|1191048361|ref|XM_021046228.1| | 2652724 | g48280 | i0 | 97.143 | 0.294871794871795 | 35 | 0 | 11 | 1 | 35 | 69 | 86 | 119 | PREDICTED: Exaiptasia diaphana 60S ribosomal protein L19 (LOC110240417), partial mRNA | blastn | 92 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 26014062 | 26014062 | PRJNA816047d_S_NODE_7036_length_1163_cov_29.029730_g5961_i0 | PRJNA816047 | 7036 | 1163 | 29.02973 | 337.6157599 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 1858 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g5961 | i0 | 99.802 | 30.2665520206363 | 1012 | 2 | 87 | 0 | 119 | 1130 | 1654 | 643 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 35200 | 1858 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 26015076 | 26015076 | PRJNA816047d_S_NODE_9756_length_817_cov_11.662304_g8385_i0 | PRJNA816047 | 9756 | 817 | 11.662304 | 95.28102368 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 100 | 2.89e-16 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g8385 | i0 | 94.03 | 4.92778457772338 | 67 | 3 | 8 | 1 | 751 | 817 | 1069 | 1004 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 4026 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 26015080 | 26015080 | PRJNA816047d_S_NODE_9772_length_815_cov_6309.900262_g8401_i0 | PRJNA816047 | 9772 | 815 | 6309.900262 | 51425.6871353 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 100 | 2.88e-16 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g8401 | i0 | 94.03 | 4.92147239263804 | 67 | 3 | 8 | 1 | 749 | 815 | 1069 | 1004 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 4011 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 26145254 | 26145254 | PRJNA816047d_S_NODE_103813_length_248_cov_539.435897_g101978_i0 | PRJNA816047 | 103813 | 248 | 539.435897 | 1337.80102456 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 58.4 | 4.82e-4 | NTclustered | gi|1191048361|ref|XM_021046228.1| | 2652724 | g101978 | i0 | 100 | 4.39112903225806 | 31 | 0 | 24 | 0 | 1 | 31 | 86 | 116 | PREDICTED: Exaiptasia diaphana 60S ribosomal protein L19 (LOC110240417), partial mRNA | blastn | 1089 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 26146013 | 26146013 | PRJNA816047d_S_NODE_130061_length_231_cov_1.831461_g128226_i0 | PRJNA816047 | 130061 | 231 | 1.831461 | 4.23067491 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 58.4 | 4.44e-4 | NTclustered | gi|1191048361|ref|XM_021046228.1| | 2652724 | g128226 | i0 | 100 | 2.64502164502164 | 31 | 0 | 13 | 0 | 1 | 31 | 86 | 116 | PREDICTED: Exaiptasia diaphana 60S ribosomal protein L19 (LOC110240417), partial mRNA | blastn | 611 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 26146530 | 26146530 | PRJNA816047d_S_NODE_15285_length_584_cov_10532.589454_g13608_i0 | PRJNA816047 | 15285 | 584 | 10532.589454 | 61510.32241136 | Unicauda fimbrethilae | 1720082 | Cnidaria | other_Eukaryota | 272 | 4.07e-68 | NTclustered | gi|2089706636|gb|OK030695.1| | 1720082 | g13608 | i0 | 97.484 | 26.4811643835616 | 159 | 4 | 27 | 0 | 376 | 534 | 1938 | 2096 | Unicauda fimbrethilae large subunit ribosomal RNA gene, partial sequence | blastn | 15465 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Unicauda | Unicauda fimbrethilae | |
| 26148095 | 26148095 | PRJNA816047d_S_NODE_32869_length_372_cov_3552.498433_g31035_i0 | PRJNA816047 | 32869 | 372 | 3552.498433 | 13215.29417076 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 130 | 1.59e-25 | NTclustered | gi|1191048361|ref|XM_021046228.1| | 2652724 | g31035 | i0 | 87.288 | 12.7365591397849 | 118 | 10 | 32 | 3 | 119 | 236 | 113 | 1 | PREDICTED: Exaiptasia diaphana 60S ribosomal protein L19 (LOC110240417), partial mRNA | blastn | 4738 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 26281294 | 26281294 | PRJNA816047d_S_NODE_103894_length_248_cov_4.707692_g102059_i0 | PRJNA816047 | 103894 | 248 | 4.707692 | 11.67507616 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 276 | 1.22e-69 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g102059 | i0 | 100 | 60.3508064516129 | 149 | 0 | 60 | 0 | 1 | 149 | 2530 | 2678 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 14967 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 26281799 | 26281799 | PRJNA816047d_S_NODE_122718_length_239_cov_6.370968_g120883_i0 | PRJNA816047 | 122718 | 239 | 6.370968 | 15.22661352 | Chloromyxum cristatum | 650990 | Cnidaria | other_Eukaryota | 99 | 2.72e-16 | NTclustered | gi|241911748|gb|FJ417054.1| | 650990 | g120883 | i0 | 100 | 18.489539748954 | 53 | 0 | 22 | 0 | 1 | 53 | 2949 | 3001 | Chloromyxum cristatum isolate M0178 28S large subunit ribosomal RNA gene, partial sequence | blastn | 4419 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Chloromyxidae | Chloromyxum | Chloromyxum cristatum | |
| 26284699 | 26284699 | PRJNA816047d_S_NODE_43014_length_331_cov_127.190647_g41179_i0 | PRJNA816047 | 43014 | 331 | 127.190647 | 421.00104157 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|1191048361|ref|XM_021046228.1| | 2652724 | g41179 | i0 | 100 | 1.45619335347432 | 30 | 0 | 18 | 0 | 119 | 148 | 26 | 55 | PREDICTED: Exaiptasia diaphana 60S ribosomal protein L19 (LOC110240417), partial mRNA | blastn | 482 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 26285867 | 26285867 | PRJNA816047d_S_NODE_64430_length_283_cov_10.373913_g62595_i0 | PRJNA816047 | 64430 | 283 | 10.373913 | 29.35817379 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 58.4 | 5.61e-4 | NTclustered | gi|1191048361|ref|XM_021046228.1| | 2652724 | g62595 | i0 | 90.909 | 0.360424028268551 | 44 | 3 | 15 | 1 | 19 | 61 | 86 | 129 | PREDICTED: Exaiptasia diaphana 60S ribosomal protein L19 (LOC110240417), partial mRNA | blastn | 102 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 26417712 | 26417712 | PRJNA816047d_S_NODE_125047_length_236_cov_225.901639_g123212_i0 | PRJNA816047 | 125047 | 236 | 225.901639 | 533.12786804 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|1191048361|ref|XM_021046228.1| | 2652724 | g123212 | i0 | 100 | 2.56779661016949 | 30 | 0 | 13 | 0 | 207 | 236 | 116 | 87 | PREDICTED: Exaiptasia diaphana 60S ribosomal protein L19 (LOC110240417), partial mRNA | blastn | 606 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 26554096 | 26554096 | PRJNA816047d_S_NODE_134536_length_226_cov_76767.826590_g132701_i0 | PRJNA816047 | 134536 | 226 | 76767.82659 | 173495.2880934 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 97.1 | 9.16e-16 | NTclustered | gi|2917940745|emb|OZ237569.1| | 6108 | g132701 | i0 | 95.161 | 0.663716814159292 | 62 | 2 | 27 | 1 | 71 | 131 | 10841882 | 10841821 | Anemonia sulcata genome assembly, chromosome: 15 | blastn | 150 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26555296 | 26555296 | PRJNA816047d_S_NODE_21536_length_469_cov_4170.649038_g19720_i0 | PRJNA816047 | 21536 | 469 | 4170.649038 | 19560.34398822 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 749 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g19720 | i0 | 98.582 | 41.0682302771855 | 423 | 6 | 90 | 0 | 47 | 469 | 28 | 450 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 19261 | 749 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 26555917 | 26555917 | PRJNA816047d_S_NODE_31432_length_380_cov_244.596330_g29598_i0 | PRJNA816047 | 31432 | 380 | 244.59633 | 929.466054 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|1191048361|ref|XM_021046228.1| | 2652724 | g29598 | i0 | 100 | 1.5 | 30 | 0 | 16 | 0 | 119 | 148 | 26 | 55 | PREDICTED: Exaiptasia diaphana 60S ribosomal protein L19 (LOC110240417), partial mRNA | blastn | 570 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 26586334 | 26586334 | PRJNA816047b_S_NODE_23504_length_336_cov_2.642586_g21192_i0 | PRJNA816047 | 23504 | 336 | 2.642586 | 8.87908896 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 6.81e-4 | NTclustered | gi|2917940720|emb|OZ237562.1| | 6108 | g21192 | i0 | 100 | 18.202380952381 | 31 | 0 | 9 | 0 | 36 | 66 | 14207279 | 14207249 | Anemonia sulcata genome assembly, chromosome: 8 | blastn | 6116 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26588759 | 26588759 | PRJNA816047d_S_NODE_8488_length_934_cov_36.382520_g7244_i0 | PRJNA816047 | 8488 | 934 | 36.38252 | 339.8127368 | Bivalvulida | 35583 | Cnidaria | other_Eukaryota | 121 | 2.55e-22 | NTclustered | gi|2806899062|dbj|LC764547.1| | 402991 | g7244 | i0 | 98.529 | 5.82226980728051 | 68 | 1 | 7 | 0 | 560 | 627 | 3232 | 3299 | Myxobolus nagaraensis mx18004 gene for 28S rRNA, partial sequence, clone: mx18004lsu3 | blastn | 5438 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus nagaraensis |
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);;