contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA944406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 924945 | 924945 | PRJNA944406_P_NODE_80441_length_247_cov_1.574713_g79482_i0 | PRJNA944406 | 80441 | 247 | 1.574713 | 3.88954111 | Antarctoscyphus spiralis | 655730 | Cnidaria | other_Eukaryota | 161 | 3.56e-35 | NTclustered | gi|984932199|gb|KT757141.1| | 655730 | g79482 | i0 | 87.681 | 50.2145748987854 | 138 | 17 | 56 | 0 | 102 | 239 | 1515 | 1652 | Antarctoscyphus spiralis voucher LEM m3x S155 large subunit 28S ribosomal RNA gene, partial sequence | blastn | 12403 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Sertulariidae | Antarctoscyphus | Antarctoscyphus spiralis | |
| 2535190 | 2535190 | PRJNA944406_P_NODE_54842_length_258_cov_5.929730_g53883_i0 | PRJNA944406 | 54842 | 258 | 5.92973 | 15.2987034 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 99 | 2.97e-16 | NTclustered | gi|2320876524|tpg|BK062609.1| | 37510 | g53883 | i0 | 92.647 | 25.5 | 68 | 5 | 26 | 0 | 1 | 68 | 2081 | 2148 | TPA_inf: Renilla muelleri 28S ribosomal RNA gene, complete sequence | blastn | 6579 | 100 | 0.99 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Renillidae | Renilla | Renilla muelleri | |
| 7302616 | 7302616 | PRJNA944406_P_NODE_43506_length_269_cov_1.571429_g42547_i0 | PRJNA944406 | 43506 | 269 | 1.571429 | 4.22714401 | Callogorgia delta | 2831853 | Cnidaria | other_Eukaryota | 126 | 1.43e-24 | NTclustered | gi|2689317331|gb|PP410761.1| | 2831853 | g42547 | i0 | 84.8 | 74.5873605947955 | 125 | 17 | 46 | 2 | 144 | 267 | 1326 | 1449 | Callogorgia delta voucher LII-10-379 large subunit ribosomal RNA gene, partial sequence | blastn | 20064 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Primnoidae | Callogorgia | Callogorgia delta | |
| 10188243 | 10188243 | PRJNA944406_P_NODE_66348_length_251_cov_0.865169_g65389_i0 | PRJNA944406 | 66348 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 145 | 3.65e-30 | NTclustered | gi|2782847639|ref|XM_067056506.1| | 252671 | g65389 | i0 | 82.822 | 50.8884462151394 | 163 | 26 | 65 | 2 | 88 | 249 | 556 | 395 | PREDICTED: Clytia hemisphaerica histone H3 (LOC136799799), mRNA | blastn | 12773 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 11128655 | 11128655 | PRJNA944406_P_NODE_84349_length_246_cov_1.780347_g83390_i0 | PRJNA944406 | 84349 | 246 | 1.780347 | 4.37965362 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2744796404|ref|XR_010645999.1| | 6087 | g83390 | i0 | 100 | 0.117886178861789 | 29 | 0 | 12 | 0 | 7 | 35 | 628 | 656 | PREDICTED: Hydra vulgaris uncharacterized LOC124807060 (LOC124807060), transcript variant X1, ncRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 11128774 | 11128774 | PRJNA944406_P_NODE_9709_length_399_cov_3.542945_g8750_i0 | PRJNA944406 | 9709 | 399 | 3.542945 | 14.13635055 | Sphaerospora elwhaiensis | 946269 | Cnidaria | other_Eukaryota | 102 | 3.74e-17 | NTclustered | gi|319960340|gb|HQ450772.1| | 946269 | g8750 | i0 | 84.404 | 0.273182957393484 | 109 | 11 | 27 | 5 | 294 | 399 | 858 | 963 | Sphaerospora elwhaiensis 28S ribosomal RNA gene, partial sequence | blastn | 109 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaerosporidae | Sphaerospora | Sphaerospora elwhaiensis | |
| 12403286 | 12403286 | PRJNA944406_P_NODE_104430_length_242_cov_0.911243_g103471_i0 | PRJNA944406 | 104430 | 242 | 0.911243 | 2.20520806 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2917940720|emb|OZ237562.1| | 6108 | g103471 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 190 | 217 | 890900 | 890873 | Anemonia sulcata genome assembly, chromosome: 8 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 13678584 | 13678584 | PRJNA944406_P_NODE_74491_length_249_cov_0.875000_g73532_i0 | PRJNA944406 | 74491 | 249 | 0.875 | 2.17875 | Kudoa sp. KY2015 | 2058834 | Cnidaria | other_Eukaryota | 71.3 | 6.22e-8 | NTclustered | gi|2523348858|dbj|LC341248.1| | 2058834 | g73532 | i0 | 86.154 | 22.6907630522088 | 65 | 9 | 26 | 0 | 182 | 246 | 5144 | 5208 | Kudoa sp. KY2015 Sawara/151120-3 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, clone: 15-Mi/3 | blastn | 5650 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Multivalvulida | Kudoidae | Kudoa | Kudoa sp. KY2015 | |
| 16562117 | 16562117 | PRJNA944406_P_NODE_7453_length_460_cov_2.043928_g6497_i0 | PRJNA944406 | 7453 | 460 | 2.043928 | 9.4020688 | Bivalvulida | 35583 | Cnidaria | other_Eukaryota | 126 | 2.59e-24 | NTclustered | gi|2089706636|gb|OK030695.1| | 1720082 | g6497 | i0 | 88.182 | 22.8260869565217 | 110 | 8 | 23 | 5 | 1 | 108 | 1004 | 898 | Unicauda fimbrethilae large subunit ribosomal RNA gene, partial sequence | blastn | 10500 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Unicauda | Unicauda fimbrethilae | |
| 17503297 | 17503297 | PRJNA944406_P_NODE_92834_length_244_cov_3.134503_g91875_i0 | PRJNA944406 | 92834 | 244 | 3.134503 | 7.64818732 | Bicaularia tongensis | 2035841 | Cnidaria | other_Eukaryota | 60.2 | 1.32e-4 | NTclustered | gi|1246716251|gb|MG001906.1| | 2035841 | g91875 | i0 | 81.944 | 0.725409836065574 | 72 | 12 | 30 | 1 | 159 | 230 | 1852 | 1782 | Bicaularia tongensis voucher XMUB000550 large subunit ribosomal RNA gene, partial sequence | blastn | 177 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Symplectoscyphidae | Bicaularia | Bicaularia tongensis | |
| 20050880 | 20050880 | PRJNA944406_P_NODE_16136_length_321_cov_1.637097_g15177_i0 | PRJNA944406 | 16136 | 321 | 1.637097 | 5.25508137 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 272 | 2.12e-68 | NTclustered | gi|2782857206|ref|XM_067058063.1| | 252671 | g15177 | i0 | 82.692 | 93.392523364486 | 312 | 48 | 96 | 5 | 3 | 311 | 484 | 176 | PREDICTED: Clytia hemisphaerica histone H3.3 (LOC136801426), mRNA | blastn | 29979 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 25150455 | 25150455 | PRJNA944406_P_NODE_14800_length_333_cov_1.488462_g13841_i0 | PRJNA944406 | 14800 | 333 | 1.488462 | 4.95657846 | Calycella syringa | 314529 | Cnidaria | other_Eukaryota | 122 | 2.3599999999999998e-23 | NTclustered | gi|256674468|gb|FJ550372.1| | 314529 | g13841 | i0 | 86.607 | 26.8168168168168 | 112 | 13 | 33 | 2 | 137 | 247 | 1457 | 1567 | Calycella syringa 28S ribosomal RNA gene, partial sequence | blastn | 8930 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Campanulariidae | Calycella | Calycella syringa |
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);;