contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax_phylum = "Parabasalia"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1892297 | 1892297 | PRJNA641707_P_NODE_331542_length_154_cov_2.190476_g328879_i0 | PRJNA641707 | 331542 | 154 | 2.190476 | 3.37333304 | Tritrichomonas augusta | 5725 | Parabasalia | other_Eukaryota | 150 | 4.359999999999999e-32 | NTclustered | gi|2274983416|gb|OP038912.1| | 5725 | g328879 | i0 | 85.235 | 3.77272727272727 | 149 | 18 | 95 | 4 | 1 | 147 | 2659 | 2513 | Tritrichomonas augusta isolate T1 large subunit ribosomal RNA gene, partial sequence | blastn | 581 | 150 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas augusta | |||
| 4444761 | 4444761 | PRJNA641707_P_NODE_69784_length_251_cov_4.559406_g67121_i0 | PRJNA641707 | 69784 | 251 | 4.559406 | 11.44410906 | Tritrichomonas muris | 5726 | Parabasalia | other_Eukaryota | 309 | 1.22e-79 | NTclustered | gi|10747|emb|Z18255.1| | 5726 | g67121 | i0 | 89.754 | 4.70119521912351 | 244 | 22 | 97 | 2 | 9 | 251 | 20 | 261 | Tritrichomonas muris 28S ribosomal RNA | blastn | 1180 | 309 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas muris | |||
| 5715317 | 5715317 | PRJNA641707_P_NODE_140765_length_241_cov_11.078125_g138102_i0 | PRJNA641707 | 140765 | 241 | 11.078125 | 26.69828125 | Tritrichomonas muris | 5726 | Parabasalia | other_Eukaryota | 435 | 1.84e-117 | NTclustered | gi|62466089|gb|AY886846.1| | 5726 | g138102 | i0 | 100 | 91.5186721991701 | 235 | 0 | 98 | 0 | 7 | 241 | 441 | 675 | Tritrichomonas muris clone 1-6 16S-like ribosomal RNA gene, partial sequence | blastn | 22056 | 435 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas muris | |||
| 5720072 | 5720072 | PRJNA641707_P_NODE_4585_length_965_cov_206.558952_g3344_i0 | PRJNA641707 | 4585 | 965 | 206.558952 | 1993.2938868 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 67.6 | 3.49e-6 | NTclustered | gi|2806480431|ref|XM_068495080.1| | 1144522 | g3344 | i0 | 88.889 | 0.52020725388601 | 54 | 6 | 6 | 0 | 369 | 422 | 1551 | 1498 | Tritrichomonas foetus dnaK protein (TRFO_09824), partial mRNA | blastn | 502 | 67.6 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 6995154 | 6995154 | PRJNA641707_P_NODE_49066_length_308_cov_7.976834_g46409_i0 | PRJNA641707 | 49066 | 308 | 7.976834 | 24.56864872 | Trichomonas vaginalis | 5722 | Parabasalia | other_Eukaryota | 58.4 | 6.18e-4 | NTclustered | gi|2319615616|ref|XR_007835995.1| | 412133 | g46409 | i0 | 88 | 0.616883116883117 | 50 | 4 | 16 | 2 | 163 | 211 | 2605 | 2557 | Trichomonas vaginalis G3 23S ribosomal RNA (TVAGG3_0034210), rRNA | blastn | 190 | 58.4 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 8266637 | 8266637 | PRJNA641707_P_NODE_212287_length_195_cov_5.075342_g209624_i0 | PRJNA641707 | 212287 | 195 | 5.075342 | 9.8969169 | Simplicimonas similis | 723912 | Parabasalia | other_Eukaryota | 246 | 7.2e-61 | NTclustered | gi|530775353|gb|KC953858.1| | 723912 | g209624 | i0 | 89.423 | 24.1692307692308 | 208 | 4 | 97 | 3 | 2 | 191 | 254 | 47 | Simplicimonas similis isolate PCC3007 18S ribosomal RNA gene, partial sequence | blastn | 4713 | 246 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Simplicimonadidae | Simplicimonas | Simplicimonas similis | |||
| 13365934 | 13365934 | PRJNA641707_P_NODE_144471_length_240_cov_7.947644_g141808_i0 | PRJNA641707 | 144471 | 240 | 7.947644 | 19.0743456 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2806455650|ref|XM_068492053.1| | 1144522 | g141808 | i0 | 100 | 0.120833333333333 | 29 | 0 | 12 | 0 | 66 | 94 | 5492 | 5464 | Tritrichomonas foetus uncharacterized protein (TRFO_04699), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 17190137 | 17190137 | PRJNA641707_P_NODE_16274_length_538_cov_5.746421_g13892_i0 | PRJNA641707 | 16274 | 538 | 5.746421 | 30.91574498 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 87.9 | 1.45e-12 | NTclustered | gi|2806440106|ref|XM_068497114.1| | 1144522 | g13892 | i0 | 82.857 | 0.195167286245353 | 105 | 10 | 19 | 7 | 417 | 517 | 7259 | 7159 | Tritrichomonas foetus Dynein heavy chain family protein (TRFO_13228), partial mRNA | blastn | 105 | 87.9 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 18469458 | 18469458 | PRJNA641707_P_NODE_77435_length_246_cov_10.096447_g74772_i0 | PRJNA641707 | 77435 | 246 | 10.096447 | 24.83725962 | Tritrichomonas sp. BR-2011 | 1109411 | Parabasalia | other_Eukaryota | 134 | 7.71e-27 | NTclustered | gi|357363755|gb|JF927156.1| | 1109411 | g74772 | i0 | 97.468 | 30.3617886178862 | 79 | 1 | 32 | 1 | 149 | 226 | 1981 | 1903 | Tritrichomonas sp. BR-2011 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 7469 | 134 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas sp. BR-2011 | |||
| 19009562 | 19009562 | PRJNA641707_P_NODE_58615_length_278_cov_11.777293_g55954_i0 | PRJNA641707 | 58615 | 278 | 11.777293 | 32.74087454 | Tritrichomonas | 5723 | Parabasalia | other_Eukaryota | 322 | 1.77e-83 | NTclustered | gi|2263042901|gb|ON907819.1| | 1915356 | g55954 | i0 | 100 | 79.1223021582734 | 174 | 0 | 97 | 0 | 1 | 174 | 339 | 166 | Tritrichomonas musculus isolate LT small subunit ribosomal RNA gene, partial sequence | blastn | 21996 | 322 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas musculus | |||
| 19741874 | 19741874 | PRJNA641707_P_NODE_28696_length_404_cov_10.259155_g26095_i0 | PRJNA641707 | 28696 | 404 | 10.259155 | 41.4469862 | Trichomonas vaginalis | 5722 | Parabasalia | other_Eukaryota | 95.3 | 6.35e-15 | NTclustered | gi|123423503|ref|XM_001306390.1| | 412133 | g26095 | i0 | 79.167 | 0.356435643564356 | 144 | 24 | 35 | 4 | 66 | 206 | 912 | 772 | Trichomonas vaginalis G3 alpha-amylase family (TVAGG3_0367540), partial mRNA | blastn | 144 | 95.3 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 23565499 | 23565499 | PRJNA641707_P_NODE_192339_length_198_cov_10.637584_g189676_i0 | PRJNA641707 | 192339 | 198 | 10.637584 | 21.06241632 | Tritrichomonas augusta | 5725 | Parabasalia | other_Eukaryota | 158 | 3.54e-34 | NTclustered | gi|2274983416|gb|OP038912.1| | 5725 | g189676 | i0 | 95.876 | 4.41414141414141 | 97 | 4 | 49 | 0 | 96 | 192 | 1216 | 1120 | Tritrichomonas augusta isolate T1 large subunit ribosomal RNA gene, partial sequence | blastn | 874 | 158 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas augusta |
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);;