RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA994052" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA994052 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
2251570 2251570 PRJNA994052_P_NODE_30862_length_279_cov_90.140777_g29618_i0 PRJNA994052 30862 279 90.140777 251.49276783 Encyonema minutum 431330 SAR_Eukaryotes SAR_Eukaryotes 483 7.689999999999998e-132   NTclustered gi|168145881|emb|AM710515.1| 431330 g29618 i0 99.621 95.2974910394265 264 1 95 0 1 264 49 312 Encyonema minutum partial 28S rRNA gene, strain AT-137.13 blastn 26588 483 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Encyonema Encyonema minutum
3526665 3526665 PRJNA994052_P_NODE_11403_length_327_cov_31.460630_g10187_i0 PRJNA994052 11403 327 31.46063 102.8762601 Asterionellopsis glacialis 33640 SAR_Eukaryotes SAR_Eukaryotes 202 2.8899999999999996e-47   NTclustered gi|2202538972|gb|OM891878.1| 33640 g10187 i0 91.781 84.7584097859327 146 10 86 1 184 327 4369 4224 Asterionellopsis glacialis 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 27716 202 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionellopsis Asterionellopsis glacialis
16575901 16575901 PRJNA994052_P_NODE_80493_length_200_cov_26.102362_g79236_i0 PRJNA994052 80493 200 26.102362 52.204724 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 339 1.19e-88   NTclustered gi|168145917|emb|AM710568.1| 431397 g79236 i0 99.462 92.22 186 1 93 0 14 199 313 128 Navicula capitatoradiata partial 28S rRNA gene, strain AT-212Gel07 blastn 18444 339 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula capitatoradiata
17554451 17554451 PRJNA994052_P_NODE_51834_length_238_cov_33.024242_g50579_i0 PRJNA994052 51834 238 33.024242 78.59769596 Nitzschia cf. pusilla 185983 SAR_Eukaryotes SAR_Eukaryotes 185 2.0199999999999998e-42   NTclustered gi|1891520127|gb|MN696717.1| 185983 g50579 i0 97.248 85.1848739495798 109 3 92 0 1 109 590 698 Nitzschia cf. pusilla culture TCC:586 small subunit ribosomal RNA gene, partial sequence blastn 20274 185 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia cf. pusilla
19124516 19124516 PRJNA994052_P_NODE_56735_length_231_cov_5.607595_g55480_i0 PRJNA994052 56735 231 5.607595 12.95354445 Ulnaria 426668 SAR_Eukaryotes SAR_Eukaryotes 196 9.01e-46   NTclustered gi|187957792|emb|AM497727.1| 426669 g55480 i0 97.414 95.025974025974 116 2 95 1 116 231 962 848 Synedra ulna 18S rRNA gene, strain AtFULN1 blastn 21951 196 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria ulna
22653755 22653755 PRJNA994052_P_NODE_60658_length_225_cov_16.796053_g59402_i0 PRJNA994052 60658 225 16.796053 37.79111925 Brebissonia lanceolata 487518 SAR_Eukaryotes SAR_Eukaryotes 387 4.829999999999998e-103   NTclustered gi|168145930|emb|AM710582.1| 487518 g59402 i0 99.528 57.2133333333333 212 1 94 0 14 225 310 99 Cymbella lanceolata partial 28S rRNA gene, strain AT-194Gel07 blastn 12873 387 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Brebissonia Brebissonia lanceolata
24224935 24224935 PRJNA994052_P_NODE_78459_length_202_cov_57.883721_g77202_i0 PRJNA994052 78459 202 57.883721 116.92511642 Fragilariophyceae 33853 SAR_Eukaryotes SAR_Eukaryotes 152 1.6899999999999998e-32   NTclustered gi|215400920|gb|EU883365.1| 232514 g77202 i0 100 40.5940594059406 82 0 41 0 115 196 93 12 Tabularia tabulata strain 421D 5.8S ribosomal RNA gene and internal transcribed spacer 2, partial sequence blastn 8200 152 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Tabularia Tabularia tabulata

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