contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA1059246" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7829818 | 7829818 | PRJNA1059246_P_NODE_52127_length_283_cov_1.100000_g51501_i0 | PRJNA1059246 | 52127 | 283 | 1.1 | 3.113 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 159 | 3.16e-43 | NR | GAV03839.1 | 947166 | g51501 | i0 | 79.6 | 3.9434628975265 | 93 | 19 | 98.6 | 0 | 280 | 2 | 182 | 274 | GAV03839.1 hypothetical protein RvY_14214 [Ramazzottius varieornatus] | diamond | 1116 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 27351756 | 27351756 | PRJNA1059246_P_NODE_8323_length_842_cov_1.266580_g7812_i0 | PRJNA1059246 | 8323 | 842 | 1.26658 | 10.6646036 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 233 | 4.0899999999999994e-67 | NR | GAV03424.1 | 947166 | g7812 | i0 | 47.6 | 2.69714964370546 | 252 | 120 | 89.1 | 6 | 3 | 752 | 28 | 269 | GAV03424.1 hypothetical protein RvY_13849-2 [Ramazzottius varieornatus] | diamond | 2271 | 233 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 27541103 | 27541103 | PRJNA1059246_P_NODE_8744_length_820_cov_2.692102_g8229_i0 | PRJNA1059246 | 8744 | 820 | 2.692102 | 22.0752364 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 184 | 3.09e-53 | NR | XP_055350779.1 | 2943436 | g8229 | i0 | 51.4 | 0.669512195121951 | 183 | 86 | 66.6 | 3 | 626 | 81 | 94 | 274 | XP_055350779.1 uncharacterized protein LOC129597320 [Paramacrobiotus metropolitanus] | diamond | 549 | 184 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 27667408 | 27667408 | PRJNA1059246_P_NODE_38524_length_345_cov_1.106618_g37898_i0 | PRJNA1059246 | 38524 | 345 | 1.106618 | 3.8178321 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 51.6 | 8.64e-5 | NR | XP_055351250.1 | 2943436 | g37898 | i0 | 37.1 | 1.30434782608696 | 89 | 52 | 76.5 | 2 | 336 | 73 | 3 | 88 | XP_055351250.1 sequestosome-1-like [Paramacrobiotus metropolitanus] | diamond | 450 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 28361767 | 28361767 | PRJNA1059246_P_NODE_42266_length_325_cov_1.222222_g41640_i0 | PRJNA1059246 | 42266 | 325 | 1.222222 | 3.9722215 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 154 | 1.53e-44 | NR | GAV00527.1 | 947166 | g41640 | i0 | 70 | 0.923076923076923 | 100 | 29 | 92.3 | 1 | 300 | 1 | 89 | 187 | GAV00527.1 hypothetical protein RvY_11360 [Ramazzottius varieornatus] | diamond | 300 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 28456721 | 28456721 | PRJNA1059246_P_NODE_33266_length_376_cov_1.749175_g32640_i0 | PRJNA1059246 | 33266 | 376 | 1.749175 | 6.576898 | Hypsibius exemplaris | 2072580 | Tardigrada | other_Eukaryota | 78.2 | 6.4e-15 | NR | OWA50473.1 | 2072580 | g32640 | i0 | 61.7 | 1.53989361702128 | 60 | 23 | 47.9 | 0 | 179 | 358 | 1 | 60 | OWA50473.1 putative Glutathione S-transferase 1 [Hypsibius exemplaris] | diamond | 579 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 29561573 | 29561573 | PRJNA1059246_P_NODE_66970_length_246_cov_0.890173_g66344_i0 | PRJNA1059246 | 66970 | 246 | 0.890173 | 2.18982558 | Ramazzottius varieornatus | 947166 | Tardigrada | other_Eukaryota | 43.5 | 0.00503 | NR | GAV02702.1 | 947166 | g66344 | i0 | 64.3 | 1 | 28 | 10 | 34.1 | 0 | 245 | 162 | 67 | 94 | GAV02702.1 hypothetical protein RvY_13233 [Ramazzottius varieornatus] | diamond | 246 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Ramazzottiidae | Ramazzottius | Ramazzottius varieornatus | |
| 29940834 | 29940834 | PRJNA1059246_P_NODE_61551_length_251_cov_0.887640_g60925_i0 | PRJNA1059246 | 61551 | 251 | 0.88764 | 2.2279764 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 55.8 | 9.59e-7 | NR | XP_055329624.1 | 2943436 | g60925 | i0 | 50 | 0.717131474103586 | 60 | 30 | 71.7 | 0 | 72 | 251 | 346 | 405 | XP_055329624.1 interferon-inducible GTPase 5-like [Paramacrobiotus metropolitanus] | diamond | 180 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 30098467 | 30098467 | PRJNA1059246_P_NODE_44112_length_316_cov_1.267490_g43486_i0 | PRJNA1059246 | 44112 | 316 | 1.26749 | 4.0052684 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 76.6 | 7.75e-14 | NR | XP_055329972.1 | 2943436 | g43486 | i0 | 46.5 | 0.939873417721519 | 99 | 50 | 94 | 3 | 314 | 18 | 152 | 247 | XP_055329972.1 uncharacterized protein LOC129582483 [Paramacrobiotus metropolitanus] | diamond | 297 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 30880263 | 30880263 | PRJNA1059246_P_NODE_71174_length_242_cov_0.911243_g70548_i0 | PRJNA1059246 | 71174 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 60.1 | 2.8e-8 | NR | OQV16299.1 | 2072580 | g70548 | i0 | 55.1 | 1.77272727272727 | 49 | 22 | 60.7 | 0 | 157 | 11 | 65 | 113 | OQV16299.1 hypothetical protein BV898_09607 [Hypsibius exemplaris] | diamond | 429 | 60.5 | 0.993388429752066 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Hypsibiidae | Hypsibius | Hypsibius exemplaris | |
| 31109533 | 31109533 | PRJNA1059246_P_NODE_69015_length_244_cov_0.900585_g68389_i0 | PRJNA1059246 | 69015 | 244 | 0.900585 | 2.1974274 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 53.5 | 4.58e-6 | NR | XP_055351563.1 | 2943436 | g68389 | i0 | 47.5 | 1.5 | 61 | 32 | 75 | 0 | 244 | 62 | 196 | 256 | XP_055351563.1 syntaxin-12-like isoform X3 [Paramacrobiotus metropolitanus] | diamond | 366 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus |
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);;