RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA560932" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA560932 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
3095857 3095857 PRJNA560932_P_NODE_7503_length_632_cov_1.509839_g7151_i0 PRJNA560932 7503 632 1.509839 9.54218248 Asterionellopsis glacialis 33640 SAR_Eukaryotes SAR_Eukaryotes 366 1.97e-96   NTclustered gi|225685848|dbj|AB461922.1| 33640 g7151 i0 78.114 26.4098101265823 594 119 93 11 5 592 15 603 Asterionellopsis glacialis MAT mRNA for methionine S-adenosyl transferase, complete cds blastn 16691 366 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionellopsis Asterionellopsis glacialis
4372191 4372191 PRJNA560932_P_NODE_48444_length_262_cov_1.222222_g48088_i0 PRJNA560932 48444 262 1.222222 3.20222164 Helicotheca tamesis 374047 SAR_Eukaryotes SAR_Eukaryotes 104 6.51e-18   NTclustered gi|2248495790|ref|NC_063455.1| 374047 g48088 i0 81.159 7.68702290076336 138 18 50 6 1 132 5408 5273 Helicotheca tamesis isolate Qingdao in China mitochondrion, complete genome blastn 2014 104 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Helicotheca Helicotheca tamesis
15847689 15847689 PRJNA560932_P_NODE_58493_length_247_cov_0.885057_g58137_i0 PRJNA560932 58493 247 0.885057 2.18609079 Actinocyclus sp. mgcode 4 2914904 SAR_Eukaryotes SAR_Eukaryotes 73.1 1.71e-8   NTclustered gi|2074156125|gb|MW413902.1| 2914904 g58137 i0 85.714 18.7854251012146 70 8 28 2 77 144 12378 12309 Actinocyclus sp. mgcode 4 mitochondrion, complete genome blastn 4640 73.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Hemidiscaceae Actinocyclus Actinocyclus sp. mgcode 4
17122187 17122187 PRJNA560932_P_NODE_15014_length_452_cov_2.031662_g14659_i0 PRJNA560932 15014 452 2.031662 9.18311224 Attheya longicornis 451786 SAR_Eukaryotes SAR_Eukaryotes 193 2.470000000000001e-44   NTclustered gi|2046217437|gb|MW729336.1| 451786 g14659 i0 77.465 35.1991150442478 355 59 76 16 1 342 38680 38334 Attheya longicornis mitochondrion, complete genome blastn 15910 193 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Attheyaceae Attheya Attheya longicornis

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