RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA207343" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA207343 · 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
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
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
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
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
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

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