contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA980585" and tax_phylum = "Tardigrada"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12748641 | 12748641 | PRJNA980585_P_NODE_53810_length_244_cov_1.801170_g53556_i0 | PRJNA980585 | 53810 | 244 | 1.80117 | 4.3948548 | root | 1 | Root_unresolved | Root_unresolved | 131 | 2.35e-33 | NR | AAK12358.1 | 46460 | g53556 | i0 | 75 | 18.577868852459 | 80 | 20 | 98.4 | 0 | 242 | 3 | 321 | 400 | AAK12358.1 elongation factor-2, partial [Milnesium tardigradum] | diamond | 4533 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Apochela | Milnesiidae | Milnesium | Milnesium tardigradum | |
| 18806206 | 18806206 | PRJNA980585_P_NODE_13735_length_372_cov_2.458194_g13481_i0 | PRJNA980585 | 13735 | 372 | 2.458194 | 9.14448168 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 145 | 4.58e-42 | NR | GAU89613.1 | 947166 | g13481 | i0 | 55.2 | 5.03225806451613 | 125 | 53 | 98.4 | 1 | 4 | 369 | 1 | 125 | GAU89613.1 hypothetical protein RvY_02145 [Ramazzottius varieornatus] | diamond | 1872 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 20081026 | 20081026 | PRJNA980585_P_NODE_18016_length_336_cov_1.463878_g17762_i0 | PRJNA980585 | 18016 | 336 | 1.463878 | 4.91863008 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 119 | 2.5e-29 | NR | GAV03413.1 | 947166 | g17762 | i0 | 57.9 | 0.955357142857143 | 107 | 43 | 95.5 | 1 | 14 | 334 | 117 | 221 | GAV03413.1 hypothetical protein RvY_13840 [Ramazzottius varieornatus] | diamond | 321 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 20395715 | 20395715 | PRJNA980585_P_NODE_25836_length_292_cov_1.050228_g25582_i0 | PRJNA980585 | 25836 | 292 | 1.050228 | 3.06666576 | Metazoa | 33208 | Tardigrada | other_Eukaryota | 181 | 2.19e-51 | NR | AAK12358.1 | 46460 | g25582 | i0 | 89.6 | 34.5205479452055 | 96 | 10 | 98.6 | 0 | 3 | 290 | 604 | 699 | AAK12358.1 elongation factor-2, partial [Milnesium tardigradum] | diamond | 10080 | 182 | 0.994505494505495 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Apochela | Milnesiidae | Milnesium | Milnesium tardigradum | |
| 22632307 | 22632307 | PRJNA980585_P_NODE_658_length_1309_cov_3.589806_g534_i0 | PRJNA980585 | 658 | 1309 | 3.589806 | 46.99056054 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 440 | 1.1699999999999997e-148 | NR | XP_055344506.1 | 2943436 | g534 | i0 | 53.5 | 33.0343773873186 | 409 | 189 | 93.7 | 1 | 1287 | 61 | 15 | 422 | XP_055344506.1 eukaryotic peptide chain release factor subunit 1-like [Paramacrobiotus metropolitanus] | diamond | 43242 | 441 | 0.997732426303855 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 23907544 | 23907544 | PRJNA980585_P_NODE_50919_length_246_cov_0.890173_g50665_i0 | PRJNA980585 | 50919 | 246 | 0.890173 | 2.18982558 | Metazoa | 33208 | Tardigrada | other_Eukaryota | 106 | 4.01e-27 | NR | OQV18047.1 | 2072580 | g50665 | i0 | 69.9 | 12.0975609756098 | 73 | 22 | 89 | 0 | 27 | 245 | 8 | 80 | OQV18047.1 40S ribosomal protein S16 [Hypsibius exemplaris] | diamond | 2976 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 24220943 | 24220943 | PRJNA980585_P_NODE_15839_length_352_cov_2.949821_g15585_i0 | PRJNA980585 | 15839 | 352 | 2.949821 | 10.38336992 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 90.1 | 1.55e-20 | NR | GAU98877.1 | 947166 | g15585 | i0 | 47.2 | 1.74715909090909 | 106 | 49 | 84.4 | 2 | 317 | 21 | 2 | 107 | GAU98877.1 hypothetical protein RvY_09960 [Ramazzottius varieornatus] | diamond | 615 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 27310878 | 27310878 | PRJNA980585_P_NODE_24883_length_296_cov_2.067265_g24629_i0 | PRJNA980585 | 24883 | 296 | 2.067265 | 6.1191044 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 77 | 6.07e-14 | NR | OQV18148.1 | 2072580 | g24629 | i0 | 58.8 | 0.516891891891892 | 51 | 21 | 51.7 | 0 | 155 | 3 | 64 | 114 | OQV18148.1 Delta(5) fatty acid desaturase A [Hypsibius exemplaris] | diamond | 153 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 27879045 | 27879045 | PRJNA980585_P_NODE_31105_length_277_cov_1.014706_g30851_i0 | PRJNA980585 | 31105 | 277 | 1.014706 | 2.81073562 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 89 | 3.18e-18 | NR | GAV05744.1 | 947166 | g30851 | i0 | 55.9 | 5.04693140794224 | 93 | 37 | 98.6 | 3 | 277 | 5 | 495 | 585 | GAV05744.1 hypothetical protein RvY_15825 [Ramazzottius varieornatus] | diamond | 1398 | 89.7 | 0.992196209587514 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 27910344 | 27910344 | PRJNA980585_P_NODE_34305_length_268_cov_1.041026_g34051_i0 | PRJNA980585 | 34305 | 268 | 1.041026 | 2.78994968 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 130 | 2.98e-33 | NR | OQV18149.1 | 2072580 | g34051 | i0 | 63.5 | 1.90298507462687 | 85 | 31 | 95.1 | 0 | 3 | 257 | 241 | 325 | OQV18149.1 Delta(5) fatty acid desaturase A [Hypsibius exemplaris] | diamond | 510 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 29236834 | 29236834 | PRJNA980585_P_NODE_43549_length_250_cov_0.870056_g43295_i0 | PRJNA980585 | 43549 | 250 | 0.870056 | 2.17514 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 64.3 | 6.23e-10 | NR | GAU90584.1 | 947166 | g43295 | i0 | 41.8 | 1.932 | 79 | 39 | 94.8 | 1 | 239 | 3 | 77 | 148 | GAU90584.1 hypothetical protein RvY_02983 [Ramazzottius varieornatus] | diamond | 483 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 30374117 | 30374117 | PRJNA980585_P_NODE_13052_length_380_cov_0.996743_g12798_i0 | PRJNA980585 | 13052 | 380 | 0.996743 | 3.7876234 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 85.5 | 9.98e-18 | NR | XP_055346023.1 | 2943436 | g12798 | i0 | 45.5 | 0.868421052631579 | 110 | 51 | 82.1 | 4 | 27 | 338 | 5 | 111 | XP_055346023.1 glutathione S-transferase 1-like [Paramacrobiotus metropolitanus] | diamond | 330 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 31543198 | 31543198 | PRJNA980585_P_NODE_10156_length_421_cov_0.885057_g9902_i0 | PRJNA980585 | 10156 | 421 | 0.885057 | 3.72608997 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 162 | 2.27e-44 | NR | GAV01754.1 | 947166 | g9902 | i0 | 51.1 | 2.03087885985748 | 141 | 68 | 99.8 | 1 | 421 | 2 | 124 | 264 | GAV01754.1 hypothetical protein RvY_12413 [Ramazzottius varieornatus] | diamond | 855 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 31795969 | 31795969 | PRJNA980585_P_NODE_53897_length_244_cov_1.649123_g53643_i0 | PRJNA980585 | 53897 | 244 | 1.649123 | 4.02386012 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 53.5 | 3.9e-6 | NR | XP_055331249.1 | 2943436 | g53643 | i0 | 49.1 | 0.676229508196721 | 55 | 23 | 66.4 | 3 | 21 | 182 | 149 | 199 | XP_055331249.1 uncharacterized protein LOC129583481 [Paramacrobiotus metropolitanus] | diamond | 165 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 32112618 | 32112618 | PRJNA980585_P_NODE_31698_length_275_cov_1.321782_g31444_i0 | PRJNA980585 | 31698 | 275 | 1.321782 | 3.6349005 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 66.6 | 2.19e-10 | NR | OQV22728.1 | 2072580 | g31444 | i0 | 40.7 | 0.938181818181818 | 86 | 49 | 93.8 | 2 | 2 | 259 | 279 | 362 | OQV22728.1 Unconventional myosin-Id [Hypsibius exemplaris] | diamond | 258 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 32524183 | 32524183 | PRJNA980585_P_NODE_41619_length_251_cov_0.865169_g41365_i0 | PRJNA980585 | 41619 | 251 | 0.865169 | 2.17157419 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 67.8 | 4.05e-12 | NR | OWA49937.1 | 2072580 | g41365 | i0 | 50 | 1.19521912350598 | 50 | 25 | 59.8 | 0 | 198 | 49 | 27 | 76 | OWA49937.1 hypothetical protein BV898_14471 [Hypsibius exemplaris] | diamond | 300 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris |
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);;