RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA493828" and tax_phylum = "Rotifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rotifera · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA493828 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
6852334 6852334 PRJNA493828_P_NODE_2666_length_649_cov_10.802083_g2325_i0 PRJNA493828 2666 649 10.802083 70.10551867 Philodina roseola 96448 Rotifera other_Eukaryota 1171 0   NTclustered gi|37785582|gb|AY210469.1| 96448 g2325 i0 99.381 41.7596302003082 646 4 99 0 4 649 2519 1874 Philodina roseola 28S ribosomal RNA gene, partial sequence blastn 27102 1171 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Philodina Philodina roseola
10678058 10678058 PRJNA493828_P_NODE_13249_length_320_cov_10.259109_g12830_i0 PRJNA493828 13249 320 10.259109 32.8291488 Philodina roseola 96448 Rotifera other_Eukaryota 566 8.669999999999999e-157   NTclustered gi|37785582|gb|AY210469.1| 96448 g12830 i0 99.048 45.88125 315 3 98 0 4 318 3045 2731 Philodina roseola 28S ribosomal RNA gene, partial sequence blastn 14682 566 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Philodina Philodina roseola
10678151 10678151 PRJNA493828_P_NODE_1949_length_755_cov_8.326979_g1625_i0 PRJNA493828 1949 755 8.326979 62.86869145 Philodina roseola 96448 Rotifera other_Eukaryota 1345 0   NTclustered gi|37785582|gb|AY210469.1| 96448 g1625 i0 98.808 93.1205298013245 755 9 100 0 1 755 1142 388 Philodina roseola 28S ribosomal RNA gene, partial sequence blastn 70306 1345 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Philodina Philodina roseola
14503178 14503178 PRJNA493828_P_NODE_11852_length_336_cov_3.216730_g11433_i0 PRJNA493828 11852 336 3.21673 10.8082128 Asplanchna sp. 3231738 Rotifera other_Eukaryota 342 1.68e-89   NTclustered gi|2778092479|gb|PP988071.1| 3231738 g11433 i0 85.337 73.1101190476191 341 38 99 12 2 336 2264 1930 Asplanchna sp. chromosome I mitochondrion, complete sequence blastn 24565 342 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Asplanchnidae Asplanchna Asplanchna sp.
15777244 15777244 PRJNA493828_P_NODE_23733_length_274_cov_20.875622_g23314_i0 PRJNA493828 23733 274 20.875622 57.19920428 Philodina roseola 96448 Rotifera other_Eukaryota 492 1.2499999999999996e-134   NTclustered gi|37785582|gb|AY210469.1| 96448 g23314 i0 100 55.521897810219 266 0 97 0 6 271 1822 1557 Philodina roseola 28S ribosomal RNA gene, partial sequence blastn 15213 492 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Philodina Philodina roseola
23426848 23426848 PRJNA493828_P_NODE_11479_length_340_cov_4.928839_g11060_i0 PRJNA493828 11479 340 4.928839 16.7580526 Philodina roseola 96448 Rotifera other_Eukaryota 592 1.5299999999999996e-164   NTclustered gi|37785582|gb|AY210469.1| 96448 g11060 i0 99.69 76.3264705882353 323 1 95 0 18 340 5 327 Philodina roseola 28S ribosomal RNA gene, partial sequence blastn 25951 592 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Philodina Philodina roseola

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