contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA724039" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4539592 | 4539592 | PRJNA724039_S_NODE_4884_length_317_cov_4.489286_g4677_i0 | PRJNA724039 | 4884 | 317 | 4.489286 | 14.23103662 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 224 | 5.949999999999999e-54 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g4677 | i0 | 79.495 | 67.7097791798107 | 317 | 63 | 99 | 2 | 1 | 316 | 548 | 233 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 21464 | 224 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila | ||
| 5814632 | 5814632 | PRJNA724039_S_NODE_12185_length_184_cov_2.231293_g11978_i0 | PRJNA724039 | 12185 | 184 | 2.231293 | 4.10557912 | Sappinia pedata | 472956 | Discosea | other_Eukaryota | 243 | 8.67e-60 | NTclustered | gi|157673542|gb|EU004601.1| | 472956 | g11978 | i0 | 90.659 | 81.2445652173913 | 182 | 17 | 99 | 0 | 1 | 182 | 437 | 618 | Sappinia pedata strain NZ05-11L-1 actin gene, partial cds | blastn | 14949 | 243 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Sappinia | Sappinia pedata | |||
| 9639669 | 9639669 | PRJNA724039_S_NODE_3068_length_417_cov_13.926316_g2861_i0 | PRJNA724039 | 3068 | 417 | 13.926316 | 58.07273772 | Planopodium haveli | 2773112 | Discosea | other_Eukaryota | 765 | 0 | NTclustered | gi|1914009729|gb|MT975619.1| | 2773112 | g2861 | i0 | 99.76 | 48.484412470024 | 417 | 1 | 100 | 0 | 1 | 417 | 419 | 3 | Planopodium haveli clone 1 18S ribosomal RNA gene, complete sequence | blastn | 20218 | 765 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Planopodium | Planopodium haveli | |||
| 10122632 | 10122632 | PRJNA724039_S_NODE_12268_length_183_cov_4.369863_g12061_i0 | PRJNA724039 | 12268 | 183 | 4.369863 | 7.99684929 | Cochliopodium | 313557 | Discosea | other_Eukaryota | 244 | 2.4e-60 | NTclustered | gi|59876024|gb|AY785057.1| | 313998 | g12061 | i0 | 97.887 | 6.13661202185792 | 142 | 1 | 77 | 2 | 44 | 183 | 328 | 469 | Cochliopodium sp. strain Kiel 18S ribosomal RNA gene, partial sequence | blastn | 1123 | 244 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium sp. strain Kiel | |||
| 15222752 | 15222752 | PRJNA724039_S_NODE_3612_length_379_cov_7.350877_g3405_i0 | PRJNA724039 | 3612 | 379 | 7.350877 | 27.85982383 | Ripella | 1217112 | Discosea | other_Eukaryota | 612 | 1.3199999999999999e-170 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g3405 | i0 | 95.812 | 101.554089709763 | 382 | 10 | 100 | 6 | 1 | 379 | 27 | 405 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 38489 | 616 | 0.993506493506494 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 17289184 | 17289184 | PRJNA724039_S_NODE_2414_length_481_cov_10.707207_g2213_i0 | PRJNA724039 | 2414 | 481 | 10.707207 | 51.50166567 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 204 | 1.22e-47 | NTclustered | gi|1583105587|ref|NC_040955.1| | 1443144 | g2213 | i0 | 76.842 | 48.7214137214137 | 380 | 77 | 78 | 10 | 3 | 375 | 50231 | 49856 | Paravannella minima mitochondrion, complete genome | blastn | 23435 | 204 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima | |||
| 18562872 | 18562872 | PRJNA724039_S_NODE_16255_length_158_cov_1.561983_g16048_i0 | PRJNA724039 | 16255 | 158 | 1.561983 | 2.46793314 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 267 | 4.2799999999999996e-67 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g16048 | i0 | 96.894 | 50.0443037974684 | 161 | 2 | 100 | 1 | 1 | 158 | 2722 | 2562 | 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 | 7907 | 267 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 18562873 | 18562873 | PRJNA724039_S_NODE_16335_length_157_cov_13.375000_g16128_i0 | PRJNA724039 | 16335 | 157 | 13.375 | 20.99875 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 159 | 7.419999999999998e-35 | NTclustered | gi|1079488025|ref|NC_031417.1| | 180228 | g16128 | i0 | 85.207 | 157.668789808917 | 169 | 9 | 97 | 5 | 2 | 154 | 33257 | 33425 | Paramoeba pemaquidensis culture-collection CCAP:1560/4 mitochondrion, complete genome | blastn | 24754 | 159 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 19838164 | 19838164 | PRJNA724039_S_NODE_5716_length_289_cov_4.519841_g5509_i0 | PRJNA724039 | 5716 | 289 | 4.519841 | 13.06234049 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 440 | 4.889999999999998e-119 | NTclustered | gi|659103923|gb|KJ569725.1| | 1512276 | g5509 | i0 | 94.218 | 33.8442906574394 | 294 | 7 | 100 | 7 | 1 | 289 | 306 | 18 | Cochliopodium kieliense clone 9601 18S ribosomal RNA gene, partial sequence | blastn | 9781 | 440 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 19838227 | 19838227 | PRJNA724039_S_NODE_9696_length_209_cov_3.726744_g9489_i0 | PRJNA724039 | 9696 | 209 | 3.726744 | 7.78889496 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 108 | 3.86e-19 | NTclustered | gi|1583105587|ref|NC_040955.1| | 1443144 | g9489 | i0 | 78.916 | 4.57894736842105 | 166 | 29 | 78 | 5 | 47 | 209 | 2858 | 2696 | Paravannella minima mitochondrion, complete genome | blastn | 957 | 108 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima | |||
| 20320550 | 20320550 | PRJNA724039_S_NODE_11016_length_194_cov_3.019108_g10809_i0 | PRJNA724039 | 11016 | 194 | 3.019108 | 5.85706952 | Vannella | 95228 | Discosea | other_Eukaryota | 353 | 4.1e-93 | NTclustered | gi|62865936|gb|AY929911.1| | 325074 | g10809 | i0 | 99.485 | 96.1752577319588 | 194 | 1 | 100 | 0 | 1 | 194 | 1033 | 840 | Vannella sp. strain 4354/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 18658 | 353 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain 4354/I | |||
| 21113793 | 21113793 | PRJNA724039_S_NODE_5397_length_299_cov_63.255725_g5190_i0 | PRJNA724039 | 5397 | 299 | 63.255725 | 189.13461775 | Planopodium desertum | 2773111 | Discosea | other_Eukaryota | 542 | 1.35e-149 | NTclustered | gi|330902849|gb|JF298243.1| | 2773111 | g5190 | i0 | 99.331 | 45.0735785953177 | 299 | 2 | 100 | 0 | 1 | 299 | 1038 | 740 | Ovalopodium desertum clone 3701 18S ribosomal RNA gene, partial sequence | blastn | 13477 | 542 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Planopodium | Planopodium desertum | |||
| 23664134 | 23664134 | PRJNA724039_S_NODE_13739_length_172_cov_5.118519_g13532_i0 | PRJNA724039 | 13739 | 172 | 5.118519 | 8.80385268 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 174 | 2.95e-39 | NTclustered | gi|1079488025|ref|NC_031417.1| | 180228 | g13532 | i0 | 85.143 | 26.4476744186047 | 175 | 21 | 100 | 4 | 1 | 172 | 32268 | 32440 | Paramoeba pemaquidensis culture-collection CCAP:1560/4 mitochondrion, complete genome | blastn | 4549 | 174 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 23664285 | 23664285 | PRJNA724039_S_NODE_7019_length_254_cov_9.995392_g6812_i0 | PRJNA724039 | 7019 | 254 | 9.995392 | 25.38829568 | Paramoeba aparasomata | 2583407 | Discosea | other_Eukaryota | 326 | 1.23e-84 | NTclustered | gi|1767098935|gb|MK518072.1| | 2583407 | g6812 | i0 | 89.883 | 71.9370078740157 | 257 | 21 | 99 | 4 | 2 | 254 | 15482 | 15227 | Paramoeba aparasomata mitochondrion, complete genome | blastn | 18272 | 326 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba aparasomata | ||
| 24937681 | 24937681 | PRJNA724039_S_NODE_300_length_1926_cov_122.605082_g250_i0 | PRJNA724039 | 300 | 1926 | 122.605082 | 2361.37387932 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 285 | 1.8e-71 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g250 | i0 | 77.689 | 20.5711318795431 | 502 | 88 | 26 | 21 | 1 | 497 | 2248 | 1766 | 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 | 39620 | 285 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis |
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);;