RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJEB28062" 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

  • PRJEB28062 · 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
10226295 10226295 PRJEB28062_P_NODE_105169_length_299_cov_26.075221_g102806_i0 PRJEB28062 105169 299 26.075221 77.96491079 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 58.5 1.85e-7   NR GKY95628.1 2872254 g102806 i0 74.3 0.702341137123746 35 9 35.1 0 297 193 328 362 GKY95628.1 hypothetical protein MPSEU_000524100 [Mayamaea pseudoterrestris] diamond 210 58.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
26716237 26716237 PRJEB28062_P_NODE_134361_length_227_cov_21.051948_g131997_i0 PRJEB28062 134361 227 21.051948 47.78792196 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 52 1.63e-5   NR CAB9508794.1 568900 g131997 i0 81.5 0.713656387665198 27 5 35.7 0 204 124 452 478 CAB9508794.1 factor 3 subunit E [Seminavis robusta] diamond 162 52 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27222614 27222614 PRJEB28062_P_NODE_111083_length_283_cov_7.314286_g108720_i0 PRJEB28062 111083 283 7.314286 20.69942938 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 85.1 7.81e-17   NR GKY99969.1 2872254 g108720 i0 62.7 0.625441696113074 59 22 62.5 0 259 83 745 803 GKY99969.1 hypothetical protein MPSEU_000950500 [Mayamaea pseudoterrestris] diamond 177 85.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28858308 28858308 PRJEB28062_P_NODE_40688_length_569_cov_24.723790_g38354_i0 PRJEB28062 40688 569 24.72379 140.6783651 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 170 1.4899999999999999e-46   NR KAG7338049.1 303405 g38354 i0 67.8 1.21792618629174 118 38 62.2 0 136 489 391 508 KAG7338049.1 MATE efflux family protein [Nitzschia inconspicua] diamond 693 171 0.994152046783626 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29054463 29054463 PRJEB28062_P_NODE_137508_length_203_cov_9.084615_g135144_i0 PRJEB28062 137508 203 9.084615 18.44176845 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 56.6 1.35e-7   NR CAJ1930569.1 2856 g135144 i0 86.2 0.857142857142857 29 4 42.9 0 22 108 180 208 CAJ1930569.1 unnamed protein product [Cylindrotheca closterium] diamond 174 56.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30349709 30349709 PRJEB28062_P_NODE_138032_length_199_cov_5.769841_g135668_i0 PRJEB28062 138032 199 5.769841 11.48198359 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 105 5.28e-26   NR KAI2496222.1 210448 g135668 i0 87.3 0.829145728643216 55 7 82.9 0 23 187 216 270 KAI2496222.1 hypothetical protein MHU86_18273 [Fragilaria crotonensis] diamond 165 105 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30728285 30728285 PRJEB28062_P_NODE_72154_length_403_cov_133.103030_g69793_i0 PRJEB28062 72154 403 133.10303 536.4052109 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 88.2 4.53e-18   NR GKY90595.1 2872254 g69793 i0 51.4 0.781637717121588 105 40 70 2 26 307 170 274 GKY90595.1 hypothetical protein MPSEU_000033200 [Mayamaea pseudoterrestris] diamond 315 88.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
30949637 30949637 PRJEB28062_P_NODE_133434_length_231_cov_4.481013_g131070_i0 PRJEB28062 133434 231 4.481013 10.35114003 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 72.8 1.19e-13   NR KAG7356920.1 303405 g131070 i0 89.7 1.01298701298701 39 4 50.6 0 12 128 160 198 KAG7356920.1 chlorophyll A-B binding protein [Nitzschia inconspicua] diamond 234 72.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30981299 30981299 PRJEB28062_P_NODE_77314_length_386_cov_2.929712_g74952_i0 PRJEB28062 77314 386 2.929712 11.30868832 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 67 1.7e-11   NR KAI2510103.1 210448 g74952 i0 80 0.272020725388601 35 7 27.2 0 169 65 68 102 KAI2510103.1 hypothetical protein MHU86_4270 [Fragilaria crotonensis] diamond 105 67 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32278001 32278001 PRJEB28062_P_NODE_136539_length_212_cov_5.187050_g134175_i0 PRJEB28062 136539 212 5.18705 10.996546 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.00545   NR KAI2504924.1 210448 g134175 i0 68 0.35377358490566 25 8 35.4 0 187 113 68 92 KAI2504924.1 hypothetical protein MHU86_9533 [Fragilaria crotonensis] diamond 75 42.7 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32436252 32436252 PRJEB28062_P_NODE_119139_length_262_cov_16.931217_g116776_i0 PRJEB28062 119139 262 16.931217 44.35978854 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 63.2 5.89e-10   NR KAI2491859.1 210448 g116776 i0 64 1.69465648854962 50 18 57.3 0 262 113 126 175 KAI2491859.1 chlorophyll A-B binding protein [Fragilaria crotonensis] diamond 444 63.2 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);;