RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1123686" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA1123686 · 7 ✖

analysis 1

  • diamond · 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
26943601 26943601 PRJNA1123686_S_NODE_542_length_376_cov_138.538905_g511_i0 PRJNA1123686 542 376 138.538905 520.9062828 [Pythium] brassicae (nom. inval.) 1485010 SAR_Eukaryotes SAR_Eukaryotes 58.5 1.31e-7   NR TYZ58852.1 1485010 g511 i0 50.8 0.502659574468085 63 31 50.3 0 260 72 62 124 TYZ58852.1 hypothetical protein PybrP1_000488 [[Pythium] brassicae (nom. inval.)] diamond 189 58.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium [Pythium] brassicae (nom. inval.)
27639119 27639119 PRJNA1123686_S_NODE_2804_length_264_cov_12.446809_g2772_i0 PRJNA1123686 2804 264 12.446809 32.85957576 Plasmodium relictum 85471 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0204   NR YP_009325489.1 85471 g2772 i0 32.3 0.704545454545455 62 42 70.5 0 79 264 12 73 YP_009325489.1 ribosomal protein S3, putative [Plasmodium relictum] diamond 186 43.5 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium relictum
27796977 27796977 PRJNA1123686_S_NODE_19664_length_155_cov_1.968254_g19632_i0 PRJNA1123686 19664 155 1.968254 3.0507937 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.00818   NR CAB9514417.1 568900 g19632 i0 52.9 0.658064516129032 34 16 65.8 0 137 36 263 296 CAB9514417.1 Protein of unknown function (DUF3493) [Seminavis robusta] diamond 102 43.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28144321 28144321 PRJNA1123686_S_NODE_2565_length_269_cov_41.833333_g2533_i0 PRJNA1123686 2565 269 41.833333 112.53166577 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 53.5 3.78e-6   NR KAJ8577208.1 4785 g2533 i0 60.8 0.568773234200744 51 20 56.9 0 191 39 135 185 KAJ8577208.1 hypothetical protein ON010_g2004 [Phytophthora cinnamomi] diamond 153 53.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
28449214 28449214 PRJNA1123686_S_NODE_2566_length_269_cov_38.087500_g2534_i0 PRJNA1123686 2566 269 38.0875 102.455375 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 53.9 2.71e-6   NR KAJ8577208.1 4785 g2534 i0 60.8 1.182156133829 51 20 56.9 0 79 231 135 185 KAJ8577208.1 hypothetical protein ON010_g2004 [Phytophthora cinnamomi] diamond 318 53.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
32156839 32156839 PRJNA1123686_S_NODE_1138_length_324_cov_132.576271_g1106_i0 PRJNA1123686 1138 324 132.576271 429.54711804 Pelagomonas calceolata 35677 SAR_Eukaryotes SAR_Eukaryotes 47.8 3.83e-4   NR CAH0373173.1 35677 g1106 i0 44 0.462962962962963 50 28 46.3 0 227 78 16 65 CAH0373173.1 unnamed protein product, partial [Pelagomonas calceolata] diamond 150 47.8 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Pelagomonas Pelagomonas calceolata
32188417 32188417 PRJNA1123686_S_NODE_2478_length_271_cov_103.727273_g2446_i0 PRJNA1123686 2478 271 103.727273 281.10090983 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 67 1.45e-10   NR KAJ8574777.1 4785 g2446 i0 52.9 0.774907749077491 70 33 77.5 0 61 270 108 177 KAJ8574777.1 hypothetical protein ON010_g4436 [Phytophthora cinnamomi] diamond 210 67 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi

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