RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA800090", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 20 ✖

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJNA800090 · 20 ✖

analysis 1

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
3772539 3772539 PRJNA800090_P_NODE_24663_length_792_cov_3.384509_g22721_i0 PRJNA800090 24663 792 3.384509 26.80531128 Cyclotella 29203 SAR_Eukaryotes SAR_Eukaryotes 488 2.0499999999999994e-172   NR AAX09600.1 29204 g22721 i0 88.6 2 264 30 100 0 792 1 35 298 AAX09600.1 elongation factor 1 alpha, partial [Cyclotella cryptica] diamond 1584 488 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
5902289 5902289 PRJNA800090_P_NODE_29805_length_705_cov_2.391509_g27735_i0 PRJNA800090 29805 705 2.391509 16.86013845 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 320 9.069999999999996e-106   NR KAI2503397.1 210448 g27735 i0 63.1 14.5021276595745 233 86 99.1 0 7 705 100 332 KAI2503397.1 ribosomal eS4-like protein [Fragilaria crotonensis] diamond 10224 320 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
8873160 8873160 PRJNA800090_P_NODE_110847_length_306_cov_2.075949_g108662_i0 PRJNA800090 110847 306 2.075949 6.35240394 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 109 2.12e-28   NR CAJ1953280.1 2856 g108662 i0 67.9 3.92156862745098 78 24 75.5 1 277 47 30 107 CAJ1953280.1 unnamed protein product [Cylindrotheca closterium] diamond 1200 109 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
17377888 17377888 PRJNA800090_P_NODE_63914_length_432_cov_1.887052_g61730_i0 PRJNA800090 63914 432 1.887052 8.15206464 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 221 2.65e-71   NR GFH58715.1 426638 g61730 i0 85.4 26.1736111111111 130 19 90.3 0 2 391 37 166 GFH58715.1 small subunit ribosomal protein S13e [Chaetoceros tenuissimus] diamond 11307 221 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
23752614 23752614 PRJNA800090_P_NODE_84759_length_361_cov_0.952055_g82574_i0 PRJNA800090 84759 361 0.952055 3.43691855 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 237 2.18e-77   NR CAJ1953473.1 2856 g82574 i0 90.7 11.617728531856 118 11 98.1 0 354 1 68 185 CAJ1953473.1 unnamed protein product [Cylindrotheca closterium] diamond 4194 237 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27843607 27843607 PRJNA800090_P_NODE_118344_length_294_cov_1.933333_g116159_i0 PRJNA800090 118344 294 1.933333 5.68399902 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 97.4 2.67e-22   NR GFH49679.1 426638 g116159 i0 72.4 1.36734693877551 58 16 59.2 0 183 10 14 71 GFH49679.1 hypothetical protein CTEN210_06155 [Chaetoceros tenuissimus] diamond 402 97.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
27843636 27843636 PRJNA800090_P_NODE_179604_length_233_cov_0.890244_g177419_i0 PRJNA800090 179604 233 0.890244 2.07426852 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 60.8 3.34e-10   NR OEU08345.1 635003 g177419 i0 56.3 0.618025751072961 48 21 61.8 0 15 158 8 55 OEU08345.1 hypothetical protein FRACYDRAFT_271807 [Fragilariopsis cylindrus CCMP1102] diamond 144 60.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
28064782 28064782 PRJNA800090_P_NODE_149225_length_257_cov_1.148936_g147040_i0 PRJNA800090 149225 257 1.148936 2.95276552 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 58.5 1.09e-7   NR KAL3938366.1 3061772 g147040 i0 38.8 1.86770428015564 80 43 89.9 2 251 21 171 247 KAL3938366.1 MAG: hypothetical protein SGBAC_006716 [Bacillariaceae sp.] diamond 480 58.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
28412205 28412205 PRJNA800090_P_NODE_176786_length_234_cov_0.884848_g174601_i0 PRJNA800090 176786 234 0.884848 2.07054432 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 70.9 4.26e-12   NR CAB9510153.1 568900 g174601 i0 44.1 2.61538461538462 68 38 87.2 0 234 31 629 696 CAB9510153.1 chloride channel [Seminavis robusta] diamond 612 70.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28421260 28421260 PRJNA800090_P_NODE_134486_length_272_cov_1.467980_g132301_i0 PRJNA800090 134486 272 1.46798 3.9929056 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 125 4.79e-34   NR GFH54804.1 426638 g132301 i0 65.2 5.88970588235294 89 31 98.2 0 1 267 60 148 GFH54804.1 hypothetical protein CTEN210_11280 [Chaetoceros tenuissimus] diamond 1602 126 0.992063492063492 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28443885 28443885 PRJNA800090_P_NODE_196006_length_222_cov_2.156863_g193821_i0 PRJNA800090 196006 222 2.156863 4.78823586 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0378   NR GKY93563.1 2872254 g193821 i0 50 0.459459459459459 34 17 45.9 0 2 103 287 320 GKY93563.1 hypothetical protein MPSEU_000323700 [Mayamaea pseudoterrestris] diamond 102 42.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29115789 29115789 PRJNA800090_P_NODE_131188_length_276_cov_1.913043_g129003_i0 PRJNA800090 131188 276 1.913043 5.27999868 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 66.6 1.96e-10   NR GFH54439.1 426638 g129003 i0 49.1 1.23913043478261 57 29 62 0 176 6 168 224 GFH54439.1 hypothetical protein CTEN210_10915 [Chaetoceros tenuissimus] diamond 342 66.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
29368316 29368316 PRJNA800090_P_NODE_11549_length_1194_cov_3.343111_g10287_i0 PRJNA800090 11549 1194 3.343111 39.91674534 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 129 1.91e-29   NR KAL3808677.1 382380 g10287 i0 32.7 2.02261306532663 294 145 70.4 11 1115 276 69 323 KAL3808677.1 hypothetical protein ACHAXA_009230 [Cyclostephanos tholiformis] diamond 2415 129 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
29517085 29517085 PRJNA800090_P_NODE_179550_length_233_cov_0.890244_g177365_i0 PRJNA800090 179550 233 0.890244 2.07426852 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 84.3 4.36e-18   NR GFH46801.1 426638 g177365 i0 60.9 4.33905579399142 69 27 88.8 0 208 2 2 70 GFH46801.1 large subunit ribosomal protein L13Ae [Chaetoceros tenuissimus] diamond 1011 84.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30031503 30031503 PRJNA800090_P_NODE_182091_length_232_cov_0.895706_g179906_i0 PRJNA800090 182091 232 0.895706 2.07803792 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 115 1.07e-27   NR GFH60156.1 426638 g179906 i0 73.7 1.96551724137931 76 20 98.3 0 3 230 397 472 GFH60156.1 hypothetical protein CTEN210_16631 [Chaetoceros tenuissimus] diamond 456 115 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30094474 30094474 PRJNA800090_P_NODE_174352_length_235_cov_0.879518_g172167_i0 PRJNA800090 174352 235 0.879518 2.0668673 Fragilariophyceae 33853 SAR_Eukaryotes SAR_Eukaryotes 85.5 2.83e-17   NR AFS18271.1 1436140 g172167 i0 63.2 1.73617021276596 68 25 86.8 0 30 233 254 321 AFS18271.1 silicic acid transport protein, partial [Ulnaria acus] diamond 408 85.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria acus
31191199 31191199 PRJNA800090_P_NODE_181995_length_232_cov_0.895706_g179810_i0 PRJNA800090 181995 232 0.895706 2.07803792 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 47 9.82e-4   NR KAI2499002.1 210448 g179810 i0 53.8 0.504310344827586 39 18 50.4 0 197 81 23 61 KAI2499002.1 hypothetical protein MHU86_15506 [Fragilaria crotonensis] diamond 117 47 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31602842 31602842 PRJNA800090_P_NODE_157496_length_249_cov_1.561111_g155311_i0 PRJNA800090 157496 249 1.561111 3.88716639 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 59.3 5.82e-8   NR KAL3781266.1 29204 g155311 i0 32.9 2.92771084337349 85 50 97.6 2 244 2 962 1043 KAL3781266.1 LOW QUALITY PROTEIN: hypothetical protein HJC23_012816 [Cyclotella cryptica] diamond 729 59.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32457065 32457065 PRJNA800090_P_NODE_110379_length_307_cov_1.533613_g108194_i0 PRJNA800090 110379 307 1.533613 4.70819191 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 88.6 4.55e-19   NR KAG7366721.1 303405 g108194 i0 46.9 2.87296416938111 98 50 95.8 1 13 306 47 142 KAG7366721.1 ribosomal protein 50S-L18Ae/60S-L20/60S-L18A [Nitzschia inconspicua] diamond 882 88.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32592394 32592394 PRJNA800090_P_NODE_149199_length_257_cov_1.164894_g147014_i0 PRJNA800090 149199 257 1.164894 2.99377758 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 71.2 6.21e-13   NR KAI2495804.1 210448 g147014 i0 48.1 2.6147859922179 79 33 82.9 2 218 6 2 80 KAI2495804.1 Ribosomal protein L6 [Fragilaria crotonensis] diamond 672 71.6 0.994413407821229 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);;