contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1010662" and tax_phylum = "Apicomplexa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 154959 | 154959 | PRJNA1010662_P_NODE_6281_length_219_cov_2.252941_g6222_i0 | PRJNA1010662 | 6281 | 219 | 2.252941 | 4.93394079 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 6.77e-22 | NTclustered | gi|1620112141|ref|XM_028671477.1| | 5849 | g6222 | i0 | 82.576 | 1.92237442922374 | 132 | 23 | 60 | 0 | 48 | 179 | 133 | 264 | Plasmodium gallinaceum 60S ribosomal protein L15, putative (PGAL8A_00089300), partial mRNA | blastn | 421 | 117 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 3552021 | 3552021 | PRJNA1010662_P_NODE_5843_length_225_cov_2.903409_g5784_i0 | PRJNA1010662 | 5843 | 225 | 2.903409 | 6.53267025 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 4.04e-49 | NTclustered | gi|1620142820|ref|XM_028677298.1| | 85471 | g5784 | i0 | 83.482 | 63.4177777777778 | 224 | 35 | 99 | 2 | 3 | 225 | 228 | 6 | Plasmodium relictum ubiquitin-60S ribosomal protein L40, putative (PRELSG_1104600), partial mRNA | blastn | 14269 | 207 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 6533058 | 6533058 | PRJNA1010662_P_NODE_16166_length_163_cov_0.903509_g16107_i0 | PRJNA1010662 | 16166 | 163 | 0.903509 | 1.47271967 | Plasmodium inui | 52288 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 2.23e-15 | NTclustered | gi|672187452|ref|XM_008816348.1| | 1237626 | g16107 | i0 | 92.537 | 2.74233128834356 | 67 | 3 | 40 | 2 | 17 | 82 | 384 | 449 | Plasmodium inui San Antonio 1 arginyl-tRNA synthetase partial mRNA | blastn | 447 | 95.3 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium inui | ||
| 7379019 | 7379019 | PRJNA1010662_P_NODE_2826_length_307_cov_1.476744_g2767_i0 | PRJNA1010662 | 2826 | 307 | 1.476744 | 4.53360408 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 2.14e-28 | NTclustered | gi|1976646300|ref|XR_005506384.1| | 5851 | g2767 | i0 | 88.793 | 37.9869706840391 | 116 | 9 | 37 | 4 | 64 | 177 | 2348 | 2235 | Plasmodium knowlesi strain H 28S ribosomal RNA (PKNH_1001000), rRNA | blastn | 11662 | 139 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 11633438 | 11633438 | PRJNA1010662_P_NODE_10090_length_184_cov_1.155556_g10031_i0 | PRJNA1010662 | 10090 | 184 | 1.155556 | 2.12622304 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 2.61e-5 | NTclustered | gi|916516433|ref|XM_013502564.1| | 44415 | g10031 | i0 | 93.023 | 0.467391304347826 | 43 | 1 | 23 | 2 | 66 | 108 | 78 | 118 | Eimeria mitis uncharacterized protein (EMH_0026070), partial mRNA | blastn | 86 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 18006593 | 18006593 | PRJNA1010662_P_NODE_11175_length_176_cov_2.149606_g11116_i0 | PRJNA1010662 | 11175 | 176 | 2.149606 | 3.78330656 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 5.1500000000000005e-27 | NTclustered | gi|2794940381|ref|XM_067858927.1| | 5871 | g11116 | i0 | 83.221 | 9.26136363636364 | 149 | 21 | 84 | 3 | 12 | 158 | 1053 | 907 | Babesia caballi 26S protease regulatory subunit 4, putative (BcabD6B2_23940), partial mRNA | blastn | 1630 | 134 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 18006673 | 18006673 | PRJNA1010662_P_NODE_4675_length_246_cov_1.842640_g4616_i0 | PRJNA1010662 | 4675 | 246 | 1.84264 | 4.5328944 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|915122682|ref|XM_013477151.1| | 5804 | g4616 | i0 | 100 | 0.252032520325203 | 30 | 0 | 12 | 0 | 200 | 229 | 443 | 414 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 62 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 18006701 | 18006701 | PRJNA1010662_P_NODE_7535_length_205_cov_1.666667_g7476_i0 | PRJNA1010662 | 7535 | 205 | 1.666667 | 3.41666735 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.001 | NTclustered | gi|1624689154|ref|XM_029009452.1| | 189622 | g7476 | i0 | 100 | 0.146341463414634 | 30 | 0 | 15 | 0 | 109 | 138 | 1153 | 1182 | Babesia ovata decapping 5 (BOVATA_005350), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 21831714 | 21831714 | PRJNA1010662_P_NODE_6818_length_213_cov_1.256098_g6759_i0 | PRJNA1010662 | 6818 | 213 | 1.256098 | 2.67548874 | Babesia bovis | 5865 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.08e-29 | NTclustered | gi|2325211320|ref|XM_001610874.2| | 484906 | g6759 | i0 | 85 | 36.5586854460094 | 140 | 21 | 66 | 0 | 22 | 161 | 2852 | 2713 | Babesia bovis T2Bo HAD ATPase P-type IC family protein (BBOV_IV010020), mRNA | blastn | 7787 | 143 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 25227664 | 25227664 | PRJNA1010662_P_NODE_12340_length_169_cov_1.733333_g12281_i0 | PRJNA1010662 | 12340 | 169 | 1.733333 | 2.92933277 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 8.43e-5 | NTclustered | gi|221054465|ref|XM_002258336.1| | 5851 | g12281 | i0 | 100 | 6.89349112426035 | 32 | 0 | 19 | 0 | 1 | 32 | 1628 | 1659 | Plasmodium knowlesi strain H helicase SKI2W, putative (PKNH_0707900), partial mRNA | blastn | 1165 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi |
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);;