RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA289590" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA289590 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
372591 372591 PRJNA289590_P_NODE_24001_length_178_cov_1.612403_g23777_i0 PRJNA289590 24001 178 1.612403 2.87007734 Fallacia monoculata 1003053 SAR_Eukaryotes SAR_Eukaryotes 296 6.3e-76   NTclustered gi|817090803|gb|KM009461.1| 1003053 g23777 i0 96.629 102.595505617978 178 6 100 0 1 178 268 445 Fallacia monoculata isolate FD254 PSII protein D1 (psbA) gene, partial cds; chloroplast blastn 18262 296 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Sellaphoraceae Fallacia Fallacia monoculata
372783 372783 PRJNA289590_P_NODE_5541_length_417_cov_1.225543_g5317_i0 PRJNA289590 5541 417 1.225543 5.11051431 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 309 2.16e-79   NTclustered gi|657012367|gb|KF302531.1| 2850 g5317 i0 83.891 28.2685851318945 329 47 78 6 1 326 341 16 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 11788 309 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
1647088 1647088 PRJNA289590_P_NODE_13862_length_244_cov_1.528205_g13638_i0 PRJNA289590 13862 244 1.528205 3.7288202 Haslea provincialis 1764367 SAR_Eukaryotes SAR_Eukaryotes 374 4.1399999999999986e-99   NTclustered gi|2328347993|ref|NC_067579.1| 1764367 g13638 i0 94.309 100.094262295082 246 11 100 3 1 244 3254 3498 Haslea provincialis strain NCC 342 mitochondrion, complete genome blastn 24423 374 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea provincialis
12537930 12537930 PRJNA289590_P_NODE_23110_length_183_cov_1.216418_g22886_i0 PRJNA289590 23110 183 1.216418 2.22604494 Entomoneis 186042 SAR_Eukaryotes SAR_Eukaryotes 316 5.009999999999999e-82   NTclustered gi|2325195844|gb|OM494341.1| 186043 g22886 i0 97.826 193.311475409836 184 2 100 2 1 183 89300 89118 Entomoneis sp. isolate C2 plastid, complete genome blastn 35376 316 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.
18224107 18224107 PRJNA289590_P_NODE_18595_length_207_cov_2.867089_g18371_i0 PRJNA289590 18595 207 2.867089 5.93487423 Nitzschia ovalis 908985 SAR_Eukaryotes SAR_Eukaryotes 377 2.63e-100   NTclustered gi|2199203432|ref|NC_061046.1| 908985 g18371 i0 99.517 197.202898550725 207 1 100 0 1 207 60673 60467 Nitzschia ovalis chloroplast, complete genome blastn 40821 377 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia ovalis

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