RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1242190", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA1242190 · 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
2901649 2901649 PRJNA1242190_S_NODE_10103_length_272_cov_1.065327_g10096_i0 PRJNA1242190 10103 272 1.065327 2.89768944 Minutocellus polymorphus 265543 SAR_Eukaryotes SAR_Eukaryotes 115 3.14e-21   NTclustered gi|2020303798|gb|MW417227.1| 265543 g10096 i0 78.378 1.29044117647059 185 34 67 6 14 195 8521 8702 Minutocellus polymorphus isolate CNS00217 mitochondrion, complete genome blastn 351 115 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Minutocellus Minutocellus polymorphus
29586062 29586062 PRJNA1242190_S_NODE_5090_length_363_cov_3.086207_g5083_i0 PRJNA1242190 5090 363 3.086207 11.20293141 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 88.6 5.81e-20   NR AID23573.1 2850 g5083 i0 77.6 1.21487603305785 49 11 40.5 0 362 216 63 111 AID23573.1 ribosomal protein, partial [Phaeodactylum tricornutum] diamond 441 88.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30028635 30028635 PRJNA1242190_S_NODE_5471_length_353_cov_1.546429_g5464_i0 PRJNA1242190 5471 353 1.546429 5.45889437 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 97.1 2.4299999999999998e-23   NR EJK48626.1 159749 g5464 i0 58.8 3.62039660056657 85 34 72.2 1 351 97 25 108 EJK48626.1 hypothetical protein THAOC_32560, partial [Thalassiosira oceanica] diamond 1278 97.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31559144 31559144 PRJNA1242190_S_NODE_10456_length_267_cov_2.010309_g10449_i0 PRJNA1242190 10456 267 2.010309 5.36752503 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 61.6 7.54e-10   NR AID23596.1 2850 g10449 i0 56.9 0.573033707865168 51 22 57.3 0 247 95 67 117 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 153 61.6 1 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);;