RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA438572" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 21 ✖

tax_clade 1

bioproject 1

  • PRJNA438572 · 21 ✖

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
434829 434829 PRJNA438572_P_NODE_10881_length_311_cov_1.911765_g10762_i0 PRJNA438572 10881 311 1.911765 5.94558915 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 464 3.1499999999999995e-126   NTclustered gi|146762526|gb|EF553458.1| 2850 g10762 i0 93.59 78.2508038585209 312 18 100 2 1 311 4523 4213 Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 24336 464 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
10638911 10638911 PRJNA438572_P_NODE_19709_length_249_cov_0.886364_g19590_i0 PRJNA438572 19709 249 0.886364 2.20704636 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 368 1.97e-97   NTclustered gi|2163362274|dbj|LC648448.1| 2872254 g19590 i0 93.522 98.85140562249 247 16 99 0 3 249 1238 992 Mayamaea pseudoterrestris NIES-4280 chloroplast gene for ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit, partial cds blastn 24614 368 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
24042874 24042874 PRJNA438572_P_NODE_23559_length_243_cov_0.917647_g23440_i0 PRJNA438572 23559 243 0.917647 2.22988221 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 91.7 1.07e-21   NR KAL3811149.1 382380 g23440 i0 63.8 8.35802469135803 69 24 85.2 1 209 3 10 77 KAL3811149.1 hypothetical protein ACHAXA_001364 [Cyclostephanos tholiformis] diamond 2031 92.4 0.992424242424242 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
26632810 26632810 PRJNA438572_P_NODE_17821_length_252_cov_0.871508_g17702_i0 PRJNA438572 17821 252 0.871508 2.19620016 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 80.1 2.81e-15   NR CAB9504150.1 568900 g17702 i0 44.6 1.97619047619048 83 45 98.8 1 2 250 168 249 CAB9504150.1 unknown protein [Seminavis robusta] diamond 498 80.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
26949336 26949336 PRJNA438572_P_NODE_15182_length_267_cov_1.273196_g15063_i0 PRJNA438572 15182 267 1.273196 3.39943332 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 47.8 1.19e-4   NR KAI2501972.1 210448 g15063 i0 33.3 1.64044943820225 72 48 80.9 0 235 20 6 77 KAI2501972.1 hypothetical protein MHU86_12455 [Fragilaria crotonensis] diamond 438 47.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27865532 27865532 PRJNA438572_P_NODE_17965_length_251_cov_1.702247_g17846_i0 PRJNA438572 17965 251 1.702247 4.27263997 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 75.5 1.22e-13   NR GFH53639.1 426638 g17846 i0 45.8 0.99203187250996006 83 45 99.2 0 250 2 357 439 GFH53639.1 hypothetical protein CTEN210_10115 [Chaetoceros tenuissimus] diamond 249 75.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28465726 28465726 PRJNA438572_P_NODE_6766_length_386_cov_1.734824_g6647_i0 PRJNA438572 6766 386 1.734824 6.69642064 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 112 2.16e-26   NR GAX18045.1 1519565 g6647 i0 68.8 2.40932642487047 77 24 59.8 0 2 232 321 397 GAX18045.1 sterol 24-C-methyltransferase [Fistulifera solaris] diamond 930 112 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28655088 28655088 PRJNA438572_P_NODE_19547_length_249_cov_0.886364_g19428_i0 PRJNA438572 19547 249 0.886364 2.20704636 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 47.4 3.11e-4   NR XP_002291878.1 296543 g19428 i0 47.6 0.506024096385542 42 22 50.6 0 243 118 81 122 XP_002291878.1 predicted protein, partial [Thalassiosira pseudonana CCMP1335] diamond 126 47.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
28718268 28718268 PRJNA438572_P_NODE_5747_length_417_cov_1.892442_g5628_i0 PRJNA438572 5747 417 1.892442 7.89148314 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 146 1.5199999999999998e-37   NR CAB9516456.1 568900 g5628 i0 55.4 0.805755395683453 112 49 79.9 1 85 417 418 529 CAB9516456.1 expressed unknown protein [Seminavis robusta] diamond 336 146 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28765958 28765958 PRJNA438572_P_NODE_20007_length_248_cov_1.720000_g19888_i0 PRJNA438572 20007 248 1.72 4.2656 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 86.7 2.79e-18   NR CAJ1914643.1 2856 g19888 i0 50.6 8.68548387096774 81 35 91.9 1 19 246 16 96 CAJ1914643.1 unnamed protein product [Cylindrotheca closterium] diamond 2154 86.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
28939314 28939314 PRJNA438572_P_NODE_14388_length_275_cov_0.811881_g14269_i0 PRJNA438572 14388 275 0.811881 2.23267275 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 55.8 1.35e-6   NR KAL3924583.1 3061772 g14269 i0 57.8 4.40727272727273 45 19 49.1 0 141 275 89 133 KAL3924583.1 MAG: hypothetical protein SGILL_000953 [Bacillariaceae sp.] diamond 1212 55.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29034161 29034161 PRJNA438572_P_NODE_10908_length_311_cov_1.310924_g10789_i0 PRJNA438572 10908 311 1.310924 4.07697364 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0246   NR KAL3945222.1 3061772 g10789 i0 45 0.578778135048232 60 30 57.9 1 182 3 1471 1527 KAL3945222.1 MAG: hypothetical protein SGBAC_000695 [Bacillariaceae sp.] diamond 180 44.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29302793 29302793 PRJNA438572_P_NODE_9209_length_336_cov_1.186312_g9090_i0 PRJNA438572 9209 336 1.186312 3.98600832 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 110 6.3099999999999996e-27   NR KAL3797826.1 29204 g9090 i0 53.9 3.51785714285714 102 39 91.1 1 310 5 2 95 KAL3797826.1 hypothetical protein HJC23_006864 [Cyclotella cryptica] diamond 1182 110 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29412673 29412673 PRJNA438572_P_NODE_13329_length_284_cov_1.364929_g13210_i0 PRJNA438572 13329 284 1.364929 3.87639836 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 84 1.99e-16   NR XP_002178088.1 556484 g13210 i0 53.7 0.707746478873239 67 30 70.8 1 203 3 565 630 XP_002178088.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 201 84 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29823038 29823038 PRJNA438572_P_NODE_16271_length_257_cov_1.570652_g16152_i0 PRJNA438572 16271 257 1.570652 4.03657564 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 57.4 3.08e-7   NR GFH53639.1 426638 g16152 i0 40.5 0.980544747081712 84 46 93.4 2 250 11 205 288 GFH53639.1 hypothetical protein CTEN210_10115 [Chaetoceros tenuissimus] diamond 252 57.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30897642 30897642 PRJNA438572_P_NODE_23214_length_244_cov_0.883041_g23095_i0 PRJNA438572 23214 244 0.883041 2.15462004 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 129 4.39e-33   NR GKY93540.1 2872254 g23095 i0 76.5 1.99180327868852 81 19 99.6 0 243 1 379 459 GKY93540.1 hypothetical protein MPSEU_000321400 [Mayamaea pseudoterrestris] diamond 486 129 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
31008585 31008585 PRJNA438572_P_NODE_15474_length_264_cov_2.198953_g15355_i0 PRJNA438572 15474 264 2.198953 5.80523592 root 1 Root_unresolved Root_unresolved 85.9 3.18e-17   NR CAB9516456.1 568900 g15355 i0 46.3 1.86363636363636 82 43 93.2 1 17 262 418 498 CAB9516456.1 expressed unknown protein [Seminavis robusta] diamond 492 85.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31229540 31229540 PRJNA438572_P_NODE_14715_length_271_cov_1.575758_g14596_i0 PRJNA438572 14715 271 1.575758 4.27030418 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 92.4 1.7e-19   NR CAB9521928.1 568900 g14596 i0 54.1 4.79335793357934 85 35 93 3 270 19 198 279 CAB9521928.1 Aspartate aminotransferase, mitochondrial [Seminavis robusta] diamond 1299 93.2 0.991416309012876 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31656058 31656058 PRJNA438572_P_NODE_17357_length_252_cov_1.737430_g17238_i0 PRJNA438572 17357 252 1.73743 4.3783236 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 127 2.73e-32   NR KAL3823544.1 382380 g17238 i0 76.5 1.94047619047619 81 19 96.4 0 9 251 381 461 KAL3823544.1 hypothetical protein ACHAXA_002885 [Cyclostephanos tholiformis] diamond 489 127 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
32352534 32352534 PRJNA438572_P_NODE_15639_length_263_cov_1.389474_g15520_i0 PRJNA438572 15639 263 1.389474 3.65431662 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 102 1.6499999999999995e-23   NR CAB9520027.1 568900 g15520 i0 77.5 0.809885931558935 71 11 81 2 50 262 78 143 CAB9520027.1 stress transcription factor B-2b [Seminavis robusta] diamond 213 102 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32762601 32762601 PRJNA438572_P_NODE_20660_length_247_cov_1.787356_g20541_i0 PRJNA438572 20660 247 1.787356 4.41476932 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 74.7 2.11e-13   NR KAI2505735.1 210448 g20541 i0 53.2 2.90283400809717 77 33 89.9 1 224 3 180 256 KAI2505735.1 Ubiquitin carboxyl-terminal hydrolase [Fragilaria crotonensis] diamond 717 74.7 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);;