contig_metadata
15 rows where bioproject = "PRJNA312615" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5481496 | 5481496 | PRJNA312615_P_NODE_23525_length_252_cov_0.896552_g23374_i0 | PRJNA312615 | 23525 | 252 | 0.896552 | 2.25931104 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 90.9 | 3e-19 | NR | XP_031560834.1 | 6105 | g23374 | i0 | 67.2 | 0.797619047619048 | 67 | 21 | 78.6 | 1 | 202 | 5 | 152 | 218 | XP_031560834.1 nucleoredoxin-like [Actinia tenebrosa] | diamond | 201 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 18915316 | 18915316 | PRJNA312615_P_NODE_3835_length_601_cov_3.353261_g3695_i0 | PRJNA312615 | 3835 | 601 | 3.353261 | 20.15309861 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 178 | 4.14e-50 | NR | PFX18144.1 | 50429 | g3695 | i0 | 68.5 | 1.26788685524126 | 127 | 40 | 63.4 | 0 | 532 | 152 | 331 | 457 | PFX18144.1 60S ribosomal protein L23a [Stylophora pistillata] | diamond | 762 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 25290135 | 25290135 | PRJNA312615_P_NODE_39460_length_195_cov_1.616438_g39309_i0 | PRJNA312615 | 39460 | 195 | 1.616438 | 3.1520541 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 65.8 | 2.16e-6 | NTclustered | gi|2917940737|emb|OZ237566.1| | 6108 | g39309 | i0 | 97.368 | 19.2666666666667 | 38 | 1 | 19 | 0 | 85 | 122 | 592339 | 592302 | Anemonia sulcata genome assembly, chromosome: 12 | blastn | 3757 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26694328 | 26694328 | PRJNA312615_P_NODE_20801_length_267_cov_1.830275_g20650_i0 | PRJNA312615 | 20801 | 267 | 1.830275 | 4.88683425 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 59.7 | 3.77e-8 | NR | XP_032241407.2 | 45351 | g20650 | i0 | 61 | 0.460674157303371 | 41 | 13 | 46.1 | 1 | 266 | 144 | 239 | 276 | XP_032241407.2 uncharacterized protein LOC116620024 [Nematostella vectensis] | diamond | 123 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 27060236 | 27060236 | PRJNA312615_P_NODE_43242_length_186_cov_1.160584_g43091_i0 | PRJNA312615 | 43242 | 186 | 1.160584 | 2.15868624 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 44.3 | 7.15e-4 | NR | XP_057314035.1 | 13093 | g43091 | i0 | 40 | 2.80645161290323 | 40 | 24 | 64.5 | 0 | 56 | 175 | 31 | 70 | XP_057314035.1 mitochondrial import inner membrane translocase subunit Tim8 A-like [Hydractinia symbiolongicarpus] | diamond | 522 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 27137028 | 27137028 | PRJNA312615_P_NODE_21162_length_265_cov_1.300926_g21011_i0 | PRJNA312615 | 21162 | 265 | 1.300926 | 3.4474539 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 54.3 | 4.3e-6 | NR | XP_068713595.1 | 591990 | g21011 | i0 | 37.9 | 1.64150943396226 | 58 | 36 | 65.7 | 0 | 89 | 262 | 847 | 904 | XP_068713595.1 endoribonuclease Dicer-like isoform X1 [Montipora foliosa] | diamond | 435 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 28305982 | 28305982 | PRJNA312615_P_NODE_38546_length_198_cov_0.959732_g38395_i0 | PRJNA312615 | 38546 | 198 | 0.959732 | 1.90026936 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 41.6 | 0.0394 | NR | CAH3197243.1 | 104178 | g38395 | i0 | 87.5 | 0.46969696969697 | 16 | 2 | 24.2 | 0 | 67 | 114 | 157 | 172 | CAH3197243.1 unnamed protein product, partial [Porites evermanni] | diamond | 93 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 30579531 | 30579531 | PRJNA312615_P_NODE_24393_length_247_cov_2.060606_g24242_i0 | PRJNA312615 | 24393 | 247 | 2.060606 | 5.08969682 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 43.9 | 0.0159 | NR | CAH3034769.1 | 104759 | g24242 | i0 | 37.5 | 0.777327935222672 | 64 | 35 | 74.1 | 3 | 17 | 199 | 442 | 503 | CAH3034769.1 unnamed protein product [Porites lobata] | diamond | 192 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 30579536 | 30579536 | PRJNA312615_P_NODE_28713_length_228_cov_2.206704_g28562_i0 | PRJNA312615 | 28713 | 228 | 2.206704 | 5.03128512 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 70.1 | 7.06e-12 | NR | XP_057304745.1 | 13093 | g28562 | i0 | 54.4 | 2.59210526315789 | 68 | 30 | 88.2 | 1 | 221 | 21 | 772 | 839 | XP_057304745.1 phospholipid-transporting ATPase ABCA3-like [Hydractinia symbiolongicarpus] | diamond | 591 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 30674459 | 30674459 | PRJNA312615_P_NODE_17893_length_289_cov_1.275000_g17742_i0 | PRJNA312615 | 17893 | 289 | 1.275 | 3.68475 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 48.5 | 6.26e-4 | NR | XP_048581406.1 | 45351 | g17742 | i0 | 34.8 | 0.923875432525952 | 89 | 55 | 92.4 | 2 | 5 | 271 | 513 | 598 | XP_048581406.1 platelet binding protein GspB [Nematostella vectensis] | diamond | 267 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 31292451 | 31292451 | PRJNA312615_P_NODE_13575_length_334_cov_2.136842_g13424_i0 | PRJNA312615 | 13575 | 334 | 2.136842 | 7.13705228 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 111 | 6.49e-27 | NR | XP_047134745.1 | 6087 | g13424 | i0 | 89.3 | 18.5748502994012 | 56 | 6 | 50.3 | 0 | 2 | 169 | 280 | 335 | XP_047134745.1 DNA repair protein RAD51 homolog A [Hydra vulgaris] | diamond | 6204 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 31450802 | 31450802 | PRJNA312615_P_NODE_27776_length_232_cov_1.114754_g27625_i0 | PRJNA312615 | 27776 | 232 | 1.114754 | 2.58622928 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 80.9 | 6.86e-16 | NR | RMX40233.1 | 46731 | g27625 | i0 | 72.5 | 4.42241379310345 | 51 | 14 | 65.9 | 0 | 78 | 230 | 54 | 104 | RMX40233.1 hypothetical protein pdam_00014337 [Pocillopora damicornis] | diamond | 1026 | 81.3 | 0.995079950799508 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 32399905 | 32399905 | PRJNA312615_P_NODE_22959_length_254_cov_2.409756_g22808_i0 | PRJNA312615 | 22959 | 254 | 2.409756 | 6.12078024 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.00651 | NR | PFX21664.1 | 50429 | g22808 | i0 | 42.2 | 1.2992125984252 | 45 | 26 | 53.1 | 0 | 217 | 83 | 230 | 274 | PFX21664.1 hypothetical protein AWC38_SpisGene13848 [Stylophora pistillata] | diamond | 330 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 32904267 | 32904267 | PRJNA312615_P_NODE_24320_length_247_cov_5.363636_g24169_i0 | PRJNA312615 | 24320 | 247 | 5.363636 | 13.24818092 | Porites | 46719 | Cnidaria | other_Eukaryota | 50.8 | 5.38e-5 | NR | CAH3187153.1 | 104178 | g24169 | i0 | 63.3 | 1.51821862348178 | 30 | 11 | 36.4 | 0 | 91 | 2 | 290 | 319 | CAH3187153.1 unnamed protein product [Porites evermanni] | diamond | 375 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 32904271 | 32904271 | PRJNA312615_P_NODE_40420_length_193_cov_1.062500_g40269_i0 | PRJNA312615 | 40420 | 193 | 1.0625 | 2.050625 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 76.3 | 2.9e-14 | NR | KAK2560533.1 | 6130 | g40269 | i0 | 56.5 | 14.3160621761658 | 62 | 27 | 96.4 | 0 | 191 | 6 | 4564 | 4625 | KAK2560533.1 Dynein axonemal heavy chain 7 [Acropora cervicornis] | diamond | 2763 | 76.6 | 0.996083550913838 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis |
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);;