contig_metadata
7 rows where bioproject = "PRJEB28589", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1300224 | 1300224 | PRJEB28589_S_NODE_1862_length_423_cov_1.981383_g1754_i0 | PRJEB28589 | 1862 | 423 | 1.981383 | 8.38125009 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 52.8 | 0.041 | NTclustered | gi|2202666560|ref|XR_006951441.1| | 2897299 | g1754 | i0 | 100 | 0.066193853427896 | 28 | 0 | 7 | 0 | 1 | 28 | 1 | 28 | PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 6404160 | 6404160 | PRJEB28589_S_NODE_15926_length_179_cov_1.537879_g15818_i0 | PRJEB28589 | 15926 | 179 | 1.537879 | 2.75280341 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|2202666560|ref|XR_006951441.1| | 2897299 | g15818 | i0 | 100 | 0.156424581005587 | 28 | 0 | 16 | 0 | 1 | 28 | 1 | 28 | PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 24251738 | 24251738 | PRJEB28589_S_NODE_1060_length_516_cov_28.066098_g957_i0 | PRJEB28589 | 1060 | 516 | 28.066098 | 144.82106568 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.004 | NTclustered | gi|2918369535|emb|OZ237717.1| | 317547 | g957 | i0 | 100 | 0.0581395348837209 | 30 | 0 | 6 | 0 | 459 | 488 | 36194299 | 36194270 | Eunicella cavolini genome assembly, chromosome: 1 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 27722177 | 27722177 | PRJEB28589_S_NODE_16964_length_170_cov_1.455285_g16856_i0 | PRJEB28589 | 16964 | 170 | 1.455285 | 2.4739845 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 81.3 | 3.68e-16 | NR | XP_031552906.1 | 6105 | g16856 | i0 | 97.2 | 502.323529411765 | 36 | 1 | 63.5 | 0 | 151 | 44 | 1551 | 1586 | XP_031552906.1 disco-interacting protein 2-like [Actinia tenebrosa] | diamond | 85395 | 82 | 0.991463414634146 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28580849 | 28580849 | PRJEB28589_S_NODE_11247_length_231_cov_1.108696_g11139_i0 | PRJEB28589 | 11247 | 231 | 1.108696 | 2.56108776 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 48.9 | 2.15e-4 | NR | RMX51535.1 | 46731 | g11139 | i0 | 47.3 | 0.714285714285714 | 55 | 28 | 70.1 | 1 | 231 | 70 | 431 | 485 | RMX51535.1 hypothetical protein pdam_00010321 [Pocillopora damicornis] | diamond | 165 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 32144814 | 32144814 | PRJEB28589_S_NODE_17198_length_168_cov_1.933884_g17090_i0 | PRJEB28589 | 17198 | 168 | 1.933884 | 3.24892512 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 53.1 | 2.84e-6 | NR | XP_065644490.1 | 6087 | g17090 | i0 | 54.2 | 2.57142857142857 | 48 | 22 | 85.7 | 0 | 23 | 166 | 586 | 633 | XP_065644490.1 uncharacterized protein LOC136075392 isoform X1 [Hydra vulgaris] | diamond | 432 | 53.5 | 0.992523364485981 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 32303284 | 32303284 | PRJEB28589_S_NODE_18179_length_162_cov_1.556522_g18071_i0 | PRJEB28589 | 18179 | 162 | 1.556522 | 2.52156564 | Acropora | 6127 | Cnidaria | other_Eukaryota | 67 | 2.15e-11 | NR | XP_015779512.1 | 70779 | g18071 | i0 | 60.8 | 4.64814814814815 | 51 | 18 | 90.7 | 1 | 162 | 16 | 21 | 71 | XP_015779512.1 PREDICTED: uncharacterized protein LOC107357391 [Acropora digitifera] | diamond | 753 | 67 | 1 | 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);;