RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJEB20058" and tax_phylum = "Rotifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rotifera · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB20058 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
25614162 25614162 PRJEB20058_P_NODE_31649_length_745_cov_30.861111_g29142_i0 PRJEB20058 31649 745 30.861111 229.91527695 Metazoa 33208 Rotifera other_Eukaryota 1116 0   NTclustered gi|37785582|gb|AY210469.1| 96448 g29142 i0 95.809 37.9463087248322 692 28 93 1 23 714 1842 2532 Philodina roseola 28S ribosomal RNA gene, partial sequence blastn 28270 1127 0.990239574090506 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Philodina Philodina roseola
26430213 26430213 PRJEB20058_P_NODE_244943_length_205_cov_4.562500_g242118_i0 PRJEB20058 244943 205 4.5625 9.353125 Philodinidae 44580 Rotifera other_Eukaryota 296 7.49e-76   NTclustered gi|37785582|gb|AY210469.1| 96448 g242118 i0 93.5 80.6 200 12 98 1 1 200 143 341 Philodina roseola 28S ribosomal RNA gene, partial sequence blastn 16523 296 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Philodina Philodina roseola
26467642 26467642 PRJEB20058_P_NODE_151112_length_312_cov_2.278884_g148290_i0 PRJEB20058 151112 312 2.278884 7.11011808 Encentrum astridae 360661 Rotifera other_Eukaryota 459 1.47e-124   NTclustered gi|124388846|gb|EF151006.1| 360661 g148290 i0 95.47 83.8685897435897 287 13 92 0 22 308 1767 2053 Encentrum astridae 28S ribosomal RNA gene, partial sequence blastn 26167 459 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Dicranophoridae Encentrum Encentrum astridae
26567299 26567299 PRJEB20058_P_NODE_71704_length_491_cov_91.872093_g68929_i0 PRJEB20058 71704 491 91.872093 451.09197663 Brachionus 10194 Rotifera other_Eukaryota 460 6.72e-125   NTclustered gi|478683563|gb|KC193096.1| 104777 g68929 i0 92.097 64.1975560081466 329 23 89 3 13 339 2453 2126 Brachionus calyciflorus 28S ribosomal RNA gene, partial sequence blastn 31521 462 0.995670995670996 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus calyciflorus

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