RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA534016" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA534016 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
507623 507623 PRJNA534016_P_NODE_5621_length_351_cov_3.302158_g5531_i0 PRJNA534016 5621 351 3.302158 11.59057458 Ditylum brightwellii 49249 SAR_Eukaryotes SAR_Eukaryotes 209 1.86e-49   NTclustered gi|398372887|gb|JX305464.1| 49249 g5531 i0 78.683 3.47578347578348 319 64 90 4 2 318 1767 2083 Ditylum brightwellii strain B-326 heat shock protein 90 (Hsp90) mRNA, complete cds blastn 1220 209 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Ditylum Ditylum brightwellii
507635 507635 PRJNA534016_P_NODE_6841_length_322_cov_3.365462_g6751_i0 PRJNA534016 6841 322 3.365462 10.83678764 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 462 1.18e-125   NTclustered gi|146762526|gb|EF553458.1| 2850 g6751 i0 92.812 99.7515527950311 320 22 99 1 1 320 4306 3988 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 32120 462 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
8160197 8160197 PRJNA534016_P_NODE_107_length_1964_cov_7.243258_g94_i0 PRJNA534016 107 1964 7.243258 142.25758712 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 1297 0   NTclustered gi|219111198|ref|XM_002177315.1| 556484 g94 i0 78.915 59.7622199592668 1954 380 99 25 23 1957 2024 84 Phaeodactylum tricornutum CCAP 1055/1 protein heat shock protein Hsp70 (HSP70A), mRNA blastn 117373 1297 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
10711507 10711507 PRJNA534016_P_NODE_14549_length_249_cov_1.284091_g14459_i0 PRJNA534016 14549 249 1.284091 3.19738659 Cylindrotheca fusiformis 2853 SAR_Eukaryotes SAR_Eukaryotes 180 9.91e-41   NTclustered gi|23168442|gb|AY125589.1| 2853 g14459 i0 83.333 5.6706827309237 198 30 79 3 53 249 574 379 Cylindrotheca fusiformis fucoxanthin chlorophyll a/c-binding protein precursor (cffcpB-2) mRNA, complete cds blastn 1412 180 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca fusiformis
12597276 12597276 PRJNA534016_P_NODE_6330_length_334_cov_1.475096_g6240_i0 PRJNA534016 6330 334 1.475096 4.92682064 Sellaphora 216740 SAR_Eukaryotes SAR_Eukaryotes 597 3.219999999999998e-166   NTclustered gi|134143232|gb|EF151962.1| 216741 g6240 i0 99.099 99.6407185628743 333 2 99 1 2 334 349 18 Sellaphora pupula clone RBG1 18S ribosomal RNA gene, partial sequence blastn 33280 603 0.990049751243781 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Sellaphoraceae Sellaphora Sellaphora pupula
16421081 16421081 PRJNA534016_P_NODE_6213_length_336_cov_25.684411_g6123_i0 PRJNA534016 6213 336 25.684411 86.29962096 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 228 4.909999999999999e-55   NTclustered gi|2202538974|gb|OM891880.1| 355634 g6123 i0 92.949 46.5089285714286 156 11 46 0 181 336 2133 1978 Navicula arenaria 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 15627 228 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
17085025 17085025 PRJNA534016_P_NODE_6154_length_338_cov_1.056604_g6064_i0 PRJNA534016 6154 338 1.056604 3.57132152 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 377 4.63e-100   NTclustered gi|219118860|ref|XM_002180161.1| 556484 g6064 i0 87.087 279.41124260355 333 43 99 0 6 338 1470 1138 Phaeodactylum tricornutum CCAP 1055/1 predicted protein (hUbi), mRNA blastn 94441 377 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
18358922 18358922 PRJNA534016_P_NODE_1055_length_804_cov_5.878249_g978_i0 PRJNA534016 1055 804 5.878249 47.26112196 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 300 2.61e-76   NTclustered gi|2785082235|gb|PQ157946.1| 2126271 g978 i0 75.073 22.2039800995025 686 149 84 21 133 804 44054 44731 Naviculales sp. strain SZCZO2114 mitochondrion, complete genome blastn 17852 300 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
19633515 19633515 PRJNA534016_P_NODE_10296_length_277_cov_1.161765_g10206_i0 PRJNA534016 10296 277 1.161765 3.21808905 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 65.8 3.27e-6   NTclustered gi|341604006|dbj|AB573062.1| 2850 g10206 i0 93.182 0.15884476534296 44 3 16 0 85 128 729 772 Phaeodactylum tricornutum ptbZIP16 mRNA for bZIP transcription factor, complete cds blastn 44 65.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
20244713 20244713 PRJNA534016_P_NODE_11816_length_264_cov_95.764398_g11726_i0 PRJNA534016 11816 264 95.764398 252.81801072 Entomoneis 186042 SAR_Eukaryotes SAR_Eukaryotes 464 2.6099999999999998e-126   NTclustered gi|2325195844|gb|OM494341.1| 186043 g11726 i0 98.485 195.984848484848 264 2 99 2 2 264 89309 89047 Entomoneis sp. isolate C2 plastid, complete genome blastn 51740 464 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.
23459663 23459663 PRJNA534016_P_NODE_12959_length_256_cov_1.234973_g12869_i0 PRJNA534016 12959 256 1.234973 3.16153088 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 396 9.33e-106   NTclustered gi|2785082235|gb|PQ157946.1| 2126271 g12869 i0 94.553 106.4765625 257 13 100 1 1 256 5397 5653 Naviculales sp. strain SZCZO2114 mitochondrion, complete genome blastn 27258 396 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.

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