contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA906294" and tax_phylum = "Fornicata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26897852 | 26897852 | PRJNA906294_P_NODE_155121_length_304_cov_3.636364_g151005_i0 | PRJNA906294 | 155121 | 304 | 3.636364 | 11.05454656 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 43.1 | 0.0296 | NR | GKT28178.1 | 2918883 | g151005 | i0 | 30.5 | 0.809210526315789 | 82 | 56 | 79.9 | 1 | 60 | 302 | 31 | 112 | GKT28178.1 hypothetical protein ADUPG1_000485 [Aduncisulcus paluster] | diamond | 246 | 43.1 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 28982532 | 28982532 | PRJNA906294_P_NODE_206208_length_250_cov_0.870056_g202092_i0 | PRJNA906294 | 206208 | 250 | 0.870056 | 2.17514 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 43.5 | 0.0228 | NR | GKT26054.1 | 2918883 | g202092 | i0 | 34.2 | 0.876 | 73 | 47 | 86.4 | 1 | 246 | 31 | 840 | 912 | GKT26054.1 Alanyl-tRNA synthetase [Aduncisulcus paluster] | diamond | 219 | 43.5 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 29613418 | 29613418 | PRJNA906294_P_NODE_185890_length_269_cov_1.653061_g181774_i0 | PRJNA906294 | 185890 | 269 | 1.653061 | 4.44673409 | Giardia intestinalis assemblage B | 1394984 | Fornicata | other_Eukaryota | 80.9 | 1.95e-15 | NR | KWX11382.1 | 1394984 | g181774 | i0 | 46.6 | 0.981412639405205 | 88 | 47 | 98.1 | 0 | 269 | 6 | 543 | 630 | KWX11382.1 Cytosolic HSP70 [Giardia intestinalis assemblage B] | diamond | 264 | 80.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29898070 | 29898070 | PRJNA906294_P_NODE_118871_length_366_cov_1.040956_g114756_i0 | PRJNA906294 | 118871 | 366 | 1.040956 | 3.80989896 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 47.8 | 0.00247 | NR | GKT35541.1 | 2918883 | g114756 | i0 | 43.4 | 1.09836065573771 | 53 | 25 | 43.4 | 1 | 262 | 104 | 255 | 302 | GKT35541.1 hypothetical protein ADUPG1_008684, partial [Aduncisulcus paluster] | diamond | 402 | 47.8 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 30561244 | 30561244 | PRJNA906294_P_NODE_233913_length_229_cov_2.801282_g229797_i0 | PRJNA906294 | 233913 | 229 | 2.801282 | 6.41493578 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 60.5 | 1.41e-8 | NR | XP_001704877.1 | 5741 | g229797 | i0 | 46.6 | 1.51965065502183 | 58 | 31 | 76 | 0 | 175 | 2 | 72 | 129 | XP_001704877.1 Cathepsin B [Giardia intestinalis] | diamond | 348 | 60.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31192988 | 31192988 | PRJNA906294_P_NODE_131555_length_341_cov_1.078358_g127439_i0 | PRJNA906294 | 131555 | 341 | 1.078358 | 3.67720078 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 76.3 | 1.26e-13 | NR | KAG9390544.1 | 201153 | g127439 | i0 | 45.5 | 0.774193548387097 | 88 | 39 | 75.7 | 2 | 7 | 264 | 32 | 112 | KAG9390544.1 WD domain, G-beta repeat [Carpediemonas membranifera] | diamond | 264 | 76.3 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31738414 | 31738414 | PRJNA906294_P_NODE_45497_length_756_cov_2.204978_g41646_i0 | PRJNA906294 | 45497 | 756 | 2.204978 | 16.66963368 | root | 1 | Root_unresolved | Root_unresolved | 123 | 5.29e-29 | NR | KAG9390019.1 | 201153 | g41646 | i0 | 29.1 | 1.89285714285714 | 251 | 176 | 98.8 | 1 | 9 | 755 | 40 | 290 | KAG9390019.1 MAC/Perforin domain [Carpediemonas membranifera] | diamond | 1431 | 123 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31794122 | 31794122 | PRJNA906294_P_NODE_56757_length_641_cov_1.399648_g52713_i0 | PRJNA906294 | 56757 | 641 | 1.399648 | 8.97174368 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 91.3 | 3.28e-17 | NR | CAK8812246.1 | 28002 | g52713 | i0 | 33 | 4.94227769110764 | 221 | 123 | 97.8 | 9 | 10 | 636 | 1626 | 1833 | CAK8812246.1 HINF_059753 [Hexamita inflata] | diamond | 3168 | 91.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32142427 | 32142427 | PRJNA906294_P_NODE_216758_length_246_cov_0.878613_g212642_i0 | PRJNA906294 | 216758 | 246 | 0.878613 | 2.16138798 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 67 | 7.91e-11 | NR | ESU45417.1 | 5741 | g212642 | i0 | 41.8 | 3.68292682926829 | 79 | 42 | 96.3 | 2 | 244 | 8 | 98 | 172 | ESU45417.1 Cathepsin B-like cysteine proteinase, partial [Giardia intestinalis] | diamond | 906 | 67 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32899944 | 32899944 | PRJNA906294_P_NODE_129440_length_345_cov_0.893382_g125324_i0 | PRJNA906294 | 129440 | 345 | 0.893382 | 3.0821679 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 46.6 | 0.0053 | NR | KAG9394743.1 | 201153 | g125324 | i0 | 34.5 | 0.756521739130435 | 87 | 55 | 73.9 | 2 | 88 | 342 | 323 | 409 | KAG9394743.1 MAC/Perforin domain [Carpediemonas membranifera] | diamond | 261 | 46.6 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera |
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);;