RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1245487" and tax_phylum = "Cryptomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cryptomycota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1245487 · 4 ✖

analysis 1

  • blastn · 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
1625736 1625736 PRJNA1245487_P_NODE_12862_length_322_cov_8.228916_g12524_i0 PRJNA1245487 12862 322 8.228916 26.49710952 Cryptomycota sp. 2012228 Fungi Fungi 412 1.1999999999999999e-110   NTclustered gi|2468791071|gb|OQ702935.1| 2012228 g12524 i0 89.783 100.819875776398 323 31 100 2 1 322 3381 3702 Cryptomycota sp. isolate PSC281 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 32464 412 1 Eukaryota Opisthokonta Fungi Cryptomycota         Cryptomycota sp.
11829643 11829643 PRJNA1245487_P_NODE_12990_length_320_cov_2.753036_g12652_i0 PRJNA1245487 12990 320 2.753036 8.8097152 Rozella sp. 1932610 Fungi Fungi 100 1.06e-16   NTclustered gi|2468791009|gb|OQ702919.1| 1932610 g12652 i0 93.939 21.2 66 4 21 0 201 266 4232 4297 Rozella sp. isolate PSC238 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 6784 100 1 Eukaryota Opisthokonta Fungi Cryptomycota       Rozella Rozella sp.
19477297 19477297 PRJNA1245487_P_NODE_6296_length_495_cov_21.518957_g5960_i0 PRJNA1245487 6296 495 21.518957 106.51883715 Cryptomycota sp. 2012228 Fungi Fungi 372 3.27e-98   NTclustered gi|2468790980|gb|OQ702912.1| 2012228 g5960 i0 80.769 84.6767676767677 494 79 99 13 1 488 3686 4169 Cryptomycota sp. isolate PSC211 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 41915 372 1 Eukaryota Opisthokonta Fungi Cryptomycota         Cryptomycota sp.
23303517 23303517 PRJNA1245487_P_NODE_21519_length_244_cov_0.912281_g21181_i0 PRJNA1245487 21519 244 0.912281 2.22596564 uncultured Cryptomycota 1130064 Fungi Fungi 135 2.1200000000000003e-27   NTclustered gi|387155805|emb|HE806178.1| 1130064 g21181 i0 88.393 44.4672131147541 112 13 46 0 133 244 1326 1437 Uncultured Cryptomycota partial 26S rRNA gene, clone Bcomple7 blastn 10850 135 1 Eukaryota Opisthokonta Fungi Cryptomycota         uncultured Cryptomycota

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