RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJEB36940" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 3 ✖

tax_clade 1

bioproject 1

  • PRJEB36940 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
15016828 15016828 PRJEB36940_P_NODE_6152_length_346_cov_2.344322_g6023_i0 PRJEB36940 6152 346 2.344322 8.11135412 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 283 1.07e-71   NTclustered gi|224010101|ref|XM_002293973.1| 296543 g6023 i0 86.415 80.4277456647399 265 28 76 7 25 288 258 1 Thalassiosira pseudonana CCMP1335 histone H3 partial mRNA blastn 27828 283 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
17908344 17908344 PRJEB36940_P_NODE_13695_length_248_cov_0.891429_g13566_i0 PRJEB36940 13695 248 0.891429 2.21074392 Minutocellus polymorphus 265543 SAR_Eukaryotes SAR_Eukaryotes 121 6.059999999999999e-23   NTclustered gi|2020303798|gb|MW417227.1| 265543 g13566 i0 77.477 1.58467741935484 222 36 87 10 1 216 8502 8715 Minutocellus polymorphus isolate CNS00217 mitochondrion, complete genome blastn 393 121 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Minutocellus Minutocellus polymorphus
17908510 17908510 PRJEB36940_P_NODE_9675_length_281_cov_1.100962_g9546_i0 PRJEB36940 9675 281 1.100962 3.09370322 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 379 1.05e-100   NTclustered gi|146762526|gb|EF553458.1| 2850 g9546 i0 91.667 97.7508896797153 276 20 98 3 2 276 4288 4015 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 27468 379 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);;