RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA890871", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 17 ✖

tax_kingdom 1

  • Pseudomonadati · 17 ✖

bioproject 1

  • PRJNA890871 · 17 ✖

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
865484 865484 PRJNA890871_P_NODE_91601_length_228_cov_2.548387_g91466_i0 PRJNA890871 91601 228 2.548387 5.81032236 Trichlorobacter lovleyi 313985 Bacteria Bacteria 56.5 0.002   NTclustered gi|1928744636|gb|CP058410.1| 313985 g91466 i0 100 0.131578947368421 30 0 13 0 99 128 127518 127547 Trichlorobacter lovleyi strain IAE plasmid pIAE1, complete sequence blastn 30 56.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Trichlorobacter Trichlorobacter lovleyi
8518112 8518112 PRJNA890871_P_NODE_81087_length_243_cov_0.905882_g80952_i0 PRJNA890871 81087 243 0.905882 2.20129326 Desulfovibrio desulfuricans 876 Bacteria Bacteria 438 1.4399999999999996e-118   NTclustered gi|2172810686|gb|CP077745.1| 876 g80952 i0 99.177 2.99588477366255 243 2 100 0 1 243 2026673 2026915 Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome blastn 728 438 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
12344366 12344366 PRJNA890871_P_NODE_84830_length_241_cov_2.077381_g84695_i0 PRJNA890871 84830 241 2.077381 5.00648821 Desulfovibrio desulfuricans 876 Bacteria Bacteria 440 3.959999999999999e-119   NTclustered gi|2172810686|gb|CP077745.1| 876 g84695 i0 99.585 63.3526970954357 241 1 100 0 1 241 2296578 2296818 Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome blastn 15268 440 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
17442646 17442646 PRJNA890871_P_NODE_39574_length_283_cov_1.376190_g39439_i0 PRJNA890871 39574 283 1.37619 3.8946177 Desulfovibrio desulfuricans 876 Bacteria Bacteria 512 9.97e-141   NTclustered gi|2172810686|gb|CP077745.1| 876 g39439 i0 99.293 13.113074204947 283 2 100 0 1 283 2218971 2218689 Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome blastn 3711 512 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
18716686 18716686 PRJNA890871_P_NODE_85715_length_241_cov_0.916667_g85580_i0 PRJNA890871 85715 241 0.916667 2.20916747 Desulfovibrio desulfuricans 876 Bacteria Bacteria 440 3.959999999999999e-119   NTclustered gi|2172810686|gb|CP077745.1| 876 g85580 i0 99.585 4.32780082987552 241 1 100 0 1 241 3207340 3207100 Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome blastn 1043 440 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
21267030 21267030 PRJNA890871_P_NODE_70617_length_248_cov_0.880000_g70482_i0 PRJNA890871 70617 248 0.88 2.1824 Desulfovibrio desulfuricans 876 Bacteria Bacteria 448 2.4499999999999996e-121   NTclustered gi|2172810686|gb|CP077745.1| 876 g70482 i0 99.194 19.8185483870968 248 2 100 0 1 248 2343046 2342799 Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome blastn 4915 448 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
22541446 22541446 PRJNA890871_P_NODE_48138_length_269_cov_1.571429_g48003_i0 PRJNA890871 48138 269 1.571429 4.22714401 Desulfovibrio desulfuricans 876 Bacteria Bacteria 486 5.699999999999999e-133   NTclustered gi|2172810686|gb|CP077745.1| 876 g48003 i0 99.257 2.99256505576208 269 2 100 0 1 269 3109190 3109458 Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome blastn 805 486 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
26865980 26865980 PRJNA890871_P_NODE_26801_length_324_cov_3.047809_g26666_i0 PRJNA890871 26801 324 3.047809 9.87490116 Desulfobulbaceae bacterium 2053307 Bacteria Bacteria 94.4 1.6400000000000001e-22   NR MCP3887305.1 2053307 g26666 i0 67.2 2.37962962962963 64 21 59.3 0 2 193 42 105 MCP3887305.1 methylated-DNA--[protein]-cysteine S-methyltransferase [Desulfobulbaceae bacterium] diamond 771 94.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
27094950 27094950 PRJNA890871_P_NODE_68222_length_249_cov_0.875000_g68087_i0 PRJNA890871 68222 249 0.875 2.17875 Pseudomonadati 3379134 Bacteria Bacteria 154 2.97e-42   NR WP_092376848.1 52560 g68087 i0 85.4 7.90361445783132 82 12 98.8 0 3 248 36 117 WP_092376848.1 DUF262 domain-containing protein [Desulfomicrobium apsheronum] diamond 1968 154 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium apsheronum
27632123 27632123 PRJNA890871_P_NODE_21324_length_356_cov_1.049470_g21189_i0 PRJNA890871 21324 356 1.04947 3.7361132 Pseudomonadati 3379134 Bacteria Bacteria 238 1.61e-76   NR MFA5719312.1 2053307 g21189 i0 100 1.98876404494382 118 0 99.4 0 2 355 137 254 MFA5719312.1 LysR family transcriptional regulator [Desulfobulbaceae bacterium] diamond 708 238 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
28034850 28034850 PRJNA890871_P_NODE_83285_length_242_cov_0.911243_g83150_i0 PRJNA890871 83285 242 0.911243 2.20520806 Desulforhopalus vacuolatus 40414 Bacteria Bacteria 66.2 1.94e-10   NR WP_205219220.1 40414 g83150 i0 42.3 0.966942148760331 78 45 96.7 0 238 5 676 753 WP_205219220.1 hypothetical protein [Desulforhopalus vacuolatus] diamond 234 66.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulforhopalus Desulforhopalus vacuolatus
28792288 28792288 PRJNA890871_P_NODE_2407_length_1047_cov_4.228953_g2290_i0 PRJNA890871 2407 1047 4.228953 44.27713791 Desulfatiglans sp. 1969697 Bacteria Bacteria 111 9.96e-23   NR NLD39097.1 1969697 g2290 i0 36.3 2.00859598853868 223 127 62.5 5 230 883 371 583 NLD39097.1 hypothetical protein [Desulfatiglans sp.] diamond 2103 111 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfatiglandales Desulfatiglandaceae Desulfatiglans Desulfatiglans sp.
29076772 29076772 PRJNA890871_P_NODE_10728_length_473_cov_2.705000_g10593_i0 PRJNA890871 10728 473 2.705 12.79465 Desulfobulbaceae bacterium 2053307 Bacteria Bacteria 89 3.19e-17   NR MCK9295141.1 2053307 g10593 i0 33.3 1.00845665961945 159 103 99.6 3 1 471 427 584 MCK9295141.1 single-stranded-DNA-specific exonuclease RecJ [Desulfobulbaceae bacterium] diamond 477 89 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
29423731 29423731 PRJNA890871_P_NODE_1749_length_1395_cov_9.138427_g1643_i0 PRJNA890871 1749 1395 9.138427 127.48105665 Desulfovibrio sp. 885 Bacteria Bacteria 276 1.32e-85   NR MBQ9407002.1 885 g1643 i0 50.5 2.52688172043011 293 130 63 2 514 1392 7 284 MBQ9407002.1 transposase [Desulfovibrio sp.] diamond 3525 276 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
30466601 30466601 PRJNA890871_P_NODE_2533_length_1012_cov_4.500532_g2415_i0 PRJNA890871 2533 1012 4.500532 45.54538384 Desulfobacteraceae bacterium IS3 1934248 Bacteria Bacteria 84 1.01e-13   NR OQX20897.1 1934248 g2415 i0 26.9 0.58399209486166 197 136 56 3 322 888 367 563 OQX20897.1 MAG: hypothetical protein BWK80_35110 [Desulfobacteraceae bacterium IS3] diamond 591 84 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium IS3
31509433 31509433 PRJNA890871_P_NODE_1496_length_1617_cov_3.250648_g1400_i0 PRJNA890871 1496 1617 3.250648 52.56297816 Desulfobacterales bacterium 2044940 Bacteria Bacteria 52 0.0011   NR MCF8068557.1 2044940 g1400 i0 36.6 0.250463821892393 71 43 13.2 1 1060 848 4 72 MCF8068557.1 hypothetical protein [Desulfobacterales bacterium] diamond 405 52 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
31730567 31730567 PRJNA890871_P_NODE_51197_length_265_cov_1.447917_g51062_i0 PRJNA890871 51197 265 1.447917 3.83698005 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 43.5 0.0247   NR HPQ28537.1 2049433 g51062 i0 35.8 0.758490566037736 67 35 66.8 1 255 79 266 332 HPQ28537.1 methyltransferase [Desulfobacteraceae bacterium] diamond 201 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae 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);;