RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA993416" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA993416 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
975773 975773 PRJNA993416_P_NODE_12521_length_251_cov_0.865169_g12416_i0 PRJNA993416 12521 251 0.865169 2.17157419 Magallana angulata 2784310 Mollusca Mollusca 416 6.999999999999998e-112   NTclustered gi|2416903464|ref|XM_052838677.1| 2784310 g12416 i0 96.787 3.15139442231076 249 8 99 0 1 249 588 836 PREDICTED: Crassostrea angulata ATP-dependent zinc metalloprotease YME1L1-like (LOC128172940), mRNA blastn 791 416 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana angulata
9904068 9904068 PRJNA993416_P_NODE_2588_length_533_cov_3.015217_g2484_i0 PRJNA993416 2588 533 3.015217 16.07110661 Magallana angulata 2784310 Mollusca Mollusca 985 0   NTclustered gi|678946127|gb|KJ855247.1| 2784310 g2484 i0 100 48.3846153846154 533 0 100 0 1 533 7858 8390 Crassostrea angulata isolate XS14 mitochondrion, complete genome blastn 25789 985 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana angulata
16278888 16278888 PRJNA993416_P_NODE_9433_length_279_cov_1.495146_g9328_i0 PRJNA993416 9433 279 1.495146 4.17145734 Magallana angulata 2784310 Mollusca Mollusca 516 7.58e-142   NTclustered gi|2416934745|ref|XM_052855538.1| 2784310 g9328 i0 100 6.74551971326165 279 0 100 0 1 279 437 159 PREDICTED: Crassostrea angulata soma ferritin-like (LOC128185864), mRNA blastn 1882 516 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana angulata
17553719 17553719 PRJNA993416_P_NODE_15494_length_243_cov_0.905882_g15389_i0 PRJNA993416 15494 243 0.905882 2.20129326 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.022   NTclustered gi|2912999222|dbj|AP039605.1| 145626 g15389 i0 100 0.576131687242798 28 0 12 0 24 51 39767982 39768009 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence blastn 140 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
18827744 18827744 PRJNA993416_P_NODE_6215_length_334_cov_1.475096_g6110_i0 PRJNA993416 6215 334 1.475096 4.92682064 Magallana angulata 2784310 Mollusca Mollusca 606 5.359999999999998e-169   NTclustered gi|678946111|gb|KJ855246.1| 2784310 g6110 i0 99.698 75.8952095808383 331 1 99 0 4 334 2484 2154 Crassostrea angulata isolate WLY04 mitochondrion, complete genome blastn 25349 606 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana angulata
21377986 21377986 PRJNA993416_P_NODE_14837_length_245_cov_0.883721_g14732_i0 PRJNA993416 14837 245 0.883721 2.16511645 Magallana gigas 29159 Mollusca Mollusca 442 1.1199999999999994e-119   NTclustered gi|2751272121|ref|XM_034478040.2| 29159 g14732 i0 99.184 12.6285714285714 245 2 100 0 1 245 805 561 PREDICTED: Magallana gigas large ribosomal subunit protein uL10 (LOC105319364), mRNA blastn 3094 442 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas
21378191 21378191 PRJNA993416_P_NODE_8657_length_285_cov_2.278302_g8552_i0 PRJNA993416 8657 285 2.278302 6.4931607 Magallana gigas 29159 Mollusca Mollusca 527 3.59e-145   NTclustered gi|32479248|gb|AY321299.1| 29159 g8552 i0 100 25.6842105263158 285 0 100 0 1 285 243 527 Crassostrea gigas ferritin GF1 (GF1) mRNA, complete cds blastn 7320 527 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas
22653066 22653066 PRJNA993416_P_NODE_7318_length_306_cov_1.313305_g7213_i0 PRJNA993416 7318 306 1.313305 4.0187133 Magallana angulata 2784310 Mollusca Mollusca 560 3.84e-155   NTclustered gi|2416893633|ref|XM_052832076.1| 2784310 g7213 i0 99.673 5 306 1 100 0 1 306 359 54 PREDICTED: Crassostrea angulata very low-density lipoprotein receptor-like (LOC128166743), transcript variant X1, mRNA blastn 1530 560 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana angulata

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