RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA927284" and tax_phylum = "Nemertea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nemertea · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA927284 · 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
3452718 3452718 PRJNA927284_P_NODE_1543_length_590_cov_22.000000_g1379_i0 PRJNA927284 1543 590 22 129.8 Lineus viridis 56195 Nemertea other_Eukaryota 353 1.43e-92   NTclustered gi|166952366|gb|EU302577.1| 56195 g1379 i0 81.264 63.828813559322 443 78 75 5 17 457 469 30 Lineus viridis ribosomal protein rps15 mRNA, complete cds blastn 37659 353 1 Eukaryota Opisthokonta Metazoa Nemertea Pilidiophora Heteronemertea Lineidae Lineus Lineus viridis
7279927 7279927 PRJNA927284_P_NODE_566_length_1054_cov_9.541463_g471_i0 PRJNA927284 566 1054 9.541463 100.56702002 Lineus viridis 56195 Nemertea other_Eukaryota 514 1.14e-140   NTclustered gi|166952384|gb|EU302586.1| 56195 g471 i0 80.645 15.7988614800759 682 115 64 10 353 1026 702 30 Lineus viridis ribosomal protein rpsA mRNA, partial cds blastn 16652 514 1 Eukaryota Opisthokonta Metazoa Nemertea Pilidiophora Heteronemertea Lineidae Lineus Lineus viridis
14929763 14929763 PRJNA927284_P_NODE_1472_length_609_cov_21.408621_g1313_i0 PRJNA927284 1472 609 21.408621 130.37850189 Lineus longissimus 88925 Nemertea other_Eukaryota 339 4.14e-88   NTclustered gi|2724572769|ref|XM_064764770.1| 88925 g1313 i0 78.075 23.679802955665 561 105 90 11 39 587 623 69 PREDICTED: Lineus longissimus large ribosomal subunit protein uL22-like (LOC135483746), mRNA blastn 14421 339 1 Eukaryota Opisthokonta Metazoa Nemertea Pilidiophora Heteronemertea Lineidae Lineus Lineus longissimus
22578971 22578971 PRJNA927284_P_NODE_118_length_2016_cov_7.629089_g91_i0 PRJNA927284 118 2016 7.629089 153.80243424 Lineus longissimus 88925 Nemertea other_Eukaryota 1242 0   NTclustered gi|2724594305|ref|XM_064776138.1| 88925 g91 i0 82.279 67.1696428571429 1439 252 71 3 472 1909 1563 127 PREDICTED: Lineus longissimus protein transport protein Sec61 subunit alpha (LOC135490728), mRNA blastn 135414 1242 1 Eukaryota Opisthokonta Metazoa Nemertea Pilidiophora Heteronemertea Lineidae Lineus Lineus longissimus

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