RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1120203" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 6 ✖

bioproject 1

  • PRJNA1120203 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
28649226 28649226 PRJNA1120203_P_NODE_78327_length_251_cov_0.865169_g77311_i0 PRJNA1120203 78327 251 0.865169 2.17157419 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 47.4 8.84e-4   NR XP_005793414.1 280463 g77311 i0 38.5 0.621513944223108 52 31 62.2 1 157 2 5 55 XP_005793414.1 hypothetical protein EMIHUDRAFT_222007 [Emiliania huxleyi CCMP1516] diamond 156 47.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29533203 29533203 PRJNA1120203_P_NODE_78550_length_251_cov_0.865169_g77534_i0 PRJNA1120203 78550 251 0.865169 2.17157419 Prymnesium parvum 97485 Haptophyta other_Eukaryota 98.2 1.46e-22   NR KAL1522136.1 97485 g77534 i0 58 0.968127490039841 81 34 96.8 0 1 243 143 223 KAL1522136.1 hypothetical protein AB1Y20_021777 [Prymnesium parvum] diamond 243 98.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29690701 29690701 PRJNA1120203_P_NODE_87870_length_248_cov_0.880000_g86854_i0 PRJNA1120203 87870 248 0.88 2.1824 Prymnesium parvum 97485 Haptophyta other_Eukaryota 93.2 5.43e-20   NR KAL1522970.1 97485 g86854 i0 61.3 0.907258064516129 75 29 90.7 0 19 243 52 126 KAL1522970.1 hypothetical protein AB1Y20_017934 [Prymnesium parvum] diamond 225 93.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30070020 30070020 PRJNA1120203_P_NODE_92592_length_246_cov_0.890173_g91576_i0 PRJNA1120203 92592 246 0.890173 2.18982558 Prymnesium parvum 97485 Haptophyta other_Eukaryota 92 1.69e-19   NR KAL1523589.1 97485 g91576 i0 76.9 0.634146341463415 52 12 63.4 0 244 89 465 516 KAL1523589.1 hypothetical protein AB1Y20_018525 [Prymnesium parvum] diamond 156 92 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30638633 30638633 PRJNA1120203_P_NODE_100773_length_243_cov_0.905882_g99757_i0 PRJNA1120203 100773 243 0.905882 2.20129326 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 109 4.09e-26   NR KOO35829.1 1460289 g99757 i0 66.7 1 81 23 100 1 1 243 255 331 KOO35829.1 ph domain-containing protein [Chrysochromulina tobinii] diamond 243 109 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
32662071 32662071 PRJNA1120203_P_NODE_81820_length_250_cov_0.870056_g80804_i0 PRJNA1120203 81820 250 0.870056 2.17514 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 59.3 3.28e-8   NR KOO33684.1 1460289 g80804 i0 37.3 0.804 67 42 80.4 0 48 248 1 67 KOO33684.1 hypothetical protein Ctob_014736 [Chrysochromulina tobinii] diamond 201 59.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii

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