RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA793147" and tax_phylum = "Nematoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nematoda · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA793147 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
16518895 16518895 PRJNA793147_P_NODE_56773_length_230_cov_0.894410_g56507_i0 PRJNA793147 56773 230 0.89441 2.057143 Metazoa 33208 Nematoda Nematoda 73.1 1.58e-8   NTclustered gi|2722344039|gb|PP729485.1| 6313 g56507 i0 93.617 21.5652173913043 47 3 20 0 1 47 5641 5595 Angiostrongylus cantonensis isolate Acan_SYD small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 4960 73.1 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Metastrongylidae Angiostrongylus Angiostrongylus cantonensis
19904616 19904616 PRJNA793147_P_NODE_39976_length_266_cov_1.700508_g39710_i0 PRJNA793147 39976 266 1.700508 4.52335128 Strongyloides ratti 34506 Nematoda Nematoda 189 1.78e-43   NTclustered gi|1376146183|ref|XM_024653652.1| 34506 g39710 i0 83.663 5.09774436090226 202 31 76 2 52 252 1562 1362 Strongyloides ratti ATP synthase subunit beta (SRAE_2000256800), partial mRNA blastn 1356 189 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Strongyloididae Strongyloides Strongyloides ratti
22893487 22893487 PRJNA793147_P_NODE_31638_length_297_cov_6.271930_g31372_i0 PRJNA793147 31638 297 6.27193 18.6276321 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 263 1.1700000000000001e-65   NTclustered gi|1376147859|ref|XM_024654603.1| 34506 g31372 i0 83.217 221.434343434343 286 48 96 0 1 286 1065 1350 Strongyloides ratti Polyubiquitin-C (SRAE_2000341300), partial mRNA blastn 65766 263 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Strongyloididae Strongyloides Strongyloides ratti

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