RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA900028" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA900028 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
26866219 26866219 PRJNA900028_P_NODE_166761_length_163_cov_0.894737_g166012_i0 PRJNA900028 166761 163 0.894737 1.45842131 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 89 6.59e-19   NR GKY97666.1 2872254 g166012 i0 79.6 1.98773006134969 54 11 99.4 0 162 1 496 549 GKY97666.1 hypothetical protein MPSEU_000724900 [Mayamaea pseudoterrestris] diamond 324 89 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28224134 28224134 PRJNA900028_P_NODE_101026_length_175_cov_1.619048_g100277_i0 PRJNA900028 101026 175 1.619048 2.833334 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 45.8 5.37e-4   NR GFH43726.1 426638 g100277 i0 54.2 3.48 48 18 75.4 2 157 26 39 86 GFH43726.1 hypothetical protein CTEN210_00199 [Chaetoceros tenuissimus] diamond 609 45.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28887309 28887309 PRJNA900028_P_NODE_23268_length_259_cov_0.971429_g22519_i0 PRJNA900028 23268 259 0.971429 2.51600111 Actinocyclus sp. mgcode 4 2914904 SAR_Eukaryotes SAR_Eukaryotes 50.1 9.35e-5   NR QYC61840.1 2914904 g22519 i0 40.6 1.54054054054054 69 39 77.6 1 212 12 115 183 QYC61840.1 ribosomal protein L2 [Actinocyclus sp. mgcode 4] diamond 399 50.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Hemidiscaceae Actinocyclus Actinocyclus sp. mgcode 4
29077009 29077009 PRJNA900028_P_NODE_138868_length_166_cov_0.871795_g138119_i0 PRJNA900028 138868 166 0.871795 1.4471797 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 95.9 1.21e-21   NR GKY92867.1 2872254 g138119 i0 74.1 0.975903614457831 54 14 97.6 0 5 166 186 239 GKY92867.1 hypothetical protein MPSEU_000255900 [Mayamaea pseudoterrestris] diamond 162 95.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29739674 29739674 PRJNA900028_P_NODE_7770_length_389_cov_2.026471_g7024_i0 PRJNA900028 7770 389 2.026471 7.88297219 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0462   NR KAL3800710.1 382360 g7024 i0 41.1 0.431876606683805 56 33 43.2 0 267 100 52 107 KAL3800710.1 hypothetical protein ACHAWO_013252 [Cyclotella atomus] diamond 168 44.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
30094870 30094870 PRJNA900028_P_NODE_65772_length_191_cov_2.514085_g65023_i0 PRJNA900028 65772 191 2.514085 4.80190235 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 53.5 5.06e-7   NR YP_010133813.1 880757 g65023 i0 49.2 4.96335078534031 63 31 99 1 1 189 27 88 YP_010133813.1 ribosomal protein L14 [Fistulifera saprophila] diamond 948 53.9 0.992578849721707 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
30403780 30403780 PRJNA900028_P_NODE_194193_length_161_cov_0.910714_g193444_i0 PRJNA900028 194193 161 0.910714 1.46624954 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 48.1 1.52e-4   NR EJK48984.1 159749 g193444 i0 67.9 0.521739130434783 28 9 52.2 0 86 3 369 396 EJK48984.1 hypothetical protein THAOC_32180 [Thalassiosira oceanica] diamond 84 48.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31414615 31414615 PRJNA900028_P_NODE_135796_length_166_cov_0.871795_g135047_i0 PRJNA900028 135796 166 0.871795 1.4471797 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 74.7 7.06e-14   NR CAB9519463.1 568900 g135047 i0 61.8 0.993975903614458 55 21 99.4 0 166 2 155 209 CAB9519463.1 3beta-hydroxysteroid-dehydrogenase/decarboxylase isoform 2 [Seminavis robusta] diamond 165 74.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32142252 32142252 PRJNA900028_P_NODE_51978_length_205_cov_2.320513_g51229_i0 PRJNA900028 51978 205 2.320513 4.75705165 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 74.3 1.62e-13   NR KAL3787509.1 382360 g51229 i0 66.7 2.79512195121951 48 16 70.2 0 204 61 118 165 KAL3787509.1 hypothetical protein ACHAWO_003499 [Cyclotella atomus] diamond 573 74.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
32174075 32174075 PRJNA900028_P_NODE_182498_length_162_cov_0.902655_g181749_i0 PRJNA900028 182498 162 0.902655 1.4623011 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 83.2 7.08e-17   NR GKY99551.1 2872254 g181749 i0 72.1 1.12962962962963 61 10 100 3 1 162 985 1045 GKY99551.1 hypothetical protein MPSEU_000909400 [Mayamaea pseudoterrestris] diamond 183 83.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32300774 32300774 PRJNA900028_P_NODE_3619_length_566_cov_2.166344_g2900_i0 PRJNA900028 3619 566 2.166344 12.26150704 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 148 2.2199999999999996e-37   NR KAI2490608.1 210448 g2900 i0 40.6 2.95229681978799 192 106 99.6 5 2 565 634 821 KAI2490608.1 Reverse transcriptase (RNA-dependent DNA polymerase) [Fragilaria crotonensis] diamond 1671 148 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis

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