RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA704949 · 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
5013744 5013744 PRJNA704949_P_NODE_1067264_length_250_cov_1.467662_g1051928_i0 PRJNA704949 1067264 250 1.467662 3.669155 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 97.1 1.03e-15   NTclustered gi|311700481|gb|HQ396813.1| 908856 g1051928 i0 79.577 19.76 142 23 55 4 15 152 696 557 Navicula sp. CCMP544 28S ribosomal RNA gene, partial sequence blastn 4940 97.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp. BOLD:AAO6949
17271200 17271200 PRJNA704949_P_NODE_1920314_length_169_cov_1.733333_g1904975_i0 PRJNA704949 1920314 169 1.733333 2.92933277 Nitzschia dissipatoides 3068544 SAR_Eukaryotes SAR_Eukaryotes 209 7.9100000000000005e-50   NTclustered gi|2721954655|gb|OR464351.1| 3068544 g1904975 i0 92.466 11.4378698224852 146 11 86 0 21 166 68411 68556 Nitzschia dissipatoides plastid, complete genome blastn 1933 209 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipatoides
22862806 22862806 PRJNA704949_P_NODE_1010538_length_258_cov_6.952153_g995203_i0 PRJNA704949 1010538 258 6.952153 17.93655474 Entomoneis 186042 SAR_Eukaryotes SAR_Eukaryotes 250 7.76e-62   NTclustered gi|2202538958|gb|OM891864.1| 216750 g995203 i0 86.726 9.72480620155039 226 28 87 2 13 237 4053 3829 Entomoneis cf. alata 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 2509 250 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis cf. alata
23646493 23646493 PRJNA704949_P_NODE_1932279_length_169_cov_0.866667_g1916940_i0 PRJNA704949 1932279 169 0.866667 1.46466723 Cocconeis placentula 431341 SAR_Eukaryotes SAR_Eukaryotes 104 3.84e-18   NTclustered gi|168145918|emb|AM710569.1| 431341 g1916940 i0 78.846 0.923076923076923 156 31 92 2 7 161 521 367 Cocconeis placentula partial 28S rRNA gene, strain AT-212Gel11 blastn 156 104 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeis Cocconeis placentula

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