RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA207343" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 4

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 16 ✖

tax_clade 1

bioproject 1

  • PRJNA207343 · 16 ✖

analysis 1

  • blastn · 16 ✖
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
366745 366745 PRJNA207343_S_NODE_10561_length_161_cov_1.677419_g10024_i0 PRJNA207343 10561 161 1.677419 2.70064459 Myxidium streisingeri 1542451 Cnidaria other_Eukaryota 281 1.57e-71   NTclustered gi|681870004|gb|KM001687.1| 1542451 g10024 i0 100 78.055900621118 152 0 94 0 10 161 432 281 Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence blastn 12567 281 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxidiidae Myxidium Myxidium streisingeri
1641658 1641658 PRJNA207343_S_NODE_3922_length_394_cov_2.431373_g3385_i0 PRJNA207343 3922 394 2.431373 9.57960962 Notodromas monacha 399045 Arthropoda Arthropoda 691 0   NTclustered gi|1938057878|emb|OA889014.1| 399045 g3385 i0 98.964 3.91878172588833 386 4 98 0 1 386 1921 1536 Notodromas monacha blastn 1544 691 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
1641695 1641695 PRJNA207343_S_NODE_5122_length_306_cov_7.349442_g4585_i0 PRJNA207343 5122 306 7.349442 22.48929252 Notodromas monacha 399045 Arthropoda Arthropoda 431 3.139999999999999e-116   NTclustered gi|1938057878|emb|OA889014.1| 399045 g4585 i0 93.493 63.7745098039216 292 16 94 3 7 295 2500 2791 Notodromas monacha blastn 19515 431 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
10571039 10571039 PRJNA207343_S_NODE_7049_length_226_cov_2.444444_g6512_i0 PRJNA207343 7049 226 2.444444 5.52444344 Notodromas monacha 399045 Arthropoda Arthropoda 390 3.749999999999999e-104   NTclustered gi|1938065787|emb|OA890044.1| 399045 g6512 i0 97.788 2.00442477876106 226 5 100 0 1 226 5676 5901 Notodromas monacha blastn 453 390 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
10571056 10571056 PRJNA207343_S_NODE_7689_length_209_cov_1.482558_g7152_i0 PRJNA207343 7689 209 1.482558 3.09854622 Notodromas monacha 399045 Arthropoda Arthropoda 255 1.3e-63   NTclustered gi|1938065787|emb|OA890044.1| 399045 g7152 i0 88.995 2.27751196172249 209 20 99 2 3 209 6178 6385 Notodromas monacha blastn 476 255 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
13120714 13120714 PRJNA207343_S_NODE_5171_length_303_cov_4.112782_g4634_i0 PRJNA207343 5171 303 4.112782 12.46172946 Notodromas monacha 399045 Arthropoda Arthropoda 551 2.279999999999999e-152   NTclustered gi|1938057878|emb|OA889014.1| 399045 g4634 i0 100 3.93399339933993 298 0 98 0 1 298 1567 1270 Notodromas monacha blastn 1192 551 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
13120855 13120855 PRJNA207343_S_NODE_9151_length_180_cov_5.069930_g8614_i0 PRJNA207343 9151 180 5.06993 9.125874 Catarhinus sp. GD136 2837800 Arthropoda Arthropoda 169 1.4499999999999998e-37   NTclustered gi|2047395254|gb|MZ326467.1| 2837800 g8614 i0 87.333 1159.44444444444 150 16 82 3 33 180 653 505 Catarhinus sp. GD136 large subunit ribosomal RNA gene, partial sequence blastn 208700 169 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Diptilomiopidae Catarhinus Catarhinus sp. GD136
15083519 15083519 PRJNA207343_S_NODE_6692_length_237_cov_6.135000_g6155_i0 PRJNA207343 6692 237 6.135 14.53995 root 1 Root_unresolved Root_unresolved 154 5.67e-33   NTclustered gi|1870342607|gb|MT263507.1| 9031 g6155 i0 100 35.0210970464135 83 0 35 0 145 227 4126 4044 Gallus gallus endogenous virus Avian leukosis virus subgroup E (ALVE) clone ALVEB5 genomic sequence blastn 8300 154 1 Eukaryota Opisthokonta Metazoa Chordata Aves Galliformes Phasianidae Gallus Gallus gallus
15669725 15669725 PRJNA207343_S_NODE_5253_length_299_cov_2.133588_g4716_i0 PRJNA207343 5253 299 2.133588 6.37942812 Notodromas monacha 399045 Arthropoda Arthropoda 442 1.4099999999999993e-119   NTclustered gi|1938065787|emb|OA890044.1| 399045 g4716 i0 93.355 2.0133779264214 301 16 99 2 2 299 6203 5904 Notodromas monacha blastn 602 442 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
18907388 18907388 PRJNA207343_S_NODE_4615_length_339_cov_50.731788_g4078_i0 PRJNA207343 4615 339 50.731788 171.98076132 root 1 Root_unresolved Root_unresolved 555 1.9999999999999993e-153   NTclustered gi|2913002568|dbj|AP039611.1| 145626 g4078 i0 96.188 160.289085545723 341 10 100 3 1 339 1724524 1724863 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence blastn 54338 560 0.991071428571429 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
18907435 18907435 PRJNA207343_S_NODE_6795_length_234_cov_2.182741_g6258_i0 PRJNA207343 6795 234 2.182741 5.10761394 root 1 Root_unresolved Root_unresolved 433 6.41e-117   NTclustered gi|1964218311|emb|OC882703.1| 1979941 g6258 i0 100 51.6794871794872 234 0 100 0 1 234 1459 1692 Medioppia subpectinata blastn 12093 433 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
19492979 19492979 PRJNA207343_S_NODE_8436_length_193_cov_1.250000_g7899_i0 PRJNA207343 8436 193 1.25 2.4125 Mus musculus 10090 Chordata Chordata 340 3.17e-89   NTclustered gi|73695538|gb|AC137677.24| 10090 g7899 i0 98.446 260.829015544041 193 3 100 0 1 193 55807 55999 Mus musculus chromosome 1, clone RP23-257D12, complete sequence blastn 50340 340 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
21457690 21457690 PRJNA207343_S_NODE_5437_length_288_cov_3.438247_g4900_i0 PRJNA207343 5437 288 3.438247 9.90215136 root 1 Root_unresolved Root_unresolved 472 1.73e-128   NTclustered gi|1964218311|emb|OC882703.1| 1979941 g4900 i0 100 19.9479166666667 255 0 89 0 26 280 977 723 Medioppia subpectinata blastn 5745 472 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
21457735 21457735 PRJNA207343_S_NODE_7977_length_203_cov_1.174699_g7440_i0 PRJNA207343 7977 203 1.174699 2.38463897 Mus 10088 Chordata Chordata 375 9.24e-100   NTclustered gi|846388176|dbj|LC062059.1| 10090 g7440 i0 100 100 203 0 100 0 1 203 1348 1550 Mus musculus mitochondrion DNA, including Cytb, tRNA-Tyr, tRNA-Pro, tRNA-Phe, 12S rRNA genes and D-loop, complete sequence, sequence_id: (14446..634)_12 blastn 20300 375 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
22732698 22732698 PRJNA207343_S_NODE_4818_length_325_cov_13.218750_g4281_i0 PRJNA207343 4818 325 13.21875 42.9609375 root 1 Root_unresolved Root_unresolved 556 5.31e-154   NTclustered gi|1964218311|emb|OC882703.1| 1979941 g4281 i0 99.032 25.3753846153846 310 3 95 0 2 311 1134 1443 Medioppia subpectinata blastn 8247 556 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
23318812 23318812 PRJNA207343_S_NODE_10199_length_165_cov_3.875000_g9662_i0 PRJNA207343 10199 165 3.875 6.39375 Myxobolus cloutmani 2766936 Cnidaria other_Eukaryota 187 3.6199999999999985e-43   NTclustered gi|1896054819|gb|MT919695.1| 2766936 g9662 i0 99.038 60.7212121212121 104 1 63 0 1 104 2100 1997 Myxobolus cloutmani isolate CTM large subunit ribosomal RNA gene, partial sequence blastn 10019 187 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxobolidae Myxobolus Myxobolus cloutmani

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