RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA796753" 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

  • PRJNA796753 · 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
8433859 8433859 PRJNA796753_P_NODE_41547_length_249_cov_6.664773_g41235_i0 PRJNA796753 41547 249 6.664773 16.59528477 Chaetoceros laevisporus 1937691 SAR_Eukaryotes SAR_Eukaryotes 104 6.13e-18   NTclustered gi|2043890831|gb|MZ267686.1| 1937691 g41235 i0 81.955 62.8112449799197 133 14 71 4 1 132 2375 2498 Chaetoceros laevisporus isolate CNS00396 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 15640 104 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros laevisporus
8433989 8433989 PRJNA796753_P_NODE_7907_length_486_cov_1.491525_g7596_i0 PRJNA796753 7907 486 1.491525 7.2488115 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 335 4.2e-87   NTclustered gi|219110320|ref|XM_002176876.1| 556484 g7596 i0 79.218 34.3539094650206 486 97 99 4 3 486 1075 592 Phaeodactylum tricornutum CCAP 1055/1 predicted protein mRNA blastn 16696 335 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
18632124 18632124 PRJNA796753_P_NODE_24575_length_302_cov_3.353712_g24263_i0 PRJNA796753 24575 302 3.353712 10.12821024 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 119 2.73e-22   NTclustered gi|223994226|ref|XM_002286761.1| 296543 g24263 i0 93.671 1.74834437086093 79 5 26 0 7 85 1 79 Thalassiosira pseudonana CCMP1335 RS30, ribosomal protein 30 40S small ribosomal subunit (RS30), partial mRNA blastn 528 119 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
19907385 19907385 PRJNA796753_P_NODE_11876_length_406_cov_1.129129_g11564_i0 PRJNA796753 11876 406 1.129129 4.58426374 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 381 4.369999999999999e-101   NTclustered gi|657012367|gb|KF302531.1| 2850 g11564 i0 87.926 3.87684729064039 323 39 80 0 84 406 390 68 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 1574 381 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);;