RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA745553" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA745553 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
1198589 1198589 PRJNA745553_S_NODE_16961_length_300_cov_1.356828_g16766_i0 PRJNA745553 16961 300 1.356828 4.070484 Desulfobulbus 893 Bacteria Bacteria 499 8.29e-137   NTclustered gi|470487339|ref|NR_076814.1| 894 g16766 i0 96.667 216.113333333333 300 10 100 0 1 300 612 911 Desulfobulbus propionicus strain 1pr3 23S ribosomal RNA gene, complete sequence blastn 64834 499 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus Desulfobulbus propionicus
2000366 2000366 PRJNA745553_S_NODE_28342_length_230_cov_4.509554_g28147_i0 PRJNA745553 28342 230 4.509554 10.3719742 uncultured Desulfobulbus sp. 239745 Bacteria Bacteria 361 3e-95   NTclustered gi|2621704320|emb|OY760916.1| 239745 g28147 i0 96.364 276.752173913043 220 7 95 1 12 230 395387 395168 MAG: uncultured Desulfobulbus sp. isolate 7a05128d-adad-4d17-beb6-ff3d102eb21b genome assembly, chromosome: 1 blastn 63653 361 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus uncultured Desulfobulbus sp.
4552698 4552698 PRJNA745553_S_NODE_20244_length_275_cov_1.524752_g20049_i0 PRJNA745553 20244 275 1.524752 4.193068 Desulfovibrio sp. 86 2666132 Bacteria Bacteria 303 6.32e-78   NTclustered gi|1862956133|emb|LR738849.1| 2666132 g20049 i0 87.218 10.8436363636364 266 34 97 0 1 266 1483812 1484077 Desulfovibrio sp. 86 genome assembly, chromosome: DESU86 blastn 2982 303 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp. 86
5026874 5026874 PRJNA745553_S_NODE_18004_length_291_cov_1.733945_g17809_i0 PRJNA745553 18004 291 1.733945 5.04577995 Desulfovibrio 872 Bacteria Bacteria 185 2.5499999999999994e-42   NTclustered gi|559114142|tpe|HG525931.1| 525146 g17809 i0 80.46 16.9896907216495 261 36 87 12 17 270 253 1 TPA: Desulfovibrio desulfuricans subsp. desulfuricans str. ATCC 27774 tmRNA gene Desul_desul_27774 blastn 4944 185 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
18575888 18575888 PRJNA745553_S_NODE_22495_length_261_cov_1.686170_g22300_i0 PRJNA745553 22495 261 1.68617 4.4009037 Candidatus Electrothrix sp. GW3-4 3126740 Bacteria Bacteria 52.8 0.024   NTclustered gi|2706403704|gb|CP147990.1| 3126740 g22300 i0 100 0.10727969348659 28 0 11 0 5 32 2955193 2955220 MAG: Candidatus Electrothrix sp. GW3-4 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix sp. GW3-4
19851246 19851246 PRJNA745553_S_NODE_23076_length_257_cov_5.483696_g22881_i0 PRJNA745553 23076 257 5.483696 14.09309872 uncultured Mailhella sp. 1981031 Bacteria Bacteria 302 2.1e-77   NTclustered gi|2729058701|emb|OZ007001.1| 1981031 g22881 i0 91.364 136.887159533074 220 19 86 0 19 238 1893664 1893883 MAG: uncultured Mailhella sp. isolate metabat2_pooled_hifiasm.920 MAG genome assembly, chromosome: 1 blastn 35180 302 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Mailhella uncultured Mailhella sp.
21126745 21126745 PRJNA745553_S_NODE_1997_length_655_cov_6.013746_g1827_i0 PRJNA745553 1997 655 6.013746 39.3900363 Desulfovibrio piger 901 Bacteria Bacteria 1188 0   NTclustered gi|2548467271|emb|OX636706.1| 901 g1827 i0 99.39 85.0564885496183 656 2 99 1 1 654 1638569 1639224 Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1 blastn 55712 1188 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio piger
22401701 22401701 PRJNA745553_S_NODE_25678_length_245_cov_3.337209_g25483_i0 PRJNA745553 25678 245 3.337209 8.17616205 Desulfolutivibrio sulfodismutans 63561 Bacteria Bacteria 135 2.13e-27   NTclustered gi|1863422180|gb|CP045504.1| 1121464 g25483 i0 79.592 54.2816326530612 196 34 78 6 28 219 1155193 1155000 Desulfolutivibrio sulfodismutans DSM 3696 chromosome, complete genome blastn 13299 135 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfolutivibrio Desulfolutivibrio sulfodismutans
23677322 23677322 PRJNA745553_S_NODE_28779_length_227_cov_3.701299_g28584_i0 PRJNA745553 28779 227 3.701299 8.40194873 uncultured Desulfovibrio sp. 167968 Bacteria Bacteria 152 1.94e-32   NTclustered gi|1133590960|gb|KY480240.1| 167968 g28584 i0 94.118 39.1674008810573 102 2 43 3 9 106 141 242 Uncultured Desulfovibrio sp. clone CCB7487 16S ribosomal RNA gene, partial sequence blastn 8891 152 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio uncultured Desulfovibrio sp.
25425271 25425271 PRJNA745553_S_NODE_23060_length_257_cov_6.875000_g22865_i0 PRJNA745553 23060 257 6.875 17.66875 Pseudomonadati 3379134 Bacteria Bacteria 117 8.17e-22   NTclustered gi|2893358420|emb|OZ220712.1| 2202153 g22865 i0 76.856 40.9299610894942 229 39 86 12 11 232 1713385 1713606 MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1 blastn 10519 117 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium

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