contig_metadata
14 rows where bioproject = "PRJEB81327", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 140254 | 140254 | PRJEB81327_P_NODE_8261_length_484_cov_1.116788_g7654_i0 | PRJEB81327 | 8261 | 484 | 1.116788 | 5.40525392 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 190 | 1.42e-58 | NR | XP_015754731.1 | 70779 | g7654 | i0 | 66.9 | 0.91735537190082606 | 148 | 48 | 91.7 | 1 | 446 | 3 | 1 | 147 | XP_015754731.1 PREDICTED: 60S ribosomal protein L17-like isoform X1 [Acropora digitifera] | diamond | 444 | 190 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 2690348 | 2690348 | PRJEB81327_P_NODE_8523_length_475_cov_2.860697_g7915_i0 | PRJEB81327 | 8523 | 475 | 2.860697 | 13.58831075 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 329 | 1.91e-85 | NTclustered | gi|2782857558|ref|XM_067058140.1| | 252671 | g7915 | i0 | 81.683 | 92.4694736842105 | 404 | 66 | 84 | 8 | 3 | 402 | 1259 | 860 | PREDICTED: Clytia hemisphaerica actin, non-muscle 6.2 (LOC136801505), mRNA | blastn | 43923 | 329 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 3547614 | 3547614 | PRJEB81327_P_NODE_41723_length_258_cov_1.664865_g41115_i0 | PRJEB81327 | 41723 | 258 | 1.664865 | 4.2953517 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 161 | 3.74e-35 | NTclustered | gi|166007989|gb|EU247810.1| | 166266 | g41115 | i0 | 89.231 | 48.515503875969 | 130 | 12 | 50 | 2 | 131 | 258 | 843 | 972 | Maeotias marginata 28S large subunit ribosomal RNA gene, partial sequence | blastn | 12517 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Limnomedusae | Olindiidae | Maeotias | Maeotias marginata | |
| 9067381 | 9067381 | PRJEB81327_P_NODE_57128_length_245_cov_1.156977_g56520_i0 | PRJEB81327 | 57128 | 245 | 1.156977 | 2.83459365 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g56520 | i0 | 86 | 0.204081632653061 | 50 | 7 | 20 | 0 | 196 | 245 | 12940669 | 12940718 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 50 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 23091554 | 23091554 | PRJEB81327_P_NODE_18599_length_313_cov_1.604167_g17991_i0 | PRJEB81327 | 18599 | 313 | 1.604167 | 5.02104271 | root | 1 | Root_unresolved | Root_unresolved | 114 | 7.76e-30 | NR | XP_020605211.1 | 48498 | g17991 | i0 | 63.7 | 8.30990415335463 | 91 | 32 | 86.3 | 1 | 271 | 2 | 22 | 112 | XP_020605211.1 60S ribosomal protein L32-like [Orbicella faveolata] | diamond | 2601 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 24366021 | 24366021 | PRJEB81327_P_NODE_64720_length_241_cov_0.916667_g64112_i0 | PRJEB81327 | 64720 | 241 | 0.916667 | 2.20916747 | Eunicea flexuosa | 437162 | Cnidaria | other_Eukaryota | 86.1 | 2.14e-12 | NTclustered | gi|2689317196|gb|PP410695.1| | 437162 | g64112 | i0 | 87.838 | 0.614107883817427 | 74 | 5 | 30 | 4 | 1 | 73 | 2138 | 2068 | Eunicea flexuosa voucher USNM:1606843 large subunit ribosomal RNA gene, partial sequence | blastn | 148 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Eunicea | Eunicea flexuosa | |
| 26646855 | 26646855 | PRJEB81327_P_NODE_13661_length_365_cov_3.095890_g13053_i0 | PRJEB81327 | 13661 | 365 | 3.09589 | 11.2999985 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 183 | 9.99e-57 | NR | XP_002165574.2 | 6087 | g13053 | i0 | 69.2 | 43.3479452054795 | 120 | 37 | 98.6 | 0 | 5 | 364 | 15 | 134 | XP_002165574.2 eukaryotic translation initiation factor 5A [Hydra vulgaris] | diamond | 15822 | 184 | 0.994565217391304 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 26646856 | 26646856 | PRJEB81327_P_NODE_45721_length_251_cov_2.292135_g45113_i0 | PRJEB81327 | 45721 | 251 | 2.292135 | 5.75325885 | root | 1 | Root_unresolved | Root_unresolved | 77.8 | 1.87e-14 | NR | CAB4006378.1 | 317549 | g45113 | i0 | 41 | 8.23505976095618 | 83 | 49 | 99.2 | 0 | 3 | 251 | 296 | 378 | CAB4006378.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 2067 | 78.2 | 0.994884910485933 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 26844634 | 26844634 | PRJEB81327_P_NODE_57281_length_245_cov_0.895349_g56673_i0 | PRJEB81327 | 57281 | 245 | 0.895349 | 2.19360505 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 51.2 | 2.8e-5 | NR | KAJ7383649.1 | 174260 | g56673 | i0 | 40 | 0.857142857142857 | 70 | 41 | 85.7 | 1 | 15 | 224 | 6 | 74 | KAJ7383649.1 Activator of basal transcription 1 [Desmophyllum pertusum] | diamond | 210 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 27002408 | 27002408 | PRJEB81327_P_NODE_13822_length_363_cov_1.589655_g13214_i0 | PRJEB81327 | 13822 | 363 | 1.589655 | 5.77044765 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 146 | 7.0199999999999986e-43 | NR | XP_028401732.1 | 151771 | g13214 | i0 | 66.4 | 0.909090909090909 | 110 | 28 | 84.3 | 2 | 37 | 342 | 5 | 113 | XP_028401732.1 60S ribosomal protein L33-A-like [Dendronephthya gigantea] | diamond | 330 | 146 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 28953594 | 28953594 | PRJEB81327_P_NODE_17668_length_321_cov_3.189516_g17060_i0 | PRJEB81327 | 17668 | 321 | 3.189516 | 10.23834636 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 88.2 | 1.05e-17 | NR | CAH3152834.1 | 104759 | g17060 | i0 | 49.5 | 7.91588785046729 | 93 | 47 | 86.9 | 0 | 3 | 281 | 1036 | 1128 | CAH3152834.1 unnamed protein product [Porites lobata] | diamond | 2541 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 29213478 | 29213478 | PRJEB81327_P_NODE_15909_length_338_cov_3.075472_g15301_i0 | PRJEB81327 | 15909 | 338 | 3.075472 | 10.39509536 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 127 | 5.709999999999999e-32 | NR | XP_028392378.1 | 151771 | g15301 | i0 | 51.8 | 5.95562130177515 | 112 | 54 | 99.4 | 0 | 338 | 3 | 82 | 193 | XP_028392378.1 xaa-Pro dipeptidase-like isoform X1 [Dendronephthya gigantea] | diamond | 2013 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 30160420 | 30160420 | PRJEB81327_P_NODE_14712_length_351_cov_1.381295_g14104_i0 | PRJEB81327 | 14712 | 351 | 1.381295 | 4.84834545 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 143 | 1.19e-40 | NR | XP_020907839.1 | 2652724 | g14104 | i0 | 70.8 | 4.5042735042735 | 106 | 31 | 90.6 | 0 | 350 | 33 | 60 | 165 | XP_020907839.1 60S ribosomal protein L17 [Exaiptasia diaphana] | diamond | 1581 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 32120801 | 32120801 | PRJEB81327_P_NODE_63798_length_242_cov_0.875740_g63190_i0 | PRJEB81327 | 63798 | 242 | 0.87574 | 2.1192908 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 88.2 | 2.83e-20 | NR | CAH3181837.1 | 104178 | g63190 | i0 | 53.3 | 0.929752066115702 | 75 | 35 | 93 | 0 | 237 | 13 | 38 | 112 | CAH3181837.1 unnamed protein product, partial [Porites evermanni] | diamond | 225 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni |
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);;