contig_metadata
15 rows where bioproject = "PRJNA1008624", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2704135 | 2704135 | PRJNA1008624_P_NODE_13123_length_231_cov_3.175824_g12935_i0 | PRJNA1008624 | 13123 | 231 | 3.175824 | 7.33615344 | Eutima gegenbauri | 661993 | Cnidaria | other_Eukaryota | 99 | 2.61e-16 | NTclustered | gi|256674552|gb|FJ550456.1| | 661993 | g12935 | i0 | 78.981 | 23.0562770562771 | 157 | 24 | 68 | 8 | 61 | 216 | 1670 | 1522 | Eutima gegenbauri voucher MHNG INVE31748 28S ribosomal RNA gene, partial sequence | blastn | 5326 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Eirenidae | Eutima | Eutima gegenbauri | |
| 23106299 | 23106299 | PRJNA1008624_P_NODE_1639_length_674_cov_1.678400_g1476_i0 | PRJNA1008624 | 1639 | 674 | 1.6784 | 11.312416 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 58.4 | 0.001 | NTclustered | gi|2812114944|ref|XM_068870257.1| | 246305 | g1476 | i0 | 97.059 | 0.0504451038575668 | 34 | 1 | 5 | 0 | 621 | 654 | 178 | 145 | PREDICTED: Montipora capricornis nucleolar transcription factor 1-A-like (LOC138023236), mRNA | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 23106642 | 23106642 | PRJNA1008624_P_NODE_27659_length_169_cov_0.866667_g27471_i0 | PRJNA1008624 | 27659 | 169 | 0.866667 | 1.46466723 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 62.1 | 2.34e-5 | NTclustered | gi|2257873187|ref|XM_048726704.1| | 45351 | g27471 | i0 | 93.023 | 0.763313609467456 | 43 | 2 | 25 | 1 | 4 | 46 | 1638 | 1679 | PREDICTED: Nematostella vectensis uncharacterized LOC125561901 (LOC125561901), mRNA | blastn | 129 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 26907936 | 26907936 | PRJNA1008624_P_NODE_26402_length_171_cov_0.934426_g26214_i0 | PRJNA1008624 | 26402 | 171 | 0.934426 | 1.59786846 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 43.1 | 0.00903 | NR | XP_068697698.1 | 591990 | g26214 | i0 | 60.6 | 0.578947368421053 | 33 | 13 | 57.9 | 0 | 2 | 100 | 45 | 77 | XP_068697698.1 uncharacterized protein [Montipora foliosa] | diamond | 99 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 28069347 | 28069347 | PRJNA1008624_P_NODE_35305_length_163_cov_0.912281_g35117_i0 | PRJNA1008624 | 35305 | 163 | 0.912281 | 1.48701803 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 52.4 | 2.91e-6 | NR | XP_020613418.1 | 48498 | g35117 | i0 | 54.8 | 7.01226993865031 | 42 | 19 | 77.3 | 0 | 160 | 35 | 36 | 77 | XP_020613418.1 uncharacterized protein LOC110051697 [Orbicella faveolata] | diamond | 1143 | 52.8 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 28360853 | 28360853 | PRJNA1008624_P_NODE_24766_length_176_cov_1.188976_g24578_i0 | PRJNA1008624 | 24766 | 176 | 1.188976 | 2.09259776 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 58.2 | 5.47e-8 | NR | XP_057297333.1 | 13093 | g24578 | i0 | 77.5 | 0.681818181818182 | 40 | 9 | 68.2 | 0 | 8 | 127 | 411 | 450 | XP_057297333.1 LOW QUALITY PROTEIN: NADH-ubiquinone oxidoreductase chain 5-like [Hydractinia symbiolongicarpus] | diamond | 120 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 28360858 | 28360858 | PRJNA1008624_P_NODE_27706_length_169_cov_0.866667_g27518_i0 | PRJNA1008624 | 27706 | 169 | 0.866667 | 1.46466723 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 46.2 | 8.35e-4 | NR | XP_068684540.1 | 591990 | g27518 | i0 | 50 | 0.710059171597633 | 40 | 20 | 71 | 0 | 44 | 163 | 472 | 511 | XP_068684540.1 uncharacterized protein [Montipora foliosa] | diamond | 120 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 28645263 | 28645263 | PRJNA1008624_P_NODE_26547_length_170_cov_1.545455_g26359_i0 | PRJNA1008624 | 26547 | 170 | 1.545455 | 2.6272735 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 44.3 | 0.00401 | NR | XP_065678533.1 | 6087 | g26359 | i0 | 52.4 | 0.741176470588235 | 42 | 20 | 74.1 | 0 | 43 | 168 | 658 | 699 | XP_065678533.1 uncharacterized protein LOC105847050 [Hydra vulgaris] | diamond | 126 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 28771396 | 28771396 | PRJNA1008624_P_NODE_28827_length_168_cov_0.873950_g28639_i0 | PRJNA1008624 | 28827 | 168 | 0.87395 | 1.468236 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 60.1 | 9.78e-9 | NR | KXJ26128.1 | 2652724 | g28639 | i0 | 62.5 | 4.16071428571429 | 40 | 15 | 71.4 | 0 | 166 | 47 | 288 | 327 | KXJ26128.1 putative RNA-directed DNA polymerase from transposon X-element [Exaiptasia diaphana] | diamond | 699 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 28802759 | 28802759 | PRJNA1008624_P_NODE_17828_length_202_cov_1.104575_g17640_i0 | PRJNA1008624 | 17828 | 202 | 1.104575 | 2.2312415 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 43.5 | 0.0115 | NR | CAB4026731.1 | 317549 | g17640 | i0 | 73.1 | 0.772277227722772 | 26 | 7 | 38.6 | 0 | 167 | 90 | 267 | 292 | CAB4026731.1 uncharacterized protein LOC110042288 [Paramuricea clavata] | diamond | 156 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 29560619 | 29560619 | PRJNA1008624_P_NODE_13230_length_231_cov_0.835165_g13042_i0 | PRJNA1008624 | 13230 | 231 | 0.835165 | 1.92923115 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 44.3 | 0.00943 | NR | CAB3981247.1 | 317549 | g13042 | i0 | 50 | 0.597402597402597 | 46 | 20 | 57.1 | 2 | 1 | 132 | 708 | 752 | CAB3981247.1 Reticulocyte-binding 2-like a [Paramuricea clavata] | diamond | 138 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 30065996 | 30065996 | PRJNA1008624_P_NODE_32952_length_165_cov_0.896552_g32764_i0 | PRJNA1008624 | 32952 | 165 | 0.896552 | 1.4793108 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 63.5 | 6.06e-10 | NR | XP_057290814.1 | 13093 | g32764 | i0 | 59.1 | 3.12727272727273 | 44 | 18 | 80 | 0 | 34 | 165 | 70 | 113 | XP_057290814.1 O-acyltransferase like protein-like [Hydractinia symbiolongicarpus] | diamond | 516 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 31449177 | 31449177 | PRJNA1008624_P_NODE_22816_length_182_cov_1.533835_g22628_i0 | PRJNA1008624 | 22816 | 182 | 1.533835 | 2.7915797 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 43.5 | 0.00892 | NR | KAK2574170.1 | 6130 | g22628 | i0 | 48.6 | 3.98901098901099 | 35 | 18 | 57.7 | 0 | 107 | 3 | 514 | 548 | KAK2574170.1 putative RNA-directed DNA polymerase from transposon X-element [Acropora cervicornis] | diamond | 726 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 31646191 | 31646191 | PRJNA1008624_P_NODE_27317_length_169_cov_0.866667_g27129_i0 | PRJNA1008624 | 27317 | 169 | 0.866667 | 1.46466723 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 43.1 | 0.00972 | NR | XP_020905723.1 | 2652724 | g27129 | i0 | 70.8 | 1.91715976331361 | 24 | 7 | 42.6 | 0 | 158 | 87 | 78 | 101 | XP_020905723.1 uncharacterized protein LOC110243908 [Exaiptasia diaphana] | diamond | 324 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 32588118 | 32588118 | PRJNA1008624_P_NODE_1139_length_808_cov_2.105402_g1003_i0 | PRJNA1008624 | 1139 | 808 | 2.105402 | 17.01164816 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 225 | 4.09e-64 | NR | XP_068750978.1 | 246305 | g1003 | i0 | 45.5 | 11.3056930693069 | 253 | 135 | 93.6 | 2 | 5 | 760 | 562 | 812 | XP_068750978.1 uncharacterized protein [Montipora capricornis] | diamond | 9135 | 225 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis |
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);;