RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA949785" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA949785 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
3483838 3483838 PRJNA949785_P_NODE_4603_length_528_cov_2.914286_g4407_i0 PRJNA949785 4603 528 2.914286 15.38743008 Ostrea edulis 37623 Mollusca Mollusca 63.9 2.39e-5   NTclustered gi|2507356719|ref|XM_048922008.2| 37623 g4407 i0 87.5 0.189393939393939 56 5 11 2 455 510 2636 2689 PREDICTED: Ostrea edulis uncharacterized LOC125681791 (LOC125681791), mRNA blastn 100 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Ostrea Ostrea edulis
7311224 7311224 PRJNA949785_P_NODE_6686_length_421_cov_1.267241_g6489_i0 PRJNA949785 6686 421 1.267241 5.33508461 Magallana gigas 29159 Mollusca Mollusca 56.5 0.003   NTclustered gi|2751260125|ref|XM_066080886.1| 29159 g6489 i0 94.595 0.0878859857482185 37 1 9 1 242 278 792 827 PREDICTED: Magallana gigas receptor-type tyrosine-protein phosphatase zeta-like (LOC136274339), transcript variant X2, mRNA blastn 37 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana gigas
8586142 8586142 PRJNA949785_P_NODE_15947_length_250_cov_0.870056_g15750_i0 PRJNA949785 15947 250 0.870056 2.17514 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.023   NTclustered gi|2913000417|dbj|AP039607.1| 145626 g15750 i0 100 0.112 28 0 11 0 161 188 8953149 8953122 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
8586162 8586162 PRJNA949785_P_NODE_17787_length_244_cov_1.350877_g17590_i0 PRJNA949785 17787 244 1.350877 3.29613988 Lottia gigantea 225164 Mollusca Mollusca 202 2.07e-47   NTclustered gi|676466721|ref|XM_009059409.1| 225164 g17590 i0 81.818 6.46311475409836 242 42 99 2 1 241 4760 5000 Lottia gigantea hypothetical protein partial mRNA blastn 1577 202 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
8914779 8914779 PRJNA949785_P_NODE_3807_length_592_cov_8.210019_g3619_i0 PRJNA949785 3807 592 8.210019 48.60331248 Ostreidae 6563 Mollusca Mollusca 1086 0   NTclustered gi|1122822283|gb|JF919377.2| 94323 g3619 i0 99.831 46.4814189189189 591 1 99 0 2 592 605 15 Crassostrea ariakensis clone Ca82 large subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 27517 1094 0.992687385740402 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea ariakensis
11136877 11136877 PRJNA949785_P_NODE_9989_length_329_cov_1.109375_g9792_i0 PRJNA949785 9989 329 1.109375 3.64984375 Saccostrea echinata 191078 Mollusca Mollusca 52.8 0.031   NTclustered gi|2628510124|ref|XM_061331666.1| 191078 g9792 i0 100 0.0851063829787234 28 0 9 0 76 103 1193 1220 PREDICTED: Saccostrea echinata uncharacterized LOC133195741 (LOC133195741), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Saccostrea Saccostrea echinata
17511427 17511427 PRJNA949785_P_NODE_9534_length_337_cov_6.484848_g9337_i0 PRJNA949785 9534 337 6.484848 21.85393776 Patella vulgata 6465 Mollusca Mollusca 139 2.37e-28   NTclustered gi|2506311432|ref|XM_050535558.2| 6465 g9337 i0 78.017 10.9376854599407 232 44 68 6 43 271 387 160 PREDICTED: Patella vulgata uncharacterized LOC126810465 (LOC126810465), mRNA blastn 3686 139 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
22610204 22610204 PRJNA949785_P_NODE_3218_length_654_cov_5.895009_g3037_i0 PRJNA949785 3218 654 5.895009 38.55335886 Magallana hongkongensis 2653900 Mollusca Mollusca 1208 0   NTclustered gi|281190775|ref|NC_011518.2| 2653900 g3037 i0 100 86.2339449541284 654 0 100 0 1 654 1778 2431 Crassostrea hongkongensis mitochondrion, complete genome blastn 56397 1208 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana hongkongensis
25159359 25159359 PRJNA949785_P_NODE_2800_length_705_cov_4.362342_g2624_i0 PRJNA949785 2800 705 4.362342 30.7545111 Ostrea edulis 37623 Mollusca Mollusca 86.1 6.95e-12   NTclustered gi|2507356719|ref|XM_048922008.2| 37623 g2624 i0 80.469 0.251063829787234 128 12 18 11 308 433 2756 2640 PREDICTED: Ostrea edulis uncharacterized LOC125681791 (LOC125681791), mRNA blastn 177 86.1 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Ostrea Ostrea edulis
25159380 25159380 PRJNA949785_P_NODE_7400_length_396_cov_141.643963_g7203_i0 PRJNA949785 7400 396 141.643963 560.91009348 Ruditapes philippinarum 129788 Mollusca Mollusca 52.8 0.038   NTclustered gi|2616658881|ref|XM_060747556.1| 129788 g7203 i0 100 0.0707070707070707 28 0 7 0 209 236 272 245 PREDICTED: Ruditapes philippinarum heat shock 70 kDa protein 12B-like (LOC132756477), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Ruditapes Ruditapes philippinarum

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