contig_metadata
9 rows where bioproject = "PRJNA556992", tax_phylum = "Nanobdellota" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26920556 | 26920556 | PRJNA556992_P_NODE_79982_length_434_cov_4.673130_g77801_i0 | PRJNA556992 | 79982 | 434 | 4.67313 | 20.2813842 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 108 | 3.7400000000000006e-27 | NR | MCA9495918.1 | 2026764 | g77801 | i0 | 49.2 | 0.829493087557604 | 120 | 57 | 82.3 | 3 | 421 | 65 | 2 | 118 | MCA9495918.1 transposase [Nanoarchaeota archaeon] | diamond | 360 | 108 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 27268268 | 27268268 | PRJNA556992_P_NODE_687043_length_252_cov_1.698324_g684854_i0 | PRJNA556992 | 687043 | 252 | 1.698324 | 4.27977648 | Candidatus Nanoarchaeia archaeon | 2910166 | Archaea | Archaea | 120 | 9.73e-33 | NR | HLC54554.1 | 2910166 | g684854 | i0 | 74.3 | 0.833333333333333 | 70 | 18 | 83.3 | 0 | 250 | 41 | 66 | 135 | HLC54554.1 translation initiation factor IF-2 subunit beta [Candidatus Nanoarchaeia archaeon] | diamond | 210 | 120 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia archaeon | |||||
| 28657818 | 28657818 | PRJNA556992_P_NODE_696727_length_251_cov_2.370787_g694538_i0 | PRJNA556992 | 696727 | 251 | 2.370787 | 5.95067537 | Candidatus Nanoarchaeia archaeon | 2910166 | Archaea | Archaea | 49.3 | 2.04e-4 | NR | MEM4248446.1 | 2910166 | g694538 | i0 | 63.9 | 0.430278884462151 | 36 | 13 | 43 | 0 | 132 | 239 | 157 | 192 | MEM4248446.1 tail fiber domain-containing protein [Candidatus Nanoarchaeia archaeon] | diamond | 108 | 49.3 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia archaeon | |||||
| 28909639 | 28909639 | PRJNA556992_P_NODE_1070648_length_219_cov_11.705479_g1068457_i0 | PRJNA556992 | 1070648 | 219 | 11.705479 | 25.63499901 | Candidatus Nanoarchaeia archaeon | 2910166 | Archaea | Archaea | 50.8 | 3.64e-5 | NR | HLG25045.1 | 2910166 | g1068457 | i0 | 38.5 | 0.89041095890411 | 65 | 40 | 89 | 0 | 24 | 218 | 35 | 99 | HLG25045.1 Druantia anti-phage system protein DruA [Candidatus Nanoarchaeia archaeon] | diamond | 195 | 50.8 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia archaeon | |||||
| 30787957 | 30787957 | PRJNA556992_P_NODE_1114994_length_209_cov_5.580882_g1112803_i0 | PRJNA556992 | 1114994 | 209 | 5.580882 | 11.66404338 | root | 1 | Root_unresolved | Root_unresolved | 135 | 1.11e-36 | NR | MDO8656005.1 | 2026764 | g1112803 | i0 | 95.7 | 3.93301435406699 | 69 | 3 | 99 | 0 | 2 | 208 | 157 | 225 | MDO8656005.1 DNA gyrase C-terminal beta-propeller domain-containing protein [Nanoarchaeota archaeon] | diamond | 822 | 136 | 0.992647058823529 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 31026282 | 31026282 | PRJNA556992_P_NODE_1074115_length_219_cov_4.246575_g1071924_i0 | PRJNA556992 | 1074115 | 219 | 4.246575 | 9.29999925 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 84 | 7.62e-18 | NR | MBU0929563.1 | 2026764 | g1071924 | i0 | 75 | 0.657534246575342 | 48 | 10 | 65.8 | 1 | 20 | 163 | 176 | 221 | MBU0929563.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 144 | 84 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 31627045 | 31627045 | PRJNA556992_P_NODE_327776_length_285_cov_1.377358_g325587_i0 | PRJNA556992 | 327776 | 285 | 1.377358 | 3.9254703 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 123 | 2.4699999999999997e-30 | NR | MEK6909076.1 | 2026764 | g325587 | i0 | 62.8 | 1.97894736842105 | 94 | 34 | 98.9 | 1 | 284 | 3 | 536 | 628 | MEK6909076.1 DNA polymerase II large subunit [Nanoarchaeota archaeon] | diamond | 564 | 123 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 32670589 | 32670589 | PRJNA556992_P_NODE_484440_length_268_cov_4.276923_g482251_i0 | PRJNA556992 | 484440 | 268 | 4.276923 | 11.46215364 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 97.4 | 5.9e-22 | NR | MFC1697264.1 | 2026764 | g482251 | i0 | 58 | 1.98134328358209 | 88 | 36 | 98.5 | 1 | 268 | 5 | 104 | 190 | MFC1697264.1 ADP-ribosylglycohydrolase family protein [Nanoarchaeota archaeon] | diamond | 531 | 97.4 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 32796622 | 32796622 | PRJNA556992_P_NODE_883340_length_241_cov_4.946429_g881150_i0 | PRJNA556992 | 883340 | 241 | 4.946429 | 11.92089389 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 58.2 | 1.33e-7 | NR | MEK6873557.1 | 2026764 | g881150 | i0 | 45.6 | 2.06639004149378 | 79 | 35 | 88.4 | 2 | 214 | 2 | 56 | 134 | MEK6873557.1 carboxypeptidase M32 [Nanoarchaeota archaeon] | diamond | 498 | 58.2 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon |
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);;