contig_metadata
10 rows where bioproject = "PRJNA1245487", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 351069 | 351069 | PRJNA1245487_P_NODE_8341_length_423_cov_1.262857_g8003_i0 | PRJNA1245487 | 8341 | 423 | 1.262857 | 5.34188511 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 435 | 3.46e-117 | NTclustered | gi|2575803239|emb|OY729416.1| | 2202153 | g8003 | i0 | 86.139 | 123.307328605201 | 404 | 54 | 96 | 2 | 1 | 404 | 77048 | 76647 | MAG: Thermodesulfobacteriota bacterium isolate ba02c5ff-97d3-4768-ae28-618c4039653d genome assembly, chromosome: 1 | blastn | 52159 | 435 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 9279266 | 9279266 | PRJNA1245487_P_NODE_14008_length_305_cov_1.715517_g13670_i0 | PRJNA1245487 | 14008 | 305 | 1.715517 | 5.23232685 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 292 | 1.54e-74 | NTclustered | gi|2891482145|emb|OZ219878.1| | 2202153 | g13670 | i0 | 86.029 | 210.4 | 272 | 38 | 89 | 0 | 34 | 305 | 213853 | 213582 | MAG: Thermodesulfobacteriota bacterium isolate 5b8d878f-b741-4c1d-a9b4-bc29eff46044 genome assembly, chromosome: 1 | blastn | 64172 | 292 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 16928424 | 16928424 | PRJNA1245487_P_NODE_7034_length_466_cov_2.071247_g6698_i0 | PRJNA1245487 | 7034 | 466 | 2.071247 | 9.65201102 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 575 | 2.1699999999999994e-159 | NTclustered | gi|2575803239|emb|OY729416.1| | 2202153 | g6698 | i0 | 89.079 | 154.534334763948 | 467 | 46 | 100 | 4 | 1 | 466 | 76380 | 75918 | MAG: Thermodesulfobacteriota bacterium isolate ba02c5ff-97d3-4768-ae28-618c4039653d genome assembly, chromosome: 1 | blastn | 72013 | 575 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 17628953 | 17628953 | PRJNA1245487_P_NODE_10134_length_374_cov_2.897010_g9796_i0 | PRJNA1245487 | 10134 | 374 | 2.89701 | 10.8348174 | Desulfocarbo indianensis | 1348163 | Bacteria | Bacteria | 259 | 5.960000000000001e-85 | NR | KMY65383.1 | 1348163 | g9796 | i0 | 100 | 0.994652406417112 | 124 | 0 | 99.5 | 0 | 372 | 1 | 141 | 264 | KMY65383.1 CoA-transferase, partial [Desulfocarbo indianensis] | diamond | 372 | 259 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Desulfarculales | Desulfarculaceae | Desulfocarbo | Desulfocarbo indianensis | ||
| 26756903 | 26756903 | PRJNA1245487_P_NODE_7421_length_452_cov_3.820580_g7085_i0 | PRJNA1245487 | 7421 | 452 | 3.82058 | 17.2690216 | Desulfocarbo indianensis | 1348163 | Bacteria | Bacteria | 300 | 8.58e-102 | NR | KMY65487.1 | 1348163 | g7085 | i0 | 99.3 | 0.995575221238938 | 150 | 1 | 99.6 | 0 | 1 | 450 | 55 | 204 | KMY65487.1 hypothetical protein AAU61_22005 [Desulfocarbo indianensis] | diamond | 450 | 300 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Desulfarculales | Desulfarculaceae | Desulfocarbo | Desulfocarbo indianensis | ||
| 28115746 | 28115746 | PRJNA1245487_P_NODE_6725_length_478_cov_1.540741_g6389_i0 | PRJNA1245487 | 6725 | 478 | 1.540741 | 7.36474198 | Desulfocarbo indianensis | 1348163 | Bacteria | Bacteria | 234 | 4.450000000000001e-77 | NR | KMY65275.1 | 1348163 | g6389 | i0 | 100 | 0.702928870292887 | 112 | 0 | 70.3 | 0 | 478 | 143 | 5 | 116 | KMY65275.1 hypothetical protein AAU61_23110 [Desulfocarbo indianensis] | diamond | 336 | 234 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Desulfarculales | Desulfarculaceae | Desulfocarbo | Desulfocarbo indianensis | ||
| 28526506 | 28526506 | PRJNA1245487_P_NODE_15827_length_283_cov_1.447619_g15489_i0 | PRJNA1245487 | 15827 | 283 | 1.447619 | 4.09676177 | Desulfocarbo indianensis | 1348163 | Bacteria | Bacteria | 195 | 5.54e-62 | NR | KMY65216.1 | 1348163 | g15489 | i0 | 100 | 0.996466431095406 | 94 | 0 | 99.6 | 0 | 2 | 283 | 43 | 136 | KMY65216.1 hypothetical protein AAU61_23415, partial [Desulfocarbo indianensis] | diamond | 282 | 195 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Desulfarculales | Desulfarculaceae | Desulfocarbo | Desulfocarbo indianensis | ||
| 28652660 | 28652660 | PRJNA1245487_P_NODE_17747_length_264_cov_2.785340_g17409_i0 | PRJNA1245487 | 17747 | 264 | 2.78534 | 7.3532976 | Desulfocarbo indianensis | 1348163 | Bacteria | Bacteria | 144 | 3.7399999999999997e-42 | NR | KMY65284.1 | 1348163 | g17409 | i0 | 100 | 0.806818181818182 | 71 | 0 | 80.7 | 0 | 51 | 263 | 1 | 71 | KMY65284.1 hypothetical protein AAU61_23065 [Desulfocarbo indianensis] | diamond | 213 | 144 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Desulfarculales | Desulfarculaceae | Desulfocarbo | Desulfocarbo indianensis | ||
| 32001800 | 32001800 | PRJNA1245487_P_NODE_3818_length_643_cov_3.028070_g3491_i0 | PRJNA1245487 | 3818 | 643 | 3.02807 | 19.4704901 | Desulfocarbo indianensis | 1348163 | Bacteria | Bacteria | 267 | 1.26e-88 | NR | KMY65461.1 | 1348163 | g3491 | i0 | 100 | 0.643856920684292 | 138 | 0 | 64.4 | 0 | 639 | 226 | 1 | 138 | KMY65461.1 hypothetical protein AAU61_22145 [Desulfocarbo indianensis] | diamond | 414 | 267 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Desulfarculales | Desulfarculaceae | Desulfocarbo | Desulfocarbo indianensis | ||
| 32823215 | 32823215 | PRJNA1245487_P_NODE_14400_length_299_cov_5.938053_g14062_i0 | PRJNA1245487 | 14400 | 299 | 5.938053 | 17.75477847 | Desulfocarbo indianensis | 1348163 | Bacteria | Bacteria | 145 | 3.3999999999999993e-43 | NR | KMY65248.1 | 1348163 | g14062 | i0 | 97.2 | 0.712374581939799 | 71 | 2 | 71.2 | 0 | 281 | 69 | 1 | 71 | KMY65248.1 hypothetical protein AAU61_23245 [Desulfocarbo indianensis] | diamond | 213 | 145 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Desulfarculales | Desulfarculaceae | Desulfocarbo | Desulfocarbo indianensis |
Advanced export
JSON shape: default, array, newline-delimited
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);;