contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1237347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 344735 | 344735 | PRJNA1237347_P_NODE_528061_length_244_cov_0.900585_g521488_i0 | PRJNA1237347 | 528061 | 244 | 0.900585 | 2.1974274 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 307 | 4.25e-79 | NTclustered | gi|403492564|gb|JX193021.1| | 249248 | g521488 | i0 | 92.558 | 72.5409836065574 | 215 | 15 | 88 | 1 | 2 | 215 | 1019 | 805 | Adineta ricciae isolate AU.1.2 alpha tubulin gene, partial cds | blastn | 17700 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 1616062 | 1616062 | PRJNA1237347_P_NODE_347862_length_304_cov_1.987013_g341289_i0 | PRJNA1237347 | 347862 | 304 | 1.987013 | 6.04051952 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 370 | 6.89e-98 | NTclustered | gi|402761787|gb|JX184025.1| | 104782 | g341289 | i0 | 88.742 | 0.993421052631579 | 302 | 34 | 99 | 0 | 2 | 303 | 1 | 302 | Adineta vaga cytochrome b (CYTB) gene, complete cds; mitochondrial | blastn | 302 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 2890874 | 2890874 | PRJNA1237347_P_NODE_274363_length_353_cov_1.732143_g267790_i0 | PRJNA1237347 | 274363 | 353 | 1.732143 | 6.11446479 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 322 | 2.3e-83 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g267790 | i0 | 83.52 | 1.01416430594901 | 358 | 45 | 100 | 11 | 1 | 353 | 4010 | 3662 | 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 | 358 | 322 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 4172236 | 4172236 | PRJNA1237347_P_NODE_541044_length_243_cov_0.900000_g534471_i0 | PRJNA1237347 | 541044 | 243 | 0.9 | 2.187 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 279 | 9.23e-71 | NTclustered | gi|403492629|gb|JX193053.1| | 104782 | g534471 | i0 | 93.194 | 98.4238683127572 | 191 | 11 | 78 | 2 | 1 | 190 | 554 | 743 | Adineta vaga isolate BE1C1 alpha tubulin gene, partial cds | blastn | 23917 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 4876919 | 4876919 | PRJNA1237347_P_NODE_419244_length_271_cov_79.010101_g412671_i0 | PRJNA1237347 | 419244 | 271 | 79.010101 | 214.11737371 | Metazoa | 33208 | Rotifera | other_Eukaryota | 479 | 9.62e-131 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g412671 | i0 | 98.524 | 98.9889298892989 | 271 | 4 | 100 | 0 | 1 | 271 | 1461 | 1191 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 26826 | 479 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 6152340 | 6152340 | PRJNA1237347_P_NODE_567805_length_217_cov_77.305556_g561231_i0 | PRJNA1237347 | 567805 | 217 | 77.305556 | 167.75305652 | Metazoa | 33208 | Rotifera | other_Eukaryota | 401 | 1.6499999999999994e-107 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g561231 | i0 | 100 | 99.6359447004608 | 217 | 0 | 100 | 0 | 1 | 217 | 3155 | 2939 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 21621 | 401 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 6714334 | 6714334 | PRJNA1237347_P_NODE_117706_length_614_cov_1.085028_g111206_i0 | PRJNA1237347 | 117706 | 614 | 1.085028 | 6.66207192 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 758 | 0 | NTclustered | gi|402761741|gb|JX184002.1| | 104786 | g111206 | i0 | 88.925 | 87.9299674267101 | 614 | 68 | 100 | 0 | 1 | 614 | 871 | 1484 | Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 53989 | 758 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 6723230 | 6723230 | PRJNA1237347_P_NODE_560366_length_236_cov_152.282209_g553793_i0 | PRJNA1237347 | 560366 | 236 | 152.282209 | 359.38601324 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 411 | 3.03e-110 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g553793 | i0 | 98.291 | 59.3432203389831 | 234 | 4 | 99 | 0 | 3 | 236 | 2613 | 2380 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 14005 | 411 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 9976619 | 9976619 | PRJNA1237347_P_NODE_351088_length_302_cov_85.794760_g344515_i0 | PRJNA1237347 | 351088 | 302 | 85.79476 | 259.1001752 | Lecane | 96445 | Rotifera | other_Eukaryota | 520 | 6.409999999999999e-143 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g344515 | i0 | 97.682 | 82.9205298013245 | 302 | 7 | 100 | 0 | 1 | 302 | 2082 | 1781 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 25042 | 520 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 11818014 | 11818014 | PRJNA1237347_P_NODE_239450_length_385_cov_1.560897_g232877_i0 | PRJNA1237347 | 239450 | 385 | 1.560897 | 6.00945345 | Habrotrocha constricta | 104786 | Rotifera | other_Eukaryota | 241 | 7.310000000000001e-59 | NTclustered | gi|402761805|gb|JX184034.1| | 104786 | g232877 | i0 | 78.421 | 2.55844155844156 | 380 | 74 | 98 | 8 | 9 | 384 | 395 | 20 | Habrotrocha constricta NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial | blastn | 985 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Habrotrochidae | Habrotrocha | Habrotrocha constricta | |
| 11819071 | 11819071 | PRJNA1237347_P_NODE_291470_length_340_cov_1.438202_g284897_i0 | PRJNA1237347 | 291470 | 340 | 1.438202 | 4.8898868 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 206 | 2.33e-48 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g284897 | i0 | 81.25 | 1.50294117647059 | 256 | 46 | 75 | 2 | 6 | 260 | 11466 | 11212 | Philodina citrina complete mitochondrial genome | blastn | 511 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 11819426 | 11819426 | PRJNA1237347_P_NODE_310370_length_327_cov_1.212598_g303797_i0 | PRJNA1237347 | 310370 | 327 | 1.212598 | 3.96519546 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 327 | 4.559999999999999e-85 | NTclustered | gi|402761777|gb|JX184020.1| | 104788 | g303797 | i0 | 85.061 | 5.13761467889908 | 328 | 41 | 99 | 6 | 1 | 324 | 291 | 614 | Macrotrachela quadricornifera isolate CR cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial | blastn | 1680 | 327 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 15076012 | 15076012 | PRJNA1237347_P_NODE_347332_length_304_cov_227.389610_g340759_i0 | PRJNA1237347 | 347332 | 304 | 227.38961 | 691.2644144 | Adinetidae | 104780 | Rotifera | other_Eukaryota | 292 | 1.53e-74 | NTclustered | gi|2537903787|gb|KM043252.2| | 104782 | g340759 | i0 | 100 | 101.559210526316 | 158 | 0 | 100 | 0 | 147 | 304 | 708 | 865 | Adineta vaga voucher AD005 18S ribosomal RNA gene, partial sequence | blastn | 30874 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 15648211 | 15648211 | PRJNA1237347_P_NODE_553693_length_241_cov_0.916667_g547120_i0 | PRJNA1237347 | 553693 | 241 | 0.916667 | 2.20916747 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 278 | 3.29e-70 | NTclustered | gi|402761793|gb|JX184028.1| | 104788 | g547120 | i0 | 88.085 | 0.975103734439834 | 235 | 26 | 97 | 2 | 2 | 235 | 499 | 732 | Macrotrachela quadricornifera isolate CR cytochrome b (CYTB) gene, complete cds; mitochondrial | blastn | 235 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 16351694 | 16351694 | PRJNA1237347_P_NODE_49273_length_1064_cov_286.714430_g44384_i0 | PRJNA1237347 | 49273 | 1064 | 286.71443 | 3050.6415352 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 1821 | 0 | NTclustered | gi|72153762|gb|DQ089743.1| | 231624 | g44384 | i0 | 97.484 | 48.75 | 1073 | 16 | 100 | 8 | 1 | 1064 | 1153 | 2223 | Rotaria rotatoria 28S ribosomal RNA gene, partial sequence | blastn | 51870 | 1836 | 0.991830065359477 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 23293000 | 23293000 | PRJNA1237347_P_NODE_303359_length_331_cov_206.569767_g296786_i0 | PRJNA1237347 | 303359 | 331 | 206.569767 | 683.74592877 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 538 | 1.9599999999999998e-148 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g296786 | i0 | 95.821 | 89.5770392749245 | 335 | 10 | 100 | 3 | 1 | 331 | 1387 | 1721 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 29650 | 538 | 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);;