RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA564013 · 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
10753225 10753225 PRJNA564013_P_NODE_20429_length_815_cov_11.888594_g18159_i0 PRJNA564013 20429 815 11.888594 96.8920411 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 989 0   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g18159 i0 89.48 95.1128834355828 789 74 96 8 22 806 4135 4918 Naviculales sp. strain SZCZO2114 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 77517 989 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
24775376 24775376 PRJNA564013_P_NODE_218440_length_289_cov_2.258772_g215589_i0 PRJNA564013 218440 289 2.258772 6.52785108 Trieres regia 1335017 SAR_Eukaryotes SAR_Eukaryotes 122 2.0099999999999994e-23   NTclustered gi|2055417059|ref|NC_056371.1| 1335017 g215589 i0 88.889 12.4463667820069 99 11 34 0 2 100 12230 12328 Odontella regia mitochondrion, complete genome blastn 3597 122 1 Eukaryota Sar   Bacillariophyta Mediophyceae Eupodiscales Parodontellaceae Trieres Trieres regia
25358904 25358904 PRJNA564013_P_NODE_295060_length_228_cov_8.083832_g292208_i0 PRJNA564013 295060 228 8.083832 18.43113696 Phaeodactylum 2849 SAR_Eukaryotes SAR_Eukaryotes 139 1.52e-28   NTclustered gi|6979057|gb|AF063803.1|AF063803 2850 g292208 i0 87.5 4.73684210526316 120 15 53 0 101 220 1537 1418 Phaeodactylum tricornutum glyceraldehyde-3-phosphate dehydrogenase precursor (GapC1) gene, complete cds blastn 1080 139 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);;