RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJEB1404" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB1404 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
3536320 3536320 PRJEB1404_S_NODE_2463_length_205_cov_3.976471_g2443_i0 PRJEB1404 2463 205 3.976471 8.15176555 Ascomycota 4890 Fungi Fungi 379 7.229999999999999e-101   NTclustered gi|767813157|gb|KP114602.1| 29917 g2443 i0 100 100 205 0 100 0 1 205 111 315 Cladosporium cladosporioides strain PF3 large subunit ribosomal RNA gene, partial sequence blastn 20500 379 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Cladosporiales Cladosporiaceae Cladosporium Cladosporium cladosporioides
15013559 15013559 PRJEB1404_P_NODE_312_length_448_cov_5.460432_g293_i0 PRJEB1404 312 448 5.460432 24.46273536 Dothideales 5014 Fungi Fungi 689 0   NTclustered gi|28200380|gb|AY185811.1| 5580 g293 i0 93.778 89.109375 450 25 100 3 1 448 944 496 Aureobasidium pullulans isolate 044.4 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence blastn 39921 689 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Dothideales Saccotheciaceae Aureobasidium Aureobasidium pullulans
17563561 17563561 PRJEB1404_S_NODE_1194_length_265_cov_15.921739_g1174_i0 PRJEB1404 1194 265 15.921739 42.19260835 Eukaryota 2759 Fungi Fungi 488 1.5599999999999996e-133   NTclustered gi|514829572|gb|KC771883.1| 4929 g1174 i0 100 82.9396226415094 264 0 99 0 1 264 299 36 Meyerozyma guilliermondii strain SNP3S 26S ribosomal RNA gene, partial sequence blastn 21979 488 1 Eukaryota Opisthokonta Fungi Ascomycota Pichiomycetes Serinales Debaryomycetaceae Meyerozyma Meyerozyma guilliermondii
20421771 20421771 PRJEB1404_S_NODE_2017_length_224_cov_5.613757_g1997_i0 PRJEB1404 2017 224 5.613757 12.57481568 Hanseniaspora uvarum 29833 Fungi Fungi 75 4.25e-9   NTclustered gi|974144812|gb|KT922772.1| 29833 g1997 i0 86.567 0.299107142857143 67 9 30 0 158 224 262 328 Hanseniaspora uvarum strain NS-O-49 26S ribosomal RNA gene, partial sequence blastn 67 75 1 Eukaryota Opisthokonta Fungi Ascomycota Saccharomycetes Saccharomycodales Saccharomycodaceae Hanseniaspora Hanseniaspora uvarum
23938074 23938074 PRJEB1404_S_NODE_919_length_286_cov_4.494024_g899_i0 PRJEB1404 919 286 4.494024 12.85290864 Eukaryota 2759 Fungi Fungi 507 4.69e-139   NTclustered gi|401670345|gb|JX408364.1| 341458 g899 i0 98.601 105 286 4 100 0 1 286 21 306 Uncultured Saccharomyces clone MEC_1919 26S ribosomal RNA gene, partial sequence blastn 30030 507 1 Eukaryota Opisthokonta Fungi Ascomycota Saccharomycetes Saccharomycetales Saccharomycetaceae   uncultured Saccharomyces

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