RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA767802" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA767802 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
745222 745222 PRJNA767802_P_NODE_7721_length_272_cov_1.825112_g7648_i0 PRJNA767802 7721 272 1.825112 4.96430464 Ulnaria acus 1436140 SAR_Eukaryotes SAR_Eukaryotes 388 1.67e-103   NTclustered gi|283795033|ref|NC_013710.1| 1436140 g7648 i0 92.937 101.044117647059 269 16 99 2 4 271 29144 28878 Synedra acus mitochondrion, complete genome blastn 27484 388 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria acus
3296461 3296461 PRJNA767802_P_NODE_9463_length_235_cov_5.704301_g9390_i0 PRJNA767802 9463 235 5.704301 13.40510735 Ulnaria ulna 426669 SAR_Eukaryotes SAR_Eukaryotes 409 1.08e-109   NTclustered gi|2579686273|ref|NC_082433.1| 426669 g9390 i0 100 187.144680851064 221 0 94 0 14 234 66393 66173 Ulnaria ulna chloroplast, complete genome blastn 43979 409 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria ulna
4573430 4573430 PRJNA767802_P_NODE_12704_length_194_cov_1.993103_g12631_i0 PRJNA767802 12704 194 1.993103 3.86661982 Gomphonema parvulum 97227 SAR_Eukaryotes SAR_Eukaryotes 333 5.339999999999999e-87   NTclustered gi|2444483253|gb|OP718170.1| 97227 g12631 i0 97.449 102.015463917526 196 3 100 1 1 194 5454 5649 Gomphonema parvulum mitochondrion, complete genome blastn 19791 333 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
8398415 8398415 PRJNA767802_P_NODE_6667_length_303_cov_3.322835_g6594_i0 PRJNA767802 6667 303 3.322835 10.06819005 Ulnaria acus 1436140 SAR_Eukaryotes SAR_Eukaryotes 407 5.23e-109   NTclustered gi|283795033|ref|NC_013710.1| 1436140 g6594 i0 91.837 1.06930693069307 294 21 97 3 1 294 33306 33596 Synedra acus mitochondrion, complete genome blastn 324 407 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria acus
9673661 9673661 PRJNA767802_P_NODE_5188_length_359_cov_2.106452_g5115_i0 PRJNA767802 5188 359 2.106452 7.56216268 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 375 1.7799999999999997e-99   NTclustered gi|2862228864|gb|PQ645498.1| 2675857 g5115 i0 87.85 82.966573816156 321 38 89 1 20 339 3843 3523 Nitzschia reversa isolate AGSB0348 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 29785 375 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
19057803 19057803 PRJNA767802_P_NODE_11475_length_207_cov_4.196203_g11402_i0 PRJNA767802 11475 207 4.196203 8.68614021 Ulnaria 426668 SAR_Eukaryotes SAR_Eukaryotes 383 5.65e-102   NTclustered gi|187957792|emb|AM497727.1| 426669 g11402 i0 100 100 207 0 100 0 1 207 1621 1415 Synedra ulna 18S rRNA gene, strain AtFULN1 blastn 20700 383 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria ulna
22422507 22422507 PRJNA767802_P_NODE_5418_length_347_cov_2.295302_g5345_i0 PRJNA767802 5418 347 2.295302 7.96469794 Fragilaria sp. AT124.05b 432267 SAR_Eukaryotes SAR_Eukaryotes 477 4.5699999999999986e-130   NTclustered gi|168145912|emb|AM710562.1| 432267 g5345 i0 91.643 84.1095100864553 347 25 99 4 1 345 48 392 Fragilaria sp. AT-124.05b partial 28S rRNA gene, strain AT-124.05b blastn 29186 477 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria sp. AT124.05b

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