contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJEB73599" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135175 | 135175 | PRJEB73599_P_NODE_3341_length_391_cov_9.439227_g3055_i0 | PRJEB73599 | 3341 | 391 | 9.439227 | 36.90737757 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 532 | 1.0999999999999996e-146 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g3055 | i0 | 91.184 | 60.8746803069054 | 397 | 28 | 100 | 3 | 1 | 391 | 2816 | 2421 | 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 | 23802 | 532 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 1409769 | 1409769 | PRJEB73599_P_NODE_5282_length_279_cov_10.144000_g4995_i0 | PRJEB73599 | 5282 | 279 | 10.144 | 28.30176 | Vannella sp. ELH6 | 1215641 | Discosea | other_Eukaryota | 444 | 3.63e-120 | NTclustered | gi|399764226|gb|JQ271737.1| | 1215641 | g4995 | i0 | 96.31 | 91.1720430107527 | 271 | 9 | 97 | 1 | 9 | 279 | 828 | 1097 | Vannella sp. ELH6 18S ribosomal RNA gene, partial sequence | blastn | 25437 | 444 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. ELH6 | |||
| 1409791 | 1409791 | PRJEB73599_P_NODE_7262_length_211_cov_2.873626_g6975_i0 | PRJEB73599 | 7262 | 211 | 2.873626 | 6.06335086 | Mastigamoeba balamuthi | 108607 | Evosea | other_Eukaryota | 106 | 1.4e-18 | NTclustered | gi|463171|gb|L23799.1|PMHRRSS | 108607 | g6975 | i0 | 80.69 | 0.687203791469194 | 145 | 20 | 66 | 7 | 72 | 211 | 1193 | 1052 | Phreatamoeba balamuthi ribosomal RNA small subunit gene | blastn | 145 | 106 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Mastigamoebidae | Mastigamoeba | Mastigamoeba balamuthi | |||
| 2685242 | 2685242 | PRJEB73599_P_NODE_2823_length_433_cov_3.841584_g2544_i0 | PRJEB73599 | 2823 | 433 | 3.841584 | 16.63405872 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 492 | 2.0799999999999995e-134 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g2544 | i0 | 87.471 | 37.7528868360277 | 431 | 48 | 99 | 6 | 1 | 428 | 66 | 493 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 16347 | 492 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 2685282 | 2685282 | PRJEB73599_P_NODE_823_length_834_cov_31.795031_g407_i1 | PRJEB73599 | 823 | 834 | 31.795031 | 265.17055854 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 1083 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g407 | i1 | 99.662 | 126.717026378897 | 592 | 2 | 71 | 0 | 243 | 834 | 1206 | 1797 | 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 | 105682 | 1083 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5237772 | 5237772 | PRJEB73599_P_NODE_9225_length_167_cov_1.702899_g8938_i0 | PRJEB73599 | 9225 | 167 | 1.702899 | 2.84384133 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 211 | 2.18e-50 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g8938 | i0 | 91.083 | 0.940119760479042 | 157 | 12 | 94 | 2 | 1 | 157 | 472 | 626 | 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 | 157 | 211 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6513262 | 6513262 | PRJEB73599_P_NODE_3466_length_381_cov_28.218750_g3180_i0 | PRJEB73599 | 3466 | 381 | 28.21875 | 107.5134375 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 671 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g3180 | i0 | 98.425 | 35.7296587926509 | 381 | 6 | 100 | 0 | 1 | 381 | 6720 | 7100 | 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 | 13613 | 671 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7787558 | 7787558 | PRJEB73599_P_NODE_5947_length_253_cov_2.535714_g5660_i0 | PRJEB73599 | 5947 | 253 | 2.535714 | 6.41535642 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 250 | 7.58e-62 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g5660 | i0 | 84.674 | 48.1067193675889 | 261 | 28 | 100 | 11 | 1 | 253 | 915 | 1171 | 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 | 12171 | 250 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 9062438 | 9062438 | PRJEB73599_P_NODE_2968_length_421_cov_3.145408_g2686_i0 | PRJEB73599 | 2968 | 421 | 3.145408 | 13.24216768 | Amoebozoa sp. SZA19 | 1089205 | Root_unresolved | Root_unresolved | 691 | 0 | NTclustered | gi|441475832|emb|FN562422.4| | 1089205 | g2686 | i0 | 96.209 | 15.4513064133017 | 422 | 12 | 100 | 4 | 1 | 421 | 439 | 21 | Amoebozoa sp. SZA19 18S rRNA gene, isolate SZA19 | blastn | 6505 | 691 | 1 | Eukaryota | Amoebozoa | Amoebozoa sp. SZA19 | |||||||
| 11613714 | 11613714 | PRJEB73599_P_NODE_8050_length_191_cov_1.641975_g7763_i0 | PRJEB73599 | 8050 | 191 | 1.641975 | 3.13617225 | Mastigamoeba balamuthi | 108607 | Evosea | other_Eukaryota | 80.5 | 7.54e-11 | NTclustered | gi|19911165|dbj|AB066365.1| | 108607 | g7763 | i0 | 86.667 | 0.392670157068063 | 75 | 7 | 39 | 2 | 111 | 185 | 72 | 1 | Mastigamoeba balamuthi gene for LSU rRNA, partial sequence, clone:MbR3 | blastn | 75 | 80.5 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Mastigamoebidae | Mastigamoeba | Mastigamoeba balamuthi | |||
| 12474458 | 12474458 | PRJEB73599_P_NODE_5690_length_262_cov_13.725322_g5403_i0 | PRJEB73599 | 5690 | 262 | 13.725322 | 35.96034364 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 484 | 1.99e-132 | NTclustered | gi|421976371|gb|JQ519505.1| | 5778 | g5403 | i0 | 100 | 99.9923664122137 | 262 | 0 | 100 | 0 | 1 | 262 | 126 | 387 | Vermamoeba vermiformis clone JG10.99 18S ribosomal RNA gene, partial sequence | blastn | 26198 | 484 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 12888768 | 12888768 | PRJEB73599_P_NODE_8411_length_182_cov_9.496732_g8124_i0 | PRJEB73599 | 8411 | 182 | 9.496732 | 17.28405224 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 296 | 6.48e-76 | NTclustered | gi|46393848|gb|AY502960.1| | 5778 | g8124 | i0 | 100 | 87.8791208791209 | 160 | 0 | 88 | 0 | 1 | 160 | 1819 | 1660 | Hartmannella vermiformis isolate KWR-2 18S ribosomal RNA gene, partial sequence | blastn | 15994 | 296 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17573426 | 17573426 | PRJEB73599_P_NODE_5914_length_254_cov_3.355556_g5627_i0 | PRJEB73599 | 5914 | 254 | 3.355556 | 8.52311224 | Cochliopodium | 313557 | Discosea | other_Eukaryota | 431 | 2.539999999999999e-116 | NTclustered | gi|399764162|gb|JQ271673.1| | 313997 | g5627 | i0 | 96.923 | 42.503937007874 | 260 | 2 | 100 | 4 | 1 | 254 | 727 | 986 | Cochliopodium minus strain UKNCC:CCAP1537/1 18S ribosomal RNA gene, partial sequence | blastn | 10796 | 431 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 17573438 | 17573438 | PRJEB73599_P_NODE_9114_length_169_cov_2.114286_g8827_i0 | PRJEB73599 | 9114 | 169 | 2.114286 | 3.57314334 | Hartmannellidae | 5776 | Tubulinea | other_Eukaryota | 302 | 1.27e-77 | NTclustered | gi|24527245|gb|AY145442.1| | 211864 | g8827 | i0 | 98.817 | 17.4319526627219 | 169 | 2 | 100 | 0 | 1 | 169 | 248 | 416 | Hartmannellidae sp. LOS7N/I small subunit ribosomal RNA gene, complete sequence | blastn | 2946 | 302 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannellidae sp. LOS7N/I | |||
| 20122017 | 20122017 | PRJEB73599_P_NODE_3716_length_363_cov_28.356287_g3430_i0 | PRJEB73599 | 3716 | 363 | 28.356287 | 102.93332181 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 671 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g3430 | i0 | 100 | 54.5619834710744 | 363 | 0 | 100 | 0 | 1 | 363 | 872 | 1234 | 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 | 19806 | 671 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20536075 | 20536075 | PRJEB73599_P_NODE_3177_length_403_cov_8.029412_g2891_i0 | PRJEB73599 | 3177 | 403 | 8.029412 | 32.35853036 | Cochliopodium sp. JvW-2015 | 1678068 | Discosea | other_Eukaryota | 580 | 3.9899999999999985e-161 | NTclustered | gi|861554067|gb|KP719191.1| | 1678068 | g2891 | i0 | 93.798 | 58.3349875930521 | 387 | 23 | 96 | 1 | 18 | 403 | 418 | 32 | Cochliopodium sp. JvW-2015 strain A1HEB clone 1 small subunit ribosomal RNA gene, partial sequence | blastn | 23509 | 580 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium sp. JvW-2015 | |||
| 20536115 | 20536115 | PRJEB73599_P_NODE_9177_length_168_cov_1.899281_g8890_i0 | PRJEB73599 | 9177 | 168 | 1.899281 | 3.19079208 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 311 | 2.11e-80 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g8890 | i0 | 100 | 41.3035714285714 | 168 | 0 | 100 | 0 | 1 | 168 | 19372 | 19205 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 6939 | 311 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 21397649 | 21397649 | PRJEB73599_P_NODE_4037_length_343_cov_2.429936_g3750_i0 | PRJEB73599 | 4037 | 343 | 2.429936 | 8.33468048 | Cochliopodium | 313557 | Discosea | other_Eukaryota | 359 | 1.7099999999999998e-94 | NTclustered | gi|399764162|gb|JQ271673.1| | 313997 | g3750 | i0 | 92.4 | 33.064139941691 | 250 | 12 | 96 | 3 | 2 | 250 | 12 | 255 | Cochliopodium minus strain UKNCC:CCAP1537/1 18S ribosomal RNA gene, partial sequence | blastn | 11341 | 359 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 23086998 | 23086998 | PRJEB73599_P_NODE_7079_length_216_cov_4.770053_g6792_i0 | PRJEB73599 | 7079 | 216 | 4.770053 | 10.30331448 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 220 | 4.94e-53 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g6792 | i0 | 85.238 | 0.972222222222222 | 210 | 27 | 97 | 4 | 8 | 216 | 4355 | 4149 | 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 | 210 | 220 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 25221636 | 25221636 | PRJEB73599_P_NODE_1540_length_598_cov_36.117750_g1322_i0 | PRJEB73599 | 1540 | 598 | 36.11775 | 215.984145 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1048 | 0 | NTclustered | gi|2777861736|gb|PQ072230.1| | 5778 | g1322 | i0 | 97.826 | 83.061872909699 | 598 | 12 | 100 | 1 | 1 | 598 | 902 | 306 | Vermamoeba vermiformis strain CCAP_1534_12_consensus_sequence small subunit ribosomal RNA gene, partial sequence | blastn | 49671 | 1048 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25221647 | 25221647 | PRJEB73599_P_NODE_4280_length_329_cov_3.643333_g3993_i0 | PRJEB73599 | 4280 | 329 | 3.643333 | 11.98656557 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 505 | 1.9799999999999995e-138 | NTclustered | gi|441475832|emb|FN562422.4| | 1089205 | g3993 | i0 | 95.541 | 42.9696048632219 | 314 | 13 | 95 | 1 | 1 | 314 | 953 | 641 | Amoebozoa sp. SZA19 18S rRNA gene, isolate SZA19 | blastn | 14137 | 510 | 0.990196078431373 | Eukaryota | Amoebozoa | Amoebozoa sp. SZA19 |
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);;