contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA986481" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2248597 | 2248597 | PRJNA986481_P_NODE_24722_length_330_cov_1.982206_g24197_i0 | PRJNA986481 | 24722 | 330 | 1.982206 | 6.5412798 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 582 | 8.91e-162 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g24197 | i0 | 98.485 | 4.36969696969697 | 330 | 5 | 100 | 0 | 1 | 330 | 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 | 1442 | 582 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 2248917 | 2248917 | PRJNA986481_P_NODE_43782_length_259_cov_1.023810_g43257_i0 | PRJNA986481 | 43782 | 259 | 1.02381 | 2.6516679 | Adineta vaga complex sp. C JFF-2016 | 1813166 | Rotifera | other_Eukaryota | 324 | 4.53e-84 | NTclustered | gi|1005061344|gb|KU861166.1| | 1813166 | g43257 | i0 | 89.189 | 97.8687258687259 | 259 | 28 | 100 | 0 | 1 | 259 | 227 | 485 | Adineta vaga complex sp. C JFF-2016 isolate H4-28a 82 kDa heat shock protein gene, partial cds | blastn | 25348 | 324 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. C JFF-2016 | |
| 3523805 | 3523805 | PRJNA986481_P_NODE_1303_length_1173_cov_15.096085_g1075_i0 | PRJNA986481 | 1303 | 1173 | 15.096085 | 177.07707705 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 647 | 1.2e-180 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g1075 | i0 | 80.207 | 36.3162830349531 | 869 | 166 | 74 | 5 | 288 | 1153 | 866 | 1 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 42599 | 647 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 7351823 | 7351823 | PRJNA986481_P_NODE_9506_length_530_cov_1.937630_g8987_i0 | PRJNA986481 | 9506 | 530 | 1.93763 | 10.269439 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 560 | 6.99e-155 | NTclustered | gi|402761725|gb|JX183994.1| | 104786 | g8987 | i0 | 89.616 | 4.41132075471698 | 443 | 42 | 83 | 4 | 68 | 508 | 630 | 190 | Habrotrocha constricta ATP synthase F0 subunit 6 (ATP6) gene, partial cds; mitochondrial | blastn | 2338 | 560 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 8924947 | 8924947 | PRJNA986481_P_NODE_20487_length_362_cov_1.814696_g19962_i0 | PRJNA986481 | 20487 | 362 | 1.814696 | 6.56919952 | Adineta | 104781 | Rotifera | other_Eukaryota | 641 | 1.5999999999999993e-179 | NTclustered | gi|1005055512|gb|KU860655.1| | 1813164 | g19962 | i0 | 98.619 | 53.4917127071823 | 362 | 5 | 100 | 0 | 1 | 362 | 1660 | 2021 | Adineta vaga complex sp. A JFF-2016 isolate H001 28S ribosomal RNA gene, partial sequence | blastn | 19364 | 641 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. A JFF-2016 | |
| 9902192 | 9902192 | PRJNA986481_P_NODE_708_length_1453_cov_4.797009_g567_i0 | PRJNA986481 | 708 | 1453 | 4.797009 | 69.70054077 | Asplanchna sp. | 3231738 | Rotifera | other_Eukaryota | 1131 | 0 | NTclustered | gi|2778092484|gb|PP988072.1| | 3231738 | g567 | i0 | 80.883 | 51.0743289745354 | 1449 | 265 | 99 | 10 | 1 | 1440 | 116 | 1561 | Asplanchna sp. chromosome II mitochondrion, complete sequence | blastn | 74211 | 1131 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sp. | |
| 13727646 | 13727646 | PRJNA986481_P_NODE_871_length_1371_cov_8.809380_g702_i0 | PRJNA986481 | 871 | 1371 | 8.80938 | 120.7765998 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 638 | 8.479999999999999e-178 | NTclustered | gi|632795131|gb|KJ489418.1| | 392764 | g702 | i0 | 75.704 | 14.8205689277899 | 1350 | 287 | 97 | 35 | 14 | 1340 | 5739 | 7070 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 20319 | 638 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 17849852 | 17849852 | PRJNA986481_P_NODE_634_length_1501_cov_5.906336_g499_i0 | PRJNA986481 | 634 | 1501 | 5.906336 | 88.65410336 | Philodinida | 104783 | Rotifera | other_Eukaryota | 1768 | 0 | NTclustered | gi|402761741|gb|JX184002.1| | 104786 | g499 | i0 | 87.933 | 48.5369753497668 | 1500 | 181 | 99 | 0 | 2 | 1501 | 19 | 1518 | Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 72854 | 1779 | 0.993816750983699 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 18825669 | 18825669 | PRJNA986481_P_NODE_56975_length_244_cov_2.789744_g56450_i0 | PRJNA986481 | 56975 | 244 | 2.789744 | 6.80697536 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 230 | 9.47e-56 | NTclustered | gi|187233665|gb|EU643499.1| | 104782 | g56450 | i0 | 83.607 | 1 | 244 | 40 | 100 | 0 | 1 | 244 | 412 | 169 | Adineta vaga ribosomal protein L26 mRNA, partial cds | blastn | 244 | 230 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 20100024 | 20100024 | PRJNA986481_P_NODE_33616_length_282_cov_1.300429_g33091_i0 | PRJNA986481 | 33616 | 282 | 1.300429 | 3.66720978 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 207 | 5.25e-49 | NTclustered | gi|209867641|gb|EU637019.1| | 96448 | g33091 | i0 | 82.353 | 34.4468085106383 | 238 | 42 | 84 | 0 | 1 | 238 | 26275 | 26038 | Philodina roseola tyramine beta hydroxylase-like protein, metallophosphoesterase domain containing 1-like protein, transmembrane protein 45b-like protein, solute carrier family 7-like protein, G protein-coupled receptor-like protein, serpin 6 precursor, molybdenum cofactor-like protein, hypothetical protein, ankyrin repeat containing protein, neuronal calcium sensor family member 2-like protein, HSP70-like protein, hypothetical protein, Hox-5b, Smc-like protein, and golgi autoantigen golgin subfamily a4-like protein genes, complete cds | blastn | 9714 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 20398586 | 20398586 | PRJNA986481_P_NODE_8976_length_543_cov_20.769231_g8463_i0 | PRJNA986481 | 8976 | 543 | 20.769231 | 112.77692433 | Philodinidae | 44580 | Rotifera | other_Eukaryota | 544 | 7.219999999999998e-150 | NTclustered | gi|270267490|ref|NC_013568.1| | 231624 | g8463 | i0 | 86.187 | 31.4935543278085 | 514 | 58 | 93 | 11 | 35 | 541 | 1896 | 2403 | Rotaria rotatoria mitochondrion, complete genome | blastn | 17101 | 549 | 0.990892531876138 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 22651060 | 22651060 | PRJNA986481_P_NODE_6158_length_646_cov_5.710218_g569_i1 | PRJNA986481 | 6158 | 646 | 5.710218 | 36.88800828 | Adineta vaga complex sp. C JFF-2016 | 1813166 | Rotifera | other_Eukaryota | 538 | 4.0399999999999984e-148 | NTclustered | gi|1005061344|gb|KU861166.1| | 1813166 | g569 | i1 | 88.864 | 72.9489164086687 | 440 | 46 | 68 | 3 | 162 | 598 | 1399 | 960 | Adineta vaga complex sp. C JFF-2016 isolate H4-28a 82 kDa heat shock protein gene, partial cds | blastn | 47125 | 538 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. C JFF-2016 | |
| 25199381 | 25199381 | PRJNA986481_P_NODE_11560_length_482_cov_1.866051_g11037_i0 | PRJNA986481 | 11560 | 482 | 1.866051 | 8.99436582 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 523 | 8.279999999999997e-144 | NTclustered | gi|402761805|gb|JX184034.1| | 104786 | g11037 | i0 | 86.555 | 18.5290456431535 | 476 | 62 | 99 | 2 | 1 | 475 | 805 | 331 | Habrotrocha constricta NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial | blastn | 8931 | 523 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 25200161 | 25200161 | PRJNA986481_P_NODE_6060_length_650_cov_5.594010_g5592_i0 | PRJNA986481 | 6060 | 650 | 5.59401 | 36.361065 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 630 | 6.529999999999999e-176 | NTclustered | gi|402761773|gb|JX184018.1| | 104786 | g5592 | i0 | 84.341 | 4.91538461538462 | 645 | 99 | 99 | 2 | 5 | 648 | 28 | 671 | Habrotrocha constricta cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial | blastn | 3195 | 630 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta |
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);;