contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax_phylum = "Rotifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 530303 | 530303 | PRJNA556992_P_NODE_568141_length_261_cov_3.159574_g565952_i0 | PRJNA556992 | 568141 | 261 | 3.159574 | 8.24648814 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 283 | 7.749999999999999e-72 | NTclustered | gi|194500447|gb|EU850438.1| | 104782 | g565952 | i0 | 92.5 | 8.75478927203065 | 200 | 11 | 75 | 2 | 6 | 201 | 28845 | 29044 | Adineta vaga hypothetical protein 18 gene, partial cds; hypothetical protein 19, coatomer, GPCR, beta-transducin repeat, speckle-type POZ, adenosine kinase, prefoldin subunit, translation initiation factor eIF-4E, rho GTPase activating protein, histone H4, histone H3, histone H2B, and histone H2Av genes, complete cds; and mitochondrial ribosomal protein s22 gene, partial cds | blastn | 2285 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 4359279 | 4359279 | PRJNA556992_P_NODE_70564_length_452_cov_32.707124_g68389_i0 | PRJNA556992 | 70564 | 452 | 32.707124 | 147.83620048 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 566 | 1.27e-156 | NTclustered | gi|187936070|gb|EU652317.1| | 96448 | g68389 | i0 | 94.309 | 88.6681415929203 | 369 | 21 | 82 | 0 | 2 | 370 | 20326 | 20694 | Philodina roseola GTP binding protein, beta prime coatomer protein complex subunit, GPCR, beta-transducin repeat containing protein, speckle-type POZ protein, adenosine kinase, prefoldin subunit 1, translation initiation factor eIF-4E, Rho GTPase activating protein, histone H4, histone H3, histone H2B, histone H2Av, cleft lip and palate associated transmembrane protein, mitochondrial ribosomal protein s22, ribosomal protein s15a, hypothetical protein 20, START domain containing protein, and filament protein genes, complete cds | blastn | 40078 | 566 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 9453690 | 9453690 | PRJNA556992_P_NODE_196868_length_329_cov_1.441406_g194680_i0 | PRJNA556992 | 196868 | 329 | 1.441406 | 4.74222574 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 564 | 3.2199999999999995e-156 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g194680 | i0 | 97.583 | 4.37689969604863 | 331 | 5 | 100 | 3 | 1 | 329 | 10066 | 10395 | Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 1440 | 564 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 13279498 | 13279498 | PRJNA556992_P_NODE_206391_length_323_cov_22.684000_g204203_i0 | PRJNA556992 | 206391 | 323 | 22.684 | 73.26932 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 418 | 2.6e-112 | NTclustered | gi|194500447|gb|EU850438.1| | 104782 | g204203 | i0 | 96.109 | 75.2229102167183 | 257 | 9 | 98 | 1 | 1 | 256 | 28069 | 28325 | Adineta vaga hypothetical protein 18 gene, partial cds; hypothetical protein 19, coatomer, GPCR, beta-transducin repeat, speckle-type POZ, adenosine kinase, prefoldin subunit, translation initiation factor eIF-4E, rho GTPase activating protein, histone H4, histone H3, histone H2B, and histone H2Av genes, complete cds; and mitochondrial ribosomal protein s22 gene, partial cds | blastn | 24297 | 418 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 13281553 | 13281553 | PRJNA556992_P_NODE_345611_length_282_cov_12.679426_g343422_i0 | PRJNA556992 | 345611 | 282 | 12.679426 | 35.75598132 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 409 | 1.34e-109 | NTclustered | gi|194500447|gb|EU850438.1| | 104782 | g343422 | i0 | 92.908 | 17.6560283687943 | 282 | 18 | 100 | 2 | 1 | 282 | 26314 | 26035 | Adineta vaga hypothetical protein 18 gene, partial cds; hypothetical protein 19, coatomer, GPCR, beta-transducin repeat, speckle-type POZ, adenosine kinase, prefoldin subunit, translation initiation factor eIF-4E, rho GTPase activating protein, histone H4, histone H3, histone H2B, and histone H2Av genes, complete cds; and mitochondrial ribosomal protein s22 gene, partial cds | blastn | 4979 | 409 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 14557683 | 14557683 | PRJNA556992_P_NODE_436212_length_273_cov_1.590000_g434023_i0 | PRJNA556992 | 436212 | 273 | 1.59 | 4.3407 | Adineta vaga complex sp. B JFF-2016 | 1813165 | Rotifera | other_Eukaryota | 460 | 3.5099999999999996e-125 | NTclustered | gi|1005055631|gb|KU860774.1| | 1813165 | g434023 | i0 | 97.07 | 64.7619047619048 | 273 | 8 | 100 | 0 | 1 | 273 | 2141 | 1869 | Adineta vaga complex sp. B JFF-2016 isolate H158a 28S ribosomal RNA gene, partial sequence | blastn | 17680 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. B JFF-2016 | |
| 17106089 | 17106089 | PRJNA556992_P_NODE_41054_length_553_cov_23.991667_g38908_i0 | PRJNA556992 | 41054 | 553 | 23.991667 | 132.67391851 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 617 | 4.279999999999999e-172 | NTclustered | gi|197321819|gb|EU853695.1| | 96448 | g38908 | i0 | 93.917 | 58.9801084990958 | 411 | 22 | 74 | 1 | 18 | 425 | 1 | 411 | Philodina roseola histone H2A variant H2Av1 copy 1a (H2Av1) gene, partial cds | blastn | 32616 | 617 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 17107770 | 17107770 | PRJNA556992_P_NODE_54394_length_496_cov_20.576832_g52230_i0 | PRJNA556992 | 54394 | 496 | 20.576832 | 102.06108672 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 348 | 5.52e-91 | NTclustered | gi|194500463|gb|EU850439.1| | 104782 | g52230 | i0 | 90.299 | 51.1532258064516 | 268 | 23 | 100 | 2 | 229 | 496 | 12961 | 12697 | Adineta vaga dihydrogenpyrimidine dehydrogenase gene, partial cds; and translation initiation factor eIF-4E, rho GTPase activating protein, 7 transmembrane protein 66, histone H4, histone H3, histone H2B, osteopetrosis associated transmembrane protein, cleft lip and palate associated transmembrane, ribosomal protein s15a, and hypothetical protein 20 genes, complete cds | blastn | 25372 | 348 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 24754744 | 24754744 | PRJNA556992_P_NODE_42020_length_548_cov_12.202105_g39872_i0 | PRJNA556992 | 42020 | 548 | 12.202105 | 66.8675354 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 569 | 1.1999999999999997e-157 | NTclustered | gi|197321821|gb|EU853696.1| | 96448 | g39872 | i0 | 94.565 | 59.3613138686131 | 368 | 20 | 67 | 0 | 14 | 381 | 1 | 368 | Philodina roseola histone H2A variant H2Av1 copy 1b (H2Av1) gene, partial cds | blastn | 32530 | 569 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 24757904 | 24757904 | PRJNA556992_P_NODE_682440_length_252_cov_2.731844_g680251_i0 | PRJNA556992 | 682440 | 252 | 2.731844 | 6.88424688 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 339 | 1.57e-88 | NTclustered | gi|197321801|gb|EU853686.1| | 104782 | g680251 | i0 | 91.77 | 15.9206349206349 | 243 | 20 | 96 | 0 | 1 | 243 | 276 | 518 | Adineta vaga histone H2A variant H2Abd copy 1 (H2Abd) gene, partial cds | blastn | 4012 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 24759105 | 24759105 | PRJNA556992_P_NODE_77700_length_438_cov_12.528767_g75521_i0 | PRJNA556992 | 77700 | 438 | 12.528767 | 54.87599946 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 518 | 3.47e-142 | NTclustered | gi|187936070|gb|EU652317.1| | 96448 | g75521 | i0 | 91.892 | 174.956621004566 | 370 | 30 | 84 | 0 | 68 | 437 | 20695 | 20326 | Philodina roseola GTP binding protein, beta prime coatomer protein complex subunit, GPCR, beta-transducin repeat containing protein, speckle-type POZ protein, adenosine kinase, prefoldin subunit 1, translation initiation factor eIF-4E, Rho GTPase activating protein, histone H4, histone H3, histone H2B, histone H2Av, cleft lip and palate associated transmembrane protein, mitochondrial ribosomal protein s22, ribosomal protein s15a, hypothetical protein 20, START domain containing protein, and filament protein genes, complete cds | blastn | 76631 | 518 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola |
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);;