RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA453111" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA453111 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
28703047 28703047 PRJNA453111_P_NODE_5967_length_331_cov_0.968992_g5875_i0 PRJNA453111 5967 331 0.968992 3.20736352 Fungi 4751 Fungi Fungi 85.1 2.63e-18   NR XP_018735866.1 796027 g5875 i0 69.4 2.94561933534743 62 19 56.2 0 85 270 89 150 XP_018735866.1 Mbf1p [Sugiyamaella lignohabitans] diamond 975 85.9 0.990686845168801 Eukaryota Opisthokonta Fungi Ascomycota Dipodascomycetes Dipodascales Trichomonascaceae Sugiyamaella Sugiyamaella lignohabitans
30755907 30755907 PRJNA453111_P_NODE_8374_length_279_cov_1.495146_g8282_i0 PRJNA453111 8374 279 1.495146 4.17145734 Chaetomiaceae 35718 Fungi Fungi 136 2.73e-38   NR XP_003651487.1 578455 g8282 i0 66.7 50.247311827957 90 30 96.8 0 2 271 2 91 XP_003651487.1 uncharacterized protein THITE_2111869 [Thermothielavioides terrestris NRRL 8126] diamond 14019 136 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Sordariales Chaetomiaceae Thermothielavioides Thermothielavioides terrestris
31403466 31403466 PRJNA453111_P_NODE_11176_length_247_cov_1.321839_g11084_i0 PRJNA453111 11176 247 1.321839 3.26494233 Leptodontidium sp. MPI-SDFR-AT- 1920929 Fungi Fungi 42.7 0.0389   NR KAH6706202.1 2826080 g11084 i0 39.6 0.582995951417004 48 28 58.3 1 94 237 114 160 KAH6706202.1 hypothetical protein BKA61DRAFT_697790 [Leptodontidium sp. MPI-SDFR-AT-0119] diamond 144 42.7 1 Eukaryota Opisthokonta Fungi Ascomycota Leotiomycetes Helotiales Leptodontidiaceae Leptodontidium Leptodontidium sp. MPI-SDFR-AT-0119
32668192 32668192 PRJNA453111_P_NODE_4380_length_387_cov_1.305732_g4288_i0 PRJNA453111 4380 387 1.305732 5.05318284 Scytalidium sp. 3C 2487125 Fungi Fungi 101 4.500000000000001e-22   NR RQM05331.1 2487125 g4288 i0 51 2.26356589147287 96 47 74.4 0 2 289 819 914 RQM05331.1 hypothetical protein DH86_00001859 [Scytalidium sp. 3C] diamond 876 101 1 Eukaryota Opisthokonta Fungi Ascomycota Leotiomycetes     Scytalidium Scytalidium sp. 3C

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