contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA432257" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 429855 | 429855 | PRJNA432257_S_NODE_5421_length_508_cov_98.566879_g5154_i0 | PRJNA432257 | 5421 | 508 | 98.566879 | 500.71974532 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 192 | 6.5e-60 | NR | XP_020904252.1 | 2652724 | g5154 | i0 | 68.6 | 2.42716535433071 | 137 | 39 | 80.9 | 1 | 442 | 32 | 1 | 133 | XP_020904252.1 60S ribosomal protein L32 [Exaiptasia diaphana] | diamond | 1233 | 192 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 4916706 | 4916706 | PRJNA432257_S_NODE_115404_length_161_cov_1.258065_g115023_i0 | PRJNA432257 | 115404 | 161 | 1.258065 | 2.02548465 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 87.8 | 2.1e-20 | NR | XP_057290043.1 | 13093 | g115023 | i0 | 67.9 | 3.95031055900621 | 53 | 17 | 98.8 | 0 | 159 | 1 | 50 | 102 | XP_057290043.1 60S ribosomal protein L27a-like [Hydractinia symbiolongicarpus] | diamond | 636 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 9357345 | 9357345 | PRJNA432257_S_NODE_1268_length_910_cov_112.389462_g1173_i0 | PRJNA432257 | 1268 | 910 | 112.389462 | 1022.7441042 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 412 | 1.71e-142 | NR | EDO33547.1 | 45351 | g1173 | i0 | 73.1 | 51.721978021978 | 260 | 70 | 85.7 | 0 | 809 | 30 | 1 | 260 | EDO33547.1 predicted protein [Nematostella vectensis] | diamond | 47067 | 412 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 26648913 | 26648913 | PRJNA432257_S_NODE_65421_length_209_cov_1.587209_g65040_i0 | PRJNA432257 | 65421 | 209 | 1.587209 | 3.31726681 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 103 | 1.2499999999999999e-23 | NR | XP_029198836.2 | 45264 | g65040 | i0 | 76.2 | 5.4688995215311 | 63 | 15 | 90.4 | 0 | 208 | 20 | 290 | 352 | XP_029198836.2 LOW QUALITY PROTEIN: diacylglycerol kinase zeta-like [Acropora millepora] | diamond | 1143 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 26980837 | 26980837 | PRJNA432257_S_NODE_49722_length_231_cov_220.701031_g49341_i0 | PRJNA432257 | 49722 | 231 | 220.701031 | 509.81938161 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 62.8 | 1.96e-10 | NR | EDO33935.1 | 45351 | g49341 | i0 | 72 | 6.72727272727273 | 50 | 14 | 64.9 | 0 | 80 | 229 | 3 | 52 | EDO33935.1 predicted protein [Nematostella vectensis] | diamond | 1554 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 28039872 | 28039872 | PRJNA432257_S_NODE_95525_length_180_cov_1.363636_g95144_i0 | PRJNA432257 | 95525 | 180 | 1.363636 | 2.4545448 | Actiniaria | 6103 | Cnidaria | other_Eukaryota | 74.3 | 9.78e-14 | NR | XP_031555713.1 | 6105 | g95144 | i0 | 66.7 | 1.71666666666667 | 54 | 18 | 90 | 0 | 17 | 178 | 299 | 352 | XP_031555713.1 3-hydroxyisobutyryl-CoA hydrolase, mitochondrial-like [Actinia tenebrosa] | diamond | 309 | 74.7 | 0.994645247657296 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28671393 | 28671393 | PRJNA432257_S_NODE_50247_length_230_cov_971.626943_g49866_i0 | PRJNA432257 | 50247 | 230 | 971.626943 | 2234.7419689 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 2.3e-25 | NR | RMX48043.1 | 46731 | g49866 | i0 | 74.5 | 6.4304347826087 | 55 | 14 | 71.7 | 0 | 190 | 26 | 118 | 172 | RMX48043.1 hypothetical protein pdam_00002618, partial [Pocillopora damicornis] | diamond | 1479 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 28955703 | 28955703 | PRJNA432257_S_NODE_54648_length_223_cov_64.392473_g54267_i0 | PRJNA432257 | 54648 | 223 | 64.392473 | 143.59521479 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 72.8 | 7.04e-13 | NR | CAH3144622.1 | 46732 | g54267 | i0 | 67.3 | 4.81614349775785 | 52 | 17 | 70 | 0 | 161 | 6 | 136 | 187 | CAH3144622.1 unnamed protein product, partial [Pocillopora meandrina] | diamond | 1074 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora meandrina | |
| 29286188 | 29286188 | PRJNA432257_S_NODE_3869_length_575_cov_5.221190_g3641_i0 | PRJNA432257 | 3869 | 575 | 5.22119 | 30.0218425 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 46.2 | 0.0494 | NR | CAH3126398.1 | 104759 | g3641 | i0 | 27.4 | 0.64695652173913 | 124 | 70 | 54.3 | 2 | 441 | 130 | 1160 | 1283 | CAH3126398.1 unnamed protein product [Porites lobata] | diamond | 372 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 31212817 | 31212817 | PRJNA432257_S_NODE_92515_length_182_cov_2.462069_g92134_i0 | PRJNA432257 | 92515 | 182 | 2.462069 | 4.48096558 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 41.6 | 0.0332 | NR | KAK3737379.1 | 3060491 | g92134 | i0 | 38.1 | 0.692307692307692 | 42 | 25 | 69.2 | 1 | 9 | 134 | 91 | 131 | KAK3737379.1 hypothetical protein QZH41_011517 [Actinostola sp. cb2023] | diamond | 126 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 31957123 | 31957123 | PRJNA432257_S_NODE_83957_length_189_cov_12.342105_g83576_i0 | PRJNA432257 | 83957 | 189 | 12.342105 | 23.32657845 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 74.7 | 2.03e-14 | NR | KAK2570250.1 | 6130 | g83576 | i0 | 78 | 208.253968253968 | 41 | 9 | 65.1 | 0 | 37 | 159 | 107 | 147 | KAK2570250.1 Serine/threonine-protein kinase tousled-like 1-B [Acropora cervicornis] | diamond | 39360 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 32130805 | 32130805 | PRJNA432257_S_NODE_4898_length_527_cov_17.187755_g4640_i0 | PRJNA432257 | 4898 | 527 | 17.187755 | 90.57946885 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 47 | 0.00304 | NR | CAB3989544.1 | 317549 | g4640 | i0 | 32.8 | 0.381404174573055 | 67 | 43 | 37 | 1 | 43 | 237 | 3 | 69 | CAB3989544.1 Serine palmitoyltransferase 1 [Paramuricea clavata] | diamond | 201 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 32699358 | 32699358 | PRJNA432257_S_NODE_2800_length_649_cov_74.119281_g2625_i0 | PRJNA432257 | 2800 | 649 | 74.119281 | 481.03413369 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 243 | 1.63e-77 | NR | XP_057294959.1 | 13093 | g2625 | i0 | 69.3 | 1.77041602465331 | 189 | 57 | 86.9 | 1 | 568 | 5 | 6 | 194 | XP_057294959.1 60S ribosomal protein L6-like [Hydractinia symbiolongicarpus] | diamond | 1149 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus |
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);;