RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1028258" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA1028258 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
3990513 3990513 PRJNA1028258_P_NODE_160064_length_229_cov_0.887500_g159501_i0 PRJNA1028258 160064 229 0.8875 2.032375 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 110 1.2e-19   NTclustered gi|224004779|ref|XM_002296005.1| 296543 g159501 i0 79.268 0.716157205240175 164 29 70 5 55 215 113 274 Thalassiosira pseudonana CCMP1335 F-type H-ATPase beta subunit mRNA blastn 164 110 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
3990753 3990753 PRJNA1028258_P_NODE_175224_length_225_cov_0.910256_g174661_i0 PRJNA1028258 175224 225 0.910256 2.048076 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 248 2.38e-61   NTclustered gi|224010101|ref|XM_002293973.1| 296543 g174661 i0 87.671 98.2266666666667 219 19 97 7 6 223 242 31 Thalassiosira pseudonana CCMP1335 histone H3 partial mRNA blastn 22101 248 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
24389247 24389247 PRJNA1028258_P_NODE_115500_length_248_cov_1.189944_g114937_i0 PRJNA1028258 115500 248 1.189944 2.95106112 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 292 1.21e-74   NTclustered gi|224004779|ref|XM_002296005.1| 296543 g114937 i0 88.983 98.5604838709677 236 26 95 0 4 239 1090 855 Thalassiosira pseudonana CCMP1335 F-type H-ATPase beta subunit mRNA blastn 24443 292 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
25231096 25231096 PRJNA1028258_P_NODE_164080_length_228_cov_0.893082_g163517_i0 PRJNA1028258 164080 228 0.893082 2.03622696 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 222 1.46e-53   NTclustered gi|223993518|ref|XM_002286407.1| 296543 g163517 i0 87.31 27.640350877193 197 21 86 4 1 195 166 360 Thalassiosira pseudonana CCMP1335 adp-ribosylation factor (ARF3), mRNA blastn 6302 224 0.991071428571429 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana

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