contig_metadata
15 rows where bioproject = "PRJNA529224" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 498015 | 498015 | PRJNA529224_S_NODE_641_length_245_cov_24.601852_g634_i0 | PRJNA529224 | 641 | 245 | 24.601852 | 60.2745374 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 342 | 1.17e-89 | NTclustered | gi|72153738|gb|DQ089740.1| | 204736 | g634 | i0 | 91.87 | 46.4040816326531 | 246 | 19 | 100 | 1 | 1 | 245 | 1797 | 2042 | Brachionus urceolaris 28S ribosomal RNA gene, partial sequence | blastn | 11369 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 1114426 | 1114426 | PRJNA529224_S_NODE_1201_length_189_cov_11.831250_g1194_i0 | PRJNA529224 | 1201 | 189 | 11.83125 | 22.3610625 | Ploima | 84394 | Rotifera | other_Eukaryota | 287 | 4.08e-73 | NTclustered | gi|37788190|gb|AY218143.1| | 231620 | g1194 | i0 | 95.055 | 85.3068783068783 | 182 | 9 | 96 | 0 | 1 | 182 | 182 | 1 | Euchlanis dilatata 28S ribosomal RNA gene, partial sequence | blastn | 16123 | 289 | 0.993079584775087 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Euchlanis | Euchlanis dilatata | |
| 1114432 | 1114432 | PRJNA529224_S_NODE_1421_length_178_cov_28.604027_g1414_i0 | PRJNA529224 | 1421 | 178 | 28.604027 | 50.91516806 | Metazoa | 33208 | Rotifera | other_Eukaryota | 327 | 2.23e-85 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g1414 | i0 | 100 | 98.2415730337079 | 177 | 0 | 99 | 0 | 2 | 178 | 2974 | 3150 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 17487 | 327 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 4324918 | 4324918 | PRJNA529224_S_NODE_1664_length_162_cov_25.556391_g1657_i0 | PRJNA529224 | 1664 | 162 | 25.556391 | 41.40135342 | Polyarthra remata | 360693 | Rotifera | other_Eukaryota | 255 | 9.570000000000001e-64 | NTclustered | gi|83285205|gb|DQ297752.1| | 360693 | g1657 | i0 | 95.062 | 77.8148148148148 | 162 | 8 | 100 | 0 | 1 | 162 | 75 | 236 | Polyarthra remata 28S ribosomal RNA gene, partial sequence | blastn | 12606 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Synchaetidae | Polyarthra | Polyarthra remata | |
| 11317657 | 11317657 | PRJNA529224_S_NODE_1269_length_185_cov_16.602564_g1262_i0 | PRJNA529224 | 1269 | 185 | 16.602564 | 30.7147434 | Ploima | 84394 | Rotifera | other_Eukaryota | 292 | 8.55e-75 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g1262 | i0 | 95.135 | 13.7567567567568 | 185 | 9 | 100 | 0 | 1 | 185 | 1555 | 1739 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 2545 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 11976721 | 11976721 | PRJNA529224_S_NODE_110_length_446_cov_17.959233_g103_i0 | PRJNA529224 | 110 | 446 | 17.959233 | 80.09817918 | Mytilina ventralis | 360682 | Rotifera | other_Eukaryota | 496 | 1.6599999999999998e-135 | NTclustered | gi|83285200|gb|DQ297747.1| | 360682 | g103 | i0 | 86.801 | 78.1457399103139 | 447 | 55 | 99 | 4 | 3 | 446 | 287 | 732 | Mytilina ventralis 28S ribosomal RNA gene, partial sequence | blastn | 34853 | 496 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Mytilina | Mytilina ventralis | |
| 11976723 | 11976723 | PRJNA529224_S_NODE_1270_length_185_cov_15.403846_g1263_i0 | PRJNA529224 | 1270 | 185 | 15.403846 | 28.4971151 | Asplanchna sieboldii | 84397 | Rotifera | other_Eukaryota | 318 | 1.41e-82 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g1263 | i0 | 97.826 | 13.6864864864865 | 184 | 4 | 99 | 0 | 2 | 185 | 1556 | 1739 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 2532 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 13251838 | 13251838 | PRJNA529224_S_NODE_1111_length_198_cov_17.224852_g1104_i0 | PRJNA529224 | 1111 | 198 | 17.224852 | 34.10520696 | Abrochtha meselsoni | 338310 | Rotifera | other_Eukaryota | 361 | 2.51e-95 | NTclustered | gi|2537903784|gb|KM043249.2| | 338310 | g1104 | i0 | 99.497 | 96.6818181818182 | 199 | 0 | 100 | 1 | 1 | 198 | 249 | 51 | Abrochtha meselsoni voucher Angl_1_1 18S ribosomal RNA gene, partial sequence | blastn | 19143 | 361 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinavida | Philodinavidae | Abrochtha | Abrochtha meselsoni | |
| 17692363 | 17692363 | PRJNA529224_S_NODE_614_length_249_cov_24.872727_g607_i0 | PRJNA529224 | 614 | 249 | 24.872727 | 61.93309023 | Brachionus | 10194 | Rotifera | other_Eukaryota | 335 | 2e-87 | NTclustered | gi|478683563|gb|KC193096.1| | 104777 | g607 | i0 | 91.803 | 102.248995983936 | 244 | 14 | 96 | 5 | 1 | 240 | 2649 | 2890 | Brachionus calyciflorus 28S ribosomal RNA gene, partial sequence | blastn | 25460 | 335 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 18349489 | 18349489 | PRJNA529224_S_NODE_115_length_443_cov_13.405797_g108_i0 | PRJNA529224 | 115 | 443 | 13.405797 | 59.38768071 | Polyarthra remata | 360693 | Rotifera | other_Eukaryota | 671 | 0 | NTclustered | gi|83285205|gb|DQ297752.1| | 360693 | g108 | i0 | 94.104 | 78.6975169300226 | 441 | 26 | 99 | 0 | 3 | 443 | 305 | 745 | Polyarthra remata 28S ribosomal RNA gene, partial sequence | blastn | 34863 | 671 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Synchaetidae | Polyarthra | Polyarthra remata | |
| 18966070 | 18966070 | PRJNA529224_S_NODE_1855_length_154_cov_16.872000_g1848_i0 | PRJNA529224 | 1855 | 154 | 16.872 | 25.98288 | Metazoa | 33208 | Rotifera | other_Eukaryota | 268 | 1.15e-67 | NTclustered | gi|1399047|gb|U41281.1|PAU41281 | 44582 | g1848 | i0 | 99.324 | 96.1558441558442 | 148 | 1 | 96 | 0 | 7 | 154 | 266 | 413 | Philodina acuticornis 18S rRNA gene | blastn | 14808 | 270 | 0.992592592592593 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina acuticornis | |
| 22791604 | 22791604 | PRJNA529224_S_NODE_1878_length_153_cov_45.088710_g1871_i0 | PRJNA529224 | 1878 | 153 | 45.08871 | 68.9857263 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 278 | 1.9e-70 | NTclustered | gi|1173728641|gb|KY886364.1| | 104777 | g1871 | i0 | 100 | 98.6862745098039 | 150 | 0 | 98 | 0 | 3 | 152 | 1445 | 1594 | Brachionus calyciflorus isolate AP2 small subunit ribosomal RNA gene, partial sequence | blastn | 15099 | 279 | 0.996415770609319 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 23450340 | 23450340 | PRJNA529224_S_NODE_1639_length_163_cov_46.208955_g1632_i0 | PRJNA529224 | 1639 | 163 | 46.208955 | 75.32059665 | Keratella tropica | 885372 | Rotifera | other_Eukaryota | 291 | 2.64e-74 | NTclustered | gi|398258127|gb|JN579390.1| | 885372 | g1632 | i0 | 98.773 | 99.398773006135 | 163 | 2 | 100 | 0 | 1 | 163 | 357 | 519 | Keratella tropica isolate T15 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 16202 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Keratella | Keratella tropica | |
| 24066401 | 24066401 | PRJNA529224_S_NODE_1579_length_167_cov_17.021739_g1572_i0 | PRJNA529224 | 1579 | 167 | 17.021739 | 28.42630413 | Metazoa | 33208 | Rotifera | other_Eukaryota | 309 | 7.53e-80 | NTclustered | gi|146157266|gb|EF485009.1| | 96448 | g1572 | i0 | 100 | 5.95808383233533 | 167 | 0 | 100 | 0 | 1 | 167 | 368 | 534 | Philodina roseola clone Pr_TEL_J telomeric repeat and subterminal DNA junction | blastn | 995 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 24723995 | 24723995 | PRJNA529224_S_NODE_1220_length_188_cov_17.949686_g1213_i0 | PRJNA529224 | 1220 | 188 | 17.949686 | 33.74540968 | Cephalodella gibba | 231616 | Rotifera | other_Eukaryota | 270 | 4.09e-68 | NTclustered | gi|37788188|gb|AY218141.1| | 231616 | g1213 | i0 | 93.478 | 101.117021276596 | 184 | 8 | 96 | 3 | 1 | 180 | 184 | 1 | Cephalodella gibba 28S ribosomal RNA gene, partial sequence | blastn | 19010 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Notommatidae | Cephalodella | Cephalodella gibba |
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);;