RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA1144090" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 11 ✖

bioproject 1

  • PRJNA1144090 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
287336 287336 PRJNA1144090_P_NODE_46721_length_374_cov_1.956811_g46186_i0 PRJNA1144090 46721 374 1.956811 7.31847314 Deinococcus ficus 317577 Bacteria Bacteria 580 3.67e-161   NTclustered gi|1220362168|gb|CP021081.1| 317577 g46186 i0 94.667 217.465240641711 375 18 100 2 1 374 2341673 2341300 Deinococcus ficus strain CC-FR2-10, complete genome blastn 81332 580 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
287904 287904 PRJNA1144090_P_NODE_98801_length_251_cov_1.752809_g98266_i0 PRJNA1144090 98801 251 1.752809 4.39955059 Deinococcus ficus 317577 Bacteria Bacteria 316 7.31e-82   NTclustered gi|1220362168|gb|CP021081.1| 317577 g98266 i0 89.641 173.418326693227 251 23 99 2 3 251 2342829 2342580 Deinococcus ficus strain CC-FR2-10, complete genome blastn 43528 316 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
1562323 1562323 PRJNA1144090_P_NODE_7702_length_1026_cov_2.235047_g7338_i0 PRJNA1144090 7702 1026 2.235047 22.93158222 Thermus brockianus 56956 Bacteria Bacteria 54.7 0.029   NTclustered gi|1102955210|gb|CP016312.1| 56956 g7338 i0 92.5 0.0779727095516569 40 0 4 3 905 942 283075 283113 Thermus brockianus strain GE-1 chromosome, complete genome blastn 80 54.7 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus brockianus
4114031 4114031 PRJNA1144090_P_NODE_14324_length_737_cov_3.852410_g13848_i0 PRJNA1144090 14324 737 3.85241 28.3922617 Deinococcus aquaticus 328692 Bacteria Bacteria 1072 0   NTclustered gi|2444120906|gb|CP115165.1| 328692 g13848 i0 93.001 208.454545454545 743 38 100 11 1 737 715571 714837 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 153631 1072 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
5390939 5390939 PRJNA1144090_P_NODE_82565_length_277_cov_1.509804_g82030_i0 PRJNA1144090 82565 277 1.509804 4.18215708 Deinococcus grandis 57498 Bacteria Bacteria 462 9.929999999999999e-126   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g82030 i0 96.751 20.703971119133602 277 9 100 0 1 277 1852347 1852071 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 5735 462 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
8686084 8686084 PRJNA1144090_P_NODE_120427_length_226_cov_5.764706_g119892_i0 PRJNA1144090 120427 226 5.764706 13.02823556 Deinococcus 1298 Bacteria Bacteria 298 2.34e-76   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g119892 i0 91.071 153.938053097345 224 15 98 3 1 221 422864 423085 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 34790 298 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
11236263 11236263 PRJNA1144090_P_NODE_109949_length_244_cov_5.134503_g109414_i0 PRJNA1144090 109949 244 5.134503 12.52818732 Deinococcus 1298 Bacteria Bacteria 448 2.4e-121   NTclustered gi|1407440128|gb|MH504174.1| 328692 g109414 i0 99.59 101.454918032787 244 1 100 0 1 244 250 7 Deinococcus aquaticus strain P41 16S ribosomal RNA gene, partial sequence blastn 24755 448 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
11765583 11765583 PRJNA1144090_P_NODE_115950_length_241_cov_0.916667_g115415_i0 PRJNA1144090 115950 241 0.916667 2.20916747 Deinococcus wulumuqiensis 980427 Bacteria Bacteria 313 9.01e-81   NTclustered gi|1435316362|gb|CP031158.1| 980427 g115415 i0 90.041 23.8174273858921 241 24 100 0 1 241 2652021 2651781 Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome blastn 5740 313 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
16864021 16864021 PRJNA1144090_P_NODE_113094_length_243_cov_0.905882_g112559_i0 PRJNA1144090 113094 243 0.905882 2.20129326 Deinococcus yunweiensis 367282 Bacteria Bacteria 274 4.29e-69   NTclustered gi|2890653062|gb|CP177252.1| 367282 g112559 i0 87.347 12.5020576131687 245 23 99 5 3 243 1918863 1919103 Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome blastn 3038 274 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus yunweiensis
18138606 18138606 PRJNA1144090_P_NODE_102495_length_249_cov_0.875000_g101960_i0 PRJNA1144090 102495 249 0.875 2.17875 Deinococcus aquaticus 328692 Bacteria Bacteria 215 2.72e-51   NTclustered gi|2444120906|gb|CP115165.1| 328692 g101960 i0 95.522 2.48995983935743 134 6 54 0 116 249 188233 188366 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 620 215 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
20689361 20689361 PRJNA1144090_P_NODE_95057_length_257_cov_1.532609_g94522_i0 PRJNA1144090 95057 257 1.532609 3.93880513 Deinococcus sp. KNUC1210 2917691 Bacteria Bacteria 187 6.1399999999999984e-43   NTclustered gi|2197029603|gb|CP092190.1| 2917691 g94522 i0 85.556 23.7354085603113 180 24 70 2 14 192 1083198 1083020 Deinococcus sp. KNUC1210 chromosome, complete genome blastn 6100 187 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. KNUC1210

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