contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1126198" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 281052 | 281052 | PRJNA1126198_P_NODE_10841_length_580_cov_3.315582_g10169_i0 | PRJNA1126198 | 10841 | 580 | 3.315582 | 19.2303756 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 202 | 5.369999999999999e-47 | NTclustered | gi|831792076|ref|XM_012904471.1| | 1410327 | g10169 | i0 | 82.627 | 0.803448275862069 | 236 | 33 | 40 | 6 | 292 | 523 | 1643 | 1412 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 466 | 202 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 281311 | 281311 | PRJNA1126198_P_NODE_253141_length_277_cov_1.519608_g252420_i0 | PRJNA1126198 | 253141 | 277 | 1.519608 | 4.20931416 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 158 | 5.25e-34 | NTclustered | gi|1865795|emb|Y11271.1| | 5759 | g252420 | i0 | 88.06 | 4.6028880866426 | 134 | 14 | 48 | 2 | 145 | 277 | 1093 | 961 | E.histolytica ss1 gene | blastn | 1275 | 158 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 281680 | 281680 | PRJNA1126198_P_NODE_438701_length_245_cov_0.901163_g437980_i0 | PRJNA1126198 | 438701 | 245 | 0.901163 | 2.20784935 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 62.1 | 3.67e-5 | NTclustered | gi|1160570722|ref|XM_020574855.1| | 670386 | g437980 | i0 | 100 | 13.1469387755102 | 33 | 0 | 13 | 0 | 138 | 170 | 3176 | 3144 | Polysphondylium pallidum PN500 DNA polymerase zeta catalytic subunit (polZ), partial mRNA | blastn | 3221 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 281738 | 281738 | PRJNA1126198_P_NODE_458381_length_243_cov_0.917647_g457660_i0 | PRJNA1126198 | 458381 | 243 | 0.917647 | 2.22988221 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|831753239|ref|XM_012892301.1| | 1410327 | g457660 | i0 | 100 | 0.11522633744856 | 28 | 0 | 12 | 0 | 215 | 242 | 1330 | 1303 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 1556428 | 1556428 | PRJNA1126198_P_NODE_488282_length_229_cov_5.576923_g487561_i0 | PRJNA1126198 | 488282 | 229 | 5.576923 | 12.77115367 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 422 | 1.35e-113 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g487561 | i0 | 100 | 3.14410480349345 | 228 | 0 | 99 | 0 | 2 | 229 | 6317 | 6090 | Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 720 | 422 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6659008 | 6659008 | PRJNA1126198_P_NODE_191586_length_295_cov_3.058559_g190866_i0 | PRJNA1126198 | 191586 | 295 | 3.058559 | 9.02274905 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 108 | 5.76e-19 | NTclustered | gi|470458637|ref|XM_004341224.1| | 1257118 | g190866 | i0 | 95.522 | 0.430508474576271 | 67 | 3 | 43 | 0 | 19 | 85 | 1611 | 1545 | Acanthamoeba castellanii str. Neff Flavinbinding monooxygenase-like subfamily protein (ACA1_262350), partial mRNA | blastn | 127 | 108 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 7934049 | 7934049 | PRJNA1126198_P_NODE_119527_length_329_cov_2.214844_g118808_i0 | PRJNA1126198 | 119527 | 329 | 2.214844 | 7.28683676 | Thecamoeba foliovenanda | 2653195 | Discosea | other_Eukaryota | 603 | 6.819999999999999e-168 | NTclustered | gi|1758284524|gb|MN544291.1| | 2653195 | g118808 | i0 | 99.697 | 44.7629179331307 | 330 | 0 | 100 | 1 | 1 | 329 | 590 | 919 | Thecamoeba foliovenanda strain Ta68 small subunit ribosomal RNA gene, partial sequence | blastn | 14727 | 603 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba foliovenanda | |||
| 9209205 | 9209205 | PRJNA1126198_P_NODE_2228_length_1255_cov_3.491540_g1849_i0 | PRJNA1126198 | 2228 | 1255 | 3.49154 | 43.818827 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 942 | 0 | NTclustered | gi|470484553|ref|XM_004344028.1| | 1257118 | g1849 | i0 | 80.614 | 63.6326693227092 | 1238 | 224 | 98 | 14 | 1 | 1230 | 184 | 1413 | Acanthamoeba castellanii str. Neff Sadenosyl-L-homocysteine hydrolase, putative (ACA1_054200), partial mRNA | blastn | 79859 | 942 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9209895 | 9209895 | PRJNA1126198_P_NODE_86188_length_354_cov_1.103203_g85470_i0 | PRJNA1126198 | 86188 | 354 | 1.103203 | 3.90533862 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 276 | 1.83e-69 | NTclustered | gi|470521902|ref|XM_004353878.1| | 1257118 | g85470 | i0 | 81.006 | 86.4237288135593 | 358 | 58 | 99 | 9 | 1 | 353 | 1507 | 1859 | Acanthamoeba castellanii str. Neff integral membrane protein 1 isoform 5, putative (ACA1_169070), partial mRNA | blastn | 30594 | 276 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 13035497 | 13035497 | PRJNA1126198_P_NODE_471651_length_242_cov_0.911243_g470930_i0 | PRJNA1126198 | 471651 | 242 | 0.911243 | 2.20520806 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 161 | 3.47e-35 | NTclustered | gi|167381393|ref|XM_001735644.1| | 370354 | g470930 | i0 | 80.18 | 0.91735537190082606 | 222 | 38 | 90 | 6 | 22 | 240 | 804 | 586 | Entamoeba dispar SAW760 uncharacterized protein (EDI_025790), partial mRNA | blastn | 222 | 161 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 14310717 | 14310717 | PRJNA1126198_P_NODE_494812_length_210_cov_4.218978_g494090_i0 | PRJNA1126198 | 494812 | 210 | 4.218978 | 8.8598538 | Thecamoeba foliovenanda | 2653195 | Discosea | other_Eukaryota | 388 | 1.24e-103 | NTclustered | gi|1758284524|gb|MN544291.1| | 2653195 | g494090 | i0 | 100 | 30.7238095238095 | 210 | 0 | 100 | 0 | 1 | 210 | 1314 | 1105 | Thecamoeba foliovenanda strain Ta68 small subunit ribosomal RNA gene, partial sequence | blastn | 6452 | 388 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba foliovenanda | |||
| 18881741 | 18881741 | PRJNA1126198_P_NODE_15595_length_524_cov_13.771619_g14910_i0 | PRJNA1126198 | 15595 | 524 | 13.771619 | 72.16328356 | Vannellidae | 95227 | Discosea | other_Eukaryota | 797 | 0 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g14910 | i0 | 94.14 | 100.81106870229 | 529 | 21 | 100 | 9 | 1 | 524 | 1693 | 1170 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 52825 | 802 | 0.993765586034913 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 19406964 | 19406964 | PRJNA1126198_P_NODE_13496_length_545_cov_5.527542_g12815_i0 | PRJNA1126198 | 13496 | 545 | 5.527542 | 30.1251039 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 231 | 6.41e-56 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g12815 | i0 | 80.464 | 55.0990825688073 | 302 | 59 | 55 | 0 | 103 | 404 | 422 | 121 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 30029 | 231 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 20156695 | 20156695 | PRJNA1126198_P_NODE_265836_length_274_cov_1.373134_g265115_i0 | PRJNA1126198 | 265836 | 274 | 1.373134 | 3.76238716 | Entamoeba | 5758 | Evosea | other_Eukaryota | 189 | 1.84e-43 | NTclustered | gi|807611|gb|L36807.1|ENHRGS | 5759 | g265115 | i0 | 98.148 | 38.7408759124088 | 108 | 2 | 39 | 0 | 1 | 108 | 3059 | 2952 | Entamoeba histolytica strain HK9 17S ribosomal RNA (17S rRNA) gene, partial sequence | blastn | 10615 | 189 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 22707139 | 22707139 | PRJNA1126198_P_NODE_179418_length_300_cov_1.687225_g178698_i0 | PRJNA1126198 | 179418 | 300 | 1.687225 | 5.061675 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 555 | 1.7399999999999995e-153 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g178698 | i0 | 100 | 91.5166666666667 | 300 | 0 | 100 | 0 | 1 | 300 | 1221 | 922 | Hartmannella vermiformis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 27455 | 555 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 23982782 | 23982782 | PRJNA1126198_P_NODE_491359_length_227_cov_3.967532_g490637_i0 | PRJNA1126198 | 491359 | 227 | 3.967532 | 9.00629764 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 420 | 4.81e-113 | NTclustered | gi|399764177|gb|JQ271688.1| | 5778 | g490637 | i0 | 100 | 100 | 227 | 0 | 100 | 0 | 1 | 227 | 152 | 378 | Hartmannella vermiformis strain ECH26 18S ribosomal RNA gene, partial sequence | blastn | 22700 | 420 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis |
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);;