RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1022139" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA1022139 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
161572 161572 PRJNA1022139_P_NODE_1981_length_867_cov_14.405542_g1902_i0 PRJNA1022139 1981 867 14.405542 124.89604914 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 416 2.69e-111   NTclustered gi|657012367|gb|KF302531.1| 2850 g1902 i0 87.363 61.4844290657439 364 44 42 2 275 637 385 23 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 53307 416 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
10365013 10365013 PRJNA1022139_P_NODE_8609_length_450_cov_1.729443_g8504_i0 PRJNA1022139 8609 450 1.729443 7.7824935 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 281 5.11e-71   NTclustered gi|223997787|ref|XM_002288531.1| 296543 g8504 i0 78.242 6.45555555555556 455 87 99 12 1 449 103 551 Thalassiosira pseudonana CCMP1335 heat shock protein/chaperone (hsp70_4), mRNA blastn 2905 281 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
14190277 14190277 PRJNA1022139_P_NODE_25792_length_282_cov_1.282297_g25687_i0 PRJNA1022139 25792 282 1.282297 3.61607754 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 219 2.4199999999999993e-52   NTclustered gi|657012566|gb|KF302620.1| 2850 g25687 i0 84.783 66.8368794326241 230 21 79 10 57 280 759 538 Phaeodactylum tricornutum clone C821 hypothetical protein mRNA, complete cds blastn 18848 219 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);;