contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA416866" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 419635 | 419635 | PRJNA416866_P_NODE_8961_length_214_cov_4.549020_g8817_i0 | PRJNA416866 | 8961 | 214 | 4.54902 | 9.7349028 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 374 | 3.539999999999999e-99 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g8817 | i0 | 98.131 | 3.14485981308411 | 214 | 4 | 100 | 0 | 1 | 214 | 10184 | 10397 | 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 | 673 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 2970370 | 2970370 | PRJNA416866_P_NODE_8623_length_219_cov_2.018987_g8479_i0 | PRJNA416866 | 8623 | 219 | 2.018987 | 4.42158153 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 252 | 1.78e-62 | NTclustered | gi|402761739|gb|JX184001.1| | 104782 | g8479 | i0 | 88.152 | 86.986301369863 | 211 | 25 | 96 | 0 | 9 | 219 | 1209 | 999 | Adineta vaga cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 19050 | 252 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 2970372 | 2970372 | PRJNA416866_P_NODE_903_length_765_cov_26.808239_g774_i0 | PRJNA416866 | 903 | 765 | 26.808239 | 205.08302835 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 678 | 0 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g774 | i0 | 83.031 | 23.0235294117647 | 772 | 107 | 99 | 20 | 2 | 762 | 1656 | 2414 | Philodina citrina complete mitochondrial genome | blastn | 17613 | 678 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 4911761 | 4911761 | PRJNA416866_P_NODE_3684_length_346_cov_3.077193_g3541_i0 | PRJNA416866 | 3684 | 346 | 3.077193 | 10.64708778 | Adinetidae | 104780 | Rotifera | other_Eukaryota | 634 | 2.5599999999999996e-177 | NTclustered | gi|2537903788|gb|KM043253.2| | 104782 | g3541 | i0 | 99.711 | 99.8670520231214 | 346 | 1 | 100 | 0 | 1 | 346 | 559 | 904 | Adineta vaga voucher AD006 18S ribosomal RNA gene, partial sequence | blastn | 34554 | 634 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 7461688 | 7461688 | PRJNA416866_P_NODE_1126_length_670_cov_5.796388_g989_i0 | PRJNA416866 | 1126 | 670 | 5.796388 | 38.8357996 | Adineta | 104781 | Rotifera | other_Eukaryota | 1210 | 0 | NTclustered | gi|1005055512|gb|KU860655.1| | 1813164 | g989 | i0 | 99.254 | 41.0507462686567 | 670 | 5 | 100 | 0 | 1 | 670 | 1435 | 2104 | Adineta vaga complex sp. A JFF-2016 isolate H001 28S ribosomal RNA gene, partial sequence | blastn | 27504 | 1210 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. A JFF-2016 | |
| 8072950 | 8072950 | PRJNA416866_P_NODE_11127_length_203_cov_1.408451_g10983_i0 | PRJNA416866 | 11127 | 203 | 1.408451 | 2.85915553 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 268 | 1.6099999999999998e-67 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g10983 | i0 | 90.594 | 86.9261083743842 | 202 | 19 | 99 | 0 | 1 | 202 | 220 | 19 | Philodina citrina complete mitochondrial genome | blastn | 17646 | 268 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 8736620 | 8736620 | PRJNA416866_P_NODE_11387_length_202_cov_3.624113_g11243_i0 | PRJNA416866 | 11387 | 202 | 3.624113 | 7.32070826 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 374 | 3.3e-99 | NTclustered | gi|2537903921|gb|JX494739.2| | 104782 | g11243 | i0 | 100 | 100.009900990099 | 202 | 0 | 100 | 0 | 1 | 202 | 77 | 278 | Adineta vaga isolate O1 18S ribosomal RNA gene, partial sequence | blastn | 20202 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 8736639 | 8736639 | PRJNA416866_P_NODE_4927_length_295_cov_5.807692_g4783_i0 | PRJNA416866 | 4927 | 295 | 5.807692 | 17.1326914 | Adineta | 104781 | Rotifera | other_Eukaryota | 529 | 1.0399999999999996e-145 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g4783 | i0 | 98.983 | 91.9559322033898 | 295 | 3 | 100 | 0 | 1 | 295 | 797 | 503 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 27127 | 529 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 13837225 | 13837225 | PRJNA416866_P_NODE_3631_length_349_cov_7.315972_g3488_i0 | PRJNA416866 | 3631 | 349 | 7.315972 | 25.53274228 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 628 | 1.1999999999999999e-175 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g3488 | i0 | 99.14 | 76.9914040114613 | 349 | 3 | 100 | 0 | 1 | 349 | 6650 | 6998 | 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 | 26870 | 628 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 14448530 | 14448530 | PRJNA416866_P_NODE_2232_length_459_cov_2.412060_g2089_i0 | PRJNA416866 | 2232 | 459 | 2.41206 | 11.0713554 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 566 | 1.29e-156 | NTclustered | gi|134141758|gb|EF173243.1| | 104782 | g2089 | i0 | 88.913 | 97.9368191721133 | 460 | 49 | 100 | 2 | 1 | 459 | 190 | 648 | Adineta vaga isolate FR.3.1 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 44953 | 566 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 15722323 | 15722323 | PRJNA416866_P_NODE_1573_length_553_cov_6.642276_g1432_i0 | PRJNA416866 | 1573 | 553 | 6.642276 | 36.73178628 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 612 | 1.9899999999999998e-170 | NTclustered | gi|402761761|gb|JX184012.1| | 104788 | g1432 | i0 | 86.667 | 9.07414104882459 | 555 | 70 | 100 | 4 | 1 | 553 | 72 | 624 | Macrotrachela quadricornifera isolate CR cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial | blastn | 5018 | 612 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 16997059 | 16997059 | PRJNA416866_P_NODE_1774_length_519_cov_4.718341_g1632_i0 | PRJNA416866 | 1774 | 519 | 4.718341 | 24.48818979 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 538 | 3.2e-148 | NTclustered | gi|402761773|gb|JX184018.1| | 104786 | g1632 | i0 | 85.521 | 1.27167630057803 | 518 | 72 | 99 | 3 | 3 | 519 | 199 | 714 | Habrotrocha constricta cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial | blastn | 660 | 538 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 16997064 | 16997064 | PRJNA416866_P_NODE_2554_length_427_cov_2.601093_g2411_i0 | PRJNA416866 | 2554 | 427 | 2.601093 | 11.10666711 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 540 | 7.21e-149 | NTclustered | gi|402761725|gb|JX183994.1| | 104786 | g2411 | i0 | 89.535 | 4.00936768149883 | 430 | 40 | 100 | 5 | 1 | 427 | 192 | 619 | Habrotrocha constricta ATP synthase F0 subunit 6 (ATP6) gene, partial cds; mitochondrial | blastn | 1712 | 540 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 16997072 | 16997072 | PRJNA416866_P_NODE_4114_length_325_cov_1.939394_g3971_i0 | PRJNA416866 | 4114 | 325 | 1.939394 | 6.3030305 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 579 | 1.1299999999999997e-160 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g3971 | i0 | 98.769 | 53.0615384615385 | 325 | 4 | 100 | 0 | 1 | 325 | 2746 | 2422 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 17245 | 579 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 18271314 | 18271314 | PRJNA416866_P_NODE_9135_length_212_cov_2.543046_g8991_i0 | PRJNA416866 | 9135 | 212 | 2.543046 | 5.39125752 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 180 | 8.19e-41 | NTclustered | gi|402761775|gb|JX184019.1| | 104788 | g8991 | i0 | 84.239 | 3.47169811320755 | 184 | 29 | 87 | 0 | 2 | 185 | 16 | 199 | Macrotrachela quadricornifera isolate MQ cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial | blastn | 736 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 19545510 | 19545510 | PRJNA416866_P_NODE_9056_length_213_cov_2.052632_g8912_i0 | PRJNA416866 | 9056 | 213 | 2.052632 | 4.37210616 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 263 | 7.95e-66 | NTclustered | gi|402761741|gb|JX184002.1| | 104786 | g8912 | i0 | 89.423 | 84.1549295774648 | 208 | 22 | 98 | 0 | 6 | 213 | 971 | 764 | Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 17925 | 263 | 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);;