contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA229468" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9295360 | 9295360 | PRJNA229468_S_NODE_428_length_239_cov_2.336842_g415_i0 | PRJNA229468 | 428 | 239 | 2.336842 | 5.58505238 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 147 | 2.5e-41 | NR | XP_004338972.1 | 1257118 | g415 | i0 | 88.6 | 14.5983263598326 | 79 | 9 | 99.2 | 0 | 237 | 1 | 10 | 88 | XP_004338972.1 adenine nucleotide translocator, putative [Acanthamoeba castellanii str. Neff] | diamond | 3489 | 147 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 10571336 | 10571336 | PRJNA229468_S_NODE_329_length_274_cov_1.395556_g316_i0 | PRJNA229468 | 329 | 274 | 1.395556 | 3.82382344 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 160 | 4.69e-49 | NR | XP_004339588.1 | 1257118 | g316 | i0 | 85.7 | 8.96715328467153 | 91 | 13 | 99.6 | 0 | 273 | 1 | 12 | 102 | XP_004339588.1 60S ribosomal protein, putative [Acanthamoeba castellanii str. Neff] | diamond | 2457 | 160 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 10571340 | 10571340 | PRJNA229468_S_NODE_729_length_192_cov_1.251748_g716_i0 | PRJNA229468 | 729 | 192 | 1.251748 | 2.40335616 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 103 | 7.04e-25 | NR | XP_004356622.1 | 1257118 | g716 | i0 | 76.6 | 1 | 64 | 15 | 100 | 0 | 192 | 1 | 226 | 289 | XP_004356622.1 mitochondrial phosphate transporter, putative [Acanthamoeba castellanii str. Neff] | diamond | 192 | 103 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 17634187 | 17634187 | PRJNA229468_S_NODE_774_length_188_cov_1.201439_g761_i0 | PRJNA229468 | 774 | 188 | 1.201439 | 2.25870532 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 92 | 7.58e-20 | NR | XP_004348463.1 | 1257118 | g761 | i0 | 72.1 | 3.8936170212766 | 61 | 17 | 97.3 | 0 | 5 | 187 | 289 | 349 | XP_004348463.1 DEAD box RNA helicase [Acanthamoeba castellanii str. Neff] | diamond | 732 | 92 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19493250 | 19493250 | PRJNA229468_S_NODE_96_length_504_cov_1.114286_g84_i0 | PRJNA229468 | 96 | 504 | 1.114286 | 5.61600144 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 155 | 3.5799999999999993e-43 | NR | XP_004341795.1 | 1257118 | g84 | i0 | 63.3 | 2.01190476190476 | 169 | 61 | 100 | 1 | 1 | 504 | 38 | 206 | XP_004341795.1 guanine nucleotide-binding protein beta subunit, putative [Acanthamoeba castellanii str. Neff] | diamond | 1014 | 155 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26648403 | 26648403 | PRJNA229468_S_NODE_761_length_189_cov_1.107143_g748_i0 | PRJNA229468 | 761 | 189 | 1.107143 | 2.09250027 | root | 1 | Root_unresolved | Root_unresolved | 87 | 2.18e-18 | NR | XP_004336164.1 | 1257118 | g748 | i0 | 71 | 6.88888888888889 | 62 | 18 | 98.4 | 0 | 188 | 3 | 166 | 227 | XP_004336164.1 alcohol dehydrogenase GroESlike domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 1302 | 87.4 | 0.995423340961098 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28260135 | 28260135 | PRJNA229468_S_NODE_106_length_483_cov_4.246544_g94_i0 | PRJNA229468 | 106 | 483 | 4.246544 | 20.51080752 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 171 | 1.62e-51 | NR | 7SOG_A | 5755 | g94 | i0 | 59.4 | 5.85093167701863 | 133 | 54 | 82.6 | 0 | 5 | 403 | 3 | 135 | 7SOG_A Chain A, Actophorin [Acanthamoeba castellanii] | diamond | 2826 | 172 | 0.994186046511628 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29063598 | 29063598 | PRJNA229468_S_NODE_348_length_267_cov_2.211009_g335_i0 | PRJNA229468 | 348 | 267 | 2.211009 | 5.90339403 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 155 | 4.52e-47 | NR | XP_004352812.1 | 1257118 | g335 | i0 | 85.2 | 2.97752808988764 | 88 | 13 | 98.9 | 0 | 1 | 264 | 2 | 89 | XP_004352812.1 ribosomal L37ae protein family [Acanthamoeba castellanii str. Neff] | diamond | 795 | 155 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29947671 | 29947671 | PRJNA229468_S_NODE_151_length_394_cov_1.342029_g138_i0 | PRJNA229468 | 151 | 394 | 1.342029 | 5.28759426 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 135 | 4.9000000000000005e-34 | NR | XP_004338648.1 | 1257118 | g138 | i0 | 53.4 | 2.70304568527919 | 116 | 53 | 88.3 | 1 | 387 | 40 | 226 | 340 | XP_004338648.1 ABC transporter, ATPbinding domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 1065 | 135 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30091552 | 30091552 | PRJNA229468_S_NODE_352_length_266_cov_1.410138_g339_i0 | PRJNA229468 | 352 | 266 | 1.410138 | 3.75096708 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 119 | 6.969999999999999e-32 | NR | XP_004358287.1 | 1257118 | g339 | i0 | 65.9 | 3.86842105263158 | 88 | 29 | 99.2 | 1 | 2 | 265 | 6 | 92 | XP_004358287.1 eukaryotic ribosomal protein L18, putative [Acanthamoeba castellanii str. Neff] | diamond | 1029 | 119 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30471075 | 30471075 | PRJNA229468_S_NODE_353_length_266_cov_1.410138_g340_i0 | PRJNA229468 | 353 | 266 | 1.410138 | 3.75096708 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 57.8 | 2.45e-7 | NR | ALV66539.1 | 5755 | g340 | i0 | 50 | 3.43984962406015 | 74 | 31 | 82.3 | 3 | 255 | 37 | 368 | 436 | ALV66539.1 arginine methyltransferase 5 [Acanthamoeba castellanii] | diamond | 915 | 57.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31242982 | 31242982 | PRJNA229468_S_NODE_95_length_505_cov_2.032895_g83_i0 | PRJNA229468 | 95 | 505 | 2.032895 | 10.26611975 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 184 | 4.649999999999998e-55 | NR | XP_004340229.1 | 1257118 | g83 | i0 | 62 | 1.01584158415842 | 171 | 56 | 98 | 4 | 495 | 1 | 1 | 168 | XP_004340229.1 ribosomal protein L6e, putative [Acanthamoeba castellanii str. Neff] | diamond | 513 | 184 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;