contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA929952" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2184518 | 2184518 | PRJNA929952_P_NODE_23582_length_162_cov_2.150376_g22288_i0 | PRJNA929952 | 23582 | 162 | 2.150376 | 3.48360912 | Lecane bulla AEG9 | 1225256 | Rotifera | other_Eukaryota | 122 | 1.0099999999999999e-23 | NTclustered | gi|320564723|gb|HQ944348.1| | 1225256 | g22288 | i0 | 85.965 | 42.3888888888889 | 114 | 16 | 70 | 0 | 42 | 155 | 502 | 389 | Lecane bulla AEG9 voucher CTM0061 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial | blastn | 6867 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla AEG9 | |
| 2184546 | 2184546 | PRJNA929952_P_NODE_9882_length_369_cov_88.852941_g8601_i0 | PRJNA929952 | 9882 | 369 | 88.852941 | 327.86735229 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 355 | 2.39e-93 | NTclustered | gi|83285189|gb|DQ297736.1| | 96446 | g8601 | i0 | 100 | 27.7777777777778 | 192 | 0 | 77 | 0 | 178 | 369 | 1 | 192 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 10250 | 355 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 2530473 | 2530473 | PRJNA929952_P_NODE_22622_length_172_cov_23.594406_g21328_i0 | PRJNA929952 | 22622 | 172 | 23.594406 | 40.58237832 | Ploima | 84394 | Rotifera | other_Eukaryota | 318 | 1.2899999999999999e-82 | NTclustered | gi|2317705897|gb|OP653727.1| | 96446 | g21328 | i0 | 100 | 99.9941860465116 | 172 | 0 | 100 | 0 | 1 | 172 | 1372 | 1543 | Lecane bulla voucher P11 small subunit ribosomal RNA gene, partial sequence | blastn | 17199 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 4737502 | 4737502 | PRJNA929952_P_NODE_13384_length_292_cov_2.517110_g12091_i0 | PRJNA929952 | 13384 | 292 | 2.51711 | 7.3499612 | Adineta vaga complex sp. B JFF-2016 | 1813165 | Rotifera | other_Eukaryota | 516 | 7.979999999999999e-142 | NTclustered | gi|1005055631|gb|KU860774.1| | 1813165 | g12091 | i0 | 98.63 | 26.4041095890411 | 292 | 3 | 99 | 1 | 1 | 291 | 1442 | 1733 | Adineta vaga complex sp. B JFF-2016 isolate H158a 28S ribosomal RNA gene, partial sequence | blastn | 7710 | 516 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. B JFF-2016 | |
| 5083123 | 5083123 | PRJNA929952_P_NODE_6804_length_470_cov_2.349206_g5627_i0 | PRJNA929952 | 6804 | 470 | 2.349206 | 11.0412682 | Brachionus | 10194 | Rotifera | other_Eukaryota | 152 | 4.38e-32 | NTclustered | gi|260909209|gb|GQ894740.1| | 183141 | g5627 | i0 | 83.133 | 27.9425531914894 | 166 | 28 | 35 | 0 | 113 | 278 | 1328 | 1163 | Brachionus ibericus cytochrome oxidase subunit I (COI) gene, complete cds; mitochondrial | blastn | 13133 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus ibericus | |
| 7287258 | 7287258 | PRJNA929952_P_NODE_23666_length_161_cov_2.583333_g22372_i0 | PRJNA929952 | 23666 | 161 | 2.583333 | 4.15916613 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 187 | 3.5099999999999993e-43 | NTclustered | gi|924266819|gb|KP993543.1| | 10195 | g22372 | i0 | 87.578 | 84.2484472049689 | 161 | 20 | 100 | 0 | 1 | 161 | 2010 | 2170 | Brachionus plicatilis beta-actin gene, complete cds | blastn | 13564 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 7632943 | 7632943 | PRJNA929952_P_NODE_3226_length_689_cov_10.707576_g2424_i0 | PRJNA929952 | 3226 | 689 | 10.707576 | 73.77519864 | Brachionus | 10194 | Rotifera | other_Eukaryota | 113 | 3.11e-20 | NTclustered | gi|950655830|gb|KT151641.1| | 183142 | g2424 | i0 | 75.836 | 3.99854862119013 | 269 | 40 | 37 | 23 | 270 | 527 | 293 | 547 | Brachionus quadridentatus 12S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 2755 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus quadridentatus | |
| 8562096 | 8562096 | PRJNA929952_P_NODE_20787_length_197_cov_15.160714_g19493_i0 | PRJNA929952 | 20787 | 197 | 15.160714 | 29.86660658 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 359 | 8.98e-95 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g19493 | i0 | 100 | 18.0304568527919 | 194 | 0 | 98 | 0 | 1 | 194 | 1814 | 2007 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 3552 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 8562106 | 8562106 | PRJNA929952_P_NODE_267_length_1702_cov_3.465631_g181_i0 | PRJNA929952 | 267 | 1702 | 3.465631 | 58.98503962 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 1086 | 0 | NTclustered | gi|254587481|dbj|AB513493.1| | 10195 | g181 | i0 | 80.742 | 70.5616921269095 | 1402 | 242 | 81 | 20 | 221 | 1605 | 1460 | 70 | Brachionus plicatilis tef1a mRNA for translation elongation factor 1 alpha, complete cds | blastn | 120096 | 1086 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 9837158 | 9837158 | PRJNA929952_P_NODE_23528_length_163_cov_1.134328_g22234_i0 | PRJNA929952 | 23528 | 163 | 1.134328 | 1.84895464 | Eosphora ehrenbergi | 104793 | Rotifera | other_Eukaryota | 130 | 6.1e-26 | NTclustered | gi|6018205|gb|AF143858.1|AF143858 | 104793 | g22234 | i0 | 81.366 | 30.478527607362 | 161 | 28 | 98 | 2 | 4 | 163 | 272 | 113 | Eosphora ehrenbergi 82 kD heat shock protein (hsp82) gene, partial cds | blastn | 4968 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Notommatidae | Eosphora | Eosphora ehrenbergi | |
| 11112815 | 11112815 | PRJNA929952_P_NODE_7269_length_451_cov_259.936019_g6066_i0 | PRJNA929952 | 7269 | 451 | 259.936019 | 1172.31144569 | Lepadella patella | 231622 | Rotifera | other_Eukaryota | 645 | 1.5799999999999996e-180 | NTclustered | gi|83285192|gb|DQ297739.1| | 231622 | g6066 | i0 | 92.494 | 76.1286031042129 | 453 | 31 | 100 | 3 | 1 | 451 | 287 | 738 | Lepadella patella 28S ribosomal RNA gene, partial sequence | blastn | 34334 | 645 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella patella | |
| 12388350 | 12388350 | PRJNA929952_P_NODE_9310_length_386_cov_2.812325_g8036_i0 | PRJNA929952 | 9310 | 386 | 2.812325 | 10.8555745 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 477 | 5.129999999999998e-130 | NTclustered | gi|167842611|gb|EU188928.1| | 96446 | g8036 | i0 | 90.489 | 90.3212435233161 | 368 | 24 | 95 | 2 | 1 | 367 | 372 | 15 | Lecane bulla isolate Cattail D cytochrome oxidase subunit I-like (cox1) gene, partial sequence; mitochondrial | blastn | 34864 | 477 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 16212086 | 16212086 | PRJNA929952_P_NODE_13173_length_296_cov_1.973783_g11880_i0 | PRJNA929952 | 13173 | 296 | 1.973783 | 5.84239768 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 481 | 2.96e-131 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g11880 | i0 | 95.946 | 4.63851351351351 | 296 | 12 | 100 | 0 | 1 | 296 | 10354 | 10059 | 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 | 1373 | 481 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 16212088 | 16212088 | PRJNA929952_P_NODE_13293_length_294_cov_2.015094_g12000_i0 | PRJNA929952 | 13293 | 294 | 2.015094 | 5.92437636 | Synchaeta pectinata | 525906 | Rotifera | other_Eukaryota | 351 | 2.4e-92 | NTclustered | gi|403492659|gb|JX193068.1| | 525906 | g12000 | i0 | 87.931 | 101.62925170068 | 290 | 35 | 99 | 0 | 1 | 290 | 538 | 827 | Synchaeta pectinata isolate A458.2 alpha tubulin gene, partial cds | blastn | 29879 | 351 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Synchaetidae | Synchaeta | Synchaeta pectinata | |
| 16212120 | 16212120 | PRJNA929952_P_NODE_7133_length_457_cov_9.563084_g5936_i0 | PRJNA929952 | 7133 | 457 | 9.563084 | 43.70329388 | Lepadella patella | 231622 | Rotifera | other_Eukaryota | 226 | 2.4699999999999993e-54 | NTclustered | gi|166014123|gb|EU252112.1| | 497825 | g5936 | i0 | 81.605 | 22.7199124726477 | 299 | 29 | 63 | 18 | 168 | 457 | 464 | 183 | Lepadella patella oblonga internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 10383 | 226 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella patella | |
| 16212123 | 16212123 | PRJNA929952_P_NODE_8453_length_410_cov_723.236220_g7194_i0 | PRJNA929952 | 8453 | 410 | 723.23622 | 2965.268502 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 680 | 0 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g7194 | i0 | 96.585 | 63.3756097560976 | 410 | 14 | 100 | 0 | 1 | 410 | 447 | 38 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 25984 | 680 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 16212127 | 16212127 | PRJNA929952_P_NODE_9773_length_372_cov_227.364431_g8495_i0 | PRJNA929952 | 9773 | 372 | 227.364431 | 845.79568332 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 652 | 0 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g8495 | i0 | 98.387 | 86.1424731182796 | 372 | 5 | 100 | 1 | 1 | 372 | 1358 | 1728 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 32045 | 652 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 17487411 | 17487411 | PRJNA929952_P_NODE_13714_length_286_cov_3.058366_g12421_i0 | PRJNA929952 | 13714 | 286 | 3.058366 | 8.74692676 | Proales similis | 360698 | Rotifera | other_Eukaryota | 309 | 1.4200000000000002e-79 | NTclustered | gi|1859640894|gb|MN970216.1| | 360698 | g12421 | i0 | 89.2 | 56.7622377622378 | 250 | 23 | 87 | 3 | 35 | 282 | 12235 | 12482 | Proales similis mitochondrion, complete genome | blastn | 16234 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Proalidae | Proales | Proales similis | |
| 17487413 | 17487413 | PRJNA929952_P_NODE_14534_length_273_cov_23.413934_g13240_i0 | PRJNA929952 | 14534 | 273 | 23.413934 | 63.92003982 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 503 | 5.76e-138 | NTclustered | gi|83285086|gb|DQ297698.1| | 96446 | g13240 | i0 | 100 | 99.6410256410256 | 272 | 0 | 99 | 0 | 1 | 272 | 893 | 622 | Lecane bulla 18S ribosomal RNA gene, partial sequence | blastn | 27202 | 503 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 18760786 | 18760786 | PRJNA929952_P_NODE_2775_length_733_cov_18.876420_g2057_i0 | PRJNA929952 | 2775 | 733 | 18.87642 | 138.3641586 | Brachionus angularis | 396692 | Rotifera | other_Eukaryota | 346 | 3.01e-90 | NTclustered | gi|1999716433|gb|MT875425.1| | 396692 | g2057 | i0 | 81.839 | 13.3519781718963 | 435 | 57 | 58 | 19 | 307 | 732 | 6205 | 6626 | Brachionus angularis chromosome I mitochondrion, complete sequence | blastn | 9787 | 346 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus angularis | |
| 22586139 | 22586139 | PRJNA929952_P_NODE_20058_length_209_cov_14.650000_g18764_i0 | PRJNA929952 | 20058 | 209 | 14.65 | 30.6185 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 385 | 1.59e-102 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g18764 | i0 | 100 | 101.205741626794 | 208 | 0 | 99 | 0 | 1 | 208 | 2305 | 2512 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 21152 | 385 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 22932627 | 22932627 | PRJNA929952_P_NODE_19818_length_213_cov_18.755435_g18524_i0 | PRJNA929952 | 19818 | 213 | 18.755435 | 39.94907655 | Lecane | 96445 | Rotifera | other_Eukaryota | 394 | 2.7e-105 | NTclustered | gi|83285086|gb|DQ297698.1| | 96446 | g18524 | i0 | 100 | 100.272300469484 | 213 | 0 | 100 | 0 | 1 | 213 | 355 | 143 | Lecane bulla 18S ribosomal RNA gene, partial sequence | blastn | 21358 | 394 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla |
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);;