RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA380660" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA380660 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
4902183 4902183 PRJNA380660_P_NODE_7024_length_276_cov_15.834008_g6624_i0 PRJNA380660 7024 276 15.834008 43.70186208 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 414 2.81e-111   NTclustered gi|98978883|gb|DQ512402.1| 29205 g6624 i0 96.109 92.5869565217391 257 5 93 2 20 276 115 366 Cyclotella menegheniana strain F8 large subunit ribosomal RNA gene, partial sequence blastn 25554 414 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
6779961 6779961 PRJNA380660_P_NODE_10046_length_206_cov_333.847458_g9646_i0 PRJNA380660 10046 206 333.847458 687.72576348 Attheya ussurensis 451787 SAR_Eukaryotes SAR_Eukaryotes 161 2.87e-35   NTclustered gi|1569270389|gb|MH367507.1| 451787 g9646 i0 92.793 54.5873786407767 111 8 54 0 53 163 386 496 Attheya ussurensis strain MBRU_AU-01 28S ribosomal RNA gene, partial sequence blastn 11245 161 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Attheyaceae Attheya Attheya ussurensis
6779965 6779965 PRJNA380660_P_NODE_12246_length_163_cov_7.716418_g11846_i0 PRJNA380660 12246 163 7.716418 12.57776134 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 292 7.35e-75   NTclustered gi|1169296926|gb|KY364696.1| 29205 g11846 i0 99.379 90.4355828220859 161 1 99 0 1 161 5609 5769 Cyclotella meneghiniana 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 14741 292 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
7452207 7452207 PRJNA380660_P_NODE_8266_length_241_cov_3.179245_g7866_i0 PRJNA380660 8266 241 3.179245 7.66198045 Stephanocyclus 2818153 SAR_Eukaryotes SAR_Eukaryotes 446 8.519999999999999e-121   NTclustered gi|40557157|gb|AY496213.1| 29205 g7866 i0 100 100 241 0 100 0 1 241 147 387 Cyclotella meneghiniana strain G17W8 18S ribosomal RNA gene, partial sequence blastn 24100 446 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
8726933 8726933 PRJNA380660_P_NODE_12727_length_154_cov_1.840000_g12327_i0 PRJNA380660 12727 154 1.84 2.8336 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 257 2.5e-64   NTclustered gi|2429803054|ref|NC_069610.1| 216927 g12327 i0 99.296 181.779220779221 142 1 92 0 12 153 52066 51925 Paralia sulcata chloroplast, complete genome blastn 27994 257 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Paraliales Paraliaceae Paralia Paralia sulcata
10002341 10002341 PRJNA380660_P_NODE_10448_length_200_cov_1.812865_g10048_i0 PRJNA380660 10448 200 1.812865 3.62573 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 303 4.34e-78   NTclustered gi|2589355395|ref|NC_077461.1| 29204 g10048 i0 95.288 191.46 191 9 96 0 10 200 69740 69550 Cyclotella cryptica chloroplast, complete genome blastn 38292 303 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
14430980 14430980 PRJNA380660_P_NODE_172_length_1966_cov_164.566340_g41_i2 PRJNA380660 172 1966 164.56634 3235.3742444 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 316 6.52e-81   NTclustered gi|2074156200|gb|MW413905.1| 216802 g41 i2 75.099 65.6454730417091 755 149 78 29 1233 1965 23865 24602 Guinardia delicatula mitochondrion, complete genome blastn 129059 316 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
16376715 16376715 PRJNA380660_P_NODE_3653_length_429_cov_555.505000_g3265_i0 PRJNA380660 3653 429 555.505 2383.11645 Ulnaria 426668 SAR_Eukaryotes SAR_Eukaryotes 654 0   NTclustered gi|2199610541|gb|OM837375.1| 426669 g3265 i0 95.588 87.4522144522144 408 18 95 0 3 410 599 1006 Ulnaria ulna strain XZ4.7 small subunit ribosomal RNA gene, partial sequence blastn 37517 654 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria ulna
16376721 16376721 PRJNA380660_P_NODE_7313_length_267_cov_12.878151_g6913_i0 PRJNA380660 7313 267 12.878151 34.38466317 Fragilariophyceae 33853 SAR_Eukaryotes SAR_Eukaryotes 311 3.65e-80   NTclustered gi|18698484|gb|AF417685.1| 186020 g6913 i0 88.346 92.4943820224719 266 21 99 7 4 267 93 350 Synedropsis hyperboreoides strain 5-15 large subunit ribosomal RNA gene, partial sequence blastn 24696 311 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Synedropsis Synedropsis hyperboreoides
20803747 20803747 PRJNA380660_P_NODE_9477_length_216_cov_2.614973_g9077_i0 PRJNA380660 9477 216 2.614973 5.64834168 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 375 9.96e-100   NTclustered gi|1169296926|gb|KY364696.1| 29205 g9077 i0 99.048 94.2638888888889 210 1 97 1 2 210 4154 4363 Cyclotella meneghiniana 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 20361 375 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus

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