RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA520845" 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

  • PRJNA520845 · 6 ✖

analysis 1

  • blastn · 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
1765540 1765540 PRJNA520845_P_NODE_217582_length_250_cov_2.028249_g216083_i0 PRJNA520845 217582 250 2.028249 5.0706225 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 106 1.71e-18   NTclustered gi|224004779|ref|XM_002296005.1| 296543 g216083 i0 78.659 0.656 164 31 65 4 71 232 113 274 Thalassiosira pseudonana CCMP1335 F-type H-ATPase beta subunit mRNA blastn 164 106 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
4314386 4314386 PRJNA520845_P_NODE_112224_length_351_cov_2.230216_g110725_i0 PRJNA520845 112224 351 2.230216 7.82805816 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 257 6.55e-64   NTclustered gi|657012367|gb|KF302531.1| 2850 g110725 i0 85.039 19.8518518518519 254 36 72 2 1 253 133 385 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 6968 257 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
4939491 4939491 PRJNA520845_P_NODE_137904_length_318_cov_1.542857_g136405_i0 PRJNA520845 137904 318 1.542857 4.90628526 Thalassiosira 35127 SAR_Eukaryotes SAR_Eukaryotes 553 6.699999999999998e-153   NTclustered gi|2862228846|gb|PQ645480.1| 1048533 g136405 i0 98.107 99.7138364779874 317 6 99 0 1 317 3576 3892 Thalassiosira bioculata isolate AGSB0307 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 31709 553 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira bioculata
5594148 5594148 PRJNA520845_P_NODE_217065_length_251_cov_0.865169_g215566_i0 PRJNA520845 217065 251 0.865169 2.17157419 Climaconeis cf. scalaris 2846828 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.006   NTclustered gi|2073949001|gb|MZ365054.1| 2846828 g215566 i0 100 0.115537848605578 29 0 12 0 217 245 97519 97491 Climaconeis cf. scalaris strain SZCZ1888 plastid, complete genome blastn 29 54.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Berkeleyaceae Climaconeis Climaconeis cf. scalaris
11968691 11968691 PRJNA520845_P_NODE_202870_length_259_cov_1.634409_g201371_i0 PRJNA520845 202870 259 1.634409 4.23311931 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 193 1.33e-44   NTclustered gi|657012465|gb|KF302574.1| 2850 g201371 i0 84.343 0.764478764478765 198 29 76 2 16 212 197 1 Phaeodactylum tricornutum clone C567 ribosomal protein mRNA, partial cds blastn 198 193 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
17065227 17065227 PRJNA520845_P_NODE_131634_length_325_cov_2.345238_g130135_i0 PRJNA520845 131634 325 2.345238 7.6220235 Guinardia striata 1514137 SAR_Eukaryotes SAR_Eukaryotes 143 1.76e-29   NTclustered gi|2202538957|gb|OM891863.1| 1514137 g130135 i0 81.977 3.99384615384615 172 27 52 3 156 325 6053 5884 Guinardia striata 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 1298 143 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia striata

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