contig_metadata
21 rows where bioproject = "PRJNA306153" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1062311 | 1062311 | PRJNA306153_S_NODE_2201_length_168_cov_7.280576_g2188_i0 | PRJNA306153 | 2201 | 168 | 7.280576 | 12.23136768 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 9.81e-79 | NTclustered | gi|83034975|gb|DQ211604.1| | 352465 | g2188 | i0 | 100 | 96.8571428571429 | 165 | 0 | 98 | 0 | 1 | 165 | 313 | 477 | Bodomorpha sp. HFCC57 28S ribosomal RNA gene, partial sequence | blastn | 16272 | 305 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC57 | |||
| 1062320 | 1062320 | PRJNA306153_S_NODE_981_length_242_cov_12.042254_g968_i0 | PRJNA306153 | 981 | 242 | 12.042254 | 29.14225468 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 448 | 2.3799999999999995e-121 | NTclustered | gi|2493707699|dbj|LC764482.1| | 45107 | g968 | i0 | 100 | 100 | 242 | 0 | 100 | 0 | 1 | 242 | 744 | 985 | Heteromita globosa LAP3-2017 gene for 18S rRNA, partial sequence | blastn | 24200 | 448 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 1651157 | 1651157 | PRJNA306153_S_NODE_482_length_329_cov_6.783333_g469_i0 | PRJNA306153 | 482 | 329 | 6.783333 | 22.31716557 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 608 | 1.4599999999999995e-169 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g469 | i0 | 100 | 84.048632218845 | 329 | 0 | 100 | 0 | 1 | 329 | 335 | 663 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 27652 | 608 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 1651161 | 1651161 | PRJNA306153_S_NODE_982_length_242_cov_4.539906_g969_i0 | PRJNA306153 | 982 | 242 | 4.539906 | 10.98657252 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.48e-93 | NTclustered | gi|300676732|gb|GQ377662.1| | 188950 | g969 | i0 | 98.99 | 96.8347107438017 | 198 | 2 | 82 | 0 | 45 | 242 | 1120 | 923 | Bodomorpha minima alpha-tubulin (Atub) gene, partial cds | blastn | 23434 | 355 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 3612785 | 3612785 | PRJNA306153_S_NODE_1523_length_197_cov_16.333333_g1510_i0 | PRJNA306153 | 1523 | 197 | 16.333333 | 32.17666601 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 1.17e-88 | NTclustered | gi|219524778|gb|EU709141.1| | 175275 | g1510 | i0 | 98.429 | 96.9543147208122 | 191 | 3 | 97 | 0 | 1 | 191 | 1528 | 1338 | Uncultured cercozoan isolate HetChi37 18S ribosomal RNA gene, partial sequence | blastn | 19100 | 342 | 0.991228070175439 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 4203533 | 4203533 | PRJNA306153_S_NODE_2304_length_164_cov_4.429630_g2291_i0 | PRJNA306153 | 2304 | 164 | 4.42963 | 7.2645932 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.42e-78 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g2291 | i0 | 100 | 99.4939024390244 | 164 | 0 | 100 | 0 | 1 | 164 | 1014 | 851 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 16317 | 303 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 4203539 | 4203539 | PRJNA306153_S_NODE_844_length_260_cov_4.554113_g831_i0 | PRJNA306153 | 844 | 260 | 4.554113 | 11.8406938 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 1.44e-31 | NR | MES1907458.1 | 1215613 | g831 | i0 | 70.2 | 1.95 | 84 | 25 | 96.9 | 0 | 4 | 255 | 76 | 159 | MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 507 | 121 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 5479839 | 5479839 | PRJNA306153_S_NODE_1945_length_178_cov_2.342282_g1932_i0 | PRJNA306153 | 1945 | 178 | 2.342282 | 4.16926196 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 1.54e-25 | NR | AAT09077.1 | 227086 | g1932 | i0 | 84.2 | 1.93820224719101 | 57 | 9 | 96.1 | 0 | 178 | 8 | 59 | 115 | AAT09077.1 transcription factor BTF3 [Bigelowiella natans] | diamond | 345 | 101 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 5479843 | 5479843 | PRJNA306153_S_NODE_345_length_374_cov_12.591304_g332_i0 | PRJNA306153 | 345 | 374 | 12.591304 | 47.09147696 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 3.069999999999999e-107 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g332 | i0 | 86.885 | 54.2058823529412 | 366 | 39 | 97 | 9 | 1 | 362 | 3661 | 4021 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20273 | 401 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 6754011 | 6754011 | PRJNA306153_S_NODE_846_length_260_cov_3.220779_g833_i0 | PRJNA306153 | 846 | 260 | 3.220779 | 8.3740254 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 464 | 2.57e-126 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g833 | i0 | 98.846 | 68.9461538461538 | 260 | 3 | 100 | 0 | 1 | 260 | 419 | 678 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 17926 | 464 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 8714896 | 8714896 | PRJNA306153_S_NODE_2087_length_172_cov_12.475524_g2074_i0 | PRJNA306153 | 2087 | 172 | 12.475524 | 21.45790128 | root | 1 | Root_unresolved | Root_unresolved | 309 | 7.75e-80 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g2074 | i0 | 98.851 | 99.8604651162791 | 174 | 0 | 100 | 1 | 1 | 172 | 2536 | 2363 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 17176 | 309 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 9304414 | 9304414 | PRJNA306153_S_NODE_1088_length_229_cov_9.815000_g1075_i0 | PRJNA306153 | 1088 | 229 | 9.815 | 22.47635 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 3.28e-30 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g1075 | i0 | 78.355 | 32.2794759825328 | 231 | 44 | 99 | 6 | 1 | 228 | 1656 | 1883 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 7392 | 145 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 9990399 | 9990399 | PRJNA306153_S_NODE_1688_length_189_cov_9.325000_g1675_i0 | PRJNA306153 | 1688 | 189 | 9.325 | 17.62425 | root | 1 | Root_unresolved | Root_unresolved | 87.9 | 4.45e-13 | NTclustered | gi|220983376|dbj|AB453012.1| | 552662 | g1675 | i0 | 93.22 | 2.28042328042328 | 59 | 4 | 31 | 0 | 128 | 186 | 3548 | 3606 | Cercozoa sp. YPF501 gene for nuclear large subunit ribosomal RNA, partial sequence | blastn | 431 | 87.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. YPF501 | ||||||
| 10580301 | 10580301 | PRJNA306153_S_NODE_489_length_327_cov_22.651007_g476_i0 | PRJNA306153 | 489 | 327 | 22.651007 | 74.06879289 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 407 | 5.7e-109 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g476 | i0 | 94.03 | 82.3608562691132 | 268 | 16 | 82 | 0 | 1 | 268 | 1171 | 1438 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 26932 | 407 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 11855021 | 11855021 | PRJNA306153_S_NODE_590_length_303_cov_9.839416_g577_i0 | PRJNA306153 | 590 | 303 | 9.839416 | 29.81343048 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 542 | 1.37e-149 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g577 | i0 | 99.007 | 99.9240924092409 | 302 | 3 | 99 | 0 | 2 | 303 | 330 | 29 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 30277 | 542 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 15679121 | 15679121 | PRJNA306153_S_NODE_2353_length_162_cov_7.443609_g2340_i0 | PRJNA306153 | 2353 | 162 | 7.443609 | 12.05864658 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.36e-77 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g2340 | i0 | 100 | 54.0308641975309 | 162 | 0 | 100 | 0 | 1 | 162 | 2687 | 2848 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 8753 | 300 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 16953725 | 16953725 | PRJNA306153_S_NODE_2434_length_159_cov_5.469231_g2421_i0 | PRJNA306153 | 2434 | 159 | 5.469231 | 8.69607729 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 4.29e-72 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g2421 | i0 | 98.742 | 95.3962264150943 | 159 | 2 | 100 | 0 | 1 | 159 | 4 | 162 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 15168 | 283 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 22052887 | 22052887 | PRJNA306153_S_NODE_2378_length_161_cov_4.151515_g2365_i0 | PRJNA306153 | 2378 | 161 | 4.151515 | 6.68393915 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 1.56e-76 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g2365 | i0 | 100 | 1 | 161 | 0 | 100 | 0 | 1 | 161 | 455 | 615 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 161 | 298 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 22739052 | 22739052 | PRJNA306153_S_NODE_2578_length_155_cov_12.452381_g2565_i0 | PRJNA306153 | 2578 | 155 | 12.452381 | 19.30119055 | Imbricatea | 1736114 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 6.95e-70 | NTclustered | gi|46393899|gb|AY496043.1| | 45107 | g2565 | i0 | 99.342 | 98.0645161290323 | 152 | 1 | 98 | 0 | 3 | 154 | 1104 | 1255 | Heteromita globosa strain SCCAP H251 small subunit ribosomal RNA gene, partial sequence | blastn | 15200 | 276 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 23328382 | 23328382 | PRJNA306153_S_NODE_1259_length_214_cov_12.767568_g1246_i0 | PRJNA306153 | 1259 | 214 | 12.767568 | 27.32259552 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.28e-93 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g1246 | i0 | 96.714 | 97.7757009345794 | 213 | 7 | 99 | 0 | 2 | 214 | 1605 | 1393 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 20924 | 355 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 24602451 | 24602451 | PRJNA306153_S_NODE_1180_length_221_cov_6.791667_g1167_i0 | PRJNA306153 | 1180 | 221 | 6.791667 | 15.00958407 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 409 | 1.0100000000000001e-109 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g1167 | i0 | 100 | 9.3393665158371 | 221 | 0 | 100 | 0 | 1 | 221 | 589 | 809 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 2064 | 409 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima |
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);;