RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax_phylum = "Zoopagomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Zoopagomycota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA312899 · 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
379492 379492 PRJNA312899_P_NODE_38761_length_288_cov_1.707113_g38319_i0 PRJNA312899 38761 288 1.707113 4.91648544 Conidiobolus lichenicola 1167816 Fungi Fungi 143 1.54e-29   NTclustered gi|2127863481|ref|NC_058637.1| 1167816 g38319 i0 80.711 6.74305555555556 197 26 64 10 3 187 32374 32570 Conidiobolus lichenicola culture ATCC:16200 mitochondrion, complete genome blastn 1942 143 1 Eukaryota Opisthokonta Fungi Zoopagomycota Entomophthoromycetes Entomophthorales Ancylistaceae Conidiobolus Conidiobolus lichenicola
6757656 6757656 PRJNA312899_P_NODE_67046_length_200_cov_3.370861_g66604_i0 PRJNA312899 67046 200 3.370861 6.741722 Piptocephalis corymbifera 78917 Fungi Fungi 71.3 4.8e-8   NTclustered gi|311235601|ref|NG_027616.1| 78917 g66604 i0 88.333 2.75 60 6 30 1 69 127 3175 3234 Piptocephalis corymbifera NRRL 2385 28S rRNA gene, partial sequence; from reference material blastn 550 71.3 1 Eukaryota Opisthokonta Fungi Zoopagomycota Zoopagomycetes Zoopagales Piptocephalidaceae Piptocephalis Piptocephalis corymbifera
16956322 16956322 PRJNA312899_P_NODE_10334_length_588_cov_16.476809_g9923_i0 PRJNA312899 10334 588 16.476809 96.88363692 Piptocephalis corymbifera 78917 Fungi Fungi 246 2.48e-60   NTclustered gi|311235601|ref|NG_027616.1| 78917 g9923 i0 78.465 40.2312925170068 404 68 68 12 140 541 2114 1728 Piptocephalis corymbifera NRRL 2385 28S rRNA gene, partial sequence; from reference material blastn 23656 246 1 Eukaryota Opisthokonta Fungi Zoopagomycota Zoopagomycetes Zoopagales Piptocephalidaceae Piptocephalis Piptocephalis corymbifera
23332227 23332227 PRJNA312899_P_NODE_78279_length_181_cov_2.318182_g77837_i0 PRJNA312899 78279 181 2.318182 4.19590942 Pandora neoaphidis 76017 Fungi Fungi 335 1.36e-87   NTclustered gi|166812027|gb|EU267193.1| 76017 g77837 i0 100 99.0331491712707 181 0 100 0 1 181 373 193 Pandora neoaphidis ARSEF 7939 pn7939-3 MboI- pattern 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 25S ribosomal RNA gene, partial sequence blastn 17925 335 1 Eukaryota Opisthokonta Fungi Zoopagomycota Entomophthoromycetes Entomophthorales Entomophthoraceae Pandora Pandora neoaphidis
24604955 24604955 PRJNA312899_P_NODE_103720_length_155_cov_3.556604_g103278_i0 PRJNA312899 103720 155 3.556604 5.5127362 Zoophagus sp. CGW-2021a 2876187 Fungi Fungi 276 6.95e-70   NTclustered gi|2095779121|gb|OK156471.1| 2876187 g103278 i0 98.71 47.8967741935484 155 2 100 0 1 155 547 701 Zoophagus sp. CGW-2021a strain Tk1 small subunit ribosomal RNA gene, partial sequence blastn 7424 276 1 Eukaryota Opisthokonta Fungi Zoopagomycota Zoopagomycetes Zoopagales Zoopagaceae Zoophagus Zoophagus sp. CGW-2021a

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