RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB11523" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 8 ✖

tax_clade 1

bioproject 1

  • PRJEB11523 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
13739 13739 PRJEB11523_P_NODE_5201_length_205_cov_1.211538_g5123_i0 PRJEB11523 5201 205 1.211538 2.4836529 Nitzschia sp. pyKryTriq1 3034176 SAR_Eukaryotes SAR_Eukaryotes 292 9.69e-75   NTclustered gi|2524387093|emb|OY101132.1| 3034176 g5123 i0 95.604 93.5658536585366 182 8 89 0 1 182 33637 33818 Nitzschia sp. pyKryTriq1 genome assembly, organelle: mitochondrion blastn 19181 292 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. pyKryTriq1
982486 982486 PRJEB11523_P_NODE_4541_length_221_cov_24.360465_g4463_i0 PRJEB11523 4541 221 24.360465 53.83662765 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 363 7.97e-96   NTclustered gi|1891520243|gb|MN696747.1| 185983 g4463 i0 99.01 91.4027149321267 202 2 91 0 20 221 114 315 Nitzschia cf. pusilla culture TCC:586 large subunit ribosomal RNA gene, partial sequence blastn 20200 363 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia cf. pusilla
8940732 8940732 PRJEB11523_P_NODE_4308_length_229_cov_7.683333_g4230_i0 PRJEB11523 4308 229 7.683333 17.59483257 Lineaperpetua lacustris 2923095 SAR_Eukaryotes SAR_Eukaryotes 315 2.36e-81   NTclustered gi|2728413486|gb|OR666654.1| 2923095 g4230 i0 94.608 174.681222707424 204 10 89 1 26 229 68928 69130 Thalassiosira lacustris strain SXU-149 chloroplast, complete genome blastn 40002 315 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Lineaperpetua Lineaperpetua lacustris
10216541 10216541 PRJEB11523_P_NODE_6329_length_183_cov_5.470149_g6251_i0 PRJEB11523 6329 183 5.470149 10.01037267 Encyonema minutum 431330 SAR_Eukaryotes SAR_Eukaryotes 322 1.08e-83   NTclustered gi|168145881|emb|AM710515.1| 431330 g6251 i0 100 98.2131147540984 174 0 95 0 10 183 128 301 Encyonema minutum partial 28S rRNA gene, strain AT-137.13 blastn 17973 322 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Encyonema Encyonema minutum
11491716 11491716 PRJEB11523_P_NODE_2850_length_301_cov_2.369048_g2772_i0 PRJEB11523 2850 301 2.369048 7.13083448 Ulnaria acus 1436140 SAR_Eukaryotes SAR_Eukaryotes 359 1.4699999999999998e-94   NTclustered gi|283795033|ref|NC_013710.1| 1436140 g2772 i0 89.492 1.0797342192691 295 15 95 12 17 301 33469 33181 Synedra acus mitochondrion, complete genome blastn 325 359 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria acus
17560403 17560403 PRJEB11523_P_NODE_5274_length_203_cov_3.753247_g5196_i0 PRJEB11523 5274 203 3.753247 7.61909141 Fragilariophyceae 33853 SAR_Eukaryotes SAR_Eukaryotes 342 9.369999999999999e-90   NTclustered gi|2579686273|ref|NC_082433.1| 426669 g5196 i0 99.468 184.266009852217 188 1 93 0 1 188 66141 65954 Ulnaria ulna chloroplast, complete genome blastn 37406 342 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria ulna
20414412 20414412 PRJEB11523_P_NODE_8937_length_156_cov_2.523364_g8859_i0 PRJEB11523 8937 156 2.523364 3.93644784 Sundstroemia setigera 3005 SAR_Eukaryotes SAR_Eukaryotes 163 5.69e-36   NTclustered gi|2172620428|ref|NC_059919.1| 3005 g8859 i0 89.231 82.4551282051282 130 14 83 0 27 156 21901 21772 Rhizosolenia setigera isolate CNS00456 mitochondrion, complete genome blastn 12863 163 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Sundstroemia Sundstroemia setigera
22659525 22659525 PRJEB11523_P_NODE_5598_length_196_cov_14.292517_g5520_i0 PRJEB11523 5598 196 14.292517 28.01333332 root 1 Root_unresolved Root_unresolved 254 4.33e-63   NTclustered gi|1803023461|gb|MN937452.1| 2850 g5520 i0 98.611 92.6530612244898 144 0 72 1 23 164 69260 69403 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 18160 255 0.996078431372549 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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