contig_metadata
12 rows where bioproject = "PRJNA690124" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1945047 | 1945047 | PRJNA690124_P_NODE_21002_length_355_cov_1.156028_g20636_i0 | PRJNA690124 | 21002 | 355 | 1.156028 | 4.1038994 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 651 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g20636 | i0 | 99.718 | 15.9915492957746 | 355 | 1 | 100 | 0 | 1 | 355 | 1286 | 1640 | 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 | 5677 | 651 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 3220091 | 3220091 | PRJNA690124_P_NODE_31603_length_294_cov_2.470588_g31237_i0 | PRJNA690124 | 31603 | 294 | 2.470588 | 7.26352872 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 401 | 2.3499999999999994e-107 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g31237 | i0 | 91.234 | 1.04761904761905 | 308 | 8 | 100 | 17 | 1 | 294 | 5621 | 5923 | Acanthamoeba castellanii 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 | 308 | 401 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 8322238 | 8322238 | PRJNA690124_P_NODE_26527_length_319_cov_3.113821_g26161_i0 | PRJNA690124 | 26527 | 319 | 3.113821 | 9.93308899 | Protacanthamoeba bohemica | 325062 | Discosea | other_Eukaryota | 446 | 1.17e-120 | NTclustered | gi|2806326584|gb|PQ345834.1| | 325062 | g26161 | i0 | 92.476 | 47.6457680250784 | 319 | 13 | 100 | 10 | 1 | 319 | 452 | 145 | Protacanthamoeba bohemica isolate 6FSb1 small subunit ribosomal RNA gene, partial sequence | blastn | 15199 | 446 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Protacanthamoeba | Protacanthamoeba bohemica | |||
| 10873774 | 10873774 | PRJNA690124_P_NODE_55269_length_242_cov_1.846154_g54903_i0 | PRJNA690124 | 55269 | 242 | 1.846154 | 4.46769268 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 289 | 1.53e-73 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g54903 | i0 | 88.618 | 20.3636363636364 | 246 | 17 | 100 | 9 | 1 | 242 | 7070 | 6832 | Acanthamoeba castellanii 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 | 4928 | 289 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12148468 | 12148468 | PRJNA690124_P_NODE_28750_length_308_cov_1.523404_g28384_i0 | PRJNA690124 | 28750 | 308 | 1.523404 | 4.69208432 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 529 | 1.0899999999999996e-145 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g28384 | i0 | 97.452 | 76.1655844155844 | 314 | 0 | 100 | 3 | 1 | 308 | 860 | 1171 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 23459 | 529 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 17246982 | 17246982 | PRJNA690124_P_NODE_25634_length_324_cov_4.382470_g25268_i0 | PRJNA690124 | 25634 | 324 | 4.38247 | 14.1992028 | Vannella simplex | 197532 | Discosea | other_Eukaryota | 582 | 8.729999999999998e-162 | NTclustered | gi|284192609|gb|GQ265407.1| | 197532 | g25268 | i0 | 99.074 | 97.5679012345679 | 324 | 3 | 100 | 0 | 1 | 324 | 798 | 475 | Vannella simplex strain L4A Cl 4/1/2 clone A147.4 18S ribosomal RNA gene, partial sequence | blastn | 31612 | 582 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella simplex | |||
| 17247401 | 17247401 | PRJNA690124_P_NODE_44554_length_252_cov_0.871508_g44188_i0 | PRJNA690124 | 44554 | 252 | 0.871508 | 2.19620016 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 388 | 1.5299999999999998e-103 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g44188 | i0 | 94.488 | 48.7976190476191 | 254 | 11 | 100 | 3 | 1 | 252 | 26183 | 25931 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 12297 | 388 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 19030018 | 19030018 | PRJNA690124_P_NODE_21835_length_348_cov_2.589091_g21469_i0 | PRJNA690124 | 21835 | 348 | 2.589091 | 9.01003668 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 632 | 9.25e-177 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g21469 | i0 | 99.425 | 41.3850574712644 | 348 | 2 | 100 | 0 | 1 | 348 | 2844 | 2497 | 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 | 14402 | 632 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 21071639 | 21071639 | PRJNA690124_P_NODE_30317_length_300_cov_3.722467_g29951_i0 | PRJNA690124 | 30317 | 300 | 3.722467 | 11.167401 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 549 | 8.119999999999997e-152 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g29951 | i0 | 99.668 | 66.36 | 301 | 0 | 100 | 1 | 1 | 300 | 560 | 260 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 19908 | 549 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 21071986 | 21071986 | PRJNA690124_P_NODE_46337_length_250_cov_1.254237_g45971_i0 | PRJNA690124 | 46337 | 250 | 1.254237 | 3.1355925 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 241 | 4.5e-59 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g45971 | i0 | 95.946 | 1.82 | 148 | 6 | 59 | 0 | 1 | 148 | 6172 | 6319 | Acanthamoeba castellanii 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 | 455 | 241 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27840281 | 27840281 | PRJNA690124_P_NODE_48984_length_248_cov_0.891429_g48618_i0 | PRJNA690124 | 48984 | 248 | 0.891429 | 2.21074392 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 98.6 | 3.81e-24 | NR | PRP82916.1 | 1890364 | g48618 | i0 | 73.8 | 1.4758064516129 | 61 | 16 | 73.8 | 0 | 187 | 5 | 28 | 88 | PRP82916.1 putative 60S ribosomal protein L22 [Planoprotostelium fungivorum] | diamond | 366 | 98.6 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 30650842 | 30650842 | PRJNA690124_P_NODE_55773_length_242_cov_0.923077_g55407_i0 | PRJNA690124 | 55773 | 242 | 0.923077 | 2.23384634 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 109 | 2.17e-28 | NR | PRP75136.1 | 1890364 | g55407 | i0 | 61.3 | 0.991735537190083 | 80 | 30 | 99.2 | 1 | 2 | 241 | 2 | 80 | PRP75136.1 ubiquitin-conjugating enzyme E2 [Planoprotostelium fungivorum] | diamond | 240 | 109 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum |
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);;