contig_metadata
15 rows where bioproject = "PRJNA340009", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 392284 | 392284 | PRJNA340009_P_NODE_47621_length_187_cov_1.847826_g47314_i0 | PRJNA340009 | 47621 | 187 | 1.847826 | 3.45543462 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2918369558|emb|OZ237728.1| | 317547 | g47314 | i0 | 96.97 | 0.176470588235294 | 33 | 1 | 18 | 0 | 4 | 36 | 1794363 | 1794331 | Eunicella cavolini genome assembly, chromosome: 12 | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 1070043 | 1070043 | PRJNA340009_P_NODE_39341_length_202_cov_56.222222_g39034_i0 | PRJNA340009 | 39341 | 202 | 56.222222 | 113.56888844 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 75 | 3.75e-9 | NTclustered | gi|2257873035|ref|XM_001636570.3| | 45351 | g39034 | i0 | 88.525 | 5.59405940594059 | 61 | 7 | 30 | 0 | 19 | 79 | 1433 | 1493 | PREDICTED: Nematostella vectensis tubulin alpha-1A chain (LOC5516629), mRNA | blastn | 1130 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 2942513 | 2942513 | PRJNA340009_P_NODE_15803_length_299_cov_1.520000_g15496_i0 | PRJNA340009 | 15803 | 299 | 1.52 | 4.5448 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 111 | 4.639999999999999e-28 | NR | EDO39969.1 | 45351 | g15496 | i0 | 62.8 | 15.1103678929766 | 94 | 33 | 94.3 | 2 | 283 | 2 | 19 | 110 | EDO39969.1 predicted protein [Nematostella vectensis] | diamond | 4518 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 3620718 | 3620718 | PRJNA340009_P_NODE_48823_length_185_cov_2.250000_g48516_i0 | PRJNA340009 | 48823 | 185 | 2.25 | 4.1625 | root | 1 | Root_unresolved | Root_unresolved | 83.2 | 7.95e-17 | NR | KAF0993178.1 | 69463 | g48516 | i0 | 70 | 21 | 60 | 18 | 97.3 | 0 | 183 | 4 | 251 | 310 | KAF0993178.1 hypothetical protein HZS_826 [Henneguya salminicola] | diamond | 3885 | 84 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 5495596 | 5495596 | PRJNA340009_P_NODE_21285_length_263_cov_1.429907_g20978_i0 | PRJNA340009 | 21285 | 263 | 1.429907 | 3.76065541 | Heteropolypus sp. | 3097316 | Cnidaria | other_Eukaryota | 150 | 8.279999999999998e-32 | NTclustered | gi|2689317291|gb|PP410741.1| | 3097316 | g20978 | i0 | 86.861 | 81.2319391634981 | 137 | 15 | 51 | 2 | 21 | 155 | 2188 | 2053 | Heteropolypus sp. voucher RB-19-192 large subunit ribosomal RNA gene, partial sequence | blastn | 21364 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Coralliidae | Heteropolypus | Heteropolypus sp. | |
| 10595729 | 10595729 | PRJNA340009_P_NODE_24469_length_248_cov_1.025126_g24162_i0 | PRJNA340009 | 24469 | 248 | 1.025126 | 2.54231248 | cf. Latyspora sp. AK-2014 | 1483226 | Cnidaria | other_Eukaryota | 113 | 1.01e-20 | NTclustered | gi|605060085|gb|KF874225.1| | 1483226 | g24162 | i0 | 85.981 | 42.2096774193548 | 107 | 13 | 43 | 2 | 142 | 248 | 1067 | 963 | Cf. Latyspora sp. AK-2014 28S ribosomal RNA gene, partial sequence | blastn | 10468 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | cf. Latyspora sp. AK-2014 | |||
| 13145967 | 13145967 | PRJNA340009_P_NODE_5511_length_459_cov_4.495122_g5204_i0 | PRJNA340009 | 5511 | 459 | 4.495122 | 20.63260998 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 335 | 3.9499999999999984e-87 | NTclustered | gi|1619698735|ref|XM_021060602.2| | 2652724 | g5204 | i0 | 81.5 | 83.3507625272331 | 400 | 70 | 87 | 4 | 11 | 408 | 25 | 422 | PREDICTED: Exaiptasia diaphana histone H3 (LOC110253653), mRNA | blastn | 38258 | 335 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 18243829 | 18243829 | PRJNA340009_P_NODE_43755_length_193_cov_20.618056_g43448_i0 | PRJNA340009 | 43755 | 193 | 20.618056 | 39.79284808 | Malo kingi | 500532 | Cnidaria | other_Eukaryota | 117 | 5.82e-22 | NTclustered | gi|265141568|gb|EU878255.1| | 500532 | g43448 | i0 | 86.792 | 5.73575129533679 | 106 | 12 | 54 | 2 | 87 | 191 | 2236 | 2132 | Malo kingi clone Mk-BJA-1 non-muscle actin 6.2 mRNA, complete cds | blastn | 1107 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Cubozoa | Carybdeida | Carukiidae | Malo | Malo kingi | |
| 18244116 | 18244116 | PRJNA340009_P_NODE_735_length_1052_cov_11.444666_g524_i0 | PRJNA340009 | 735 | 1052 | 11.444666 | 120.39788632 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 95.3 | 1.75e-14 | NTclustered | gi|2257858806|ref|XR_007306876.1| | 45351 | g524 | i0 | 95 | 5.57984790874525 | 60 | 3 | 6 | 0 | 492 | 551 | 3324 | 3383 | PREDICTED: Nematostella vectensis large subunit ribosomal RNA (LOC125560793), rRNA | blastn | 5870 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 23344295 | 23344295 | PRJNA340009_P_NODE_56319_length_174_cov_1.632000_g56012_i0 | PRJNA340009 | 56319 | 174 | 1.632 | 2.83968 | Zanclea sp. ZX JRH-2014 | 1483213 | Cnidaria | other_Eukaryota | 89.8 | 1.12e-13 | NTclustered | gi|608606704|gb|KF962379.1| | 1483213 | g56012 | i0 | 89.855 | 34.7701149425287 | 69 | 7 | 40 | 0 | 6 | 74 | 3126 | 3194 | Zanclea sp. ZX JRH-2014 voucher XMZS7 28S ribosomal RNA gene, partial sequence | blastn | 6050 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Zancleidae | Zanclea | Zanclea sp. ZX JRH-2014 | |
| 27643580 | 27643580 | PRJNA340009_P_NODE_37264_length_207_cov_2.455696_g36957_i0 | PRJNA340009 | 37264 | 207 | 2.455696 | 5.08329072 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 46.2 | 0.00122 | NR | XP_022802503.1 | 50429 | g36957 | i0 | 40.3 | 1.94202898550725 | 67 | 31 | 97.1 | 3 | 4 | 204 | 3 | 60 | XP_022802503.1 uncharacterized protein LOC111340009 [Stylophora pistillata] | diamond | 402 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 27801355 | 27801355 | PRJNA340009_P_NODE_41584_length_198_cov_1.369128_g41277_i0 | PRJNA340009 | 41584 | 198 | 1.369128 | 2.71087344 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 69.3 | 8.55e-12 | NR | XP_020605851.1 | 48498 | g41277 | i0 | 54.2 | 2.68181818181818 | 59 | 26 | 87.9 | 1 | 197 | 24 | 550 | 608 | XP_020605851.1 E3 ubiquitin-protein ligase TRIM71-like [Orbicella faveolata] | diamond | 531 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 32273509 | 32273509 | PRJNA340009_P_NODE_46698_length_188_cov_5.273381_g46391_i0 | PRJNA340009 | 46698 | 188 | 5.273381 | 9.91395628 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.00275 | NR | PFX21664.1 | 50429 | g46391 | i0 | 42.2 | 1.30851063829787 | 45 | 26 | 71.8 | 0 | 9 | 143 | 230 | 274 | PFX21664.1 hypothetical protein AWC38_SpisGene13848 [Stylophora pistillata] | diamond | 246 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 32635169 | 32635169 | PRJNA340009_P_NODE_51980_length_180_cov_2.816794_g51673_i0 | PRJNA340009 | 51980 | 180 | 2.816794 | 5.0702292 | Pocillopora meandrina | 46732 | Cnidaria | other_Eukaryota | 45.4 | 0.0018 | NR | CAH3105018.1 | 46732 | g51673 | i0 | 47.8 | 0.766666666666667 | 46 | 24 | 76.7 | 0 | 29 | 166 | 153 | 198 | CAH3105018.1 unnamed protein product [Pocillopora meandrina] | diamond | 138 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora meandrina | |
| 32824344 | 32824344 | PRJNA340009_P_NODE_27820_length_234_cov_4.005405_g27513_i0 | PRJNA340009 | 27820 | 234 | 4.005405 | 9.3726477 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 45.4 | 0.00103 | NR | XP_020623061.1 | 48498 | g27513 | i0 | 49 | 0.628205128205128 | 49 | 22 | 62.8 | 2 | 148 | 2 | 1 | 46 | XP_020623061.1 coactosin-like protein, partial [Orbicella faveolata] | diamond | 147 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata |
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);;