contig_metadata
10 rows where bioproject = "PRJNA1196384" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1597322 | 1597322 | PRJNA1196384_S_NODE_542_length_507_cov_3.936170_g480_i0 | PRJNA1196384 | 542 | 507 | 3.93617 | 19.9563819 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 234 | 5.94e-76 | NR | XP_004368153.1 | 1257118 | g480 | i0 | 72 | 1.84615384615385 | 157 | 39 | 89.9 | 2 | 507 | 52 | 5 | 161 | XP_004368153.1 ribosomal protein S17, putative [Acanthamoeba castellanii str. Neff] | diamond | 936 | 234 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 5425912 | 5425912 | PRJNA1196384_S_NODE_6445_length_165_cov_1.218750_g6381_i0 | PRJNA1196384 | 6445 | 165 | 1.21875 | 2.0109375 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 104 | 3.76e-18 | NTclustered | gi|470483818|ref|XM_004343959.1| | 1257118 | g6381 | i0 | 78.659 | 33.7393939393939 | 164 | 29 | 99 | 2 | 1 | 164 | 187 | 344 | Acanthamoeba castellanii str. Neff Vtype ATPase, C subunit (ACA1_053290), partial mRNA | blastn | 5567 | 104 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 11801246 | 11801246 | PRJNA1196384_S_NODE_5570_length_174_cov_2.795620_g5506_i0 | PRJNA1196384 | 5570 | 174 | 2.79562 | 4.8643788 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 322 | 1.01e-83 | NTclustered | gi|571331049|gb|KF895376.1| | 1443144 | g5506 | i0 | 100 | 93.5747126436782 | 174 | 0 | 100 | 0 | 1 | 174 | 490 | 317 | Paravannella minima strain CCAP 1533/1 clone 1 actin gene, partial cds | blastn | 16282 | 322 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima | |||
| 18174263 | 18174263 | PRJNA1196384_S_NODE_1135_length_362_cov_2.815385_g1071_i0 | PRJNA1196384 | 1135 | 362 | 2.815385 | 10.1916937 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 175 | 3.4899999999999995e-54 | NR | XP_004339588.1 | 1257118 | g1071 | i0 | 85.3 | 0.845303867403315 | 102 | 15 | 84.5 | 0 | 308 | 3 | 8 | 109 | XP_004339588.1 60S ribosomal protein, putative [Acanthamoeba castellanii str. Neff] | diamond | 306 | 175 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 20724006 | 20724006 | PRJNA1196384_S_NODE_1137_length_362_cov_1.923077_g1073_i0 | PRJNA1196384 | 1137 | 362 | 1.923077 | 6.96153874 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 154 | 1.5499999999999998e-42 | NR | XP_004341586.1 | 1257118 | g1073 | i0 | 67.3 | 1.61602209944751 | 101 | 33 | 83.7 | 0 | 58 | 360 | 245 | 345 | XP_004341586.1 elongation factor 1-gamma family protein [Acanthamoeba castellanii str. Neff] | diamond | 585 | 154 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27072411 | 27072411 | PRJNA1196384_S_NODE_4642_length_187_cov_1.293333_g4578_i0 | PRJNA1196384 | 4642 | 187 | 1.293333 | 2.41853271 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 95.9 | 3.78e-22 | NR | XP_004341414.1 | 1257118 | g4578 | i0 | 69.4 | 0.994652406417112 | 62 | 19 | 99.5 | 0 | 186 | 1 | 5 | 66 | XP_004341414.1 Factin-capping protein subunit alpha-2, putative [Acanthamoeba castellanii str. Neff] | diamond | 186 | 95.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29219982 | 29219982 | PRJNA1196384_S_NODE_6449_length_165_cov_1.210938_g6385_i0 | PRJNA1196384 | 6449 | 165 | 1.210938 | 1.9980477 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 87 | 6.34e-20 | NR | XP_004351535.1 | 1257118 | g6385 | i0 | 77.8 | 0.981818181818182 | 54 | 12 | 98.2 | 0 | 4 | 165 | 26 | 79 | XP_004351535.1 actinrelated protein ARPC3, putative [Acanthamoeba castellanii str. Neff] | diamond | 162 | 87 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29535551 | 29535551 | PRJNA1196384_S_NODE_3390_length_213_cov_1.301136_g3326_i0 | PRJNA1196384 | 3390 | 213 | 1.301136 | 2.77141968 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 51.6 | 1.81e-5 | NR | XP_004337281.1 | 1257118 | g3326 | i0 | 48.9 | 0.633802816901408 | 45 | 23 | 63.4 | 0 | 212 | 78 | 378 | 422 | XP_004337281.1 calponin domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 135 | 51.6 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30040866 | 30040866 | PRJNA1196384_S_NODE_2191_length_262_cov_3.644444_g2127_i0 | PRJNA1196384 | 2191 | 262 | 3.644444 | 9.54844328 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 50.8 | 6.53e-5 | NR | ALV66539.1 | 5755 | g2127 | i0 | 50.9 | 1.95801526717557 | 57 | 28 | 65.3 | 0 | 246 | 76 | 392 | 448 | ALV66539.1 arginine methyltransferase 5 [Acanthamoeba castellanii] | diamond | 513 | 50.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31020412 | 31020412 | PRJNA1196384_S_NODE_4575_length_188_cov_1.403974_g4511_i0 | PRJNA1196384 | 4575 | 188 | 1.403974 | 2.63947112 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 81.3 | 1.32e-16 | NR | XP_004355015.1 | 1257118 | g4511 | i0 | 63.9 | 1.93085106382979 | 61 | 22 | 97.3 | 0 | 188 | 6 | 208 | 268 | XP_004355015.1 Factin-capping protein subunit beta, putative [Acanthamoeba castellanii str. Neff] | diamond | 363 | 81.3 | 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);;