contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJEB17675" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2571559 | 2571559 | PRJEB17675_P_NODE_4003_length_489_cov_2.960352_g3712_i0 | PRJEB17675 | 4003 | 489 | 2.960352 | 14.47612128 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 363 | 1.9399999999999998e-95 | NTclustered | gi|1079488025|ref|NC_031417.1| | 180228 | g3712 | i0 | 81.779 | 52.7975460122699 | 461 | 59 | 91 | 21 | 34 | 478 | 32129 | 32580 | Paramoeba pemaquidensis culture-collection CCAP:1560/4 mitochondrion, complete genome | blastn | 25818 | 363 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 3847878 | 3847878 | PRJEB17675_P_NODE_264_length_1587_cov_43.011598_g217_i0 | PRJEB17675 | 264 | 1587 | 43.011598 | 682.59406026 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 2023 | 0 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g217 | i0 | 91.152 | 49.645872715816 | 1537 | 60 | 95 | 51 | 68 | 1578 | 2240 | 754 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 78788 | 2023 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 3847913 | 3847913 | PRJEB17675_P_NODE_9024_length_296_cov_1.839080_g8720_i0 | PRJEB17675 | 9024 | 296 | 1.83908 | 5.4436768 | Paramoeba aparasomata | 2583407 | Discosea | other_Eukaryota | 241 | 5.47e-59 | NTclustered | gi|1767098935|gb|MK518072.1| | 2583407 | g8720 | i0 | 84.109 | 63.6182432432432 | 258 | 31 | 84 | 8 | 32 | 280 | 15246 | 14990 | Paramoeba aparasomata mitochondrion, complete genome | blastn | 18831 | 241 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba aparasomata | ||
| 5124044 | 5124044 | PRJEB17675_P_NODE_14025_length_220_cov_1.097297_g13721_i0 | PRJEB17675 | 14025 | 220 | 1.097297 | 2.4140534 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 137 | 5.23e-28 | NTclustered | gi|1079488025|ref|NC_031417.1| | 180228 | g13721 | i0 | 82.143 | 14.5454545454545 | 168 | 23 | 75 | 5 | 55 | 220 | 33760 | 33922 | Paramoeba pemaquidensis culture-collection CCAP:1560/4 mitochondrion, complete genome | blastn | 3200 | 137 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 7673948 | 7673948 | PRJEB17675_P_NODE_4387_length_466_cov_51.846868_g4090_i0 | PRJEB17675 | 4387 | 466 | 51.846868 | 241.60640488 | Paramoeba perurans | 437603 | Discosea | other_Eukaryota | 267 | 1.4899999999999998e-66 | NTclustered | gi|145386786|gb|EF216911.1| | 437603 | g4090 | i0 | 78.104 | 27.9785407725322 | 443 | 82 | 94 | 11 | 17 | 452 | 435 | 1 | Neoparamoeba perurans strain GD-HAC/2/2 28S large subunit ribosomal RNA gene, partial sequence | blastn | 13038 | 267 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba perurans | ||
| 8638944 | 8638944 | PRJEB17675_P_NODE_20947_length_168_cov_3.030075_g20643_i0 | PRJEB17675 | 20947 | 168 | 3.030075 | 5.090526 | Cochliopodium | 313557 | Discosea | other_Eukaryota | 267 | 4.63e-67 | NTclustered | gi|330902891|gb|JF298270.1| | 313997 | g20643 | i0 | 97.436 | 95.7738095238095 | 156 | 4 | 93 | 0 | 13 | 168 | 467 | 622 | Cochliopodium minus clone 5201 actin gene, partial cds | blastn | 16090 | 267 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 8948652 | 8948652 | PRJEB17675_P_NODE_15028_length_209_cov_2.063218_g14724_i0 | PRJEB17675 | 15028 | 209 | 2.063218 | 4.31212562 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 52.8 | 0.018 | NTclustered | gi|470393215|ref|XM_004334806.1| | 1257118 | g14724 | i0 | 100 | 0.133971291866029 | 28 | 0 | 13 | 0 | 126 | 153 | 342 | 369 | Acanthamoeba castellanii str. Neff splicing factor, CC1like subfamily protein (ACA1_093880), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 8948686 | 8948686 | PRJEB17675_P_NODE_268_length_1575_cov_45.092857_g217_i1 | PRJEB17675 | 268 | 1575 | 45.092857 | 710.21249775 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 2032 | 0 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g217 | i1 | 91.373 | 51.0869841269841 | 1530 | 58 | 95 | 50 | 68 | 1566 | 2240 | 754 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 80462 | 2032 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 12775228 | 12775228 | PRJEB17675_P_NODE_1891_length_713_cov_78.069322_g1665_i0 | PRJEB17675 | 1891 | 713 | 78.069322 | 556.63426586 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 1013 | 0 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g1665 | i0 | 94.939 | 52.312762973352 | 652 | 21 | 91 | 9 | 62 | 711 | 4 | 645 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 37299 | 1013 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 15013710 | 15013710 | PRJEB17675_P_NODE_5052_length_431_cov_2.277778_g4753_i0 | PRJEB17675 | 5052 | 431 | 2.277778 | 9.81722318 | Ripella | 1217112 | Discosea | other_Eukaryota | 693 | 0 | NTclustered | gi|399764203|gb|JQ271714.1| | 1217114 | g4753 | i0 | 98.477 | 99.0696055684455 | 394 | 5 | 91 | 1 | 37 | 430 | 474 | 82 | Ripella sp. DP13 18S ribosomal RNA gene, partial sequence | blastn | 42699 | 693 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. DP13 | |||
| 19147144 | 19147144 | PRJEB17675_P_NODE_24036_length_155_cov_1.450000_g23732_i0 | PRJEB17675 | 24036 | 155 | 1.45 | 2.2475 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 237 | 3.2800000000000004e-58 | NTclustered | gi|330902885|gb|JF298267.1| | 1017091 | g23732 | i0 | 94.737 | 98.0967741935484 | 152 | 8 | 98 | 0 | 1 | 152 | 361 | 512 | Cochliopodium larifeili clone 1805 actin gene, partial cds | blastn | 15205 | 237 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 20422324 | 20422324 | PRJEB17675_P_NODE_10297_length_271_cov_1.720339_g9993_i0 | PRJEB17675 | 10297 | 271 | 1.720339 | 4.66211869 | Vannella sp. GERB | 1002216 | Discosea | other_Eukaryota | 431 | 2.729999999999999e-116 | NTclustered | gi|327391626|gb|HM363624.1| | 1002216 | g9993 | i0 | 96.226 | 98.4354243542435 | 265 | 7 | 97 | 3 | 1 | 264 | 631 | 893 | Vannella sp. GERB small subunit ribosomal RNA gene, partial sequence | blastn | 26676 | 431 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. GERB | |||
| 20422392 | 20422392 | PRJEB17675_P_NODE_3717_length_508_cov_3.627907_g3432_i0 | PRJEB17675 | 3717 | 508 | 3.627907 | 18.42976756 | Vannella simplex | 197532 | Discosea | other_Eukaryota | 804 | 0 | NTclustered | gi|284192611|gb|GQ265409.1| | 197532 | g3432 | i0 | 95.472 | 100.454724409449 | 508 | 15 | 100 | 6 | 1 | 508 | 305 | 804 | Vannella simplex strain L4A Cl 4/1/2 clone A147.6 18S ribosomal RNA gene, partial sequence | blastn | 51031 | 804 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella simplex | |||
| 20422397 | 20422397 | PRJEB17675_P_NODE_4357_length_468_cov_4.168591_g4060_i0 | PRJEB17675 | 4357 | 468 | 4.168591 | 19.50900588 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 728 | 0 | NTclustered | gi|330902893|gb|JF298271.1| | 313997 | g4060 | i0 | 94.85 | 97.6517094017094 | 466 | 24 | 99 | 0 | 1 | 466 | 636 | 1101 | Cochliopodium minus clone 5202 actin gene, partial cds | blastn | 45701 | 728 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 21387967 | 21387967 | PRJEB17675_P_NODE_13517_length_225_cov_1.673684_g13213_i0 | PRJEB17675 | 13517 | 225 | 1.673684 | 3.765789 | Vannellidae | 95227 | Discosea | other_Eukaryota | 388 | 1.34e-103 | NTclustered | gi|33946343|gb|AY294150.1| | 197527 | g13213 | i0 | 97.778 | 100.288888888889 | 225 | 5 | 100 | 0 | 1 | 225 | 1051 | 827 | Platyamoeba placida small subunit ribosomal RNA gene, partial sequence | blastn | 22565 | 388 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 22973666 | 22973666 | PRJEB17675_P_NODE_4579_length_454_cov_86.718377_g4282_i0 | PRJEB17675 | 4579 | 454 | 86.718377 | 393.70143158 | Vannella sp. | 1973054 | Discosea | other_Eukaryota | 621 | 2.6699999999999997e-173 | NTclustered | gi|1858337158|gb|MT621571.1| | 1973054 | g4282 | i0 | 90.985 | 87.5418502202643 | 477 | 20 | 100 | 12 | 1 | 454 | 195 | 671 | Vannella sp. isolate VWR2 small subunit ribosomal RNA gene, partial sequence | blastn | 39744 | 621 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. |
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);;