RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1008624" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA1008624 · 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
27382273 27382273 PRJNA1008624_P_NODE_20123_length_191_cov_1.823944_g19935_i0 PRJNA1008624 20123 191 1.823944 3.48373304 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 69.7 5.69e-12   NR CAB9528269.1 568900 g19935 i0 47.6 0.989528795811518 63 33 99 0 3 191 372 434 CAB9528269.1 Inherit from euNOG: Reverse transcriptase (RNA-dependent DNA polymerase) [Seminavis robusta] diamond 189 69.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28297755 28297755 PRJNA1008624_P_NODE_37006_length_162_cov_0.920354_g36818_i0 PRJNA1008624 37006 162 0.920354 1.49097348 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00143   NR KAI2490444.1 210448 g36818 i0 47.5 2.22222222222222 40 20 74.1 1 43 162 96 134 KAI2490444.1 hypothetical protein MHU86_24131 [Fragilaria crotonensis] diamond 360 45.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28550643 28550643 PRJNA1008624_P_NODE_27567_length_169_cov_0.866667_g27379_i0 PRJNA1008624 27567 169 0.866667 1.46466723 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 53.1 2.83e-6   NR CAB9521594.1 568900 g27379 i0 49.1 0.940828402366864 53 27 94.1 0 161 3 794 846 CAB9521594.1 Reverse transcriptase (RNA-dependent DNA polymerase) (Partial), partial [Seminavis robusta] diamond 159 53.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28708463 28708463 PRJNA1008624_P_NODE_32327_length_165_cov_0.896552_g32139_i0 PRJNA1008624 32327 165 0.896552 1.4793108 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 69.7 3.88e-12   NR CAB9525983.1 568900 g32139 i0 57.4 0.981818181818182 54 23 98.2 0 164 3 232 285 CAB9525983.1 unknown protein [Seminavis robusta] diamond 162 69.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29655116 29655116 PRJNA1008624_P_NODE_35610_length_163_cov_0.912281_g35422_i0 PRJNA1008624 35610 163 0.912281 1.48701803 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 49.7 4.51e-5   NR CAB9527445.1 568900 g35422 i0 48.8 2.57668711656442 41 21 75.5 0 123 1 339 379 CAB9527445.1 hypothetical protein SEMRO_1998_G310121.1 [Seminavis robusta] diamond 420 49.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31488447 31488447 PRJNA1008624_P_NODE_22856_length_182_cov_1.406015_g22668_i0 PRJNA1008624 22856 182 1.406015 2.5589473 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 114 1.02e-27   NR CAB9505263.1 568900 g22668 i0 89.5 0.93956043956044 57 6 94 0 176 6 1566 1622 CAB9505263.1 NADH dehydrogenase (ubiquinone) complex I, assembly factor 6 [Seminavis robusta] diamond 171 114 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32721328 32721328 PRJNA1008624_P_NODE_31220_length_166_cov_0.888889_g31032_i0 PRJNA1008624 31220 166 0.888889 1.47555574 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 60.5 7.37e-9   NR GKY94061.1 2872254 g31032 i0 50 1.89759036144578 52 26 94 0 163 8 381 432 GKY94061.1 hypothetical protein MPSEU_000372700 [Mayamaea pseudoterrestris] diamond 315 60.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris

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