RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA937226" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 5 ✖

bioproject 1

  • PRJNA937226 · 5 ✖

analysis 1

  • blastn · 5 ✖

tax_clade 0

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
3807782 3807782 PRJNA937226_S_NODE_2523_length_392_cov_19.014577_g2396_i0 PRJNA937226 2523 392 19.014577 74.53714184 Deinococcus 1298 Bacteria Bacteria 680 0   NTclustered gi|730601855|gb|CP010028.1| 57497 g2396 i0 97.959 241.510204081633 392 8 100 0 1 392 69353 68962 Deinococcus swuensis strain DY59, complete genome blastn 94672 680 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiopugnans
8564882 8564882 PRJNA937226_S_NODE_18447_length_192_cov_1.216783_g18320_i0 PRJNA937226 18447 192 1.216783 2.33622336 Deinococcus rubellus 1889240 Bacteria Bacteria 78.7 2.73e-10   NTclustered gi|2304456361|gb|CP104213.1| 1889240 g18320 i0 84.81 2.05729166666667 79 11 41 1 2 79 319607 319685 Deinococcus rubellus strain Ant6 chromosome, complete genome blastn 395 78.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus rubellus
10184438 10184438 PRJNA937226_S_NODE_13268_length_218_cov_3.887574_g13141_i0 PRJNA937226 13268 218 3.887574 8.47491132 Deinococcus 1298 Bacteria Bacteria 381 2.1599999999999994e-101   NTclustered gi|730601855|gb|CP010028.1| 57497 g13141 i0 99.522 259.426605504587 209 1 96 0 10 218 70053 69845 Deinococcus swuensis strain DY59, complete genome blastn 56555 381 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiopugnans
20382084 20382084 PRJNA937226_S_NODE_23576_length_173_cov_3.548387_g23449_i0 PRJNA937226 23576 173 3.548387 6.13870951 Deinococcus 1298 Bacteria Bacteria 276 7.92e-70   NTclustered gi|730601855|gb|CP010028.1| 57497 g23449 i0 95.376 116.21387283237 173 8 100 0 1 173 68812 68984 Deinococcus swuensis strain DY59, complete genome blastn 20105 276 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiopugnans
21658017 21658017 PRJNA937226_S_NODE_1157_length_522_cov_4.541226_g1035_i0 PRJNA937226 1157 522 4.541226 23.70519972 Deinococcus 1298 Bacteria Bacteria 924 0   NTclustered gi|730601855|gb|CP010028.1| 57497 g1035 i0 98.659 273.823754789272 522 6 100 1 1 522 69858 69338 Deinococcus swuensis strain DY59, complete genome blastn 142936 924 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiopugnans

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