RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "blastn", bioproject = "PRJNA690592" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 17 ✖

tax_clade 1

bioproject 1

  • PRJNA690592 · 17 ✖

analysis 1

  • blastn · 17 ✖

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
1948095 1948095 PRJNA690592_S_NODE_8962_length_951_cov_2.133257_g8254_i0 PRJNA690592 8962 951 2.133257 20.28727407 Paralia sulcata 216927 SAR_Eukaryotes SAR_Eukaryotes 139 7.18e-28   NTclustered gi|2074156086|gb|MW413901.1| 216927 g8254 i0 84.138 8.60252365930599 145 21 15 2 172 315 21230 21087 Paralia sulcata mitochondrion, complete genome blastn 8181 139 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Paraliales Paraliaceae Paralia Paralia sulcata
3730946 3730946 PRJNA690592_S_NODE_98523_length_329_cov_3.148438_g97509_i0 PRJNA690592 98523 329 3.148438 10.35836102 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 113 1.4e-20   NTclustered gi|1169296927|gb|KY364697.1| 29204 g97509 i0 84.956 34.0759878419453 113 15 34 2 61 172 4347 4458 Cyclotella cryptica 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 11211 113 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
4499641 4499641 PRJNA690592_S_NODE_26064_length_590_cov_2.984526_g25072_i0 PRJNA690592 26064 590 2.984526 17.6087034 Cocconeiopsis kantsiensis 3082010 SAR_Eukaryotes SAR_Eukaryotes 67.6 2.08e-6   NTclustered gi|2692958369|ref|NC_086887.1| 3082010 g25072 i0 90.196 0.264406779661017 51 5 9 0 7 57 18718 18668 Cocconeiopsis kantsiensis isolate Huiquan Bay in China mitochondrion, complete genome blastn 156 67.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeiopsis Cocconeiopsis kantsiensis
4500112 4500112 PRJNA690592_S_NODE_91064_length_340_cov_1.599251_g90050_i0 PRJNA690592 91064 340 1.599251 5.4374534 Lithodesmioides sp. mgcode 4 2914905 SAR_Eukaryotes SAR_Eukaryotes 156 2.38e-33   NTclustered gi|2073953334|gb|MW849271.1| 2914905 g90050 i0 78.175 1.75 252 49 73 6 81 329 21057 21305 Lithodesmioides sp. mgcode 4 isolate Qingdao in China mitochondrion, complete genome blastn 595 156 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmioides Lithodesmioides sp. mgcode 4
7050566 7050566 PRJNA690592_S_NODE_67666_length_385_cov_3.730769_g66652_i0 PRJNA690592 67666 385 3.730769 14.36346065 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 292 1.99e-74   NTclustered gi|657012367|gb|KF302531.1| 2850 g66652 i0 88.477 19.9974025974026 243 26 63 2 7 248 152 393 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 7699 292 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
8323871 8323871 PRJNA690592_S_NODE_108407_length_317_cov_1.508197_g107393_i0 PRJNA690592 108407 317 1.508197 4.78098449 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 163 1.31e-35   NTclustered gi|657012511|gb|KF302595.1| 2850 g107393 i0 80.088 37.1640378548896 226 39 70 6 90 312 284 62 Phaeodactylum tricornutum clone C854 ubiquitin-ribosomal protein fusion S27a mRNA, partial cds blastn 11781 163 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
12150871 12150871 PRJNA690592_S_NODE_29150_length_559_cov_2.446502_g28151_i0 PRJNA690592 29150 559 2.446502 13.67594618 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 279 2.32e-70   NTclustered gi|657012465|gb|KF302574.1| 2850 g28151 i0 81.737 12.2969588550984 334 61 60 0 104 437 3 336 Phaeodactylum tricornutum clone C567 ribosomal protein mRNA, partial cds blastn 6874 279 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
13424826 13424826 PRJNA690592_S_NODE_14691_length_767_cov_3.971182_g13808_i0 PRJNA690592 14691 767 3.971182 30.45896594 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 337 1.9e-87   NTclustered gi|657012367|gb|KF302531.1| 2850 g13808 i0 85.321 2.97001303780965 327 46 43 2 442 767 393 68 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 2278 337 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
13933043 13933043 PRJNA690592_S_NODE_64111_length_395_cov_1.003106_g63097_i0 PRJNA690592 64111 395 1.003106 3.9622687 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.011   NTclustered gi|224001985|ref|XM_002290629.1| 296543 g63097 i0 94.286 0.40506329113924 35 2 9 0 258 292 357 323 Thalassiosira pseudonana CCMP1335 predicted protein mRNA blastn 160 54.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
15974783 15974783 PRJNA690592_S_NODE_85253_length_349_cov_5.775362_g84239_i0 PRJNA690592 85253 349 5.775362 20.15601338 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 331 3.7800000000000004e-86   NTclustered gi|657012367|gb|KF302531.1| 2850 g84239 i0 85.015 7.14040114613181 327 47 93 2 24 349 393 68 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 2492 331 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
17248978 17248978 PRJNA690592_S_NODE_16034_length_738_cov_4.427068_g15128_i0 PRJNA690592 16034 738 4.427068 32.67176184 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 601 5.849999999999999e-167   NTclustered gi|657012562|gb|KF302618.1| 2850 g15128 i0 82.553 15.719512195122 705 102 93 15 50 736 34 735 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 11601 601 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
17249220 17249220 PRJNA690592_S_NODE_19094_length_682_cov_2.609195_g18147_i0 PRJNA690592 19094 682 2.609195 17.7947099 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 246 2.91e-60   NTclustered gi|223997787|ref|XM_002288531.1| 296543 g18147 i0 77.913 10.0571847507331 412 80 60 8 1 411 1445 1846 Thalassiosira pseudonana CCMP1335 heat shock protein/chaperone (hsp70_4), mRNA blastn 6859 246 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
18523205 18523205 PRJNA690592_S_NODE_172935_length_259_cov_4.096774_g171921_i0 PRJNA690592 172935 259 4.096774 10.61064466 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 224 4.72e-54   NTclustered gi|219112330|ref|XM_002177881.1| 556484 g171921 i0 82.51 98.6833976833977 263 39 99 3 3 259 566 827 Phaeodactylum tricornutum CCAP 1055/1 predicted protein (atpB), mRNA blastn 25559 224 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
19798137 19798137 PRJNA690592_S_NODE_175796_length_257_cov_3.766304_g174782_i0 PRJNA690592 175796 257 3.766304 9.67940128 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 187 6.1399999999999984e-43   NTclustered gi|224010101|ref|XM_002293973.1| 296543 g174782 i0 83.981 76.5525291828794 206 21 80 2 1 206 194 1 Thalassiosira pseudonana CCMP1335 histone H3 partial mRNA blastn 19674 187 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
19798926 19798926 PRJNA690592_S_NODE_79776_length_359_cov_2.195804_g78762_i0 PRJNA690592 79776 359 2.195804 7.88293636 Nitzschia sp. IriIs04 1444690 SAR_Eukaryotes SAR_Eukaryotes 222 2.45e-53   NTclustered gi|944186118|dbj|LC052646.1| 1444690 g78762 i0 78.886 27.3621169916435 341 63 94 8 1 336 1639 1975 Nitzschia sp. IriIs04 hCdc48-1 mRNA for host cell division cycle protein, complete cds blastn 9823 222 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. IriIs04
22348864 22348864 PRJNA690592_S_NODE_216738_length_239_cov_3.240964_g215724_i0 PRJNA690592 216738 239 3.240964 7.74590396 Lithodesmium undulatum 59812 SAR_Eukaryotes SAR_Eukaryotes 189 1.5699999999999996e-43   NTclustered gi|2088237800|ref|NC_056903.1| 59812 g215724 i0 85.027 132.89539748954 187 27 78 1 53 238 6408 6594 Lithodesmium undulatum mitochondrion, complete genome blastn 31762 189 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmium Lithodesmium undulatum
24898428 24898428 PRJNA690592_S_NODE_96340_length_332_cov_3.115830_g95326_i0 PRJNA690592 96340 332 3.11583 10.3445556 Nitzschia alba 2858 SAR_Eukaryotes SAR_Eukaryotes 73.1 2.4e-8   NTclustered gi|1418576962|ref|NC_037729.1| 2858 g95326 i0 89.655 0.382530120481928 58 4 17 1 102 157 16367 16424 Nitzschia alba mitochondrion, complete genome blastn 127 73.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia alba

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