contig_metadata
11 rows where bioproject = "PRJEB83711" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2693608 | 2693608 | PRJEB83711_P_NODE_21503_length_382_cov_3.796117_g21237_i0 | PRJEB83711 | 21503 | 382 | 3.796117 | 14.50116694 | Zschokkella nova | 371529 | Cnidaria | other_Eukaryota | 141 | 7.560000000000001e-29 | NTclustered | gi|312184072|gb|GU471278.1| | 371529 | g21237 | i0 | 74.436 | 19.2539267015707 | 399 | 69 | 100 | 30 | 1 | 382 | 720 | 338 | Zschokkella nova isolate 809 28S ribosomal RNA gene, partial sequence | blastn | 7355 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Zschokkella | Zschokkella nova | |
| 2693630 | 2693630 | PRJEB83711_P_NODE_22443_length_374_cov_16.880399_g22177_i0 | PRJEB83711 | 22443 | 374 | 16.880399 | 63.13269226 | Zschokkella sp. KLT-2014 | 1569978 | Cnidaria | other_Eukaryota | 636 | 7.72e-178 | NTclustered | gi|705780605|gb|KM401441.1| | 1569978 | g22177 | i0 | 97.326 | 95.6363636363636 | 374 | 10 | 100 | 0 | 1 | 374 | 386 | 13 | Zschokkella sp. KLT-2014 18S ribosomal RNA gene, partial sequence | blastn | 35768 | 636 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Zschokkella | Zschokkella sp. KLT-2014 | |
| 3969697 | 3969697 | PRJEB83711_P_NODE_21164_length_385_cov_4.375000_g20898_i0 | PRJEB83711 | 21164 | 385 | 4.375 | 16.84375 | Myxidium sp. n. TN-2019 | 2577045 | Cnidaria | other_Eukaryota | 571 | 2.279999999999999e-158 | NTclustered | gi|1644666207|gb|MK913426.1| | 2577045 | g20898 | i0 | 93.506 | 91.5350649350649 | 385 | 24 | 99 | 1 | 1 | 384 | 243 | 627 | Myxidium sp. n. TN-2019 small subunit ribosomal RNA gene, partial sequence | blastn | 35241 | 571 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium sp. n. TN-2019 | |
| 5245974 | 5245974 | PRJEB83711_P_NODE_11605_length_526_cov_5.335541_g11342_i0 | PRJEB83711 | 11605 | 526 | 5.335541 | 28.06494566 | Cystodiscus australis | 1026752 | Cnidaria | other_Eukaryota | 545 | 1.9399999999999998e-150 | NTclustered | gi|331703984|gb|HQ822174.1| | 1026752 | g11342 | i0 | 85.505 | 80.0855513307985 | 545 | 54 | 100 | 18 | 1 | 526 | 1453 | 1991 | Cystodiscus australis isolate GGBF7A04 28S large subunit ribosomal RNA gene, partial sequence | blastn | 42125 | 545 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Cystodiscus | Cystodiscus australis | |
| 12896928 | 12896928 | PRJEB83711_P_NODE_16191_length_440_cov_5.376022_g15925_i0 | PRJEB83711 | 16191 | 440 | 5.376022 | 23.6544968 | Zschokkella parasiluri | 371530 | Cnidaria | other_Eukaryota | 568 | 3.42e-157 | NTclustered | gi|241911760|gb|FJ417066.1| | 371530 | g15925 | i0 | 89.76 | 34.9704545454545 | 459 | 25 | 100 | 13 | 1 | 440 | 1674 | 2129 | Zschokkella parasiluri isolate M0172 28S large subunit ribosomal RNA gene, partial sequence | blastn | 15387 | 568 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Zschokkella | Zschokkella parasiluri | |
| 14172691 | 14172691 | PRJEB83711_P_NODE_49852_length_267_cov_1.608247_g49586_i0 | PRJEB83711 | 49852 | 267 | 1.608247 | 4.29401949 | Myxidium cuneiforme | 371548 | Cnidaria | other_Eukaryota | 346 | 1e-90 | NTclustered | gi|241911755|gb|FJ417061.1| | 371548 | g49586 | i0 | 89.963 | 56.5430711610487 | 269 | 25 | 100 | 2 | 1 | 267 | 346 | 78 | Myxidium cuneiforme isolate M0171 28S large subunit ribosomal RNA gene, partial sequence | blastn | 15097 | 346 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium cuneiforme | |
| 15447161 | 15447161 | PRJEB83711_P_NODE_64193_length_249_cov_3.556818_g63927_i0 | PRJEB83711 | 64193 | 249 | 3.556818 | 8.85647682 | Sphaeromyxa zaharoni | 275449 | Cnidaria | other_Eukaryota | 141 | 4.68e-29 | NTclustered | gi|2663986569|emb|OY751524.1| | 275449 | g63927 | i0 | 77.778 | 1.01204819277108 | 252 | 41 | 100 | 9 | 1 | 249 | 6603 | 6364 | Sphaeromyxa zaharoni isolate 24.2.2011 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 252 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaeromyxidae | Sphaeromyxa | Sphaeromyxa zaharoni | |
| 21820196 | 21820196 | PRJEB83711_P_NODE_18038_length_416_cov_18.548105_g17772_i0 | PRJEB83711 | 18038 | 416 | 18.548105 | 77.1601168 | Myxidium sp. o HB-2024 | 3344062 | Cnidaria | other_Eukaryota | 758 | 0 | NTclustered | gi|2801867818|gb|PQ308094.1| | 3344062 | g17772 | i0 | 99.279 | 84.7548076923077 | 416 | 3 | 100 | 0 | 1 | 416 | 979 | 564 | Myxidium sp. o HB-2024 strain CIFA small subunit ribosomal RNA gene, partial sequence | blastn | 35258 | 758 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium sp. o HB-2024 | |
| 22675839 | 22675839 | PRJEB83711_P_NODE_81378_length_230_cov_6.503185_g81112_i0 | PRJEB83711 | 81378 | 230 | 6.503185 | 14.9573255 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|2917940745|emb|OZ237569.1| | 6108 | g81112 | i0 | 100 | 0.852173913043478 | 28 | 0 | 12 | 0 | 1 | 28 | 3426991 | 3426964 | Anemonia sulcata genome assembly, chromosome: 15 | blastn | 196 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 28448379 | 28448379 | PRJEB83711_P_NODE_82226_length_224_cov_4.377483_g81960_i0 | PRJEB83711 | 82226 | 224 | 4.377483 | 9.80556192 | root | 1 | Root_unresolved | Root_unresolved | 44.3 | 0.00835 | NR | PFX21664.1 | 50429 | g81960 | i0 | 42.2 | 1.09821428571429 | 45 | 26 | 60.3 | 0 | 72 | 206 | 230 | 274 | PFX21664.1 hypothetical protein AWC38_SpisGene13848 [Stylophora pistillata] | diamond | 246 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 28802596 | 28802596 | PRJEB83711_P_NODE_24728_length_358_cov_1.091228_g24462_i0 | PRJEB83711 | 24728 | 358 | 1.091228 | 3.90659624 | Sphaeromyxa zaharoni | 275449 | Cnidaria | other_Eukaryota | 71.6 | 5.82e-12 | NR | YP_011052095.1 | 275449 | g24462 | i0 | 38.8 | 0.82122905027933 | 98 | 59 | 81.3 | 1 | 319 | 29 | 184 | 281 | YP_011052095.1 NADH dehydrogenase subunit 1 [Sphaeromyxa zaharoni] | diamond | 294 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaeromyxidae | Sphaeromyxa | Sphaeromyxa zaharoni |
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);;