RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1115053", 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 · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1115053 · 6 ✖

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
6606821 6606821 PRJNA1115053_S_NODE_5286_length_752_cov_5.545839_g4082_i0 PRJNA1115053 5286 752 5.545839 41.70470928 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 394 1.0899999999999999e-104   NTclustered gi|657012562|gb|KF302618.1| 2850 g4082 i0 81.874 48.0558510638298 491 68 64 17 60 540 759 280 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 36138 394 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
12983743 12983743 PRJNA1115053_S_NODE_96831_length_262_cov_3.168950_g95014_i0 PRJNA1115053 96831 262 3.16895 8.302649 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 73.2 9.17e-13   NR KAI2509368.1 210448 g95014 i0 52.1 0.83587786259542 73 34 82.4 1 3 218 1343 1415 KAI2509368.1 hypothetical protein MHU86_5001 [Fragilaria crotonensis] diamond 219 73.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
18080893 18080893 PRJNA1115053_S_NODE_70115_length_297_cov_3.401575_g68298_i0 PRJNA1115053 70115 297 3.401575 10.10267775 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 84 1.32e-16   NR VEU37839.1 183589 g68298 i0 51.8 1.5959595959596 85 40 85.9 1 295 41 278 361 VEU37839.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 474 84.7 0.991735537190083 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
27920791 27920791 PRJNA1115053_S_NODE_57265_length_320_cov_5.559567_g55448_i0 PRJNA1115053 57265 320 5.559567 17.7906144 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 83.6 1.86e-16   NR VEU33732.1 183589 g55448 i0 59.7 0.58125 62 25 58.1 0 320 135 267 328 VEU33732.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 186 83.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
31259761 31259761 PRJNA1115053_S_NODE_108995_length_250_cov_3.091787_g107178_i0 PRJNA1115053 108995 250 3.091787 7.7294675 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 98.2 6.34e-24   NR CAB9509391.1 568900 g107178 i0 58.9 1.776 73 30 87.6 0 9 227 66 138 CAB9509391.1 (4S)-4-hydroxy-5-phosphonooxypentane-2,3-dione isomerase [Seminavis robusta] diamond 444 98.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32018917 32018917 PRJNA1115053_S_NODE_212458_length_189_cov_0.986301_g210641_i0 PRJNA1115053 212458 189 0.986301 1.86410889 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 50.8 2.49e-5   NR KAI2503821.1 210448 g210641 i0 54.3 2.87301587301587 46 20 73 1 47 184 43 87 KAI2503821.1 C-terminal domain of Poly(A)-binding protein [Fragilaria crotonensis] diamond 543 50.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis

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