RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA807685" 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

  • PRJNA807685 · 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
2082183 2082183 PRJNA807685_P_NODE_19422_length_320_cov_8.318021_g18350_i0 PRJNA807685 19422 320 8.318021 26.6176672 Bradybaena similaris 145626 Mollusca Mollusca 255 2.13e-63   NTclustered gi|2912990805|dbj|AP039595.1| 145626 g18350 i0 91.803 3.265625 183 15 57 0 1 183 11641070 11641252 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence blastn 1045 255 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
7184873 7184873 PRJNA807685_P_NODE_40766_length_192_cov_1.832258_g39693_i0 PRJNA807685 40766 192 1.832258 3.51793536 Lottia gigantea 225164 Mollusca Mollusca 93.5 9.74e-15   NTclustered gi|676486978|ref|XM_009065902.1| 225164 g39693 i0 85.393 6.40104166666667 89 13 46 0 104 192 1313 1225 Lottia gigantea hypothetical protein partial mRNA blastn 1229 93.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
13560394 13560394 PRJNA807685_P_NODE_67531_length_150_cov_2.044248_g66458_i0 PRJNA807685 67531 150 2.044248 3.066372 Haliotis asinina 109174 Mollusca Mollusca 122 9.18e-24   NTclustered gi|2793383441|ref|XM_067802953.1| 109174 g66458 i0 81.333 5.02666666666667 150 28 100 0 1 150 1539 1390 PREDICTED: Haliotis asinina enolase-like (LOC137268387), mRNA blastn 754 122 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis asinina
19933294 19933294 PRJNA807685_P_NODE_43676_length_185_cov_1.858108_g42603_i0 PRJNA807685 43676 185 1.858108 3.4374998 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.016   NTclustered gi|2912985489|dbj|AP039590.1| 145626 g42603 i0 100 0.151351351351351 28 0 15 0 9 36 66900499 66900526 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence blastn 28 52.8 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);;