contig_metadata
11 rows where bioproject = "PRJNA385073" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9334775 | 9334775 | PRJNA385073_P_NODE_9168_length_420_cov_1.579251_g9007_i0 | PRJNA385073 | 9168 | 420 | 1.579251 | 6.6328542 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 119 | 3.93e-22 | NTclustered | gi|1005425980|ref|XR_001560994.1| | 70779 | g9007 | i0 | 94.872 | 16.1547619047619 | 78 | 0 | 18 | 3 | 166 | 241 | 6 | 81 | PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X7, ncRNA | blastn | 6785 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 13159656 | 13159656 | PRJNA385073_P_NODE_34231_length_267_cov_2.814433_g34069_i0 | PRJNA385073 | 34231 | 267 | 2.814433 | 7.51453611 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 52.8 | 0.024 | NTclustered | gi|2113918517|ref|XM_044307546.1| | 45264 | g34069 | i0 | 100 | 0.209737827715356 | 28 | 0 | 10 | 0 | 191 | 218 | 1240 | 1267 | PREDICTED: Acropora millepora TNF receptor-associated factor 5-like (LOC114953597), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 16983013 | 16983013 | PRJNA385073_P_NODE_20974_length_313_cov_1.925000_g20812_i0 | PRJNA385073 | 20974 | 313 | 1.925 | 6.02525 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 138 | 1.9999999999999997e-37 | NR | XP_001631784.1 | 45351 | g20812 | i0 | 67.8 | 6.08626198083067 | 90 | 29 | 86.3 | 0 | 273 | 4 | 3 | 92 | XP_001631784.1 receptor of activated protein C kinase 1 [Nematostella vectensis] | diamond | 1905 | 138 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 19532008 | 19532008 | PRJNA385073_P_NODE_45176_length_249_cov_0.875000_g45014_i0 | PRJNA385073 | 45176 | 249 | 0.875 | 2.17875 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|224287098|gb|AC234868.1| | 13093 | g45014 | i0 | 96.875 | 0.257028112449799 | 32 | 0 | 12 | 1 | 133 | 163 | 785 | 816 | Hydractinia symbiolongicarpus clone YU00-066K10, complete sequence | blastn | 64 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 20808226 | 20808226 | PRJNA385073_P_NODE_8317_length_436_cov_2.093664_g8156_i0 | PRJNA385073 | 8317 | 436 | 2.093664 | 9.12837504 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 146 | 5.499999999999999e-38 | NR | PFX23400.1 | 50429 | g8156 | i0 | 62.6 | 0.901376146788991 | 131 | 49 | 90.1 | 0 | 3 | 395 | 417 | 547 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 393 | 146 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 26758595 | 26758595 | PRJNA385073_P_NODE_59761_length_239_cov_4.795181_g59599_i0 | PRJNA385073 | 59761 | 239 | 4.795181 | 11.46048259 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 89.7 | 1.01e-18 | NR | PFX23400.1 | 50429 | g59599 | i0 | 75.8 | 0.778242677824268 | 62 | 15 | 77.8 | 0 | 237 | 52 | 486 | 547 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 186 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 26853919 | 26853919 | PRJNA385073_P_NODE_15601_length_347_cov_3.244526_g15440_i0 | PRJNA385073 | 15601 | 347 | 3.244526 | 11.25850522 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 157 | 1.3899999999999996e-42 | NR | PFX23400.1 | 50429 | g15440 | i0 | 81.6 | 0.985590778097983 | 114 | 21 | 98.6 | 0 | 343 | 2 | 326 | 439 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 342 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 27328181 | 27328181 | PRJNA385073_P_NODE_47523_length_247_cov_3.551724_g47361_i0 | PRJNA385073 | 47523 | 247 | 3.551724 | 8.77275828 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 88.6 | 2.78e-18 | NR | PFX23400.1 | 50429 | g47361 | i0 | 70.6 | 0.825910931174089 | 68 | 20 | 82.6 | 0 | 3 | 206 | 480 | 547 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 204 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 28955506 | 28955506 | PRJNA385073_P_NODE_56808_length_242_cov_0.911243_g56646_i0 | PRJNA385073 | 56808 | 242 | 0.911243 | 2.20520806 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 47 | 0.001 | NR | XP_020626096.1 | 48498 | g56646 | i0 | 81 | 0.78099173553719 | 21 | 4 | 26 | 0 | 235 | 173 | 212 | 232 | XP_020626096.1 L-rhamnose-binding lectin CSL3-like [Orbicella faveolata] | diamond | 189 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 31971714 | 31971714 | PRJNA385073_P_NODE_23218_length_303_cov_1.339130_g23056_i0 | PRJNA385073 | 23218 | 303 | 1.33913 | 4.0575639 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 147 | 1.56e-40 | NR | XP_020915026.1 | 2652724 | g23056 | i0 | 69.1 | 1.91089108910891 | 97 | 30 | 96 | 0 | 293 | 3 | 5 | 101 | XP_020915026.1 peptidyl-prolyl cis-trans isomerase D [Exaiptasia diaphana] | diamond | 579 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 32541588 | 32541588 | PRJNA385073_P_NODE_33419_length_269_cov_4.010204_g33257_i0 | PRJNA385073 | 33419 | 269 | 4.010204 | 10.78744876 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 119 | 6.77e-29 | NR | PFX23400.1 | 50429 | g33257 | i0 | 76.4 | 0.992565055762082 | 89 | 21 | 99.3 | 0 | 1 | 267 | 332 | 420 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 267 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata |
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);;