RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA474911" 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

  • PRJNA474911 · 5 ✖

analysis 1

  • diamond · 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
4274602 4274602 PRJNA474911_P_NODE_5924_length_231_cov_1.223529_g5797_i0 PRJNA474911 5924 231 1.223529 2.82635199 [Torrubiella] hemipterigena 1531966 Fungi Fungi 140 1.34e-36   NR CEJ84675.1 1531966 g5797 i0 90.8 0.987012987012987 76 7 98.7 0 230 3 774 849 CEJ84675.1 Putative PDZ domain-containing protein [[Torrubiella] hemipterigena] diamond 228 140 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Clavicipitaceae   [Torrubiella] hemipterigena
26696318 26696318 PRJNA474911_P_NODE_7341_length_207_cov_0.876712_g7214_i0 PRJNA474911 7341 207 0.876712 1.81479384 Cordyceps javanica 43265 Fungi Fungi 130 4.39e-33   NR TQW02705.1 43265 g7214 i0 84.1 1 69 11 100 0 1 207 1135 1203 TQW02705.1 polyketide synthase [Cordyceps javanica] diamond 207 130 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Cordycipitaceae Cordyceps Cordyceps javanica
29160758 29160758 PRJNA474911_P_NODE_6549_length_217_cov_1.230769_g6422_i0 PRJNA474911 6549 217 1.230769 2.67076873 Penicillium nalgiovense 60175 Fungi Fungi 144 7.869999999999999e-43   NR OQE78461.1 60175 g6422 i0 100 0.857142857142857 62 0 85.7 0 1 186 52 113 OQE78461.1 hypothetical protein PENNAL_c0056G11554, partial [Penicillium nalgiovense] diamond 186 144 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Penicillium Penicillium nalgiovense
30013192 30013192 PRJNA474911_P_NODE_7791_length_204_cov_0.895105_g7664_i0 PRJNA474911 7791 204 0.895105 1.8260142 Rutstroemia sp. NJR-2 2011926 Fungi Fungi 89 3.12e-19   NR PQE12923.1 2070414 g7664 i0 87.8 1.44117647058824 49 6 72.1 0 203 57 4 52 PQE12923.1 phosphatase PP2A regulatory subunit A protein [Rutstroemia sp. NJR-2017a BBW] diamond 294 89 1 Eukaryota Opisthokonta Fungi Ascomycota Leotiomycetes Helotiales Rutstroemiaceae Rutstroemia Rutstroemia sp. NJR-2017a BBW
31276825 31276825 PRJNA474911_P_NODE_7375_length_207_cov_0.876712_g7248_i0 PRJNA474911 7375 207 0.876712 1.81479384 Lecanicillium sp. MT-2 1756136 Fungi Fungi 129 1.14e-34   NR KAK3192171.1 1964301 g7248 i0 89.9 1 69 7 100 0 1 207 142 210 KAK3192171.1 hypothetical protein K4F52_001800 [Lecanicillium sp. MT-2017a] diamond 207 129 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Cordycipitaceae Lecanicillium Lecanicillium sp. MT-2017a

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