RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA613025" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 6 ✖

bioproject 1

  • PRJNA613025 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
2424139 2424139 PRJNA613025_S_NODE_33562_length_161_cov_1.651786_g33408_i0 PRJNA613025 33562 161 1.651786 2.65937546 root 1 Root_unresolved Root_unresolved 298 1.56e-76   NTclustered gi|1336609736|gb|MG860167.1| 47478 g33408 i0 100 102.062111801242 161 0 100 0 1 161 194 34 Deinococcus sp. strain LA6P7 16S ribosomal RNA gene, partial sequence blastn 16432 298 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
5695204 5695204 PRJNA613025_S_NODE_16545_length_256_cov_1.637681_g16391_i0 PRJNA613025 16545 256 1.637681 4.19246336 Deinococcus sp. NW-56 2080419 Bacteria Bacteria 468 1.95e-127   NTclustered gi|1339790003|gb|CP026516.1| 2080419 g16391 i0 99.609 145.1796875 256 1 100 0 1 256 2418167 2418422 Deinococcus sp. NW-56 chromosome, complete genome blastn 37166 468 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. NW-56
6970530 6970530 PRJNA613025_S_NODE_6686_length_550_cov_2.201597_g6536_i0 PRJNA613025 6686 550 2.201597 12.1087835 Deinococcus sp. NW-56 2080419 Bacteria Bacteria 955 0   NTclustered gi|1339790003|gb|CP026516.1| 2080419 g6536 i0 98.004 222.607272727273 551 9 100 2 1 550 2417219 2417768 Deinococcus sp. NW-56 chromosome, complete genome blastn 122434 955 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. NW-56
13345976 13345976 PRJNA613025_S_NODE_26931_length_179_cov_1.569231_g26777_i0 PRJNA613025 26931 179 1.569231 2.80892349 Deinococcus sp. NW-56 2080419 Bacteria Bacteria 329 6.26e-86   NTclustered gi|1339790003|gb|CP026516.1| 2080419 g26777 i0 100 196.508379888268 178 0 99 0 1 178 544399 544576 Deinococcus sp. NW-56 chromosome, complete genome blastn 35175 329 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. NW-56
21550663 21550663 PRJNA613025_S_NODE_21677_length_207_cov_3.594937_g21523_i0 PRJNA613025 21677 207 3.594937 7.44151959 Deinococcus 1298 Bacteria Bacteria 383 5.65e-102   NTclustered gi|1562202923|gb|MK446833.1| 47478 g21523 i0 100 105.95652173913 207 0 100 0 1 207 484 690 Deinococcus sp. strain NW-56 16S ribosomal RNA gene, partial sequence blastn 21933 383 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
22826150 22826150 PRJNA613025_S_NODE_25578_length_185_cov_4.250000_g25424_i0 PRJNA613025 25578 185 4.25 7.8625 Deinococcus 1298 Bacteria Bacteria 342 8.369999999999999e-90   NTclustered gi|1220362168|gb|CP021081.1| 317577 g25424 i0 100 297.367567567568 185 0 100 0 1 185 2341178 2341362 Deinococcus ficus strain CC-FR2-10, complete genome blastn 55013 342 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus

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