contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJEB14803" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1295756 | 1295756 | PRJEB14803_P_NODE_562_length_1662_cov_17.866011_g466_i0 | PRJEB14803 | 562 | 1662 | 17.866011 | 296.93310282 | Cochliopodium arabianum | 1676989 | Discosea | other_Eukaryota | 1472 | 0 | NTclustered | gi|861685102|gb|KP244684.1| | 1676989 | g466 | i0 | 97.89 | 48.3231046931408 | 853 | 14 | 51 | 4 | 184 | 1034 | 851 | 1 | Cochliopodium arabianum voucher YT964 18S ribosomal RNA gene, partial sequence | blastn | 80313 | 1472 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium arabianum | |||
| 2571301 | 2571301 | PRJEB14803_P_NODE_25063_length_222_cov_2.796791_g24597_i0 | PRJEB14803 | 25063 | 222 | 2.796791 | 6.20887602 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 145 | 3.16e-30 | NTclustered | gi|470455615|ref|XM_004340928.1| | 1257118 | g24597 | i0 | 87.402 | 2.95045045045045 | 127 | 14 | 57 | 2 | 97 | 222 | 100 | 225 | Acanthamoeba castellanii str. Neff ribosomal protein S23 (S12), putative (ACA1_232480), partial mRNA | blastn | 655 | 145 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 2571417 | 2571417 | PRJEB14803_P_NODE_4603_length_652_cov_19.970827_g4213_i0 | PRJEB14803 | 4603 | 652 | 19.970827 | 130.20979204 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 931 | 0 | NTclustered | gi|659103927|gb|KJ569727.1| | 1512276 | g4213 | i0 | 93.681 | 53.7009202453988 | 633 | 23 | 94 | 11 | 35 | 650 | 1373 | 2005 | Cochliopodium kieliense clone 9611 18S ribosomal RNA gene, partial sequence | blastn | 35013 | 931 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 2571436 | 2571436 | PRJEB14803_P_NODE_5383_length_596_cov_183.705882_g4977_i0 | PRJEB14803 | 5383 | 596 | 183.705882 | 1094.88705672 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 872 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g4977 | i0 | 94.718 | 95.4496644295302 | 568 | 19 | 95 | 10 | 1 | 565 | 560 | 1 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 56888 | 872 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 3847668 | 3847668 | PRJEB14803_P_NODE_3424_length_769_cov_5.272480_g3084_i0 | PRJEB14803 | 3424 | 769 | 5.27248 | 40.5453712 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 778 | 0 | NTclustered | gi|571331049|gb|KF895376.1| | 1443144 | g3084 | i0 | 86.667 | 97.0559167750325 | 705 | 91 | 91 | 3 | 67 | 769 | 829 | 126 | Paravannella minima strain CCAP 1533/1 clone 1 actin gene, partial cds | blastn | 74636 | 778 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima | |||
| 4813650 | 4813650 | PRJEB14803_P_NODE_3144_length_805_cov_2.987013_g2814_i0 | PRJEB14803 | 3144 | 805 | 2.987013 | 24.04545465 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 616 | 2.289999999999999e-171 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g2814 | i0 | 80.521 | 56.3913043478261 | 806 | 151 | 99 | 6 | 1 | 803 | 861 | 59 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 45395 | 619 | 0.995153473344103 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila | ||
| 5123998 | 5123998 | PRJEB14803_P_NODE_8165_length_464_cov_1.689977_g7705_i0 | PRJEB14803 | 8165 | 464 | 1.689977 | 7.84149328 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 257 | 8.900000000000001e-64 | NTclustered | gi|470390001|ref|XM_004334484.1| | 1257118 | g7705 | i0 | 79.467 | 9.52155172413793 | 375 | 67 | 80 | 10 | 63 | 432 | 205 | 574 | Acanthamoeba castellanii str. Neff GTP cyclohydrolase I, putative (ACA1_028540), partial mRNA | blastn | 4418 | 257 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6399502 | 6399502 | PRJEB14803_P_NODE_1406_length_1206_cov_138.369769_g466_i1 | PRJEB14803 | 1406 | 1206 | 138.369769 | 1668.73941414 | Cochliopodium arabianum | 1676989 | Discosea | other_Eukaryota | 1399 | 0 | NTclustered | gi|861685102|gb|KP244684.1| | 1676989 | g466 | i1 | 97.901 | 33.0439469320066 | 810 | 13 | 67 | 4 | 216 | 1023 | 44 | 851 | Cochliopodium arabianum voucher YT964 18S ribosomal RNA gene, partial sequence | blastn | 39851 | 1399 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium arabianum | |||
| 6399564 | 6399564 | PRJEB14803_P_NODE_23046_length_235_cov_1.800000_g22580_i0 | PRJEB14803 | 23046 | 235 | 1.8 | 4.23 | Vexillifera fluvialis | 1105343 | Discosea | other_Eukaryota | 244 | 3.24e-60 | NTclustered | gi|354720323|gb|HQ687482.1| | 1105343 | g22580 | i0 | 91.16 | 12.3829787234043 | 181 | 15 | 77 | 1 | 1 | 180 | 909 | 1089 | Vexillifera fluvialis strain RR1 small subunit ribosomal RNA gene, partial sequence | blastn | 2910 | 244 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera fluvialis | ||
| 6399607 | 6399607 | PRJEB14803_P_NODE_30146_length_197_cov_1.833333_g29680_i0 | PRJEB14803 | 30146 | 197 | 1.833333 | 3.61166601 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 191 | 3.46e-44 | NTclustered | gi|1079488025|ref|NC_031417.1| | 180228 | g29680 | i0 | 85.561 | 16.5939086294416 | 187 | 22 | 95 | 4 | 1 | 187 | 33955 | 33774 | Paramoeba pemaquidensis culture-collection CCAP:1560/4 mitochondrion, complete genome | blastn | 3269 | 191 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 6399683 | 6399683 | PRJEB14803_P_NODE_5006_length_622_cov_20.935264_g4606_i0 | PRJEB14803 | 5006 | 622 | 20.935264 | 130.21734208 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 789 | 0 | NTclustered | gi|659103926|gb|KJ569726.1| | 1512276 | g4606 | i0 | 91.03 | 59.6784565916399 | 602 | 29 | 96 | 16 | 2 | 597 | 586 | 4 | Cochliopodium kieliense clone 9605 18S ribosomal RNA gene, partial sequence | blastn | 37120 | 789 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 7673731 | 7673731 | PRJEB14803_P_NODE_38227_length_170_cov_1.481481_g37761_i0 | PRJEB14803 | 38227 | 170 | 1.481481 | 2.5185177 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 147 | 6.339999999999999e-31 | NTclustered | gi|470511027|ref|XM_004351555.1| | 1257118 | g37761 | i0 | 100 | 7.18235294117647 | 79 | 0 | 46 | 0 | 84 | 162 | 6887 | 6809 | Acanthamoeba castellanii str. Neff Dynein heavy chain protein (ACA1_396150), partial mRNA | blastn | 1221 | 147 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 8948458 | 8948458 | PRJEB14803_P_NODE_308_length_2031_cov_39.202405_g252_i0 | PRJEB14803 | 308 | 2031 | 39.202405 | 796.20084555 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 3241 | 0 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g252 | i0 | 96.631 | 39.7321516494338 | 1959 | 55 | 96 | 9 | 79 | 2031 | 4 | 1957 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 80696 | 3241 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 14049666 | 14049666 | PRJEB14803_P_NODE_4692_length_646_cov_3.494272_g4301_i0 | PRJEB14803 | 4692 | 646 | 3.494272 | 22.57299712 | Cochliopodium crystalli | 2652061 | Discosea | other_Eukaryota | 1112 | 0 | NTclustered | gi|1758131113|gb|MN389532.1| | 2652061 | g4301 | i0 | 100 | 86.3049535603715 | 602 | 0 | 93 | 0 | 1 | 602 | 602 | 1 | Cochliopodium crystalli isolate YT379_6b cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 55753 | 1112 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium crystalli | |||
| 17563685 | 17563685 | PRJEB14803_P_NODE_434_length_1813_cov_419.975253_g358_i0 | PRJEB14803 | 434 | 1813 | 419.975253 | 7614.15133689 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 270 | 4.7399999999999994e-67 | NTclustered | gi|28194618|gb|AF479562.1| | 29195 | g358 | i0 | 72.653 | 18.5835631549917 | 980 | 208 | 52 | 45 | 174 | 1116 | 1389 | 433 | Acanthamoeba griffini strain S7 16S small subunit ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product | blastn | 33692 | 270 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba griffini | |||
| 17873215 | 17873215 | PRJEB14803_P_NODE_8815_length_442_cov_27.326781_g8353_i0 | PRJEB14803 | 8815 | 442 | 27.326781 | 120.78437202 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 171 | 1.13e-37 | NTclustered | gi|470515092|ref|XM_004352825.1| | 1257118 | g8353 | i0 | 75.462 | 47.4660633484163 | 379 | 78 | 84 | 13 | 13 | 382 | 384 | 12 | Acanthamoeba castellanii str. Neff ribosomal protein s24e, putative (ACA1_069330), partial mRNA | blastn | 20980 | 171 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 21698037 | 21698037 | PRJEB14803_P_NODE_12418_length_354_cov_2.040752_g11953_i0 | PRJEB14803 | 12418 | 354 | 2.040752 | 7.22426208 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 147 | 1.4899999999999998e-30 | NTclustered | gi|470418521|ref|XM_004337050.1| | 1257118 | g11953 | i0 | 82.081 | 31.8531073446328 | 173 | 29 | 49 | 2 | 183 | 354 | 510 | 339 | Acanthamoeba castellanii str. Neff cyclophylin, putative (ACA1_215460), partial mRNA | blastn | 11276 | 147 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 21698172 | 21698172 | PRJEB14803_P_NODE_30418_length_196_cov_1.621118_g29952_i0 | PRJEB14803 | 30418 | 196 | 1.621118 | 3.17739128 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 246 | 7.25e-61 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g29952 | i0 | 89.286 | 99.9591836734694 | 196 | 21 | 100 | 0 | 1 | 196 | 837 | 1032 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 19592 | 246 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila | ||
| 21698205 | 21698205 | PRJEB14803_P_NODE_38058_length_170_cov_3.259259_g37592_i0 | PRJEB14803 | 38058 | 170 | 3.259259 | 5.5407403 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 87.9 | 3.9e-13 | NTclustered | gi|470448716|ref|XM_004340140.1| | 1257118 | g37592 | i0 | 89.706 | 0.4 | 68 | 7 | 40 | 0 | 2 | 69 | 119 | 52 | Acanthamoeba castellanii str. Neff peroxidase (ACA1_369000), partial mRNA | blastn | 68 | 87.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 22973535 | 22973535 | PRJEB14803_P_NODE_6339_length_540_cov_2.471287_g5897_i0 | PRJEB14803 | 6339 | 540 | 2.471287 | 13.3449498 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 645 | 1.9099999999999993e-180 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g5897 | i0 | 88.148 | 88.9574074074074 | 540 | 64 | 100 | 0 | 1 | 540 | 787 | 248 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 48037 | 645 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila |
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);;