RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1093008" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA1093008 · 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
27216734 27216734 PRJNA1093008_S_NODE_18122_length_383_cov_2.980645_g17795_i0 PRJNA1093008 18122 383 2.980645 11.41587035 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 108 7.540000000000001e-27   NR XP_002182037.1 556484 g17795 i0 46.1 4.48825065274151 115 62 90.1 0 383 39 85 199 XP_002182037.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 1719 109 0.990825688073395 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29277950 29277950 PRJNA1093008_S_NODE_35429_length_323_cov_14.576000_g35102_i0 PRJNA1093008 35429 323 14.576 47.08048 Pelagomonas calceolata 35677 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0393   NR CAH0374783.1 35677 g35102 i0 63.6 0.306501547987616 33 12 30.7 0 101 3 9 41 CAH0374783.1 unnamed protein product [Pelagomonas calceolata] diamond 99 42.7 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Pelagomonas Pelagomonas calceolata
29995923 29995923 PRJNA1093008_S_NODE_33631_length_328_cov_1.811765_g33304_i0 PRJNA1093008 33631 328 1.811765 5.9425892 Ectocarpus 2879 SAR_Eukaryotes SAR_Eukaryotes 115 5.43e-28   NR CBN75455.1 2880 g33304 i0 63.1 1.53658536585366 84 31 76.8 0 328 77 316 399 CBN75455.1 fructose-2,6-bisphosphate 2-phosphatase [Ectocarpus siliculosus] diamond 504 115 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus siliculosus
30185256 30185256 PRJNA1093008_S_NODE_102172_length_197_cov_5.572581_g101845_i0 PRJNA1093008 102172 197 5.572581 10.97798457 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 64.3 1.52e-11   NR CAE7678055.1 2951 g101845 i0 96.8 78.3654822335025 31 1 47.2 0 2 94 62 92 CAE7678055.1 Eif4a3 [Symbiodinium microadriaticum] diamond 15438 64.7 0.993817619783617 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
30383965 30383965 PRJNA1093008_S_NODE_76833_length_256_cov_1.683060_g76506_i0 PRJNA1093008 76833 256 1.68306 4.3086336 Vitrella brassicaformis CCMP3155 1169540 SAR_Eukaryotes SAR_Eukaryotes 94 4.17e-20   NR CEM01478.1 1169540 g76506 i0 55.1 1.8046875 78 35 91.4 0 21 254 1829 1906 CEM01478.1 unnamed protein product [Vitrella brassicaformis CCMP3155] diamond 462 94 1 Eukaryota Sar         Vitrellaceae Vitrella Vitrella brassicaformis
32312516 32312516 PRJNA1093008_S_NODE_19119_length_378_cov_2.498361_g18792_i0 PRJNA1093008 19119 378 2.498361 9.44380458 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 68.9 1.17e-10   NR CAI2373097.1 5936 g18792 i0 43.5 0.674603174603175 85 46 65.9 1 301 53 876 960 CAI2373097.1 unnamed protein product [Moneuplotes crassus] diamond 255 68.9 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus

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