contig_metadata
12 rows where bioproject = "PRJNA478247", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5551408 | 5551408 | PRJNA478247_P_NODE_1065_length_390_cov_4.426593_g959_i0 | PRJNA478247 | 1065 | 390 | 4.4265930000000004 | 17.2637127 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 85.5 | 1.35e-18 | NR | XP_027052219.1 | 46731 | g959 | i0 | 62.3 | 0.530769230769231 | 69 | 26 | 53.1 | 0 | 18 | 224 | 1 | 69 | XP_027052219.1 60S acidic ribosomal protein P2-like [Pocillopora damicornis] | diamond | 207 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 13201395 | 13201395 | PRJNA478247_P_NODE_2611_length_202_cov_2.092486_g2505_i0 | PRJNA478247 | 2611 | 202 | 2.092486 | 4.22682172 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 87.8 | 2.86e-19 | NR | KAJ7383107.1 | 174260 | g2505 | i0 | 71.7 | 2.40594059405941 | 53 | 15 | 78.7 | 0 | 43 | 201 | 12 | 64 | KAJ7383107.1 Cathepsin L [Desmophyllum pertusum] | diamond | 486 | 88.6 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 15750419 | 15750419 | PRJNA478247_P_NODE_973_length_415_cov_3.753886_g867_i0 | PRJNA478247 | 973 | 415 | 3.753886 | 15.5786269 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 219 | 1.01e-70 | NR | XP_029193069.2 | 45264 | g867 | i0 | 80.2 | 50.8987951807229 | 131 | 26 | 94.7 | 0 | 415 | 23 | 19 | 149 | XP_029193069.2 40S ribosomal protein S15a isoform X1 [Acropora millepora] | diamond | 21123 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 18299342 | 18299342 | PRJNA478247_P_NODE_1675_length_281_cov_9.099206_g1569_i0 | PRJNA478247 | 1675 | 281 | 9.099206 | 25.56876886 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 294 | 3.8999999999999996e-75 | NTclustered | gi|2729078994|ref|XM_065201878.1| | 499914 | g1569 | i0 | 85.87 | 186.334519572954 | 276 | 39 | 98 | 0 | 1 | 276 | 1353 | 1078 | PREDICTED: Rhopilema esculentum polyubiquitin-C (LOC135685806), mRNA | blastn | 52360 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 27029092 | 27029092 | PRJNA478247_P_NODE_1622_length_287_cov_3.503876_g1516_i0 | PRJNA478247 | 1622 | 287 | 3.503876 | 10.05612412 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 76.3 | 1.72e-15 | NR | XP_022806335.1 | 50429 | g1516 | i0 | 54.7 | 4.71428571428571 | 64 | 29 | 66.9 | 0 | 276 | 85 | 4 | 67 | XP_022806335.1 60S acidic ribosomal protein P1-like [Stylophora pistillata] | diamond | 1353 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 27487070 | 27487070 | PRJNA478247_P_NODE_1703_length_278_cov_2.100402_g1597_i0 | PRJNA478247 | 1703 | 278 | 2.100402 | 5.83911756 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 117 | 5.339999999999999e-31 | NR | XP_020626092.1 | 48498 | g1597 | i0 | 59.8 | 2.90287769784173 | 92 | 37 | 99.3 | 0 | 278 | 3 | 59 | 150 | XP_020626092.1 protein disulfide-isomerase-like [Orbicella faveolata] | diamond | 807 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 31308523 | 31308523 | PRJNA478247_P_NODE_2595_length_203_cov_1.810345_g2489_i0 | PRJNA478247 | 2595 | 203 | 1.810345 | 3.67500035 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 74.7 | 1.02e-13 | NR | XP_027043563.1 | 46731 | g2489 | i0 | 51.5 | 7.3743842364532 | 68 | 31 | 99 | 2 | 1 | 201 | 295 | 361 | XP_027043563.1 proliferation-associated protein 2G4-like [Pocillopora damicornis] | diamond | 1497 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 31372049 | 31372049 | PRJNA478247_P_NODE_1376_length_326_cov_2.484848_g1270_i0 | PRJNA478247 | 1376 | 326 | 2.484848 | 8.10060448 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 90.1 | 3.55e-20 | NR | XP_065062566.1 | 499914 | g1270 | i0 | 43.6 | 2.15337423312883 | 117 | 52 | 99.4 | 6 | 2 | 325 | 34 | 145 | XP_065062566.1 ganglioside GM2 activator-like [Rhopilema esculentum] | diamond | 702 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 31514740 | 31514740 | PRJNA478247_P_NODE_1056_length_392_cov_3.578512_g950_i0 | PRJNA478247 | 1056 | 392 | 3.578512 | 14.02776704 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 117 | 6.78e-31 | NR | XP_028407708.1 | 151771 | g950 | i0 | 60.3 | 2.66326530612245 | 116 | 46 | 88.8 | 0 | 45 | 392 | 5 | 120 | XP_028407708.1 60S ribosomal protein L35-like [Dendronephthya gigantea] | diamond | 1044 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 32004540 | 32004540 | PRJNA478247_P_NODE_1578_length_293_cov_2.367424_g1472_i0 | PRJNA478247 | 1578 | 293 | 2.367424 | 6.93655232 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 43.5 | 0.0355 | NR | CAB4017677.1 | 317549 | g1472 | i0 | 34.3 | 0.686006825938567 | 67 | 39 | 68.6 | 1 | 27 | 227 | 461 | 522 | CAB4017677.1 sonic hedgehog [Paramuricea clavata] | diamond | 201 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 32067671 | 32067671 | PRJNA478247_P_NODE_1718_length_276_cov_1.955466_g1612_i0 | PRJNA478247 | 1718 | 276 | 1.955466 | 5.39708616 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 87.8 | 4.23e-20 | NR | EDO42145.1 | 45351 | g1612 | i0 | 68.8 | 4.33695652173913 | 64 | 19 | 69.6 | 1 | 83 | 274 | 9 | 71 | EDO42145.1 predicted protein, partial [Nematostella vectensis] | diamond | 1197 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 32621483 | 32621483 | PRJNA478247_P_NODE_1580_length_293_cov_2.193182_g1474_i0 | PRJNA478247 | 1580 | 293 | 2.193182 | 6.42602326 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 43.5 | 0.0348 | NR | XP_027039304.1 | 46731 | g1474 | i0 | 43.6 | 1.30034129692833 | 39 | 22 | 39.9 | 0 | 136 | 20 | 35 | 73 | XP_027039304.1 TNF receptor-associated factor 3-like isoform X2 [Pocillopora damicornis] | diamond | 381 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis |
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);;