contig_metadata
15 rows where bioproject = "PRJNA596870", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1843944 | 1843944 | PRJNA596870_P_NODE_24142_length_276_cov_1.137931_g24009_i0 | PRJNA596870 | 24142 | 276 | 1.137931 | 3.14068956 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 93.5 | 1.5e-14 | NTclustered | gi|2518995612|ref|XM_057449052.1| | 13093 | g24009 | i0 | 85.393 | 0.322463768115942 | 89 | 13 | 32 | 0 | 187 | 275 | 1334 | 1246 | PREDICTED: Hydractinia symbiolongicarpus guanine nucleotide-binding protein subunit beta-4 (LOC130641997), mRNA | blastn | 89 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 3691923 | 3691923 | PRJNA596870_P_NODE_16643_length_323_cov_1.320000_g16510_i0 | PRJNA596870 | 16643 | 323 | 1.32 | 4.2636 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 291 | 5.9e-74 | NTclustered | gi|2519007827|ref|XM_057455710.1| | 13093 | g16510 | i0 | 83.23 | 99.5696594427245 | 322 | 48 | 99 | 6 | 5 | 323 | 960 | 642 | PREDICTED: Hydractinia symbiolongicarpus actin, non-muscle 6.2 (LOC130649433), mRNA | blastn | 32161 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 3691996 | 3691996 | PRJNA596870_P_NODE_31923_length_249_cov_0.875000_g31790_i0 | PRJNA596870 | 31923 | 249 | 0.875 | 2.17875 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 204 | 5.879999999999999e-48 | NTclustered | gi|2257805361|ref|XM_032381931.2| | 45351 | g31790 | i0 | 88.235 | 67.8353413654618 | 170 | 20 | 68 | 0 | 4 | 173 | 307 | 138 | PREDICTED: Nematostella vectensis tubulin alpha-2/alpha-4 chain (LOC116618368), mRNA | blastn | 16891 | 206 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 4968636 | 4968636 | PRJNA596870_P_NODE_25864_length_267_cov_1.556701_g25731_i0 | PRJNA596870 | 25864 | 267 | 1.556701 | 4.15639167 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|1524872234|ref|XM_027187692.1| | 46731 | g25731 | i0 | 92.5 | 0.299625468164794 | 40 | 2 | 15 | 1 | 77 | 115 | 41 | 80 | PREDICTED: Pocillopora damicornis THO complex subunit 4-like (LOC113671482), mRNA | blastn | 80 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 15871401 | 15871401 | PRJNA596870_P_NODE_6273_length_488_cov_2.036145_g6140_i0 | PRJNA596870 | 6273 | 488 | 2.036145 | 9.9363876 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 549 | 1.3799999999999994e-151 | NTclustered | gi|2782873191|ref|XM_067061560.1| | 252671 | g6140 | i0 | 87.164 | 96.5348360655738 | 483 | 62 | 99 | 0 | 6 | 488 | 1451 | 969 | PREDICTED: Clytia hemisphaerica tubulin alpha-2/alpha-4 chain (LOC136805028), mRNA | blastn | 47109 | 549 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 17145917 | 17145917 | PRJNA596870_P_NODE_1994_length_810_cov_2.413840_g1882_i0 | PRJNA596870 | 1994 | 810 | 2.41384 | 19.552104 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 769 | 0 | NTclustered | gi|2782873191|ref|XM_067061560.1| | 252671 | g1882 | i0 | 85.793 | 89.341975308642 | 725 | 103 | 90 | 0 | 85 | 809 | 1466 | 742 | PREDICTED: Clytia hemisphaerica tubulin alpha-2/alpha-4 chain (LOC136805028), mRNA | blastn | 72367 | 769 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 17146071 | 17146071 | PRJNA596870_P_NODE_27514_length_258_cov_1.610811_g27381_i0 | PRJNA596870 | 27514 | 258 | 1.610811 | 4.15589238 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 88.6 | 3.41e-18 | NR | XP_028406015.1 | 151771 | g27381 | i0 | 52.9 | 1.94186046511628 | 85 | 40 | 98.8 | 0 | 4 | 258 | 1 | 85 | XP_028406015.1 glutamate--cysteine ligase catalytic subunit-like [Dendronephthya gigantea] | diamond | 501 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 22245603 | 22245603 | PRJNA596870_P_NODE_31478_length_249_cov_0.875000_g31345_i0 | PRJNA596870 | 31478 | 249 | 0.875 | 2.17875 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 58.4 | 4.84e-4 | NTclustered | gi|2917940745|emb|OZ237569.1| | 6108 | g31345 | i0 | 100 | 3.91967871485944 | 31 | 0 | 12 | 0 | 67 | 97 | 296311 | 296281 | Anemonia sulcata genome assembly, chromosome: 15 | blastn | 976 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 27617030 | 27617030 | PRJNA596870_P_NODE_31464_length_249_cov_0.875000_g31331_i0 | PRJNA596870 | 31464 | 249 | 0.875 | 2.17875 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 50.4 | 7.85e-5 | NR | XP_028409898.1 | 151771 | g31331 | i0 | 39.5 | 0.975903614457831 | 81 | 47 | 95.2 | 2 | 242 | 6 | 1877 | 1957 | XP_028409898.1 uncharacterized protein LOC114532567 [Dendronephthya gigantea] | diamond | 243 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 28722099 | 28722099 | PRJNA596870_P_NODE_30247_length_250_cov_0.870056_g30114_i0 | PRJNA596870 | 30247 | 250 | 0.870056 | 2.17514 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 83.2 | 2.39e-16 | NR | CAH3020291.1 | 104178 | g30114 | i0 | 54.5 | 0.924 | 77 | 35 | 92.4 | 0 | 231 | 1 | 222 | 298 | CAH3020291.1 unnamed protein product [Porites evermanni] | diamond | 231 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 29290280 | 29290280 | PRJNA596870_P_NODE_32049_length_249_cov_0.875000_g31916_i0 | PRJNA596870 | 32049 | 249 | 0.875 | 2.17875 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 72.8 | 8.72e-13 | NR | CAB3996609.1 | 317549 | g31916 | i0 | 44.4 | 4.51807228915663 | 81 | 45 | 97.6 | 0 | 2 | 244 | 216 | 296 | CAB3996609.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 1125 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 29447967 | 29447967 | PRJNA596870_P_NODE_31010_length_250_cov_0.870056_g30877_i0 | PRJNA596870 | 31010 | 250 | 0.870056 | 2.17514 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 129 | 1.7099999999999998e-35 | NR | XP_065643016.1 | 6087 | g30877 | i0 | 72.3 | 16.92 | 83 | 23 | 99.6 | 0 | 250 | 2 | 30 | 112 | XP_065643016.1 small ribosomal subunit protein uS7 isoform X2 [Hydra vulgaris] | diamond | 4230 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29542824 | 29542824 | PRJNA596870_P_NODE_39610_length_241_cov_0.916667_g39477_i0 | PRJNA596870 | 39610 | 241 | 0.916667 | 2.20916747 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 78.6 | 8.7e-15 | NR | XP_065649284.1 | 6087 | g39477 | i0 | 50 | 1.91701244813278 | 76 | 37 | 94.6 | 1 | 230 | 3 | 172 | 246 | XP_065649284.1 uncharacterized protein LOC136078150 [Hydra vulgaris] | diamond | 462 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 30504005 | 30504005 | PRJNA596870_P_NODE_32733_length_248_cov_0.880000_g32600_i0 | PRJNA596870 | 32733 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 85.9 | 9.82e-18 | NR | XP_057312634.1 | 13093 | g32600 | i0 | 48.1 | 1.97177419354839 | 81 | 42 | 98 | 0 | 1 | 243 | 105 | 185 | XP_057312634.1 eukaryotic translation initiation factor 3 subunit H-like [Hydractinia symbiolongicarpus] | diamond | 489 | 86.3 | 0.995365005793743 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 31452207 | 31452207 | PRJNA596870_P_NODE_38696_length_242_cov_0.911243_g38563_i0 | PRJNA596870 | 38696 | 242 | 0.911243 | 2.20520806 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 100 | 1.97e-24 | NR | XP_020630702.1 | 48498 | g38563 | i0 | 62.5 | 19.7355371900826 | 80 | 29 | 99.2 | 1 | 241 | 2 | 21 | 99 | XP_020630702.1 40S ribosomal protein S7-like [Orbicella faveolata] | diamond | 4776 | 101 | 0.99009900990099 | 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);;