contig_metadata
6 rows where bioproject = "PRJNA922890", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9825533 | 9825533 | PRJNA922890_P_NODE_27608_length_363_cov_0.823129_g27198_i0 | PRJNA922890 | 27608 | 363 | 0.823129 | 2.98795827 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 379 | 1.39e-100 | NTclustered | gi|2782844603|ref|XM_067056021.1| | 252671 | g27198 | i0 | 85.915 | 93.5674931129477 | 355 | 50 | 98 | 0 | 8 | 362 | 1398 | 1044 | PREDICTED: Clytia hemisphaerica tubulin beta-4B chain (LOC136799316), mRNA | blastn | 33965 | 379 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 27600837 | 27600837 | PRJNA922890_P_NODE_80444_length_229_cov_1.481250_g80034_i0 | PRJNA922890 | 80444 | 229 | 1.48125 | 3.3920625 | root | 1 | Root_unresolved | Root_unresolved | 94 | 2.88e-20 | NR | XP_065052198.1 | 499914 | g80034 | i0 | 67.6 | 2.89519650655022 | 71 | 23 | 93 | 0 | 11 | 223 | 473 | 543 | XP_065052198.1 uncharacterized protein LOC135681586 [Rhopilema esculentum] | diamond | 663 | 94.4 | 0.995762711864407 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 28705855 | 28705855 | PRJNA922890_P_NODE_84267_length_227_cov_3.417722_g83857_i0 | PRJNA922890 | 84267 | 227 | 3.417722 | 7.75822894 | root | 1 | Root_unresolved | Root_unresolved | 44.3 | 0.00868 | NR | PFX21664.1 | 50429 | g83857 | i0 | 42.2 | 1.08370044052863 | 45 | 26 | 59.5 | 0 | 75 | 209 | 230 | 274 | PFX21664.1 hypothetical protein AWC38_SpisGene13848 [Stylophora pistillata] | diamond | 246 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 29495087 | 29495087 | PRJNA922890_P_NODE_53730_length_266_cov_2.279188_g53320_i0 | PRJNA922890 | 53730 | 266 | 2.279188 | 6.06264008 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 75.9 | 5.72e-14 | NR | XP_057309343.1 | 13093 | g53320 | i0 | 54.7 | 3.57518796992481 | 64 | 29 | 72.2 | 0 | 266 | 75 | 203 | 266 | XP_057309343.1 60S acidic ribosomal protein P0-like [Hydractinia symbiolongicarpus] | diamond | 951 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 30790208 | 30790208 | PRJNA922890_P_NODE_82314_length_228_cov_3.477987_g81904_i0 | PRJNA922890 | 82314 | 228 | 3.477987 | 7.92981036 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 51.6 | 2.32e-5 | NR | XP_048582845.1 | 45351 | g81904 | i0 | 54.8 | 1.06578947368421 | 42 | 19 | 55.3 | 0 | 228 | 103 | 334 | 375 | XP_048582845.1 ubiquitin carboxyl-terminal hydrolase 14 [Nematostella vectensis] | diamond | 243 | 52 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 31232389 | 31232389 | PRJNA922890_P_NODE_84015_length_228_cov_0.905660_g83605_i0 | PRJNA922890 | 84015 | 228 | 0.90566 | 2.0649048 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 99 | 5.93e-24 | NR | XP_015754731.1 | 70779 | g83605 | i0 | 77.3 | 20.2105263157895 | 66 | 15 | 86.8 | 0 | 198 | 1 | 79 | 144 | XP_015754731.1 PREDICTED: 60S ribosomal protein L17-like isoform X1 [Acropora digitifera] | diamond | 4608 | 99.8 | 0.991983967935872 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera |
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);;