contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA683669" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1941061 | 1941061 | PRJNA683669_P_NODE_6462_length_504_cov_1.250580_g6231_i0 | PRJNA683669 | 6462 | 504 | 1.25058 | 6.3029232 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 193 | 2.78e-44 | NTclustered | gi|1619663561|ref|XM_021049773.2| | 2652724 | g6231 | i0 | 82.432 | 9.20238095238095 | 222 | 34 | 43 | 5 | 234 | 451 | 331 | 551 | PREDICTED: Exaiptasia diaphana ATP synthase lipid-binding protein, mitochondrial (LOC110243647), mRNA | blastn | 4638 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 3215841 | 3215841 | PRJNA683669_P_NODE_29643_length_247_cov_0.885057_g29411_i0 | PRJNA683669 | 29643 | 247 | 0.885057 | 2.18609079 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 206 | 1.6199999999999998e-48 | NTclustered | gi|2782930007|ref|XM_067073869.1| | 252671 | g29411 | i0 | 86.559 | 9.68421052631579 | 186 | 25 | 75 | 0 | 6 | 191 | 1459 | 1274 | PREDICTED: Clytia hemisphaerica protein transport protein Sec61 subunit alpha (LOC136817544), mRNA | blastn | 2392 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 3215898 | 3215898 | PRJNA683669_P_NODE_3683_length_680_cov_5.128501_g3465_i0 | PRJNA683669 | 3683 | 680 | 5.128501 | 34.8738068 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 54.7 | 0.019 | NTclustered | gi|2918369540|emb|OZ237722.1| | 317547 | g3465 | i0 | 100 | 0.0426470588235294 | 29 | 0 | 4 | 0 | 298 | 326 | 5240126 | 5240154 | Eunicella cavolini genome assembly, chromosome: 6 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 5768657 | 5768657 | PRJNA683669_P_NODE_3885_length_661_cov_2.389456_g3664_i0 | PRJNA683669 | 3885 | 661 | 2.389456 | 15.79430416 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 412 | 2.6199999999999998e-110 | NTclustered | gi|2782873191|ref|XM_067061560.1| | 252671 | g3664 | i0 | 89.362 | 49.0136157337368 | 329 | 33 | 50 | 2 | 1 | 328 | 1138 | 1465 | PREDICTED: Clytia hemisphaerica tubulin alpha-2/alpha-4 chain (LOC136805028), mRNA | blastn | 32398 | 412 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 7043668 | 7043668 | PRJNA683669_P_NODE_28366_length_248_cov_0.880000_g28134_i0 | PRJNA683669 | 28366 | 248 | 0.88 | 2.1824 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 58.4 | 4.82e-4 | NTclustered | gi|2744862524|ref|XM_065798170.1| | 6087 | g28134 | i0 | 100 | 0.370967741935484 | 31 | 0 | 13 | 0 | 153 | 183 | 7916 | 7946 | PREDICTED: Hydra vulgaris uncharacterized LOC101235879 (LOC101235879), transcript variant X2, mRNA | blastn | 92 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 8318201 | 8318201 | PRJNA683669_P_NODE_34207_length_241_cov_0.904762_g33975_i0 | PRJNA683669 | 34207 | 241 | 0.904762 | 2.18047642 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 195 | 3.41e-45 | NTclustered | gi|2782871477|ref|XM_067061169.1| | 252671 | g33975 | i0 | 82.222 | 17.1327800829876 | 225 | 40 | 93 | 0 | 15 | 239 | 522 | 298 | PREDICTED: Clytia hemisphaerica ras-related C3 botulinum toxin substrate 1 (LOC136804570), mRNA | blastn | 4129 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 12144386 | 12144386 | PRJNA683669_P_NODE_28830_length_248_cov_0.880000_g28598_i0 | PRJNA683669 | 28830 | 248 | 0.88 | 2.1824 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 67.6 | 8.01e-7 | NTclustered | gi|2751571412|ref|XM_066172543.1| | 203993 | g28598 | i0 | 95.238 | 13.741935483871 | 42 | 2 | 17 | 0 | 4 | 45 | 263 | 222 | PREDICTED: Pocillopora verrucosa uncharacterized protein (LOC131793887), transcript variant X2, mRNA | blastn | 3408 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 17242824 | 17242824 | PRJNA683669_P_NODE_14014_length_346_cov_1.128205_g13783_i0 | PRJNA683669 | 14014 | 346 | 1.128205 | 3.9035893 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 58.4 | 7.04e-4 | NTclustered | gi|2744786543|ref|XM_047272185.2| | 6087 | g13783 | i0 | 100 | 0.447976878612717 | 31 | 0 | 9 | 0 | 94 | 124 | 909 | 879 | PREDICTED: Hydra vulgaris uncharacterized LOC124808953 (LOC124808953), mRNA | blastn | 155 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 18516935 | 18516935 | PRJNA683669_P_NODE_11415_length_382_cov_0.996764_g11184_i0 | PRJNA683669 | 11415 | 382 | 0.996764 | 3.80763848 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 121 | 9.85e-23 | NTclustered | gi|2782927081|ref|XM_067073194.1| | 252671 | g11184 | i0 | 89.474 | 7.17015706806283 | 95 | 10 | 25 | 0 | 287 | 381 | 529 | 623 | PREDICTED: Clytia hemisphaerica vacuolar protein sorting-associated protein 4B-like (LOC136816865), mRNA | blastn | 2739 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 18517158 | 18517158 | PRJNA683669_P_NODE_6095_length_520_cov_1.310962_g5865_i0 | PRJNA683669 | 6095 | 520 | 1.310962 | 6.8170024 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 63.9 | 2.35e-5 | NTclustered | gi|2917940701|emb|OZ237558.1| | 6108 | g5865 | i0 | 100 | 1.96923076923077 | 34 | 0 | 7 | 0 | 381 | 414 | 14052272 | 14052239 | Anemonia sulcata genome assembly, chromosome: 4 | blastn | 1024 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 19026553 | 19026553 | PRJNA683669_P_NODE_14215_length_343_cov_1.877778_g13984_i0 | PRJNA683669 | 14215 | 343 | 1.877778 | 6.44077854 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2198158399|gb|MW618101.1| | 308606 | g13984 | i0 | 100 | 0.352769679300292 | 30 | 0 | 9 | 0 | 221 | 250 | 1068 | 1039 | Dynamena pumila snail mRNA, complete cds | blastn | 121 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Sertulariidae | Dynamena | Dynamena pumila | |
| 19791894 | 19791894 | PRJNA683669_P_NODE_23216_length_269_cov_1.091837_g22984_i0 | PRJNA683669 | 23216 | 269 | 1.091837 | 2.93704153 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 193 | 1.39e-44 | NTclustered | gi|2519002477|ref|XM_057452852.1| | 13093 | g22984 | i0 | 84.264 | 54.8624535315985 | 197 | 31 | 73 | 0 | 2 | 198 | 1874 | 1678 | PREDICTED: Hydractinia symbiolongicarpus dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit STT3A-like (LOC130647112), mRNA | blastn | 14758 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 21067406 | 21067406 | PRJNA683669_P_NODE_21577_length_279_cov_1.145631_g21345_i0 | PRJNA683669 | 21577 | 279 | 1.145631 | 3.19631049 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 167 | 8.789999999999999e-37 | NTclustered | gi|2744830666|ref|XM_002156791.5| | 6087 | g21345 | i0 | 85.897 | 21.6810035842294 | 156 | 22 | 56 | 0 | 113 | 268 | 52 | 207 | PREDICTED: Hydra vulgaris ras-like GTP-binding protein RHO (LOC100204217), transcript variant X1, mRNA | blastn | 6049 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 22342215 | 22342215 | PRJNA683669_P_NODE_18158_length_303_cov_3.204348_g17926_i0 | PRJNA683669 | 18158 | 303 | 3.204348 | 9.70917444 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 411 | 4.039999999999999e-110 | NTclustered | gi|2782844603|ref|XM_067056021.1| | 252671 | g17926 | i0 | 91.089 | 99.3201320132013 | 303 | 27 | 100 | 0 | 1 | 303 | 1383 | 1081 | PREDICTED: Clytia hemisphaerica tubulin beta-4B chain (LOC136799316), mRNA | blastn | 30094 | 411 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica |
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);;