RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA841653" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA841653 · 14 ✖

analysis 1

  • blastn · 14 ✖
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
830435 830435 PRJNA841653_P_NODE_32221_length_287_cov_58.546729_g31547_i0 PRJNA841653 32221 287 58.546729 168.02911223 Crassostrea virginica 6565 Mollusca Mollusca 514 2.82e-141   NTclustered gi|194594396|gb|EU660792.1| 6565 g31547 i0 100 96.815331010453 278 0 97 0 10 287 80 357 Crassostrea virginica isolate CvirI1 18S ribosomal RNA gene, partial sequence blastn 27786 514 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea virginica
2506256 2506256 PRJNA841653_P_NODE_32242_length_287_cov_3.785047_g31568_i0 PRJNA841653 32242 287 3.785047 10.86308489 Ostreidae 6563 Mollusca Mollusca 523 4.6799999999999984e-144   NTclustered gi|557884316|gb|KC429429.1| 6565 g31568 i0 100 98.8432055749129 283 0 99 0 5 287 1826 2108 Crassostrea virginica voucher BivAToL-276 28S ribosomal RNA gene, partial sequence blastn 28368 523 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea virginica
5933947 5933947 PRJNA841653_P_NODE_49345_length_248_cov_0.880000_g48671_i0 PRJNA841653 49345 248 0.88 2.1824 Dreissena polymorpha 45954 Mollusca Mollusca 104 6.11e-18   NTclustered gi|2364375522|ref|XM_052398984.1| 45954 g48671 i0 77.419 0.75 186 34 74 4 4 186 3988 4168 PREDICTED: Dreissena polymorpha out at first protein-like (LOC127860717), mRNA blastn 186 104 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Dreissenidae Dreissena Dreissena polymorpha
5934200 5934200 PRJNA841653_P_NODE_64425_length_204_cov_31.549618_g63751_i0 PRJNA841653 64425 204 31.549618 64.36122072 Crassostrea virginica 6565 Mollusca Mollusca 363 7.239999999999998e-96   NTclustered gi|557884316|gb|KC429429.1| 6565 g63751 i0 100 96.3774509803922 196 0 96 0 9 204 2223 2418 Crassostrea virginica voucher BivAToL-276 28S ribosomal RNA gene, partial sequence blastn 19661 363 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea virginica
7208900 7208900 PRJNA841653_P_NODE_45586_length_250_cov_0.870056_g44912_i0 PRJNA841653 45586 250 0.870056 2.17514 Bradybaena similaris 145626 Mollusca Mollusca 58.4 4.87e-4   NTclustered gi|2912992646|dbj|AP039597.1| 145626 g44912 i0 100 0.48 31 0 12 0 1 31 6396434 6396464 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence blastn 120 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
11434380 11434380 PRJNA841653_P_NODE_21869_length_348_cov_10.087273_g21195_i0 PRJNA841653 21869 348 10.087273 35.10371004 Crassostrea 6564 Mollusca Mollusca 634 2.5699999999999996e-177   NTclustered gi|662170012|gb|KF370409.1| 6565 g21195 i0 100 94.6149425287356 343 0 99 0 1 343 376 34 Crassostrea virginica isolate Cv02 28S ribosomal RNA gene, partial sequence blastn 32926 634 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea virginica
13584209 13584209 PRJNA841653_P_NODE_36711_length_271_cov_17.388889_g36037_i0 PRJNA841653 36711 271 17.388889 47.12388919 Magallana angulata 2784310 Mollusca Mollusca 353 6.08e-93   NTclustered gi|2416874841|ref|XR_008241671.1| 2784310 g36037 i0 91.506 69.5424354243542 259 19 96 2 2 260 3776 3521 PREDICTED: Crassostrea angulata large subunit ribosomal RNA (LOC128170120), rRNA blastn 18846 353 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana angulata
13584567 13584567 PRJNA841653_P_NODE_56751_length_244_cov_0.900585_g56077_i0 PRJNA841653 56751 244 0.900585 2.1974274 Crassostrea virginica 6565 Mollusca Mollusca 198 2.67e-46   NTclustered gi|1242746997|ref|XM_022450121.1| 6565 g56077 i0 95.2 2.53688524590164 125 6 51 0 2 126 1217 1341 PREDICTED: Crassostrea virginica uncharacterized LOC111112582 (LOC111112582), mRNA blastn 619 198 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea virginica
13584691 13584691 PRJNA841653_P_NODE_64391_length_207_cov_4.022388_g63717_i0 PRJNA841653 64391 207 4.022388 8.32634316 Crassostrea virginica 6565 Mollusca Mollusca 370 4.4e-98   NTclustered gi|662170012|gb|KF370409.1| 6565 g63717 i0 100 96.8888888888889 200 0 97 0 8 207 511 710 Crassostrea virginica isolate Cv02 28S ribosomal RNA gene, partial sequence blastn 20056 370 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea virginica
14858869 14858869 PRJNA841653_P_NODE_58932_length_242_cov_69.857988_g58258_i0 PRJNA841653 58932 242 69.857988 169.05633096 Crassostrea virginica 6565 Mollusca Mollusca 422 1.44e-113   NTclustered gi|34369194|gb|AY145400.1| 6565 g58258 i0 98.333 99.0537190082645 240 4 99 0 2 241 2952 2713 Crassostrea virginica 28S ribosomal RNA gene, partial sequence blastn 23971 422 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea virginica
18682103 18682103 PRJNA841653_P_NODE_50515_length_247_cov_0.885057_g49841_i0 PRJNA841653 50515 247 0.885057 2.18609079 Bradybaena similaris 145626 Mollusca Mollusca 58.4 4.8e-4   NTclustered gi|2912991694|dbj|AP039596.1| 145626 g49841 i0 100 6.78947368421053 31 0 13 0 214 244 7094970 7095000 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence blastn 1677 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
20356903 20356903 PRJNA841653_P_NODE_16116_length_408_cov_5.632836_g15444_i0 PRJNA841653 16116 408 5.632836 22.98197088 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 67.6 1.4e-6   NTclustered gi|2693871861|ref|XR_010104559.1| 6551 g15444 i0 100 10.1323529411765 36 0 9 0 366 401 3317 3282 PREDICTED: Mytilus trossulus large subunit ribosomal RNA (LOC134702777), rRNA blastn 4134 67.6 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus trossulus
22507746 22507746 PRJNA841653_P_NODE_57978_length_243_cov_0.905882_g57304_i0 PRJNA841653 57978 243 0.905882 2.20129326 Crassostrea virginica 6565 Mollusca Mollusca 394 3.16e-105   NTclustered gi|1242786594|ref|XM_022477632.1| 6565 g57304 i0 97.009 6.74074074074074 234 7 96 0 2 235 3675 3442 PREDICTED: Crassostrea virginica uncharacterized LOC111130498 (LOC111130498), transcript variant X1, mRNA blastn 1638 394 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea virginica
23782421 23782421 PRJNA841653_P_NODE_15899_length_411_cov_242.124260_g15227_i0 PRJNA841653 15899 411 242.12426 995.1307086 Physella acuta 109671 Mollusca Mollusca 697 0   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g15227 i0 99.737 3.94647201946472 380 1 92 0 32 411 3385 3764 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 1622 697 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta

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