RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA520845" and tax_phylum = "Nemertea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nemertea · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA520845 · 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
1763929 1763929 PRJNA520845_P_NODE_156122_length_298_cov_1.742222_g154623_i0 PRJNA520845 156122 298 1.742222 5.19182156 Cerebratulus lacteus 6221 Nemertea other_Eukaryota 134 9.61e-27   NTclustered gi|584614319|gb|KF887964.1| 6221 g154623 i0 87.719 16.2818791946309 114 14 38 0 183 296 1429 1316 Cerebratulus lacteus alpha-tubulin mRNA, complete cds blastn 4852 134 1 Eukaryota Opisthokonta Metazoa Nemertea Pilidiophora Heteronemertea Lineidae Cerebratulus Cerebratulus lacteus
9415361 9415361 PRJNA520845_P_NODE_103708_length_365_cov_1.756849_g102209_i0 PRJNA520845 103708 365 1.756849 6.41249885 Lineus viridis 56195 Nemertea other_Eukaryota 185 3.269999999999999e-42   NTclustered gi|166952380|gb|EU302584.1| 56195 g102209 i0 81.385 5.46849315068493 231 39 63 4 5 233 176 404 Lineus viridis ribosomal protein rps27a mRNA, complete cds blastn 1996 185 1 Eukaryota Opisthokonta Metazoa Nemertea Pilidiophora Heteronemertea Lineidae Lineus Lineus viridis
18339242 18339242 PRJNA520845_P_NODE_116535_length_345_cov_1.661765_g115036_i0 PRJNA520845 116535 345 1.661765 5.73308925 Lineus longissimus 88925 Nemertea other_Eukaryota 54.7 0.009   NTclustered gi|2724570405|ref|XM_064763497.1| 88925 g115036 i0 96.875 0.278260869565217 32 1 9 0 110 141 1721 1690 PREDICTED: Lineus longissimus leucine-rich repeat-containing protein 43-like (LOC135483006), transcript variant X2, mRNA blastn 96 54.7 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);;