RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA395690" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 9 ✖

tax_clade 1

bioproject 1

  • PRJNA395690 · 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
15714375 15714375 PRJNA395690_P_NODE_2953_length_456_cov_1.813268_g2805_i0 PRJNA395690 2953 456 1.813268 8.26850208 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 141 7.85e-40   NR ADK47156.1 323453 g2805 i0 100 0.447368421052632 68 0 44.7 0 2 205 78 145 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 204 141 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
22088263 22088263 PRJNA395690_P_NODE_3438_length_424_cov_1.522667_g3289_i0 PRJNA395690 3438 424 1.522667 6.45610808 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 167 1.51e-50   NR ADK26622.1 323453 g3289 i0 95.1 0.580188679245283 82 4 58 0 422 177 49 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 246 167 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
22088345 22088345 PRJNA395690_P_NODE_6158_length_324_cov_1.287273_g6008_i0 PRJNA395690 6158 324 1.287273 4.17076452 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 202 4.14e-63   NR ADK26624.1 323453 g6008 i0 88.8 0.990740740740741 107 12 99.1 0 324 4 170 276 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 321 202 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
29285735 29285735 PRJNA395690_P_NODE_28149_length_167_cov_1.381356_g27997_i0 PRJNA395690 28149 167 1.381356 2.30686452 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 62 2.11e-9   NR MES1917054.1 1215613 g27997 i0 49.1 2.10179640718563 55 28 98.8 0 167 3 83 137 MES1917054.1 hypothetical protein [Cercozoa sp. M6MM] diamond 351 62 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31149172 31149172 PRJNA395690_P_NODE_32335_length_164_cov_0.886957_g32183_i0 PRJNA395690 32335 164 0.886957 1.45460948 Lotharella oceanica 641309 SAR_Eukaryotes SAR_Eukaryotes 58.2 1.05e-9   NR AIB09582.1 641309 g32183 i0 57.8 0.823170731707317 45 19 82.3 0 136 2 1 45 AIB09582.1 hypothetical protein M951_chr1100 [Lotharella oceanica] diamond 135 58.2 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Lotharella Lotharella oceanica
31292747 31292747 PRJNA395690_P_NODE_30575_length_165_cov_1.551724_g30423_i0 PRJNA395690 30575 165 1.551724 2.5603446 root 1 Root_unresolved Root_unresolved 58.2 5.12e-9   NR YP_009240352.1 67809 g30423 i0 96.4 102.836363636364 28 1 50.9 0 2 85 95 122 YP_009240352.1 50S ribosomal protein L14 [Gymnochlora stellata] diamond 16968 58.5 0.994871794871795 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
31718890 31718890 PRJNA395690_P_NODE_29557_length_166_cov_0.871795_g29405_i0 PRJNA395690 29557 166 0.871795 1.4471797 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 56.2 2.29e-7   NR MES1912100.1 1215613 g29405 i0 52.8 1.91566265060241 53 25 95.8 0 5 163 468 520 MES1912100.1 hypothetical protein [Cercozoa sp. M6MM] diamond 318 56.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32066755 32066755 PRJNA395690_P_NODE_17858_length_192_cov_1.825175_g17706_i0 PRJNA395690 17858 192 1.825175 3.504336 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 80.9 5.21e-16   NR MES1912577.1 1215613 g17706 i0 60.9 2 64 24 98.4 1 191 3 112 175 MES1912577.1 hypothetical protein [Cercozoa sp. M6MM] diamond 384 80.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32667434 32667434 PRJNA395690_P_NODE_25520_length_173_cov_1.653226_g25368_i0 PRJNA395690 25520 173 1.653226 2.86008098 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 52.8 1.72e-6   NR MES1913617.1 1215613 g25368 i0 45.6 0.988439306358382 57 30 98.8 1 3 173 107 162 MES1913617.1 hypothetical protein [Cercozoa sp. M6MM] diamond 171 52.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM

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