RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1111146" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1111146 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
2766651 2766651 PRJNA1111146_P_NODE_228863_length_200_cov_2.292517_g227725_i0 PRJNA1111146 228863 200 2.292517 4.585034 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.017   NTclustered gi|2913001038|dbj|AP039608.1| 145626 g227725 i0 100 0.14 28 0 14 0 26 53 8756233 8756206 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
5319240 5319240 PRJNA1111146_P_NODE_31145_length_326_cov_1.271062_g30008_i0 PRJNA1111146 31145 326 1.271062 4.14366212 Bradybaena similaris 145626 Mollusca Mollusca 63.9 1.42e-5   NTclustered gi|2913001038|dbj|AP039608.1| 145626 g30008 i0 97.297 0.966257668711656 37 1 11 0 191 227 35675533 35675497 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence blastn 315 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
7869559 7869559 PRJNA1111146_P_NODE_406307_length_179_cov_0.888889_g405169_i0 PRJNA1111146 406307 179 0.888889 1.59111131 Macoma balthica 1903275 Mollusca Mollusca 220 3.93e-53   NTclustered gi|743435123|gb|KM373205.1| 1903275 g405169 i0 100 31.536312849162 119 0 66 0 1 119 2008 2126 Macoma balthica isolate F17 mitochondrion, partial genome blastn 5645 220 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Cardiida Tellinidae Macoma Macoma balthica
10419416 10419416 PRJNA1111146_P_NODE_215029_length_203_cov_1.520000_g213891_i0 PRJNA1111146 215029 203 1.52 3.0856 Mytilus trossulus 6551 Mollusca Mollusca 187 4.65e-43   NTclustered gi|2694110933|ref|XM_063589529.1| 6551 g213891 i0 98.131 80.5665024630542 107 2 99 0 1 107 818 924 PREDICTED: Mytilus trossulus uncharacterized LOC134725586 (LOC134725586), mRNA blastn 16355 187 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus trossulus
24442690 24442690 PRJNA1111146_P_NODE_389120_length_180_cov_0.889764_g387982_i0 PRJNA1111146 389120 180 0.889764 1.6015752 Littorina saxatilis 31220 Mollusca Mollusca 254 3.9e-63   NTclustered gi|2868636229|ref|XM_070320787.1| 31220 g387982 i0 99.286 116.422222222222 140 1 78 0 1 140 4987 5126 PREDICTED: Littorina saxatilis uncharacterized protein (LOC138949062), mRNA blastn 20956 254 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis

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