RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA879221" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA879221 · 13 ✖

analysis 1

  • blastn · 13 ✖

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
857115 857115 PRJNA879221_P_NODE_43141_length_262_cov_0.915344_g43001_i0 PRJNA879221 43141 262 0.915344 2.39820128 uncultured Mailhella sp. 1981031 Bacteria Bacteria 176 1.36e-39   NTclustered gi|2729058701|emb|OZ007001.1| 1981031 g43001 i0 79.71 4.27099236641221 276 30 98 16 1 257 2248783 2249051 MAG: uncultured Mailhella sp. isolate metabat2_pooled_hifiasm.920 MAG genome assembly, chromosome: 1 blastn 1119 176 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Mailhella uncultured Mailhella sp.
5960533 5960533 PRJNA879221_P_NODE_62905_length_242_cov_0.911243_g62765_i0 PRJNA879221 62905 242 0.911243 2.20520806 Desulfovibrio desulfuricans 876 Bacteria Bacteria 257 4.3e-64   NTclustered gi|1621566608|gb|CP036295.1| 876 g62765 i0 86.638 80.495867768595 232 31 96 0 3 234 89436 89667 Desulfovibrio desulfuricans strain IC1 chromosome, complete genome blastn 19480 257 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
6343632 6343632 PRJNA879221_P_NODE_21945_length_377_cov_1.220395_g21805_i0 PRJNA879221 21945 377 1.220395 4.60088915 Nitratidesulfovibrio 2802295 Bacteria Bacteria 324 6.89e-84   NTclustered gi|46451220|gb|AE017285.1| 882 g21805 i0 82.228 19.8143236074271 377 65 99 2 2 377 621100 621475 Desulfovibrio vulgaris subsp. vulgaris str. Hildenborough, complete genome blastn 7470 324 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio vulgaris
8510104 8510104 PRJNA879221_P_NODE_52907_length_247_cov_0.885057_g52767_i0 PRJNA879221 52907 247 0.885057 2.18609079 Pseudodesulfovibrio indicus 1716143 Bacteria Bacteria 163 9.88e-36   NTclustered gi|998152336|gb|CP014206.1| 1716143 g52767 i0 80.09 2.38866396761134 221 42 89 2 9 228 1778511 1778292 Pseudodesulfovibrio indicus strain J2 chromosome, complete genome blastn 590 163 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio indicus
8510128 8510128 PRJNA879221_P_NODE_55547_length_246_cov_0.890173_g55407_i0 PRJNA879221 55547 246 0.890173 2.18982558 uncultured Mailhella sp. 1981031 Bacteria Bacteria 209 1.25e-49   NTclustered gi|2729058701|emb|OZ007001.1| 1981031 g55407 i0 85.294 90.2560975609756 204 28 83 2 41 243 239871 240073 MAG: uncultured Mailhella sp. isolate metabat2_pooled_hifiasm.920 MAG genome assembly, chromosome: 1 blastn 22203 209 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Mailhella uncultured Mailhella sp.
9785109 9785109 PRJNA879221_P_NODE_60768_length_243_cov_0.905882_g60628_i0 PRJNA879221 60768 243 0.905882 2.20129326 Nitratidesulfovibrio liaohensis 2604158 Bacteria Bacteria 180 9.63e-41   NTclustered gi|2575677524|gb|CP133659.1| 2604158 g60628 i0 86.145 0.683127572016461 166 23 68 0 53 218 3392461 3392626 Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome blastn 166 180 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio liaohensis
13610426 13610426 PRJNA879221_P_NODE_21491_length_382_cov_0.857605_g21351_i0 PRJNA879221 21491 382 0.857605 3.2760511 Nitratidesulfovibrio sp. HK-II 2009266 Bacteria Bacteria 340 6.939999999999999e-89   NTclustered gi|2791413552|dbj|AP036014.1| 2009266 g21351 i0 82.812 9.41623036649215 384 62 100 4 1 382 3447480 3447099 Nitratidesulfovibrio sp. HK-II DNA, complete genome blastn 3597 340 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio sp. HK-II
16159641 16159641 PRJNA879221_P_NODE_34653_length_299_cov_0.942478_g34513_i0 PRJNA879221 34653 299 0.942478 2.81800922 Nitratidesulfovibrio liaohensis 2604158 Bacteria Bacteria 171 7.36e-38   NTclustered gi|2575677524|gb|CP133659.1| 2604158 g34513 i0 81.019 4.0133779264214 216 40 72 1 1 215 1435351 1435566 Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome blastn 1200 171 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio liaohensis
17435216 17435216 PRJNA879221_P_NODE_39414_length_277_cov_1.509804_g39274_i0 PRJNA879221 39414 277 1.509804 4.18215708 uncultured Mailhella sp. 1981031 Bacteria Bacteria 202 2.39e-47   NTclustered gi|2729058701|emb|OZ007001.1| 1981031 g39274 i0 82.609 67.0974729241877 230 38 83 2 28 256 2781666 2781438 MAG: uncultured Mailhella sp. isolate metabat2_pooled_hifiasm.920 MAG genome assembly, chromosome: 1 blastn 18586 202 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Mailhella uncultured Mailhella sp.
18708163 18708163 PRJNA879221_P_NODE_17935_length_421_cov_0.801724_g17796_i0 PRJNA879221 17935 421 0.801724 3.37525804 Desulfovibrio fairfieldensis 44742 Bacteria Bacteria 488 2.6099999999999993e-133   NTclustered gi|987453195|gb|CP014229.1| 44742 g17796 i0 87.799 76.5890736342043 418 49 99 2 5 421 1351546 1351962 Desulfovibrio fairfieldensis strain CCUG 45958 chromosome, complete genome blastn 32244 488 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio fairfieldensis
19983571 19983571 PRJNA879221_P_NODE_28236_length_332_cov_1.104247_g28096_i0 PRJNA879221 28236 332 1.104247 3.66610004 Desulfovibrio fairfieldensis 44742 Bacteria Bacteria 298 3.64e-76   NTclustered gi|987453195|gb|CP014229.1| 44742 g28096 i0 82.985 37.0361445783133 335 51 100 4 1 332 858492 858823 Desulfovibrio fairfieldensis strain CCUG 45958 chromosome, complete genome blastn 12296 298 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio fairfieldensis
19983830 19983830 PRJNA879221_P_NODE_47956_length_250_cov_0.870056_g47816_i0 PRJNA879221 47956 250 0.870056 2.17514 Nitratidesulfovibrio liaohensis 2604158 Bacteria Bacteria 180 9.95e-41   NTclustered gi|2575677524|gb|CP133659.1| 2604158 g47816 i0 84.53 1.928 181 28 72 0 5 185 4162216 4162036 Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome blastn 482 180 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio liaohensis
23809365 23809365 PRJNA879221_P_NODE_52939_length_247_cov_0.885057_g52799_i0 PRJNA879221 52939 247 0.885057 2.18609079 Desulfovibrio sp. 86 2666132 Bacteria Bacteria 313 9.28e-81   NTclustered gi|1862956133|emb|LR738849.1| 2666132 g52799 i0 89.754 5.80971659919028 244 25 99 0 2 245 1791697 1791454 Desulfovibrio sp. 86 genome assembly, chromosome: DESU86 blastn 1435 313 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp. 86

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