contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA1174207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 315959 | 315959 | PRJNA1174207_P_NODE_41021_length_241_cov_3.386905_g40492_i0 | PRJNA1174207 | 41021 | 241 | 3.386905 | 8.16244105 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 412 | 8.64e-111 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g40492 | i0 | 97.51 | 1.94605809128631 | 241 | 6 | 100 | 0 | 1 | 241 | 6817 | 7057 | 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 | 469 | 412 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 315964 | 315964 | PRJNA1174207_P_NODE_41321_length_241_cov_0.916667_g40792_i0 | PRJNA1174207 | 41321 | 241 | 0.916667 | 2.20916747 | Entamoeba gingivalis | 38877 | Evosea | other_Eukaryota | 438 | 1.4299999999999999e-118 | NTclustered | gi|2781670152|dbj|LC832224.1| | 38877 | g40792 | i0 | 99.585 | 97.2946058091286 | 241 | 0 | 99 | 1 | 2 | 241 | 558 | 318 | Entamoeba gingivalis ST1-1_human_Ishikawa_H118_2017 gene for 18S ribosomal RNA, partial sequence | blastn | 23448 | 438 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba gingivalis | |||
| 2866304 | 2866304 | PRJNA1174207_P_NODE_18943_length_326_cov_1.683794_g18414_i0 | PRJNA1174207 | 18943 | 326 | 1.683794 | 5.48916844 | Physarum cinereum | 289951 | Evosea | other_Eukaryota | 597 | 3.139999999999999e-166 | NTclustered | gi|224228205|dbj|AB435347.1| | 289951 | g18414 | i0 | 99.693 | 100.328220858896 | 326 | 1 | 100 | 0 | 1 | 326 | 46 | 371 | Physarum cinereum gene for small subunit ribosomal RNA, partial sequence, specimen_voucher: AK-06067 | blastn | 32707 | 597 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum cinereum | ||
| 4142643 | 4142643 | PRJNA1174207_P_NODE_33024_length_252_cov_1.290503_g32495_i0 | PRJNA1174207 | 33024 | 252 | 1.290503 | 3.25206756 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|831754232|ref|XM_012892599.1| | 1410327 | g32495 | i0 | 100 | 0.111111111111111 | 28 | 0 | 11 | 0 | 107 | 134 | 285 | 258 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 5418411 | 5418411 | PRJNA1174207_P_NODE_12505_length_417_cov_2.825581_g11978_i0 | PRJNA1174207 | 12505 | 417 | 2.825581 | 11.78267277 | uncultured Vannellidae | 544561 | Discosea | other_Eukaryota | 246 | 1.71e-60 | NTclustered | gi|724028230|gb|KP099889.1| | 544561 | g11978 | i0 | 88.67 | 40.3741007194245 | 203 | 21 | 49 | 1 | 166 | 368 | 929 | 729 | Uncultured Vannellidae clone b18 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 | 16836 | 246 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | uncultured Vannellidae | ||||
| 5418873 | 5418873 | PRJNA1174207_P_NODE_36285_length_247_cov_2.132184_g35756_i0 | PRJNA1174207 | 36285 | 247 | 2.132184 | 5.26649448 | Thecamoeba similis | 242545 | Discosea | other_Eukaryota | 193 | 1.26e-44 | NTclustered | gi|33946350|gb|AY294154.1| | 242545 | g35756 | i0 | 88.608 | 26.4493927125506 | 158 | 18 | 64 | 0 | 90 | 247 | 1171 | 1014 | Thecamoeba similis actin mRNA, complete cds | blastn | 6533 | 193 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba similis | |||
| 6693241 | 6693241 | PRJNA1174207_P_NODE_13426_length_398_cov_3.664615_g12898_i0 | PRJNA1174207 | 13426 | 398 | 3.664615 | 14.5851677 | Lobosea sp. Borok | 297386 | Tubulinea | other_Eukaryota | 695 | 0 | NTclustered | gi|54306228|gb|AY626163.1| | 297386 | g12898 | i0 | 98.241 | 76.3894472361809 | 398 | 6 | 100 | 1 | 1 | 398 | 594 | 990 | Lobosea sp. Borok small subunit ribosomal RNA gene, partial sequence | blastn | 30403 | 695 | 1 | Eukaryota | Amoebozoa | Tubulinea | Lobosea sp. Borok | ||||||
| 6693634 | 6693634 | PRJNA1174207_P_NODE_33166_length_251_cov_1.865169_g32637_i0 | PRJNA1174207 | 33166 | 251 | 1.865169 | 4.68157419 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 394 | 3.28e-105 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g32637 | i0 | 95.238 | 88.2589641434263 | 252 | 7 | 99 | 5 | 1 | 250 | 48 | 296 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 22153 | 394 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 8693316 | 8693316 | PRJNA1174207_P_NODE_11927_length_431_cov_1.159218_g11400_i0 | PRJNA1174207 | 11927 | 431 | 1.159218 | 4.99622958 | Physarum | 5790 | Evosea | other_Eukaryota | 660 | 0 | NTclustered | gi|374255699|emb|HE614599.1| | 289951 | g11400 | i0 | 94.432 | 59.5568445475638 | 431 | 20 | 100 | 3 | 1 | 431 | 655 | 1081 | Physarum cinereum partial 18S rRNA gene, strain Idn-2 | blastn | 25669 | 660 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum cinereum | ||
| 11794422 | 11794422 | PRJNA1174207_P_NODE_37470_length_246_cov_0.890173_g36941_i0 | PRJNA1174207 | 37470 | 246 | 0.890173 | 2.18982558 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 156 | 1.65e-33 | NTclustered | gi|467633|emb|Z29969.1| | 5759 | g36941 | i0 | 78.846 | 43.9268292682927 | 260 | 33 | 99 | 10 | 3 | 246 | 2274 | 2021 | E.histolytica plasmid genes for ribosomal RNA and hemolysins HLY1, HLY5mc1 HLY5mc2 HLY4 | blastn | 10806 | 156 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 14344338 | 14344338 | PRJNA1174207_P_NODE_13112_length_404_cov_3.178248_g12584_i0 | PRJNA1174207 | 13112 | 404 | 3.178248 | 12.84012192 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 741 | 0 | NTclustered | gi|262262921|gb|FJ766464.1| | 472931 | g12584 | i0 | 99.752 | 48.990099009901 | 404 | 1 | 100 | 0 | 1 | 404 | 596 | 999 | Protostelium mycophagum strain KA-T15-2 small subunit ribosomal RNA gene, partial sequence | blastn | 19792 | 741 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 15618687 | 15618687 | PRJNA1174207_P_NODE_43673_length_206_cov_7.902256_g43144_i0 | PRJNA1174207 | 43673 | 206 | 7.902256 | 16.27864736 | Lobosea sp. Borok | 297386 | Tubulinea | other_Eukaryota | 374 | 3.3799999999999997e-99 | NTclustered | gi|54306228|gb|AY626163.1| | 297386 | g43144 | i0 | 99.512 | 58.995145631068 | 205 | 1 | 99 | 0 | 1 | 205 | 1279 | 1483 | Lobosea sp. Borok small subunit ribosomal RNA gene, partial sequence | blastn | 12153 | 374 | 1 | Eukaryota | Amoebozoa | Tubulinea | Lobosea sp. Borok | ||||||
| 15618751 | 15618751 | PRJNA1174207_P_NODE_9173_length_511_cov_1.305936_g8648_i0 | PRJNA1174207 | 9173 | 511 | 1.305936 | 6.67333296 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 167 | 1.7100000000000002e-36 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g8648 | i0 | 81.517 | 23.334637964775 | 211 | 32 | 41 | 5 | 156 | 363 | 2295 | 2089 | Vannella septentrionalis 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 | 11924 | 167 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 16892722 | 16892722 | PRJNA1174207_P_NODE_28574_length_270_cov_2.182741_g28045_i0 | PRJNA1174207 | 28574 | 270 | 2.182741 | 5.8934007 | Spumochlamys bryora | 675832 | Tubulinea | other_Eukaryota | 399 | 7.669999999999998e-107 | NTclustered | gi|259595677|gb|FJ705341.1| | 675832 | g28045 | i0 | 93.358 | 44.9925925925926 | 271 | 17 | 100 | 1 | 1 | 270 | 1231 | 961 | Spumochlamys bryora clone 1901 18S ribosomal RNA gene, partial sequence | blastn | 12148 | 399 | 1 | Eukaryota | Amoebozoa | Tubulinea | Corycida | Microchlamyiidae | Spumochlamys | Spumochlamys bryora | |||
| 16893015 | 16893015 | PRJNA1174207_P_NODE_43434_length_219_cov_6.568493_g42905_i0 | PRJNA1174207 | 43434 | 219 | 6.568493 | 14.38499967 | Lobosea sp. Borok | 297386 | Tubulinea | other_Eukaryota | 383 | 6.05e-102 | NTclustered | gi|54306228|gb|AY626163.1| | 297386 | g42905 | i0 | 98.165 | 50.662100456621 | 218 | 4 | 99 | 0 | 1 | 218 | 126 | 343 | Lobosea sp. Borok small subunit ribosomal RNA gene, partial sequence | blastn | 11095 | 383 | 1 | Eukaryota | Amoebozoa | Tubulinea | Lobosea sp. Borok | ||||||
| 16893041 | 16893041 | PRJNA1174207_P_NODE_5494_length_721_cov_1.848765_g4990_i0 | PRJNA1174207 | 5494 | 721 | 1.848765 | 13.32959565 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 907 | 0 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g4990 | i0 | 89.365 | 35.8959778085992 | 724 | 74 | 100 | 1 | 1 | 721 | 2298 | 3021 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 25881 | 907 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 18167213 | 18167213 | PRJNA1174207_P_NODE_26255_length_280_cov_1.893720_g25726_i0 | PRJNA1174207 | 26255 | 280 | 1.89372 | 5.302416 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 512 | 9.85e-141 | NTclustered | gi|330902861|gb|JF298256.1| | 1017091 | g25726 | i0 | 99.643 | 70.8464285714286 | 280 | 1 | 100 | 0 | 1 | 280 | 312 | 591 | Cochliopodium larifeili clone 907 18S ribosomal RNA gene, partial sequence | blastn | 19837 | 512 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 19441720 | 19441720 | PRJNA1174207_P_NODE_32276_length_255_cov_1.681319_g31747_i0 | PRJNA1174207 | 32276 | 255 | 1.681319 | 4.28736345 | Stemonitopsis subcaespitosa | 1048528 | Evosea | other_Eukaryota | 326 | 1.2399999999999999e-84 | NTclustered | gi|426281760|gb|JX681133.1| | 1048528 | g31747 | i0 | 90.04 | 82.2666666666667 | 251 | 25 | 98 | 0 | 1 | 251 | 244 | 494 | Stemonitopsis subcaespitosa actin gene, partial cds | blastn | 20978 | 326 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Stemonitopsis | Stemonitopsis subcaespitosa | ||
| 20166828 | 20166828 | PRJNA1174207_P_NODE_19796_length_318_cov_3.134694_g19267_i0 | PRJNA1174207 | 19796 | 318 | 3.134694 | 9.96832692 | Cryptodifflugia | 1078833 | Tubulinea | other_Eukaryota | 553 | 6.699999999999998e-153 | NTclustered | gi|345294024|gb|JF694280.1| | 1078836 | g19267 | i0 | 98.107 | 85.6761006289308 | 317 | 6 | 99 | 0 | 2 | 318 | 1803 | 1487 | Cryptodifflugia operculata small subunit ribosomal RNA gene, partial sequence | blastn | 27245 | 553 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 23992832 | 23992832 | PRJNA1174207_P_NODE_29239_length_267_cov_5.896907_g28710_i0 | PRJNA1174207 | 29239 | 267 | 5.896907 | 15.74474169 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 483 | 7.31e-132 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g28710 | i0 | 99.251 | 39.1198501872659 | 267 | 2 | 100 | 0 | 1 | 267 | 3608 | 3874 | 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 | 10445 | 483 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 24541663 | 24541663 | PRJNA1174207_P_NODE_30920_length_261_cov_1.265957_g30391_i0 | PRJNA1174207 | 30920 | 261 | 1.265957 | 3.30414777 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 350 | 7.539999999999999e-92 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g30391 | i0 | 90.805 | 92.7509578544061 | 261 | 24 | 100 | 0 | 1 | 261 | 919 | 659 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 24208 | 350 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 |
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);;