RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA690592" and tax_phylum = "Fornicata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fornicata · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA690592 · 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
670855 670855 PRJNA690592_S_NODE_123621_length_300_cov_6.964758_g122607_i0 PRJNA690592 123621 300 6.964758 20.894274 Ergobibamus cyprinoides 926446 Fornicata other_Eukaryota 355 1.9e-93   NTclustered gi|339759383|dbj|AB600304.1| 926446 g122607 i0 88 99.4533333333333 300 36 100 0 1 300 81 380 Ergobibamus cyprinoides gene for translation elongation factor 1 alpha, complete cds, strain: CL blastn 29836 355 1 Eukaryota Metamonada   Fornicata       Ergobibamus Ergobibamus cyprinoides
16481856 16481856 PRJNA690592_S_NODE_204713_length_244_cov_7.707602_g203699_i0 PRJNA690592 204713 244 7.707602 18.80654888 Carpediemonas 201152 Fornicata other_Eukaryota 268 2.01e-67   NTclustered gi|339759347|dbj|AB600286.1| 797132 g203699 i0 86.777 75.8360655737705 242 30 99 2 1 241 44 284 Carpediemonas sp. NY0171 gene for beta-tubulin, partial cds blastn 18504 270 0.992592592592593 Eukaryota Metamonada   Fornicata       Carpediemonas Carpediemonas sp. NY0171
18523648 18523648 PRJNA690592_S_NODE_31215_length_543_cov_1.470213_g30209_i0 PRJNA690592 31215 543 1.470213 7.98325659 Ergobibamus cyprinoides 926446 Fornicata other_Eukaryota 399 1.6499999999999998e-106   NTclustered gi|339759377|dbj|AB600301.1| 926446 g30209 i0 80.218 92.6077348066298 551 93 100 13 1 543 731 1273 Ergobibamus cyprinoides gene for beta-tubulin, partial cds, strain: CL blastn 50286 399 1 Eukaryota Metamonada   Fornicata       Ergobibamus Ergobibamus cyprinoides

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