RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA986547" 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

  • PRJNA986547 · 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
5100504 5100504 PRJNA986547_P_NODE_1144_length_416_cov_2.927114_g1062_i0 PRJNA986547 1144 416 2.927114 12.17679424 Deinococcus 1298 Bacteria Bacteria 702 0   NTclustered gi|470486828|ref|NR_076782.1| 502394 g1062 i0 97.122 186.802884615385 417 10 100 2 1 416 684 269 Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence blastn 77710 702 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus gobiensis
11177579 11177579 PRJNA986547_P_NODE_4089_length_289_cov_4.981481_g4007_i0 PRJNA986547 4089 289 4.981481 14.39648009 Oceanithermus profundus 187137 Bacteria Bacteria 154 7.13e-33   NTclustered gi|313151615|gb|CP002361.1| 670487 g4007 i0 86.014 48.0207612456747 143 20 49 0 72 214 1930373 1930515 Oceanithermus profundus DSM 14977, complete genome blastn 13878 154 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Oceanithermus Oceanithermus profundus
14026166 14026166 PRJNA986547_P_NODE_6911_length_262_cov_1.291005_g6829_i0 PRJNA986547 6911 262 1.291005 3.3824331 Thermus 270 Bacteria Bacteria 484 1.99e-132   NTclustered gi|982540758|gb|CP014142.1| 456163 g6829 i0 100 14.8473282442748 262 0 100 0 1 262 63691 63430 Thermus parvatiensis strain RL plasmid pTP143, complete sequence blastn 3890 484 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus parvatiensis
15001992 15001992 PRJNA986547_P_NODE_10432_length_245_cov_5.168605_g10350_i0 PRJNA986547 10432 245 5.168605 12.66308225 Deinococcus sp. AB2017081 3093660 Bacteria Bacteria 451 1.87e-122   NTclustered gi|2636768990|gb|CP140098.1| 3093660 g10350 i0 100 5.7265306122449 244 0 99 0 2 245 964509 964266 Deinococcus sp. AB2017081 chromosome, complete genome blastn 1403 451 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. AB2017081
17551969 17551969 PRJNA986547_P_NODE_11374_length_243_cov_0.905882_g11292_i0 PRJNA986547 11374 243 0.905882 2.20129326 Deinococcus sp. VB142 3112952 Bacteria Bacteria 283 7.14e-72   NTclustered gi|2706837832|gb|CP149782.1| 3112952 g11292 i0 87.854 3.04115226337449 247 22 100 6 1 243 1010458 1010700 Deinococcus sp. VB142 chromosome 1, complete sequence blastn 739 283 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB142
22651239 22651239 PRJNA986547_P_NODE_16338_length_206_cov_4.097744_g16256_i0 PRJNA986547 16338 206 4.097744 8.44135264 Thermus sp. NEB1569 2918899 Bacteria Bacteria 381 2.0199999999999994e-101   NTclustered gi|2199052145|gb|CP092445.1| 2918899 g16256 i0 100 4.99029126213592 206 0 100 0 1 206 897813 898018 Thermus sp. NEB1569 chromosome, complete genome blastn 1028 381 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp. NEB1569

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