contig_metadata
18 rows where bioproject = "PRJNA1249042", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1629145 | 1629145 | PRJNA1249042_S_NODE_28782_length_244_cov_1.611940_g28568_i0 | PRJNA1249042 | 28782 | 244 | 1.61194 | 3.9331336 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 62.1 | 3.66e-5 | NTclustered | gi|2918369567|emb|OZ237733.1| | 317547 | g28568 | i0 | 90 | 0.204918032786885 | 50 | 2 | 20 | 3 | 112 | 161 | 250880 | 250834 | Eunicella cavolini genome assembly, chromosome: 17 | blastn | 50 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 6732646 | 6732646 | PRJNA1249042_S_NODE_92606_length_167_cov_1.548387_g92392_i0 | PRJNA1249042 | 92606 | 167 | 1.548387 | 2.58580629 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2918369552|emb|OZ237724.1| | 317547 | g92392 | i0 | 100 | 0.179640718562874 | 30 | 0 | 18 | 0 | 44 | 73 | 14057433 | 14057462 | Eunicella cavolini genome assembly, chromosome: 8 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 9282534 | 9282534 | PRJNA1249042_S_NODE_21128_length_261_cov_2.527523_g20914_i0 | PRJNA1249042 | 21128 | 261 | 2.527523 | 6.59683503 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 52.8 | 0.024 | NTclustered | gi|2744893764|ref|XR_010642317.1| | 6087 | g20914 | i0 | 100 | 0.10727969348659 | 28 | 0 | 11 | 0 | 136 | 163 | 1674 | 1701 | PREDICTED: Hydra vulgaris uncharacterized LOC136088605 (LOC136088605), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 13108321 | 13108321 | PRJNA1249042_S_NODE_36311_length_230_cov_1.834225_g36097_i0 | PRJNA1249042 | 36311 | 230 | 1.834225 | 4.2187175 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940766|emb|OZ237573.1| | 6108 | g36097 | i0 | 94.444 | 0.156521739130435 | 36 | 2 | 16 | 0 | 25 | 60 | 10324652 | 10324617 | Anemonia sulcata genome assembly, chromosome: 19 | blastn | 36 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 13108494 | 13108494 | PRJNA1249042_S_NODE_58211_length_200_cov_2.019108_g57997_i0 | PRJNA1249042 | 58211 | 200 | 2.019108 | 4.038216 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|2917940703|emb|OZ237559.1| | 6108 | g57997 | i0 | 100 | 0.145 | 29 | 0 | 15 | 0 | 110 | 138 | 190678 | 190706 | Anemonia sulcata genome assembly, chromosome: 5 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 14383261 | 14383261 | PRJNA1249042_S_NODE_102172_length_160_cov_1.205128_g101958_i0 | PRJNA1249042 | 102172 | 160 | 1.205128 | 1.9282048 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|1778061432|ref|XM_031712209.1| | 6105 | g101958 | i0 | 96.875 | 0.2 | 32 | 1 | 20 | 0 | 18 | 49 | 2459 | 2428 | PREDICTED: Actinia tenebrosa matrix metalloproteinase-25-like (LOC116302823), mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 15657401 | 15657401 | PRJNA1249042_S_NODE_40453_length_223_cov_2.911111_g40239_i0 | PRJNA1249042 | 40453 | 223 | 2.911111 | 6.49177753 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 60.2 | 1.18e-4 | NTclustered | gi|2917940766|emb|OZ237573.1| | 6108 | g40239 | i0 | 100 | 0.143497757847534 | 32 | 0 | 14 | 0 | 188 | 219 | 8609603 | 8609634 | Anemonia sulcata genome assembly, chromosome: 19 | blastn | 32 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26743138 | 26743138 | PRJNA1249042_S_NODE_91921_length_167_cov_4.169355_g91707_i0 | PRJNA1249042 | 91921 | 167 | 4.169355 | 6.96282285 | root | 1 | Root_unresolved | Root_unresolved | 40.8 | 0.0347 | NR | CAH3174038.1 | 104759 | g91707 | i0 | 41.9 | 1.54491017964072 | 43 | 24 | 77.2 | 1 | 143 | 15 | 14 | 55 | CAH3174038.1 unnamed protein product, partial [Porites lobata] | diamond | 258 | 41.2 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 27894816 | 27894816 | PRJNA1249042_S_NODE_75465_length_182_cov_2.028777_g75251_i0 | PRJNA1249042 | 75465 | 182 | 2.028777 | 3.69237414 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 46.2 | 9.71e-4 | NR | XP_068671620.1 | 591990 | g75251 | i0 | 54 | 3.2967032967033 | 50 | 14 | 67.6 | 1 | 47 | 169 | 69 | 118 | XP_068671620.1 uncharacterized protein [Montipora foliosa] | diamond | 600 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 28526583 | 28526583 | PRJNA1249042_S_NODE_41967_length_221_cov_1.977528_g41753_i0 | PRJNA1249042 | 41967 | 221 | 1.977528 | 4.37033688 | Acropora cervicornis | 6130 | Cnidaria | other_Eukaryota | 47.8 | 4.86e-4 | NR | KAK2547536.1 | 6130 | g41753 | i0 | 65.5 | 0.393665158371041 | 29 | 10 | 39.4 | 0 | 175 | 89 | 1086 | 1114 | KAK2547536.1 putative RNA-directed DNA polymerase from transposon BS [Acropora cervicornis] | diamond | 87 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 28778857 | 28778857 | PRJNA1249042_S_NODE_63827_length_194_cov_1.516556_g63613_i0 | PRJNA1249042 | 63827 | 194 | 1.516556 | 2.94211864 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 63.2 | 1.2e-9 | NR | XP_028408228.1 | 151771 | g63613 | i0 | 72.1 | 0.664948453608247 | 43 | 11 | 64.9 | 1 | 137 | 12 | 50 | 92 | XP_028408228.1 uncharacterized protein LOC114530812 [Dendronephthya gigantea] | diamond | 129 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 29410355 | 29410355 | PRJNA1249042_S_NODE_15329_length_280_cov_2.578059_g15115_i0 | PRJNA1249042 | 15329 | 280 | 2.578059 | 7.2185652 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 45.4 | 0.00682 | NR | XP_065062908.1 | 499914 | g15115 | i0 | 38.2 | 0.589285714285714 | 55 | 31 | 58.9 | 2 | 47 | 211 | 572 | 623 | XP_065062908.1 ral GTPase-activating protein subunit beta-like [Rhopilema esculentum] | diamond | 165 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 30136468 | 30136468 | PRJNA1249042_S_NODE_49752_length_210_cov_2.532934_g49538_i0 | PRJNA1249042 | 49752 | 210 | 2.532934 | 5.3191614 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 44.3 | 0.00703 | NR | KXJ11352.1 | 2652724 | g49538 | i0 | 55.9 | 1.48571428571429 | 34 | 15 | 48.6 | 0 | 83 | 184 | 1667 | 1700 | KXJ11352.1 Retrovirus-related Pol polyprotein from transposon 17.6 [Exaiptasia diaphana] | diamond | 312 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 30705452 | 30705452 | PRJNA1249042_S_NODE_9614_length_312_cov_1.747212_g9400_i0 | PRJNA1249042 | 9614 | 312 | 1.747212 | 5.45130144 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 67 | 2.06e-11 | NR | XP_028390691.1 | 151771 | g9400 | i0 | 41.5 | 4.25961538461539 | 65 | 38 | 62.5 | 0 | 311 | 117 | 85 | 149 | XP_028390691.1 ADP-ribose glycohydrolase OARD1-like [Dendronephthya gigantea] | diamond | 1329 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 30863471 | 30863471 | PRJNA1249042_S_NODE_67274_length_190_cov_2.285714_g67060_i0 | PRJNA1249042 | 67274 | 190 | 2.285714 | 4.3428566 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 41.6 | 0.037 | NR | XP_065675228.1 | 6087 | g67060 | i0 | 37.5 | 0.884210526315789 | 56 | 35 | 88.4 | 0 | 1 | 168 | 6 | 61 | XP_065675228.1 protein FAM210B, mitochondrial isoform X2 [Hydra vulgaris] | diamond | 168 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 30958440 | 30958440 | PRJNA1249042_S_NODE_28114_length_245_cov_2.321782_g27900_i0 | PRJNA1249042 | 28114 | 245 | 2.321782 | 5.6883659 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 53.5 | 3.33e-7 | NR | EDO38149.1 | 45351 | g27900 | i0 | 54.3 | 0.563265306122449 | 46 | 21 | 56.3 | 0 | 87 | 224 | 30 | 75 | EDO38149.1 predicted protein, partial [Nematostella vectensis] | diamond | 138 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 32160250 | 32160250 | PRJNA1249042_S_NODE_107798_length_156_cov_1.247788_g107584_i0 | PRJNA1249042 | 107798 | 156 | 1.247788 | 1.94654928 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 42.7 | 0.0114 | NR | XP_067049854.1 | 159855 | g107584 | i0 | 61.5 | 0.5 | 26 | 10 | 50 | 0 | 79 | 2 | 253 | 278 | XP_067049854.1 uncharacterized protein [Acropora muricata] | diamond | 78 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 32445098 | 32445098 | PRJNA1249042_S_NODE_80499_length_177_cov_3.156716_g80285_i0 | PRJNA1249042 | 80499 | 177 | 3.156716 | 5.58738732 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 62 | 2.4e-9 | NR | CAB4023848.1 | 317549 | g80285 | i0 | 74.3 | 4.15254237288136 | 35 | 9 | 59.3 | 0 | 69 | 173 | 224 | 258 | CAB4023848.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 735 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata |
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);;