contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJEB12296" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1294947 | 1294947 | PRJEB12296_P_NODE_382_length_217_cov_2.861702_g369_i0 | PRJEB12296 | 382 | 217 | 2.861702 | 6.20989334 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 185 | 1.81e-42 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g369 | i0 | 93.548 | 110.470046082949 | 124 | 8 | 80 | 0 | 71 | 194 | 6376 | 6253 | 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 | 23972 | 185 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25500744 | 25500744 | PRJEB12296_S_NODE_3217_length_249_cov_2.612150_g3185_i0 | PRJEB12296 | 3217 | 249 | 2.61215 | 6.5042535 | uncultured Amoebozoa | 590481 | Root_unresolved | Root_unresolved | 339 | 1.5399999999999998e-88 | NTclustered | gi|221185864|gb|FJ577811.1| | 590481 | g3185 | i0 | 94.248 | 21.425702811245 | 226 | 6 | 88 | 6 | 28 | 247 | 717 | 941 | Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence | blastn | 5335 | 339 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 25500814 | 25500814 | PRJEB12296_S_NODE_585_length_430_cov_484.187342_g555_i0 | PRJEB12296 | 585 | 430 | 484.187342 | 2082.0055706 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 87.9 | 1.14e-12 | NTclustered | gi|262262904|gb|FJ766447.1| | 472931 | g555 | i0 | 80.702 | 13.9116279069767 | 114 | 20 | 27 | 2 | 312 | 425 | 1298 | 1187 | Protostelium mycophagum strain HI06-7A-1 small subunit ribosomal RNA gene, partial sequence | blastn | 5982 | 87.9 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 25500855 | 25500855 | PRJEB12296_S_NODE_8113_length_182_cov_2.102041_g8081_i0 | PRJEB12296 | 8113 | 182 | 2.102041 | 3.82571462 | Ripella sp. 8 | 1973050 | Discosea | other_Eukaryota | 235 | 1.43e-57 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g8081 | i0 | 98.496 | 57.3516483516484 | 133 | 2 | 73 | 0 | 1 | 133 | 170 | 38 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 10438 | 235 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 25606819 | 25606819 | PRJEB12296_S_NODE_1609_length_317_cov_9.170213_g1577_i0 | PRJEB12296 | 1609 | 317 | 9.170213 | 29.06957521 | Vermistella | 354201 | Discosea | other_Eukaryota | 100 | 1.05e-16 | NTclustered | gi|766943132|gb|KJ874207.1| | 1628650 | g1577 | i0 | 90.667 | 25.9116719242902 | 75 | 7 | 24 | 0 | 1 | 75 | 1596 | 1522 | Vermistella sp. TT-2015a strain SV198 clone 1 18S ribosomal RNA gene, partial sequence | blastn | 8214 | 100 | 1 | Eukaryota | Amoebozoa | Discosea | Stygamoebida | Vermistella | Vermistella arctica | ||||
| 25636587 | 25636587 | PRJEB12296_S_NODE_3834_length_233_cov_2.348485_g3802_i0 | PRJEB12296 | 3834 | 233 | 2.348485 | 5.47197005 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 383 | 6.51e-102 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g3802 | i0 | 99.524 | 60.725321888412 | 210 | 1 | 90 | 0 | 1 | 210 | 643 | 434 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 14149 | 383 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 25636723 | 25636723 | PRJEB12296_S_NODE_986_length_367_cov_3.228916_g954_i0 | PRJEB12296 | 986 | 367 | 3.228916 | 11.85012172 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 612 | 1.2699999999999999e-170 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g954 | i0 | 96.73 | 67.6839237057221 | 367 | 12 | 100 | 0 | 1 | 367 | 2290 | 2656 | 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 | 24840 | 612 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 25772744 | 25772744 | PRJEB12296_S_NODE_2763_length_264_cov_278.336245_g2731_i0 | PRJEB12296 | 2763 | 264 | 278.336245 | 734.8076868 | Thecamoeba similis | 242545 | Discosea | other_Eukaryota | 243 | 1.33e-59 | NTclustered | gi|33946350|gb|AY294154.1| | 242545 | g2731 | i0 | 89.286 | 72.5909090909091 | 196 | 18 | 73 | 3 | 40 | 233 | 972 | 1166 | Thecamoeba similis actin mRNA, complete cds | blastn | 19164 | 243 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba similis | |||
| 25772863 | 25772863 | PRJEB12296_S_NODE_7403_length_187_cov_1.921053_g7371_i0 | PRJEB12296 | 7403 | 187 | 1.921053 | 3.59236911 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 279 | 6.74e-71 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g7371 | i0 | 96.45 | 54.620320855615 | 169 | 6 | 90 | 0 | 1 | 169 | 4231 | 4399 | 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 | 10214 | 279 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 25878811 | 25878811 | PRJEB12296_S_NODE_1963_length_297_cov_87.240458_g1931_i0 | PRJEB12296 | 1963 | 297 | 87.240458 | 259.10416026 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 486 | 6.379999999999998e-133 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g1931 | i0 | 98.545 | 34.4478114478114 | 275 | 4 | 93 | 0 | 22 | 296 | 1220 | 946 | 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 | 10231 | 486 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25908905 | 25908905 | PRJEB12296_S_NODE_2500_length_274_cov_1.820084_g2468_i0 | PRJEB12296 | 2500 | 274 | 1.820084 | 4.98703016 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 466 | 7.58e-127 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g2468 | i0 | 98.485 | 35.985401459854 | 264 | 4 | 96 | 0 | 1 | 264 | 871 | 1134 | 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 | 9860 | 466 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 25908944 | 25908944 | PRJEB12296_S_NODE_3820_length_233_cov_8.156566_g3788_i0 | PRJEB12296 | 3820 | 233 | 8.156566 | 19.00479878 | Copromyxa sp. PKD 2 | 3118317 | Tubulinea | other_Eukaryota | 431 | 2.2899999999999996e-116 | NTclustered | gi|399764168|gb|JQ271679.1| | 1215977 | g3788 | i0 | 100 | 63.7081545064378 | 233 | 0 | 100 | 0 | 1 | 233 | 411 | 179 | Copromyxa sp. PKD 2011 strain ZEB4 18S ribosomal RNA gene, partial sequence | blastn | 14844 | 431 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 | ||
| 26151257 | 26151257 | PRJEB12296_S_NODE_10205_length_172_cov_2.357664_g10173_i0 | PRJEB12296 | 10205 | 172 | 2.357664 | 4.05518208 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 252 | 1.33e-62 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g10173 | i0 | 100 | 62.2383720930233 | 136 | 0 | 79 | 0 | 2 | 137 | 5265 | 5400 | 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 | 10705 | 252 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26181257 | 26181257 | PRJEB12296_S_NODE_5582_length_204_cov_1.360947_g5550_i0 | PRJEB12296 | 5582 | 204 | 1.360947 | 2.77633188 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 294 | 2.68e-75 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g5550 | i0 | 92.683 | 12.6617647058824 | 205 | 14 | 100 | 1 | 1 | 204 | 654 | 858 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 2583 | 294 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 26181328 | 26181328 | PRJEB12296_S_NODE_894_length_377_cov_3414.862573_g863_i0 | PRJEB12296 | 894 | 377 | 3414.862573 | 12874.03190021 | uncultured Amoebozoa | 590481 | Root_unresolved | Root_unresolved | 292 | 1.94e-74 | NTclustered | gi|1569055459|gb|MK499381.1| | 590481 | g863 | i0 | 84.983 | 75.9787798408488 | 293 | 39 | 77 | 5 | 1 | 292 | 561 | 273 | Uncultured Amoebozoa clone KRN_S7s3 small subunit ribosomal RNA gene, partial sequence | blastn | 28644 | 292 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 26316988 | 26316988 | PRJEB12296_S_NODE_5311_length_207_cov_7.726744_g5279_i0 | PRJEB12296 | 5311 | 207 | 7.726744 | 15.99436008 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 377 | 2.63e-100 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g5279 | i0 | 99.517 | 3.27536231884058 | 207 | 1 | 100 | 0 | 1 | 207 | 6317 | 6111 | 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 | 678 | 377 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26317022 | 26317022 | PRJEB12296_S_NODE_7231_length_188_cov_4.522876_g7199_i0 | PRJEB12296 | 7231 | 188 | 4.522876 | 8.50300688 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 99 | 2.04e-16 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g7199 | i0 | 87.356 | 1.61702127659574 | 87 | 10 | 46 | 1 | 103 | 188 | 6888 | 6802 | 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 | 304 | 99 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26453071 | 26453071 | PRJEB12296_S_NODE_11208_length_168_cov_5.736842_g11176_i0 | PRJEB12296 | 11208 | 168 | 5.736842 | 9.63789456 | Protacanthamoeba bohemica | 325062 | Discosea | other_Eukaryota | 198 | 1.7099999999999997e-46 | NTclustered | gi|2806326584|gb|PQ345834.1| | 325062 | g11176 | i0 | 90.604 | 36.1488095238095 | 149 | 14 | 89 | 0 | 3 | 151 | 143 | 291 | Protacanthamoeba bohemica isolate 6FSb1 small subunit ribosomal RNA gene, partial sequence | blastn | 6073 | 198 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Protacanthamoeba | Protacanthamoeba bohemica | |||
| 26453106 | 26453106 | PRJEB12296_S_NODE_1440_length_328_cov_8.696246_g1408_i0 | PRJEB12296 | 1440 | 328 | 8.696246 | 28.52368688 | Protacanthamoeba bohemica | 325062 | Discosea | other_Eukaryota | 446 | 1.21e-120 | NTclustered | gi|62825358|gb|AY960120.1| | 325062 | g1408 | i0 | 91.541 | 79.015243902439 | 331 | 16 | 100 | 7 | 1 | 328 | 1118 | 797 | Protacanthamoeba bohemica small subunit ribosomal RNA gene, complete sequence | blastn | 25917 | 446 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Protacanthamoeba | Protacanthamoeba bohemica | |||
| 26453233 | 26453233 | PRJEB12296_S_NODE_4136_length_226_cov_3.722513_g4104_i0 | PRJEB12296 | 4136 | 226 | 3.722513 | 8.41287938 | Protacanthamoeba bohemica | 325062 | Discosea | other_Eukaryota | 272 | 1.42e-68 | NTclustered | gi|2806326584|gb|PQ345834.1| | 325062 | g4104 | i0 | 91.584 | 65.8230088495575 | 202 | 10 | 88 | 6 | 13 | 211 | 276 | 473 | Protacanthamoeba bohemica isolate 6FSb1 small subunit ribosomal RNA gene, partial sequence | blastn | 14876 | 272 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Protacanthamoeba | Protacanthamoeba bohemica |
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);;