RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA330616" and tax_phylum = "Rotifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rotifera · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA330616 · 12 ✖

analysis 1

  • blastn · 12 ✖
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
1069336 1069336 PRJNA330616_P_NODE_20821_length_185_cov_1.500000_g20412_i0 PRJNA330616 20821 185 1.5 2.775 Metazoa 33208 Rotifera other_Eukaryota 337 3.89e-88   NTclustered gi|37785582|gb|AY210469.1| 96448 g20412 i0 99.459 24.1297297297297 185 1 100 0 1 185 2965 3149 Philodina roseola 28S ribosomal RNA gene, partial sequence blastn 4464 337 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Philodina Philodina roseola
2940361 2940361 PRJNA330616_P_NODE_24643_length_170_cov_1.264463_g24234_i0 PRJNA330616 24643 170 1.264463 2.1495871 Adineta oculata 338306 Rotifera other_Eukaryota 315 1.64e-81   NTclustered gi|71840136|gb|DQ078515.1| 338306 g24234 i0 100 95.3470588235294 170 0 100 0 1 170 123 292 Adineta oculata clone War1.1 cytochrome oxidase subunit 1 (cox1) gene, partial cds; mitochondrial blastn 16209 315 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta oculata
3620050 3620050 PRJNA330616_P_NODE_25103_length_168_cov_1.714286_g24694_i0 PRJNA330616 25103 168 1.714286 2.88000048 Philodinidae 44580 Rotifera other_Eukaryota 311 2.11e-80   NTclustered gi|1399047|gb|U41281.1|PAU41281 44582 g24694 i0 100 99.9940476190476 168 0 100 0 1 168 1423 1256 Philodina acuticornis 18S rRNA gene blastn 16799 311 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Philodina Philodina acuticornis
5493172 5493172 PRJNA330616_P_NODE_18765_length_194_cov_1.896552_g18356_i0 PRJNA330616 18765 194 1.896552 3.67931088 Adineta vaga 104782 Rotifera other_Eukaryota 359 8.809999999999999e-95   NTclustered gi|259129963|gb|GQ398061.1| 104782 g18356 i0 100 5.58762886597938 194 0 100 0 1 194 10243 10050 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 1084 359 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga
6172411 6172411 PRJNA330616_P_NODE_7365_length_306_cov_6.665370_g6956_i0 PRJNA330616 7365 306 6.66537 20.3960322 Adineta 104781 Rotifera other_Eukaryota 566 8.239999999999998e-157   NTclustered gi|72153731|gb|DQ089739.1| 104782 g6956 i0 100 26.5947712418301 306 0 100 0 1 306 1513 1818 Adineta vaga 28S ribosomal RNA gene, partial sequence blastn 8138 566 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga
8043128 8043128 PRJNA330616_P_NODE_4947_length_380_cov_3.477341_g4538_i0 PRJNA330616 4947 380 3.477341 13.2138958 Philodina citrina 468664 Rotifera other_Eukaryota 411 5.189999999999999e-110   NTclustered gi|407227484|emb|FR856884.1| 468664 g4538 i0 87.027 33.8131578947368 370 41 97 6 13 380 1834 2198 Philodina citrina complete mitochondrial genome blastn 12849 411 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Philodina Philodina citrina
11868393 11868393 PRJNA330616_P_NODE_2790_length_528_cov_5.012526_g2386_i0 PRJNA330616 2790 528 5.012526 26.46613728 Adineta vaga 104782 Rotifera other_Eukaryota 832 0   NTclustered gi|259129963|gb|GQ398061.1| 104782 g2386 i0 95.085 96.4375 529 24 100 2 1 528 6975 7502 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 50919 832 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga
13143420 13143420 PRJNA330616_P_NODE_6651_length_324_cov_1.665455_g6242_i0 PRJNA330616 6651 324 1.665455 5.3960742 Habrotrocha constricta 104786 Rotifera other_Eukaryota 405 2.03e-108   NTclustered gi|402761757|gb|JX184010.1| 104786 g6242 i0 89.198 75.2962962962963 324 35 100 0 1 324 565 242 Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial blastn 24396 405 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Habrotrochidae Habrotrocha Habrotrocha constricta
16967233 16967233 PRJNA330616_P_NODE_7114_length_312_cov_3.703422_g6705_i0 PRJNA330616 7114 312 3.703422 11.55467664 Adineta vaga 104782 Rotifera other_Eukaryota 577 3.89e-160   NTclustered gi|72153731|gb|DQ089739.1| 104782 g6705 i0 100 89.7147435897436 312 0 100 0 1 312 503 814 Adineta vaga 28S ribosomal RNA gene, partial sequence blastn 27991 577 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga
18241133 18241133 PRJNA330616_P_NODE_11495_length_244_cov_1.138462_g11086_i0 PRJNA330616 11495 244 1.138462 2.77784728 Rotaria rotatoria 231624 Rotifera other_Eukaryota 237 5.6600000000000005e-58   NTclustered gi|270267490|ref|NC_013568.1| 231624 g11086 i0 85.246 2.15573770491803 244 21 97 10 8 244 9424 9189 Rotaria rotatoria mitochondrion, complete genome blastn 526 237 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria rotatoria
18920934 18920934 PRJNA330616_P_NODE_5415_length_361_cov_19.400641_g5006_i0 PRJNA330616 5415 361 19.400641 70.03631401 Opisthokonta 33154 Rotifera other_Eukaryota 634 2.6699999999999993e-177   NTclustered gi|259129963|gb|GQ398061.1| 104782 g5006 i0 98.338 78.4930747922438 361 6 100 0 1 361 7010 6650 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 28336 640 0.990625 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga
24615784 24615784 PRJNA330616_P_NODE_22960_length_176_cov_2.007874_g22551_i0 PRJNA330616 22960 176 2.007874 3.53385824 Adineta vaga 104782 Rotifera other_Eukaryota 206 1.08e-48   NTclustered gi|259129963|gb|GQ398061.1| 104782 g22551 i0 87.778 101.909090909091 180 17 100 3 1 176 6498 6320 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 17936 206 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;