RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA885753" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA885753 · 3 ✖

analysis 1

  • blastn · 3 ✖

tax_phylum 0

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
5965006 5965006 PRJNA885753_S_NODE_2165_length_307_cov_3.055556_g2147_i0 PRJNA885753 2165 307 3.055556 9.38055692 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 289359 SAR_Eukaryotes SAR_Eukaryotes 436 6.7699999999999986e-118   NTclustered gi|53829555|gb|AY582830.1| 289359 g2147 i0 99.174 29.5374592833876 242 2 79 0 1 242 997 1238 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds blastn 9068 436 1 Eukaryota Sar             Stramenopile sp. ex Nuclearia delicatula CCAP1552/1
15269275 15269275 PRJNA885753_S_NODE_3272_length_262_cov_1.650794_g3254_i0 PRJNA885753 3272 262 1.650794 4.32508028 Poterioochromonas 88166 SAR_Eukaryotes SAR_Eukaryotes 483 7.149999999999997e-132   NTclustered gi|323690576|gb|GU935635.1| 88167 g3254 i0 100 97.5381679389313 261 0 99 0 2 262 1601 1341 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 25555 483 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
17439863 17439863 PRJNA885753_S_NODE_1274_length_382_cov_2.226537_g1256_i0 PRJNA885753 1274 382 2.226537 8.50537134 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 289359 SAR_Eukaryotes SAR_Eukaryotes 701 0   NTclustered gi|53829555|gb|AY582830.1| 289359 g1256 i0 99.738 67.303664921466 382 1 100 0 1 382 1038 657 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds blastn 25710 701 1 Eukaryota Sar             Stramenopile sp. ex Nuclearia delicatula CCAP1552/1

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