contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA556992" and tax_phylum = "Kiritimatiellota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3082213 | 3082213 | PRJNA556992_P_NODE_645283_length_255_cov_2.467033_g643094_i0 | PRJNA556992 | 645283 | 255 | 2.467033 | 6.29093415 | Kiritimatiellales bacterium | 2202731 | Bacteria | Bacteria | 120 | 1.97e-29 | NR | MEI7851531.1 | 2202731 | g643094 | i0 | 76.2 | 0.988235294117647 | 84 | 20 | 98.8 | 0 | 254 | 3 | 823 | 906 | MEI7851531.1 putative Ig domain-containing protein [Kiritimatiellales bacterium] | diamond | 252 | 120 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellales | Kiritimatiellales bacterium | |||
| 3082945 | 3082945 | PRJNA556992_P_NODE_705083_length_251_cov_0.865169_g702894_i0 | PRJNA556992 | 705083 | 251 | 0.865169 | 2.17157419 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 101 | 9.68e-23 | NR | MDD4061288.1 | 2212473 | g702894 | i0 | 76.1 | 0.848605577689243 | 71 | 12 | 84.9 | 2 | 251 | 39 | 134 | 199 | MDD4061288.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 213 | 101 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27078526 | 27078526 | PRJNA556992_P_NODE_428622_length_274_cov_1.233831_g426433_i0 | PRJNA556992 | 428622 | 274 | 1.233831 | 3.38069694 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 160 | 1.48e-46 | NR | MDD4060236.1 | 2212473 | g426433 | i0 | 79.1 | 0.996350364963504 | 91 | 19 | 99.6 | 0 | 274 | 2 | 122 | 212 | MDD4060236.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 273 | 160 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27394961 | 27394961 | PRJNA556992_P_NODE_780923_length_247_cov_0.885057_g778733_i0 | PRJNA556992 | 780923 | 247 | 0.885057 | 2.18609079 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 62.4 | 4.65e-9 | NR | MBR4258270.1 | 2212473 | g778733 | i0 | 57.4 | 0.65587044534413 | 54 | 22 | 64.4 | 1 | 5 | 163 | 515 | 568 | MBR4258270.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 162 | 62.4 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27489442 | 27489442 | PRJNA556992_P_NODE_544983_length_263_cov_2.852632_g542794_i0 | PRJNA556992 | 544983 | 263 | 2.852632 | 7.50242216 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 64.7 | 3.37e-10 | NR | MFA7175014.1 | 2212473 | g542794 | i0 | 70.3 | 0.422053231939163 | 37 | 11 | 42.2 | 0 | 113 | 3 | 4 | 40 | MFA7175014.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 111 | 64.7 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27552373 | 27552373 | PRJNA556992_P_NODE_693344_length_251_cov_3.410112_g691155_i0 | PRJNA556992 | 693344 | 251 | 3.410112 | 8.55938112 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 131 | 6.1e-35 | NR | MFA7175015.1 | 2212473 | g691155 | i0 | 77.1 | 1.9840637450199201 | 83 | 19 | 99.2 | 0 | 250 | 2 | 117 | 199 | MFA7175015.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 498 | 131 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27583849 | 27583849 | PRJNA556992_P_NODE_155244_length_354_cov_4.163701_g153056_i0 | PRJNA556992 | 155244 | 354 | 4.163701 | 14.73950154 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 45.1 | 0.0193 | NR | HOO21993.1 | 2212473 | g153056 | i0 | 41.3 | 0.779661016949153 | 92 | 48 | 75.4 | 3 | 2 | 268 | 442 | 530 | HOO21993.1 autotransporter-associated beta strand repeat-containing protein [Kiritimatiellia bacterium] | diamond | 276 | 45.1 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27962759 | 27962759 | PRJNA556992_P_NODE_1135465_length_204_cov_12.748092_g1133274_i0 | PRJNA556992 | 1135465 | 204 | 12.748092 | 26.00610768 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 142 | 2.71e-39 | NR | MFA7054871.1 | 2212473 | g1133274 | i0 | 94.1 | 1 | 68 | 4 | 100 | 0 | 1 | 204 | 153 | 220 | MFA7054871.1 RRXRR domain-containing protein [Kiritimatiellia bacterium] | diamond | 204 | 142 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28626262 | 28626262 | PRJNA556992_P_NODE_631567_length_256_cov_2.841530_g629378_i0 | PRJNA556992 | 631567 | 256 | 2.84153 | 7.2743168 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 102 | 2.2099999999999994e-23 | NR | MFA7175017.1 | 2212473 | g629378 | i0 | 65.4 | 0.9140625 | 78 | 27 | 91.4 | 0 | 254 | 21 | 324 | 401 | MFA7175017.1 minor capsid protein [Kiritimatiellia bacterium] | diamond | 234 | 102 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29068230 | 29068230 | PRJNA556992_P_NODE_605168_length_258_cov_3.308108_g602979_i0 | PRJNA556992 | 605168 | 258 | 3.308108 | 8.53491864 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 148 | 1.38e-39 | NR | MDD4061730.1 | 2212473 | g602979 | i0 | 85.9 | 0.988372093023256 | 85 | 12 | 98.8 | 0 | 256 | 2 | 251 | 335 | MDD4061730.1 ice-binding family protein [Kiritimatiellia bacterium] | diamond | 255 | 148 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29194426 | 29194426 | PRJNA556992_P_NODE_367509_length_280_cov_1.763285_g365320_i0 | PRJNA556992 | 367509 | 280 | 1.763285 | 4.937198 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 43.5 | 0.0298 | NR | HNX34294.1 | 2212473 | g365320 | i0 | 35.4 | 0.878571428571429 | 82 | 42 | 87.9 | 3 | 254 | 9 | 80 | 150 | HNX34294.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 246 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29572864 | 29572864 | PRJNA556992_P_NODE_1133090_length_205_cov_5.439394_g1130899_i0 | PRJNA556992 | 1133090 | 205 | 5.439394 | 11.1507577 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 65.9 | 1.43e-10 | NR | MFA7335064.1 | 2212473 | g1130899 | i0 | 43.8 | 2.10731707317073 | 73 | 35 | 98 | 1 | 203 | 3 | 44 | 116 | MFA7335064.1 DUF2800 domain-containing protein [Kiritimatiellia bacterium] | diamond | 432 | 65.9 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30426740 | 30426740 | PRJNA556992_P_NODE_88193_length_421_cov_2.255747_g86011_i0 | PRJNA556992 | 88193 | 421 | 2.255747 | 9.49669487 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 43.9 | 0.00795 | NR | MDX9795148.1 | 2212473 | g86011 | i0 | 45.5 | 0.391923990498812 | 55 | 28 | 39.2 | 1 | 320 | 156 | 3 | 55 | MDX9795148.1 aspartate 1-decarboxylase [Kiritimatiellia bacterium] | diamond | 165 | 43.9 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30773770 | 30773770 | PRJNA556992_P_NODE_427774_length_274_cov_1.348259_g425585_i0 | PRJNA556992 | 427774 | 274 | 1.348259 | 3.69422966 | Kiritimatiellaeota bacterium B1221 | 3033806 | Bacteria | Bacteria | 97.4 | 2.0399999999999994e-24 | NR | MDF3129787.1 | 3033806 | g425585 | i0 | 76.4 | 0.602189781021898 | 55 | 13 | 60.2 | 0 | 166 | 2 | 1 | 55 | MDF3129787.1 DUF6500 family protein [Kiritimatiellaeota bacterium B1221] | diamond | 165 | 97.4 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellaeota bacterium B1221 | |||||
| 32006779 | 32006779 | PRJNA556992_P_NODE_379418_length_279_cov_1.223301_g377229_i0 | PRJNA556992 | 379418 | 279 | 1.223301 | 3.41300979 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 43.1 | 0.0382 | NR | MDY3229378.1 | 2212473 | g377229 | i0 | 42 | 0.537634408602151 | 50 | 29 | 53.8 | 0 | 51 | 200 | 111 | 160 | MDY3229378.1 RluA family pseudouridine synthase [Kiritimatiellia bacterium] | diamond | 150 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 32544896 | 32544896 | PRJNA556992_P_NODE_435259_length_273_cov_1.910000_g433070_i0 | PRJNA556992 | 435259 | 273 | 1.91 | 5.2143 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 120 | 2.09e-30 | NR | MBQ6339437.1 | 2212473 | g433070 | i0 | 81.5 | 1.78021978021978 | 81 | 14 | 87.9 | 1 | 242 | 3 | 33 | 113 | MBQ6339437.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 486 | 120 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 32827973 | 32827973 | PRJNA556992_P_NODE_109160_length_394_cov_4.629283_g106976_i0 | PRJNA556992 | 109160 | 394 | 4.629283 | 18.23937502 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 75.9 | 7.61e-15 | NR | HON48058.1 | 2212473 | g106976 | i0 | 39.4 | 1.36294416243655 | 94 | 53 | 68.5 | 1 | 125 | 394 | 7 | 100 | HON48058.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 537 | 75.9 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium |
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);;