RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA561138" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 7 ✖

bioproject 1

  • PRJNA561138 · 7 ✖

analysis 1

  • blastn · 7 ✖

tax_kingdom 0

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
7508583 7508583 PRJNA561138_P_NODE_16686_length_321_cov_1.076613_g16491_i0 PRJNA561138 16686 321 1.076613 3.45592773 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 523 5.309999999999998e-144   NTclustered gi|2530650642|gb|ON844104.1| 2903 g16491 i0 99.308 32.4984423676012 289 2 100 0 33 321 102301 102589 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 10432 523 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
8783531 8783531 PRJNA561138_P_NODE_16487_length_323_cov_0.924000_g16292_i0 PRJNA561138 16487 323 0.924 2.98452 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 597 3.11e-166   NTclustered gi|2530650642|gb|ON844104.1| 2903 g16292 i0 100 31.3869969040248 323 0 100 0 1 323 23876 23554 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 10138 597 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
8783580 8783580 PRJNA561138_P_NODE_29947_length_241_cov_0.916667_g29752_i0 PRJNA561138 29947 241 0.916667 2.20916747 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 446 8.519999999999999e-121   NTclustered gi|2530650642|gb|ON844104.1| 2903 g29752 i0 100 33.1659751037344 241 0 100 0 1 241 16747 16987 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 7993 446 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
10059150 10059150 PRJNA561138_P_NODE_14148_length_348_cov_1.120000_g13953_i0 PRJNA561138 14148 348 1.12 3.8976 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 643 4.279999999999998e-180   NTclustered gi|2530650642|gb|ON844104.1| 2903 g13953 i0 100 98.8275862068966 348 0 100 0 1 348 47922 48269 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 34392 643 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
17708566 17708566 PRJNA561138_P_NODE_19854_length_290_cov_1.419355_g19659_i0 PRJNA561138 19854 290 1.419355 4.1161295 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 531 2.83e-146   NTclustered gi|2530650642|gb|ON844104.1| 2903 g19659 i0 99.655 167.051724137931 290 1 100 0 1 290 88707 88996 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 48445 531 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
20257134 20257134 PRJNA561138_P_NODE_13316_length_358_cov_1.350877_g13121_i0 PRJNA561138 13316 358 1.350877 4.83613966 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 662 0   NTclustered gi|2530650642|gb|ON844104.1| 2903 g13121 i0 100 99.4106145251397 358 0 100 0 1 358 47082 47439 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 35589 662 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
24082523 24082523 PRJNA561138_P_NODE_10079_length_403_cov_0.933333_g9884_i0 PRJNA561138 10079 403 0.933333 3.76133199 Noelaerhabdaceae 418966 Haptophyta other_Eukaryota 745 0   NTclustered gi|2530650642|gb|ON844104.1| 2903 g9884 i0 100 55.9751861042184 403 0 100 0 1 403 91834 91432 Emiliania huxleyi strain CS-369 plastid, complete genome blastn 22558 745 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi

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