RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA721440" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA721440 · 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
9638628 9638628 PRJNA721440_S_NODE_19408_length_163_cov_1.201754_g19282_i0 PRJNA721440 19408 163 1.201754 1.95885902 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.004   NTclustered gi|2912997258|dbj|AP039602.1| 145626 g19282 i0 96.875 0.196319018404908 32 1 20 0 90 121 16864470 16864439 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
18561976 18561976 PRJNA721440_S_NODE_19195_length_163_cov_4.236842_g19069_i0 PRJNA721440 19195 163 4.236842 6.90605246 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.014   NTclustered gi|2912999747|dbj|AP039606.1| 145626 g19069 i0 100 0.171779141104294 28 0 17 0 133 160 2800684 2800657 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
19837124 19837124 PRJNA721440_S_NODE_9956_length_205_cov_1.948718_g9830_i0 PRJNA721440 9956 205 1.948718 3.9948719 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.005   NTclustered gi|2913001038|dbj|AP039608.1| 145626 g9830 i0 100 0.141463414634146 29 0 14 0 143 171 9147465 9147493 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
23663215 23663215 PRJNA721440_S_NODE_5819_length_250_cov_7.532338_g5693_i0 PRJNA721440 5819 250 7.532338 18.830845 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.006   NTclustered gi|2913000417|dbj|AP039607.1| 145626 g5693 i0 96.875 0.256 32 1 13 0 185 216 8068705 8068736 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris

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