contig_metadata
14 rows where bioproject = "PRJNA788929" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 769334 | 769334 | PRJNA788929_P_NODE_29581_length_290_cov_17.995392_g28920_i0 | PRJNA788929 | 29581 | 290 | 17.995392 | 52.1866368 | Chiropsalmus sp. AGC-2001 | 168723 | Cnidaria | other_Eukaryota | 171 | 7.109999999999999e-38 | NTclustered | gi|66864846|gb|AY920786.1| | 168723 | g28920 | i0 | 91.935 | 42.7172413793103 | 124 | 6 | 43 | 1 | 11 | 134 | 2378 | 2259 | Chiropsalmus sp. AGC-2001 large subunit 28S ribosomal RNA gene, partial sequence | blastn | 12388 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Cubozoa | Chirodropida | Chiropsalmidae | Chiropsalmus | Chiropsalmus sp. AGC-2001 | |
| 3320769 | 3320769 | PRJNA788929_P_NODE_4023_length_1020_cov_45.826822_g3542_i0 | PRJNA788929 | 4023 | 1020 | 45.826822 | 467.4335844 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 184 | 6.34e-48 | NR | XP_065669112.1 | 6087 | g3542 | i0 | 43.3 | 8.03529411764706 | 238 | 120 | 68.5 | 5 | 224 | 922 | 683 | 910 | XP_065669112.1 uncharacterized protein LOC100212061 isoform X3 [Hydra vulgaris] | diamond | 8196 | 184 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 4597423 | 4597423 | PRJNA788929_P_NODE_18044_length_389_cov_6.174051_g17384_i0 | PRJNA788929 | 18044 | 389 | 6.174051 | 24.01705839 | Galaxea astreata | 154325 | Cnidaria | other_Eukaryota | 54.7 | 0.01 | NTclustered | gi|640940784|gb|KJ591050.1| | 154325 | g17384 | i0 | 100 | 0.0745501285347044 | 29 | 0 | 7 | 0 | 359 | 387 | 29 | 1 | Galaxea astreata ferritin mRNA, complete cds | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Euphylliidae | Galaxea | Galaxea astreata | |
| 5042458 | 5042458 | PRJNA788929_P_NODE_2244_length_1406_cov_74.930233_g1959_i0 | PRJNA788929 | 2244 | 1406 | 74.930233 | 1053.51907598 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 0.003 | NTclustered | gi|1270076714|ref|XM_022945720.1| | 50429 | g1959 | i0 | 76.86 | 0.601706970128023 | 121 | 17 | 8 | 10 | 977 | 1090 | 464 | 580 | PREDICTED: Stylophora pistillata caldesmon-like (LOC111339130), transcript variant X2, mRNA | blastn | 846 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 14797946 | 14797946 | PRJNA788929_P_NODE_29032_length_293_cov_20.422727_g28371_i0 | PRJNA788929 | 29032 | 293 | 20.422727 | 59.83859011 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 211 | 4.24e-50 | NTclustered | gi|2519012342|ref|XM_057457598.1| | 13093 | g28371 | i0 | 87.166 | 11.9351535836177 | 187 | 22 | 63 | 2 | 22 | 207 | 1358 | 1543 | PREDICTED: Hydractinia symbiolongicarpus protein transport protein Sec61 subunit alpha (LOC130654941), mRNA | blastn | 3497 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 16072244 | 16072244 | PRJNA788929_P_NODE_8153_length_648_cov_41.060870_g7506_i0 | PRJNA788929 | 8153 | 648 | 41.06087 | 266.0744376 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 315 | 7.4399999999999995e-81 | NTclustered | gi|2782931191|ref|XM_067074155.1| | 252671 | g7506 | i0 | 77.953 | 56.2114197530864 | 508 | 109 | 78 | 3 | 82 | 588 | 656 | 151 | PREDICTED: Clytia hemisphaerica ADP-ribosylation factor 2 (LOC136817831), mRNA | blastn | 36425 | 315 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 16517156 | 16517156 | PRJNA788929_P_NODE_28733_length_295_cov_13.977477_g28072_i0 | PRJNA788929 | 28733 | 295 | 13.977477 | 41.23355715 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 58.4 | 5.88e-4 | NTclustered | gi|2917940735|emb|OZ237565.1| | 6108 | g28072 | i0 | 82.192 | 8.32542372881356 | 73 | 7 | 24 | 6 | 110 | 179 | 164990 | 165059 | Anemonia sulcata genome assembly, chromosome: 11 | blastn | 2456 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 17347578 | 17347578 | PRJNA788929_P_NODE_26654_length_308_cov_19.744681_g25993_i0 | PRJNA788929 | 26654 | 308 | 19.744681 | 60.81361748 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2257803516|ref|XM_032383078.2| | 45351 | g25993 | i0 | 96.97 | 0.107142857142857 | 33 | 0 | 11 | 1 | 56 | 88 | 1048 | 1017 | PREDICTED: Nematostella vectensis beta-2 adrenergic receptor (LOC5513567), mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 19896443 | 19896443 | PRJNA788929_P_NODE_46696_length_219_cov_8.417808_g46035_i0 | PRJNA788929 | 46696 | 219 | 8.417808 | 18.43499952 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 97.1 | 8.83e-16 | NTclustered | gi|2729058829|ref|XR_010517322.1| | 499914 | g46035 | i0 | 95.082 | 0.74429223744292194 | 61 | 3 | 28 | 0 | 20 | 80 | 3609 | 3549 | PREDICTED: Rhopilema esculentum large subunit ribosomal RNA (LOC135695981), rRNA | blastn | 163 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 24995868 | 24995868 | PRJNA788929_P_NODE_29760_length_289_cov_19.851852_g29099_i0 | PRJNA788929 | 29760 | 289 | 19.851852 | 57.37185228 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 80.9 | 2.35e-15 | NR | XP_031570540.1 | 6105 | g29099 | i0 | 47.6 | 2.58477508650519 | 84 | 38 | 86.2 | 2 | 30 | 278 | 319 | 397 | XP_031570540.1 E3 ubiquitin-protein ligase CHFR-like [Actinia tenebrosa] | diamond | 747 | 81.3 | 0.995079950799508 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 27947403 | 27947403 | PRJNA788929_P_NODE_5505_length_838_cov_48.393464_g4912_i0 | PRJNA788929 | 5505 | 838 | 48.393464 | 405.53722832 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 141 | 6.669999999999999e-37 | NR | EDO26941.1 | 45351 | g4912 | i0 | 67 | 11.4164677804296 | 109 | 34 | 39 | 1 | 515 | 189 | 129 | 235 | EDO26941.1 predicted protein [Nematostella vectensis] | diamond | 9567 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 28411844 | 28411844 | PRJNA788929_P_NODE_21466_length_351_cov_13.258993_g20805_i0 | PRJNA788929 | 21466 | 351 | 13.258993 | 46.53906543 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 87 | 4.02e-17 | NR | XP_057310772.1 | 13093 | g20805 | i0 | 50.7 | 1.97435897435897 | 73 | 36 | 62.4 | 0 | 44 | 262 | 2464 | 2536 | XP_057310772.1 lipoxygenase homology domain-containing protein 1-like [Hydractinia symbiolongicarpus] | diamond | 693 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 29715172 | 29715172 | PRJNA788929_P_NODE_21790_length_348_cov_14.461818_g21129_i0 | PRJNA788929 | 21790 | 348 | 14.461818 | 50.32712664 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 139 | 2.13e-35 | NR | XP_001628323.2 | 45351 | g21129 | i0 | 56.6 | 6.81034482758621 | 113 | 42 | 92.2 | 2 | 324 | 4 | 51 | 162 | XP_001628323.2 protein DD3-3 [Nematostella vectensis] | diamond | 2370 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 30433219 | 30433219 | PRJNA788929_P_NODE_13473_length_466_cov_55.541985_g12816_i0 | PRJNA788929 | 13473 | 466 | 55.541985 | 258.8256501 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 199 | 1.7e-60 | NR | KAK3744473.1 | 3060491 | g12816 | i0 | 64.4 | 0.959227467811159 | 149 | 50 | 95.9 | 1 | 463 | 17 | 150 | 295 | KAK3744473.1 hypothetical protein QZH41_012875 [Actinostola sp. cb2023] | diamond | 447 | 199 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 |
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);;