RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA527965" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

bioproject 1

  • PRJNA527965 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
27519748 27519748 PRJNA527965_S_NODE_4503_length_177_cov_2.478873_g4420_i0 PRJNA527965 4503 177 2.478873 4.38760521 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 84.7 1.52e-17   NR XP_001022599.2 312017 g4420 i0 70.4 0.915254237288136 54 16 91.5 0 175 14 36 89 XP_001022599.2 granule lattice protein [Tetrahymena thermophila SB210] diamond 162 84.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27519749 27519749 PRJNA527965_S_NODE_743_length_411_cov_2.720745_g660_i0 PRJNA527965 743 411 2.720745 11.18226195 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 118 8.41e-29   NR XP_001014438.3 312017 g660 i0 54.3 0.927007299270073 127 58 92.7 0 383 3 30 156 XP_001014438.3 hypothetical protein TTHERM_00522600 [Tetrahymena thermophila SB210] diamond 381 118 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29382705 29382705 PRJNA527965_S_NODE_4849_length_170_cov_1.162963_g4766_i0 PRJNA527965 4849 170 1.162963 1.9770371 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 88.6 2.79e-20   NR KAJ1436092.1 483371 g4766 i0 83.9 0.988235294117647 56 9 98.8 0 2 169 58 113 KAJ1436092.1 ribosomal protein L19/L19e domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 168 88.6 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
29951056 29951056 PRJNA527965_S_NODE_2591_length_239_cov_1.627451_g2508_i0 PRJNA527965 2591 239 1.627451 3.88960789 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 94 1.72e-20   NR XP_001027526.3 312017 g2508 i0 63 1.01673640167364 81 26 96.7 1 232 2 1 81 XP_001027526.3 Ndc1 protein [Tetrahymena thermophila SB210] diamond 243 94 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30362181 30362181 PRJNA527965_S_NODE_372_length_522_cov_3.084189_g292_i0 PRJNA527965 372 522 3.084189 16.09946658 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 163 3.41e-45   NR XP_001022598.3 312017 g292 i0 60.7 0.96551724137931 168 66 96.6 0 505 2 1 168 XP_001022598.3 granule lattice protein [Tetrahymena thermophila SB210] diamond 504 163 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31278007 31278007 PRJNA527965_S_NODE_1075_length_359_cov_3.379630_g992_i0 PRJNA527965 1075 359 3.37963 12.1328717 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 91.7 5.68e-19   NR XP_001028123.3 312017 g992 i0 70 1.16991643454039 70 21 58.5 0 359 150 275 344 XP_001028123.3 hypothetical protein TTHERM_00527180 [Tetrahymena thermophila SB210] diamond 420 91.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32259110 32259110 PRJNA527965_S_NODE_2638_length_236_cov_1.776119_g2555_i0 PRJNA527965 2638 236 1.776119 4.19164084 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 84 6.6e-17   NR XP_001022599.2 312017 g2555 i0 85.1 0.597457627118644 47 7 59.7 0 234 94 183 229 XP_001022599.2 granule lattice protein [Tetrahymena thermophila SB210] diamond 141 84 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32652969 32652969 PRJNA527965_S_NODE_2700_length_233_cov_3.535354_g2617_i0 PRJNA527965 2700 233 3.535354 8.23737482 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 106 7.1e-25   NR KAL4445467.1 5901 g2617 i0 68.8 1.98283261802575 77 24 99.1 0 2 232 307 383 KAL4445467.1 hypothetical protein ABPG74_004541 [Tetrahymena malaccensis] diamond 462 106 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
32763987 32763987 PRJNA527965_S_NODE_1360_length_326_cov_2.824742_g1277_i0 PRJNA527965 1360 326 2.824742 9.20865892 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 88.2 5.07e-18   NR KAL4480407.1 5901 g1277 i0 60.9 0.634969325153374 69 27 63.5 0 119 325 139 207 KAL4480407.1 hypothetical protein ABPG74_020923 [Tetrahymena malaccensis] diamond 207 88.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis

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