RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJDB4470", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 12 ✖

tax_clade 1

  • Sar · 12 ✖

bioproject 1

  • PRJDB4470 · 12 ✖

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
2559641 2559641 PRJDB4470_P_NODE_74263_length_211_cov_1.185185_g73108_i0 PRJDB4470 74263 211 1.185185 2.50074035 Minutocellus polymorphus 265543 SAR_Eukaryotes SAR_Eukaryotes 128 2.99e-25   NTclustered gi|2632235292|gb|OR922674.1| 265543 g73108 i0 94.118 34.4502369668246 85 4 40 1 1 84 3982 4066 Minutocellus polymorphus strain AGSB0025 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 7269 128 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Minutocellus Minutocellus polymorphus
6387885 6387885 PRJDB4470_P_NODE_55486_length_266_cov_2.635945_g54331_i0 PRJDB4470 55486 266 2.635945 7.0116137 Chaetoceros similis 1366869 SAR_Eukaryotes SAR_Eukaryotes 117 8.5e-22   NTclustered gi|2632235327|gb|OR922709.1| 1366869 g54331 i0 84.746 3.07518796992481 118 17 44 1 149 266 3932 4048 Chaetoceros similis strain AGSB0114 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 818 117 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros similis
7661608 7661608 PRJDB4470_P_NODE_21947_length_509_cov_4.202174_g20828_i0 PRJDB4470 21947 509 4.202174 21.38906566 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 743 0   NTclustered gi|146762526|gb|EF553458.1| 2850 g20828 i0 93.124 100.318271119843 509 32 99 3 2 509 4571 4065 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 51062 743 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
7661695 7661695 PRJDB4470_P_NODE_30327_length_416_cov_3.686649_g29185_i0 PRJDB4470 30327 416 3.686649 15.33645984 Nitzschia sp. (in: diatoms) 1884248 SAR_Eukaryotes SAR_Eukaryotes 126 2.32e-24   NTclustered gi|2632235302|gb|OR922684.1| 1884248 g29185 i0 87.273 0.264423076923077 110 14 26 0 204 313 3592 3483 Nitzschia sp. (in: diatoms) strain AGSB0041 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 110 126 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. (in: diatoms)
15311783 15311783 PRJDB4470_P_NODE_54433_length_270_cov_7.113122_g53278_i0 PRJDB4470 54433 270 7.113122 19.2054294 Mayamaea permitis 1302819 SAR_Eukaryotes SAR_Eukaryotes 350 7.84e-92   NTclustered gi|168145888|emb|AM710524.1| 1302819 g53278 i0 91.732 92.862962962963 254 17 94 3 1 254 294 45 Mayamaea atomus var. permitis partial 28S rRNA gene, strain AT-101Gel04 blastn 25073 350 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea permitis
24235537 24235537 PRJDB4470_P_NODE_63740_length_238_cov_1.333333_g62585_i0 PRJDB4470 63740 238 1.333333 3.17333254 Attheya longicornis 451786 SAR_Eukaryotes SAR_Eukaryotes 99 2.71e-16   NTclustered gi|2046217437|gb|MW729336.1| 451786 g62585 i0 78.808 5.16806722689076 151 28 62 4 91 238 38496 38347 Attheya longicornis mitochondrion, complete genome blastn 1230 99 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Attheyaceae Attheya Attheya longicornis
26614844 26614844 PRJDB4470_P_NODE_54581_length_270_cov_1.687783_g53426_i0 PRJDB4470 54581 270 1.687783 4.5570141 root 1 Root_unresolved Root_unresolved 70.5 3.79e-13   NR KAI2489480.1 210448 g53426 i0 46.6 1.58888888888889 73 39 81.1 0 255 37 7 79 KAI2489480.1 hypothetical protein MHU86_25120 [Fragilaria crotonensis] diamond 429 70.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
26652350 26652350 PRJDB4470_P_NODE_91621_length_180_cov_2.717557_g90466_i0 PRJDB4470 91621 180 2.717557 4.8916026 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 98.2 5.87e-24   NR XP_002177601.1 556484 g90466 i0 75.9 0.9 54 13 90 0 18 179 98 151 XP_002177601.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 162 98.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29463644 29463644 PRJDB4470_P_NODE_81470_length_196_cov_1.768707_g80315_i0 PRJDB4470 81470 196 1.768707 3.46666572 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 57.4 1.17e-7   NR KAI2489481.1 210448 g80315 i0 44.4 0.964285714285714 63 27 96.4 2 7 195 214 268 KAI2489481.1 hypothetical protein MHU86_25121 [Fragilaria crotonensis] diamond 189 57.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30317366 30317366 PRJDB4470_P_NODE_44272_length_319_cov_1.618519_g43119_i0 PRJDB4470 44272 319 1.618519 5.16307561 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 57 8.78e-7   NR KAL3921821.1 3061772 g43119 i0 35 1.12852664576802 120 60 95.9 4 317 12 422 541 KAL3921821.1 MAG: hypothetical protein SGILL_002544, partial [Bacillariaceae sp.] diamond 360 57 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
31675833 31675833 PRJDB4470_P_NODE_82237_length_195_cov_1.219178_g81082_i0 PRJDB4470 82237 195 1.219178 2.3773971 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0491   NR KAL3927776.1 3061772 g81082 i0 38.6 0.876923076923077 57 23 83.1 2 14 175 223 270 KAL3927776.1 MAG: hypothetical protein SGBAC_012937 [Bacillariaceae sp.] diamond 171 41.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
32719284 32719284 PRJDB4470_P_NODE_22720_length_499_cov_1.386667_g21599_i0 PRJDB4470 22720 499 1.386667 6.91946833 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 52.4 2.18e-4   NR XP_002179091.1 556484 g21599 i0 28.7 1.68937875751503 188 108 99.8 7 2 499 170 353 XP_002179091.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 843 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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