RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA379145" and tax_phylum = "Tardigrada"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Tardigrada · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA379145 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
13154278 13154278 PRJNA379145_P_NODE_13351_length_796_cov_3.431193_g11887_i0 PRJNA379145 13351 796 3.431193 27.31229628 Paramacrobiotus metropolitanus 2943436 Tardigrada other_Eukaryota 401 6.889999999999999e-107   NTclustered gi|2493405654|ref|XM_055472580.1| 2943436 g11887 i0 79.201 72.487437185929707 601 107 74 18 93 684 2087 2678 PREDICTED: Paramacrobiotus metropolitanus eukaryotic translation elongation factor 2-like (LOC129581475), mRNA blastn 57700 401 1 Eukaryota Opisthokonta Metazoa Tardigrada Eutardigrada Parachela Macrobiotidae Paramacrobiotus Paramacrobiotus metropolitanus
18252360 18252360 PRJNA379145_P_NODE_24555_length_503_cov_4.391489_g11887_i1 PRJNA379145 24555 503 4.391489 22.08918967 Paramacrobiotus metropolitanus 2943436 Tardigrada other_Eukaryota 279 2.07e-70   NTclustered gi|2493405658|ref|XM_055472581.1| 2943436 g11887 i1 80.157 68.0874751491054 383 68 75 8 13 391 3283 2905 PREDICTED: Paramacrobiotus metropolitanus polycystic kidney disease 2-like 2 protein (LOC129581476), mRNA blastn 34248 279 1 Eukaryota Opisthokonta Metazoa Tardigrada Eutardigrada Parachela Macrobiotidae Paramacrobiotus Paramacrobiotus metropolitanus
22077663 22077663 PRJNA379145_P_NODE_70818_length_158_cov_0.984000_g68663_i0 PRJNA379145 70818 158 0.984 1.55472 Paramacrobiotus metropolitanus 2943436 Tardigrada other_Eukaryota 134 4.53e-27   NTclustered gi|2493418936|ref|XM_055475954.1| 2943436 g68663 i0 88.288 69.4493670886076 111 13 70 0 1 111 230 120 PREDICTED: Paramacrobiotus metropolitanus histone H4 (LOC129583912), mRNA blastn 10973 134 1 Eukaryota Opisthokonta Metazoa Tardigrada Eutardigrada Parachela Macrobiotidae Paramacrobiotus Paramacrobiotus metropolitanus

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