contig_metadata
21 rows where bioproject = "PRJNA492406", tax_clade = "Sar" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 452720 | 452720 | PRJNA492406_P_NODE_31161_length_242_cov_44.372781_g30862_i0 | PRJNA492406 | 31161 | 242 | 44.372781 | 107.38213002 | Glissomonad sp. Panama103 | 563749 | SAR_Eukaryotes | SAR_Eukaryotes | 442 | 1.1099999999999995e-119 | NTclustered | gi|219524909|gb|EU709272.1| | 563749 | g30862 | i0 | 99.587 | 100.950413223141 | 242 | 1 | 100 | 0 | 1 | 242 | 22 | 263 | Glissomonad sp. Panama103 18S ribosomal RNA gene, partial sequence | blastn | 24430 | 442 | 1 | Eukaryota | Sar | Cercozoa | Glissomonad sp. Panama103 | ||||||
| 452865 | 452865 | PRJNA492406_P_NODE_7161_length_451_cov_225.558201_g6862_i0 | PRJNA492406 | 7161 | 451 | 225.558201 | 1017.26748651 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 403 | 1.0499999999999997e-107 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g6862 | i0 | 86.757 | 41.980044345898 | 370 | 40 | 81 | 8 | 84 | 450 | 4042 | 3679 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 18933 | 403 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 3003334 | 3003334 | PRJNA492406_P_NODE_29723_length_245_cov_1.343023_g29424_i0 | PRJNA492406 | 29723 | 245 | 1.343023 | 3.29040635 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 348 | 2.5200000000000005e-91 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g29424 | i0 | 92.887 | 1.19591836734694 | 239 | 17 | 98 | 0 | 7 | 245 | 17970 | 17732 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 293 | 348 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 3003581 | 3003581 | PRJNA492406_P_NODE_943_length_1237_cov_3.127148_g759_i0 | PRJNA492406 | 943 | 1237 | 3.127148 | 38.68282076 | Cercozoa sp. DMV | 1342330 | SAR_Eukaryotes | SAR_Eukaryotes | 423 | 2.66e-142 | NR | BAN37425.1 | 1342330 | g759 | i0 | 73.1 | 2.59741309620048 | 271 | 73 | 65.7 | 0 | 1236 | 424 | 166 | 436 | BAN37425.1 elongation factor 1-alpha [Cercozoa sp. DMV] | diamond | 3213 | 423 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. DMV | ||||||
| 3650397 | 3650397 | PRJNA492406_P_NODE_25523_length_256_cov_1.262295_g25224_i0 | PRJNA492406 | 25523 | 256 | 1.262295 | 3.2314752 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 166 | 3.19e-51 | NR | ADK26622.1 | 323453 | g25224 | i0 | 94 | 0.984375 | 84 | 5 | 98.4 | 0 | 254 | 3 | 37 | 120 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 252 | 166 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 4279248 | 4279248 | PRJNA492406_P_NODE_10704_length_377_cov_46.736842_g10405_i0 | PRJNA492406 | 10704 | 377 | 46.736842 | 176.19789434 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 630 | 3.629999999999999e-176 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g10405 | i0 | 97.059 | 100.814323607427 | 374 | 11 | 99 | 0 | 1 | 374 | 1214 | 1587 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 38007 | 630 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 6830230 | 6830230 | PRJNA492406_P_NODE_31726_length_241_cov_2.083333_g31427_i0 | PRJNA492406 | 31726 | 241 | 2.083333 | 5.02083253 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 1.55e-58 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g31427 | i0 | 84.49 | 52.4107883817427 | 245 | 34 | 100 | 4 | 1 | 241 | 2302 | 2058 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 12631 | 239 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 11931468 | 11931468 | PRJNA492406_P_NODE_8670_length_414_cov_5.407625_g8371_i0 | PRJNA492406 | 8670 | 414 | 5.407625 | 22.3875675 | Cercomonas sp. HFCC549 | 458874 | SAR_Eukaryotes | SAR_Eukaryotes | 737 | 0 | NTclustered | gi|161015714|gb|EF681948.1| | 458874 | g8371 | i0 | 98.792 | 36.2125603864734 | 414 | 5 | 100 | 0 | 1 | 414 | 658 | 245 | Cercomonas sp. HFCC549 28S ribosomal RNA gene, partial sequence | blastn | 14992 | 737 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC549 | |||
| 14480903 | 14480903 | PRJNA492406_P_NODE_13772_length_337_cov_7.693182_g13473_i0 | PRJNA492406 | 13772 | 337 | 7.693182 | 25.92602334 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 2.1799999999999997e-88 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g13473 | i0 | 85.588 | 52.7448071216617 | 340 | 29 | 99 | 11 | 1 | 336 | 3686 | 4009 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 17775 | 339 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 14480980 | 14480980 | PRJNA492406_P_NODE_16692_length_306_cov_2.416309_g16393_i0 | PRJNA492406 | 16692 | 306 | 2.416309 | 7.3939055400000004 | Cercomonas sp. | 1979794 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 5.4e-94 | NTclustered | gi|2651357794|gb|PP174308.1| | 1979794 | g16393 | i0 | 88.026 | 93.718954248366 | 309 | 28 | 100 | 8 | 1 | 306 | 3757 | 4059 | Cercomonas sp. isolate JGP5 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 | 28678 | 357 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. | |||
| 15755363 | 15755363 | PRJNA492406_P_NODE_4793_length_546_cov_2.750529_g4498_i0 | PRJNA492406 | 4793 | 546 | 2.750529 | 15.01788834 | Sandona mutans | 563755 | SAR_Eukaryotes | SAR_Eukaryotes | 745 | 0 | NTclustered | gi|224996445|gb|FJ654277.1| | 563755 | g4498 | i0 | 99.754 | 84.2527472527473 | 407 | 0 | 75 | 1 | 1 | 407 | 407 | 2 | Cercozoa sp. ATCC50314p145at3 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 46002 | 745 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Sandonidae | Sandona | Sandona mutans | |||
| 17676892 | 17676892 | PRJNA492406_P_NODE_21654_length_275_cov_2.079208_g21355_i0 | PRJNA492406 | 21654 | 275 | 2.079208 | 5.717822 | Thaumatomonadida | 188944 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 8e-92 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g21355 | i0 | 90.84 | 94.8545454545455 | 262 | 22 | 95 | 2 | 2 | 263 | 2000 | 1741 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 26085 | 350 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 18304391 | 18304391 | PRJNA492406_P_NODE_5695_length_503_cov_2.009302_g5396_i0 | PRJNA492406 | 5695 | 503 | 2.009302 | 10.10678906 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 459 | 2.4799999999999993e-124 | NTclustered | gi|116222176|gb|DQ980464.1| | 407209 | g5396 | i0 | 83.301 | 83.7415506958251 | 521 | 63 | 100 | 15 | 1 | 503 | 568 | 54 | Thaumatomonas sp. TMT002 Hsp90 mRNA, partial cds | blastn | 42122 | 459 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 20854197 | 20854197 | PRJNA492406_P_NODE_25257_length_257_cov_1.630435_g24958_i0 | PRJNA492406 | 25257 | 257 | 1.630435 | 4.19021795 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 1.3499999999999997e-42 | NR | MES1909201.1 | 1215613 | g24958 | i0 | 81.9 | 1.92607003891051 | 83 | 14 | 96.9 | 1 | 4 | 252 | 633 | 714 | MES1909201.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 495 | 157 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 22128692 | 22128692 | PRJNA492406_P_NODE_14278_length_331_cov_6.717054_g13979_i0 | PRJNA492406 | 14278 | 331 | 6.717054 | 22.23344874 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 606 | 5.299999999999998e-169 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g13979 | i0 | 99.698 | 97.7099697885196 | 331 | 1 | 100 | 0 | 1 | 331 | 1609 | 1939 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 32342 | 606 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 24678797 | 24678797 | PRJNA492406_P_NODE_5780_length_499_cov_2.805164_g5481_i0 | PRJNA492406 | 5780 | 499 | 2.805164 | 13.99776836 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 1.4600000000000003e-79 | NR | MES1911029.1 | 1215613 | g5481 | i0 | 74.7 | 3.01803607214429 | 166 | 42 | 99.8 | 0 | 498 | 1 | 8 | 173 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1506 | 248 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27550236 | 27550236 | PRJNA492406_P_NODE_24964_length_259_cov_1.198925_g24665_i0 | PRJNA492406 | 24964 | 259 | 1.198925 | 3.10521575 | Gymnochlora stellata | 67809 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 2.36e-27 | NR | ACF24578.1 | 67809 | g24665 | i0 | 60.3 | 0.903474903474903 | 78 | 31 | 90.3 | 0 | 236 | 3 | 1 | 78 | ACF24578.1 60S ribosomal protein L34 [Gymnochlora stellata] | diamond | 234 | 105 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Gymnochlora | Gymnochlora stellata | ||||
| 28087011 | 28087011 | PRJNA492406_P_NODE_24305_length_262_cov_1.296296_g24006_i0 | PRJNA492406 | 24305 | 262 | 1.296296 | 3.39629552 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 8.02e-38 | NR | ADK26624.1 | 323453 | g24006 | i0 | 75.3 | 0.973282442748092 | 85 | 21 | 97.3 | 0 | 261 | 7 | 192 | 276 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 255 | 137 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 29066068 | 29066068 | PRJNA492406_P_NODE_23908_length_264_cov_1.277487_g23609_i0 | PRJNA492406 | 23908 | 264 | 1.277487 | 3.37256568 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 2e-31 | NR | MES1907833.1 | 1215613 | g23609 | i0 | 63.9 | 0.943181818181818 | 83 | 29 | 93.2 | 1 | 18 | 263 | 133 | 215 | MES1907833.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 249 | 125 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30044671 | 30044671 | PRJNA492406_P_NODE_10031_length_388_cov_3.676190_g9732_i0 | PRJNA492406 | 10031 | 388 | 3.67619 | 14.2636172 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 98.6 | 3.34e-23 | NR | MES1908819.1 | 1215613 | g9732 | i0 | 43.3 | 0.981958762886598 | 127 | 69 | 96.6 | 2 | 5 | 379 | 35 | 160 | MES1908819.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 381 | 98.6 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31308682 | 31308682 | PRJNA492406_P_NODE_25455_length_256_cov_1.628415_g25156_i0 | PRJNA492406 | 25455 | 256 | 1.628415 | 4.1687424 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 7.32e-5 | NR | MES1916909.1 | 1215613 | g25156 | i0 | 58.8 | 0.796875 | 34 | 14 | 39.8 | 0 | 233 | 132 | 40 | 73 | MES1916909.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 204 | 47.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM |
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);;