contig_metadata
12 rows where bioproject = "PRJEB64798", tax_clade = "Metamonada" and tax_phylum = "Preaxostyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1402064 | 1402064 | PRJEB64798_P_NODE_180062_length_174_cov_4.840000_g178296_i0 | PRJEB64798 | 180062 | 174 | 4.84 | 8.4216 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 86.3 | 6.67e-18 | NR | WCZ58299.1 | 1709329 | g178296 | i0 | 72.5 | 2.62068965517241 | 51 | 14 | 87.9 | 0 | 170 | 18 | 242 | 292 | WCZ58299.1 isoleucyl-tRNA synthetase [Paratrimastix eleionoma] | diamond | 456 | 86.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix eleionoma | ||||
| 9055083 | 9055083 | PRJEB64798_P_NODE_197908_length_168_cov_1.386555_g196142_i0 | PRJEB64798 | 197908 | 168 | 1.386555 | 2.3294124 | uncultured Trimastix | 1275958 | Preaxostyla | other_Eukaryota | 267 | 4.63e-67 | NTclustered | gi|469401985|emb|HF568852.1| | 1275958 | g196142 | i0 | 95.783 | 72.4107142857143 | 166 | 5 | 98 | 2 | 2 | 165 | 297 | 132 | Uncultured Trimastix partial 18S rRNA gene, clone RifleRDL7 | blastn | 12165 | 267 | 1 | Eukaryota | Metamonada | Preaxostyla | Trimastigidae | Trimastix | uncultured Trimastix | ||||
| 21805198 | 21805198 | PRJEB64798_P_NODE_242318_length_154_cov_5.542857_g240552_i0 | PRJEB64798 | 242318 | 154 | 5.542857 | 8.53599978 | uncultured Oxymonadida sp. | 413579 | Preaxostyla | other_Eukaryota | 137 | 3.39e-28 | NTclustered | gi|118766745|gb|DQ925108.1| | 413579 | g240552 | i0 | 83.333 | 84.3506493506493 | 150 | 24 | 97 | 1 | 1 | 150 | 261 | 113 | Oxymonadida environmental sample clone 20 beta-tubulin (Btub) mRNA, partial cds | blastn | 12990 | 137 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | uncultured Oxymonadida sp. | |||||
| 27033663 | 27033663 | PRJEB64798_P_NODE_147202_length_190_cov_1.475177_g145436_i0 | PRJEB64798 | 147202 | 190 | 1.475177 | 2.8028363 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 63.9 | 1.82e-10 | NR | KAJ4457259.1 | 342808 | g145436 | i0 | 69.6 | 0.726315789473684 | 46 | 14 | 72.6 | 0 | 184 | 47 | 157 | 202 | KAJ4457259.1 putative 60S ribosomal protein L15 [Paratrimastix pyriformis] | diamond | 138 | 63.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27254925 | 27254925 | PRJEB64798_P_NODE_196023_length_168_cov_6.731092_g194257_i0 | PRJEB64798 | 196023 | 168 | 6.731092 | 11.30823456 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 43.1 | 0.00999 | NR | XP_067727911.1 | 2049356 | g194257 | i0 | 37.5 | 1.82142857142857 | 48 | 30 | 85.7 | 0 | 163 | 20 | 3818 | 3865 | XP_067727911.1 putative Protein ITR-1 [Monocercomonoides exilis] | diamond | 306 | 43.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 27634091 | 27634091 | PRJEB64798_P_NODE_135184_length_196_cov_2.027211_g133418_i0 | PRJEB64798 | 135184 | 196 | 2.027211 | 3.97333356 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 63.5 | 1.11e-10 | NR | KAK2950946.1 | 2049346 | g133418 | i0 | 57.4 | 1.43877551020408 | 47 | 19 | 71.9 | 1 | 142 | 2 | 55 | 100 | KAK2950946.1 hypothetical protein BLNAU_14136 [Blattamonas nauphoetae] | diamond | 282 | 63.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 27665777 | 27665777 | PRJEB64798_P_NODE_175344_length_176_cov_5.574803_g173578_i0 | PRJEB64798 | 175344 | 176 | 5.574803 | 9.81165328 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 52 | 8.27e-6 | NR | KAK2957421.1 | 2049346 | g173578 | i0 | 68.8 | 1.61931818181818 | 32 | 10 | 54.5 | 0 | 172 | 77 | 1033 | 1064 | KAK2957421.1 putative rRNA 2'-O-methyltransferase fibrillarin [Blattamonas nauphoetae] | diamond | 285 | 52 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28391893 | 28391893 | PRJEB64798_P_NODE_46926_length_286_cov_13.983122_g45161_i0 | PRJEB64798 | 46926 | 286 | 13.983122 | 39.99172892 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 50.1 | 6.34e-5 | NR | KAK2942687.1 | 2049346 | g45161 | i0 | 66.7 | 0.409090909090909 | 39 | 13 | 40.9 | 0 | 3 | 119 | 34 | 72 | KAK2942687.1 hypothetical protein BLNAU_22414 [Blattamonas nauphoetae] | diamond | 117 | 50.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28739085 | 28739085 | PRJEB64798_P_NODE_153467_length_186_cov_21.145985_g151701_i0 | PRJEB64798 | 153467 | 186 | 21.145985 | 39.3315321 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 44.3 | 0.00366 | NR | KAA6397624.1 | 222440 | g151701 | i0 | 69.2 | 8.38709677419355 | 26 | 8 | 41.9 | 0 | 80 | 3 | 130 | 155 | KAA6397624.1 MAG: hypothetical protein EZS28_006851 [Streblomastix strix] | diamond | 1560 | 44.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 30096911 | 30096911 | PRJEB64798_P_NODE_28912_length_366_cov_4.747634_g27156_i0 | PRJEB64798 | 28912 | 366 | 4.747634 | 17.37634044 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 65.5 | 1.7e-10 | NR | XP_067726936.1 | 2049356 | g27156 | i0 | 40.7 | 2.07377049180328 | 86 | 50 | 70.5 | 1 | 361 | 104 | 49 | 133 | XP_067726936.1 putative eucarytic translation initiation factor 5A [Monocercomonoides exilis] | diamond | 759 | 65.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 31266013 | 31266013 | PRJEB64798_P_NODE_146775_length_190_cov_2.900709_g145009_i0 | PRJEB64798 | 146775 | 190 | 2.900709 | 5.5113471 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 53.5 | 2.69e-6 | NR | KAK2945251.1 | 2049346 | g145009 | i0 | 53.7 | 3.17368421052632 | 41 | 19 | 64.7 | 0 | 185 | 63 | 261 | 301 | KAK2945251.1 putative 60S ribosomal protein L7a-1 [Blattamonas nauphoetae] | diamond | 603 | 53.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 32176732 | 32176732 | PRJEB64798_P_NODE_90378_length_212_cov_6.631902_g88612_i0 | PRJEB64798 | 90378 | 212 | 6.631902 | 14.05963224 | root | 1 | Root_unresolved | Root_unresolved | 43.5 | 0.0125 | NR | KAJ4460304.1 | 342808 | g88612 | i0 | 55.2 | 2.05188679245283 | 29 | 13 | 41 | 0 | 208 | 122 | 247 | 275 | KAJ4460304.1 putative Neutral ceramidase B [Paratrimastix pyriformis] | diamond | 435 | 43.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis |
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);;