RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJDB4470" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 6 ✖

tax_clade 1

bioproject 1

  • PRJDB4470 · 6 ✖

analysis 1

  • diamond · 6 ✖

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