RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA662254" and tax_phylum = "Nematoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nematoda · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA662254 · 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
12641192 12641192 PRJNA662254_P_NODE_66150_length_238_cov_2.048485_g65499_i0 PRJNA662254 66150 238 2.048485 4.8753943 Ceratoplectus 290129 Nematoda Nematoda 412 8.51e-111   NTclustered gi|460423923|gb|KC306538.1| 554024 g65499 i0 97.899 100.008403361345 238 5 100 0 1 238 133 370 Nematoda environmental sample clone BT_Euk_C8 18S ribosomal RNA gene, partial sequence blastn 23802 412 1 Eukaryota Opisthokonta Metazoa Nematoda         Nematoda environmental sample
13382345 13382345 PRJNA662254_P_NODE_37051_length_275_cov_2.287129_g36400_i0 PRJNA662254 37051 275 2.287129 6.28960475 Diploscapter sp. JU359 479134 Nematoda Nematoda 508 1.2499999999999999e-139   NTclustered gi|158821895|gb|EU195959.1| 479134 g36400 i0 100 93.9672727272727 275 0 100 0 1 275 1547 1273 Diploscapter sp. JU359 28S ribosomal RNA gene, partial sequence blastn 25841 508 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Diploscapter Diploscapter sp. JU359
23581106 23581106 PRJNA662254_P_NODE_66019_length_240_cov_2.353293_g65368_i0 PRJNA662254 66019 240 2.353293 5.6479032 Strongyloides ratti 34506 Nematoda Nematoda 248 2.57e-61   NTclustered gi|1376144067|ref|XM_024652464.1| 34506 g65368 i0 85.593 101.029166666667 236 34 98 0 3 238 94 329 Strongyloides ratti Histone H3 (SRAE_2000150400), partial mRNA blastn 24247 248 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Strongyloididae Strongyloides Strongyloides ratti
24113881 24113881 PRJNA662254_P_NODE_34059_length_286_cov_1.145540_g33408_i0 PRJNA662254 34059 286 1.14554 3.2762444 root 1 Root_unresolved Root_unresolved 63.9 1.22e-5   NTclustered gi|162280658|gb|EU163897.1| 6239 g33408 i0 95 8.74475524475525 40 2 14 0 80 119 40328 40367 Caenorhabditis elegans strain CB4856 genomic sequence blastn 2501 63.9 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis elegans

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