RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1065838" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1065838 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
2730701 2730701 PRJNA1065838_S_NODE_783_length_633_cov_1677.873288_g690_i0 PRJNA1065838 783 633 1677.873288 10620.93791304 uncultured Sandonidae 1938448 SAR_Eukaryotes SAR_Eukaryotes 121 1.7000000000000002e-22   NTclustered gi|1915674532|emb|LR868151.1| 1938448 g690 i0 97.183 108.862559241706 71 2 11 0 556 626 220 290 uncultured Sandonidae partial 18S rRNA gene blastn 68910 121 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae   uncultured Sandonidae
9940638 9940638 PRJNA1065838_S_NODE_2588_length_421_cov_12.814516_g2486_i0 PRJNA1065838 2588 421 12.814516 53.94911236 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.86e-10   NTclustered gi|1915673095|emb|LR866708.1| 1938448 g2486 i0 95.918 108.55106888361 49 2 12 0 373 421 219 267 uncultured Sandonidae partial 18S rRNA gene blastn 45700 80.5 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae   uncultured Sandonidae
12491735 12491735 PRJNA1065838_S_NODE_9350_length_253_cov_97.446078_g9248_i0 PRJNA1065838 9350 253 97.446078 246.53857734 root 1 Root_unresolved Root_unresolved 102 2.25e-17   NTclustered gi|1915673792|emb|LR867411.1| 1821250 g9248 i0 92.958 313.221343873518 71 3 41 2 5 74 290 221 uncultured Glissomonadida partial 18S rRNA gene blastn 79245 102 1 Eukaryota Sar   Cercozoa   Glissomonadida     uncultured Glissomonadida
18031868 18031868 PRJNA1065838_S_NODE_6155_length_299_cov_3935.128000_g6053_i0 PRJNA1065838 6155 299 3935.128 11766.03272 uncultured Sandonidae 1938448 SAR_Eukaryotes SAR_Eukaryotes 119 2.7e-22   NTclustered gi|1915674532|emb|LR868151.1| 1938448 g6053 i0 97.143 331.163879598662 70 2 37 0 223 292 221 290 uncultured Sandonidae partial 18S rRNA gene blastn 99018 119 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae   uncultured Sandonidae
20581206 20581206 PRJNA1065838_S_NODE_3497_length_377_cov_2986.810976_g3395_i0 PRJNA1065838 3497 377 2986.810976 11260.27737952 uncultured Sandonidae 1938448 SAR_Eukaryotes SAR_Eukaryotes 121 9.7e-23   NTclustered gi|1915674532|emb|LR868151.1| 1938448 g3395 i0 97.183 182.779840848806 71 2 19 0 300 370 220 290 uncultured Sandonidae partial 18S rRNA gene blastn 68908 121 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae   uncultured Sandonidae
22689665 22689665 PRJNA1065838_S_NODE_9458_length_252_cov_35.192118_g9356_i0 PRJNA1065838 9458 252 35.192118 88.68413736 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 78.7 3.77e-10   NTclustered gi|1915673095|emb|LR866708.1| 1938448 g9356 i0 95.833 185.325396825397 48 2 19 0 205 252 221 268 uncultured Sandonidae partial 18S rRNA gene blastn 46702 78.7 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae   uncultured Sandonidae

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