contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1120060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4072928 | 4072928 | PRJNA1120060_P_NODE_2016424_length_272_cov_1.798995_g1998391_i0 | PRJNA1120060 | 2016424 | 272 | 1.798995 | 4.8932664 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|2806486642|ref|XM_068512997.1| | 1144522 | g1998391 | i0 | 100 | 0.102941176470588 | 28 | 0 | 10 | 0 | 46 | 73 | 932 | 959 | Tritrichomonas foetus Pumilio-family RNA binding repeat containing protein (TRFO_40095), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 4081862 | 4081862 | PRJNA1120060_P_NODE_2717744_length_248_cov_1.337143_g2699661_i0 | PRJNA1120060 | 2717744 | 248 | 1.337143 | 3.31611464 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2794901636|ref|XM_067913478.1| | 135588 | g2699661 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 52 | 79 | 3452 | 3479 | Histomonas meleagridis F/Y-rich N-terminus family protein (GO595_010764), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 5336793 | 5336793 | PRJNA1120060_P_NODE_1154745_length_311_cov_2.302521_g1136810_i0 | PRJNA1120060 | 1154745 | 311 | 2.302521 | 7.16084031 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|2806473237|ref|XM_068508858.1| | 1144522 | g1136810 | i0 | 100 | 0.090032154340836 | 28 | 0 | 9 | 0 | 3 | 30 | 2103 | 2076 | Tritrichomonas foetus uncharacterized protein (TRFO_33062), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 9201563 | 9201563 | PRJNA1120060_P_NODE_949488_length_312_cov_3.171548_g931559_i0 | PRJNA1120060 | 949488 | 312 | 3.171548 | 9.89522976 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|2794888806|ref|XM_067922278.1| | 135588 | g931559 | i0 | 100 | 0.0897435897435897 | 28 | 0 | 9 | 0 | 121 | 148 | 708 | 681 | Histomonas meleagridis Appr-1-p processing enzyme family protein (GO595_008678), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 10473745 | 10473745 | PRJNA1120060_P_NODE_715009_length_331_cov_3.693798_g697176_i0 | PRJNA1120060 | 715009 | 331 | 3.693798 | 12.22647138 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 54.7 | 0.009 | NTclustered | gi|2794864132|ref|XM_067915186.1| | 135588 | g697176 | i0 | 100 | 0.0876132930513595 | 29 | 0 | 9 | 0 | 55 | 83 | 453 | 425 | Histomonas meleagridis uncharacterized protein (GO595_002293), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 11726647 | 11726647 | PRJNA1120060_P_NODE_2175690_length_266_cov_1.316062_g2157641_i0 | PRJNA1120060 | 2175690 | 266 | 1.316062 | 3.50072492 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 80.5 | 1.12e-10 | NTclustered | gi|2794871413|ref|XM_067918610.1| | 135588 | g2157641 | i0 | 85 | 0.845864661654135 | 80 | 10 | 30 | 2 | 69 | 147 | 1548 | 1470 | Histomonas meleagridis ABC transporter family protein (GO595_005374), partial mRNA | blastn | 225 | 80.5 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 15541361 | 15541361 | PRJNA1120060_P_NODE_148653_length_508_cov_3.793103_g132849_i0 | PRJNA1120060 | 148653 | 508 | 3.793103 | 19.26896324 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 54.7 | 0.014 | NTclustered | gi|2806487924|ref|XM_068496453.1| | 1144522 | g132849 | i0 | 96.875 | 0.062992125984252 | 32 | 1 | 6 | 0 | 448 | 479 | 2968 | 2999 | Tritrichomonas foetus uncharacterized protein (TRFO_12140), partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 16811590 | 16811590 | PRJNA1120060_P_NODE_1201974_length_310_cov_3.021097_g1184034_i0 | PRJNA1120060 | 1201974 | 310 | 3.021097 | 9.3654007 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|2806476739|ref|XM_068494553.1| | 1144522 | g1184034 | i0 | 100 | 0.0903225806451613 | 28 | 0 | 9 | 0 | 39 | 66 | 772 | 745 | Tritrichomonas foetus CMGC family protein kinase (TRFO_08884), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 18107296 | 18107296 | PRJNA1120060_P_NODE_2772175_length_247_cov_0.787356_g2754091_i0 | PRJNA1120060 | 2772175 | 247 | 0.787356 | 1.94476932 | Trichomonas vaginalis | 5722 | Parabasalia | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|123475709|ref|XM_001320996.1| | 412133 | g2754091 | i0 | 100 | 0.117408906882591 | 29 | 0 | 12 | 0 | 182 | 210 | 198 | 226 | Trichomonas vaginalis G3 uncharacterized protein (TVAGG3_0061290), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 19361479 | 19361479 | PRJNA1120060_P_NODE_1277416_length_308_cov_2.859574_g1259471_i0 | PRJNA1120060 | 1277416 | 308 | 2.859574 | 8.80748792 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|2806462252|ref|XM_068504949.1| | 1144522 | g1259471 | i0 | 100 | 0.0909090909090909 | 28 | 0 | 9 | 0 | 162 | 189 | 958 | 985 | Tritrichomonas foetus uncharacterized protein (TRFO_26442), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 20645719 | 20645719 | PRJNA1120060_P_NODE_1913297_length_276_cov_2.216749_g1895275_i0 | PRJNA1120060 | 1913297 | 276 | 2.216749 | 6.11822724 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2806454082|ref|XM_068491924.1| | 1144522 | g1895275 | i0 | 100 | 0.514492753623188 | 30 | 0 | 11 | 0 | 89 | 118 | 3489 | 3518 | Tritrichomonas foetus uncharacterized protein (TRFO_04475), partial mRNA | blastn | 142 | 56.5 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 21921371 | 21921371 | PRJNA1120060_P_NODE_1918278_length_276_cov_1.605911_g1900256_i0 | PRJNA1120060 | 1918278 | 276 | 1.605911 | 4.43231436 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|2806467891|ref|XM_068506997.1| | 1144522 | g1900256 | i0 | 100 | 0.101449275362319 | 28 | 0 | 10 | 0 | 212 | 239 | 956 | 983 | Tritrichomonas foetus uncharacterized protein (TRFO_29820), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 21936298 | 21936298 | PRJNA1120060_P_NODE_3122518_length_235_cov_2.450617_g3104416_i0 | PRJNA1120060 | 3122518 | 235 | 2.450617 | 5.75894995 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|2806468189|ref|XM_068507079.1| | 1144522 | g3104416 | i0 | 100 | 0.119148936170213 | 28 | 0 | 12 | 0 | 136 | 163 | 108 | 81 | Tritrichomonas foetus uncharacterized protein (TRFO_29962), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 23185019 | 23185019 | PRJNA1120060_P_NODE_1098339_length_311_cov_3.088235_g1080404_i0 | PRJNA1120060 | 1098339 | 311 | 3.088235 | 9.60441085 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|2806475125|ref|XM_068509567.1| | 1144522 | g1080404 | i0 | 100 | 0.090032154340836 | 28 | 0 | 9 | 0 | 245 | 272 | 2469 | 2496 | Tritrichomonas foetus uncharacterized protein (TRFO_34255), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 23194870 | 23194870 | PRJNA1120060_P_NODE_1769939_length_282_cov_1.789474_g1751928_i0 | PRJNA1120060 | 1769939 | 282 | 1.789474 | 5.04631668 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 52.8 | 0.026 | NTclustered | gi|2794866140|ref|XM_067916298.1| | 135588 | g1751928 | i0 | 100 | 0.099290780141844 | 28 | 0 | 10 | 0 | 160 | 187 | 228 | 255 | Histomonas meleagridis polyA polymerase family protein (GO595_003294), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 23220015 | 23220015 | PRJNA1120060_P_NODE_540619_length_359_cov_1.342657_g522961_i0 | PRJNA1120060 | 540619 | 359 | 1.342657 | 4.82013863 | Trichomonas vaginalis | 5722 | Parabasalia | other_Eukaryota | 52.8 | 0.034 | NTclustered | gi|154422030|ref|XM_001583978.1| | 412133 | g522961 | i0 | 100 | 0.0779944289693593 | 28 | 0 | 8 | 0 | 114 | 141 | 527 | 554 | Trichomonas vaginalis G3 uncharacterized protein (TVAGG3_0529360), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 24473111 | 24473111 | PRJNA1120060_P_NODE_2091260_length_269_cov_1.913265_g2073220_i0 | PRJNA1120060 | 2091260 | 269 | 1.913265 | 5.14668285 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2794899998|ref|XM_067913196.1| | 135588 | g2073220 | i0 | 94.444 | 0.133828996282528 | 36 | 0 | 13 | 2 | 227 | 262 | 760 | 793 | Histomonas meleagridis uncharacterized protein (GO595_010509), partial mRNA | blastn | 36 | 54.7 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 24476547 | 24476547 | PRJNA1120060_P_NODE_2352320_length_259_cov_2.209677_g2334259_i0 | PRJNA1120060 | 2352320 | 259 | 2.209677 | 5.72306343 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2806451098|ref|XM_068500688.1| | 1144522 | g2334259 | i0 | 100 | 0.111969111969112 | 29 | 0 | 11 | 0 | 116 | 144 | 821 | 793 | Tritrichomonas foetus CAMK family protein kinase (TRFO_19259), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 24499247 | 24499247 | PRJNA1120060_P_NODE_928740_length_312_cov_3.543933_g910811_i0 | PRJNA1120060 | 928740 | 312 | 3.543933 | 11.05707096 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 58.4 | 6.27e-4 | NTclustered | gi|2806462498|ref|XM_068504997.1| | 1144522 | g910811 | i0 | 90.909 | 0.141025641025641 | 44 | 2 | 14 | 2 | 18 | 61 | 746 | 787 | Tritrichomonas foetus uncharacterized protein (TRFO_26525), partial mRNA | blastn | 44 | 58.4 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus |
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);;