contig_metadata
20 rows where bioproject = "PRJNA934472", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 911167 | 911167 | PRJNA934472_P_NODE_34241_length_254_cov_2.254144_g33863_i0 | PRJNA934472 | 34241 | 254 | 2.254144 | 5.72552576 | Cercomonas sp. | 1979794 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 1.6299999999999998e-68 | NTclustered | gi|2651357801|gb|PP174314.1| | 1979794 | g33863 | i0 | 86.454 | 41.6220472440945 | 251 | 30 | 97 | 3 | 6 | 252 | 2722 | 2472 | Cercomonas sp. isolate P5 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 | 10572 | 272 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. | |||
| 2186084 | 2186084 | PRJNA934472_P_NODE_13082_length_394_cov_21.305296_g12705_i0 | PRJNA934472 | 13082 | 394 | 21.305296 | 83.94286624 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 5.4e-110 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g12705 | i0 | 86.684 | 47.7944162436548 | 383 | 35 | 97 | 9 | 14 | 394 | 4039 | 3671 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 18831 | 411 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 3461607 | 3461607 | PRJNA934472_P_NODE_13043_length_395_cov_2.118012_g12666_i0 | PRJNA934472 | 13043 | 395 | 2.118012 | 8.3661474 | Bodomorpha sp. HFCC55 | 624126 | SAR_Eukaryotes | SAR_Eukaryotes | 721 | 0 | NTclustered | gi|225216790|gb|FJ176705.1| | 624126 | g12666 | i0 | 99.494 | 8.87848101265823 | 395 | 2 | 100 | 0 | 1 | 395 | 304 | 698 | Bodomorpha sp. 28S ribosomal RNA gene, partial sequence | blastn | 3507 | 721 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC55 | |||
| 3461619 | 3461619 | PRJNA934472_P_NODE_13903_length_383_cov_7.325806_g13526_i0 | PRJNA934472 | 13903 | 383 | 7.325806 | 28.05783698 | Cercomonas sp. | 1979794 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 2.77e-18 | NTclustered | gi|2651357781|gb|PP174297.1| | 1979794 | g13526 | i0 | 82.927 | 24.4073107049608 | 123 | 16 | 32 | 5 | 63 | 183 | 3862 | 3981 | Cercomonas sp. isolate JGP16 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 | 9348 | 106 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. | |||
| 4739629 | 4739629 | PRJNA934472_P_NODE_39884_length_229_cov_4.711538_g39506_i0 | PRJNA934472 | 39884 | 229 | 4.711538 | 10.78942202 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.52e-28 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g39506 | i0 | 96.429 | 22.8340611353712 | 84 | 3 | 37 | 0 | 2 | 85 | 3756 | 3839 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 5229 | 139 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 6014226 | 6014226 | PRJNA934472_P_NODE_26105_length_288_cov_2.158140_g25727_i0 | PRJNA934472 | 26105 | 288 | 2.15814 | 6.2154432 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 246 | 1.14e-60 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g25727 | i0 | 94.904 | 60.5277777777778 | 157 | 8 | 55 | 0 | 132 | 288 | 3849 | 3693 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 17432 | 246 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 6014538 | 6014538 | PRJNA934472_P_NODE_40505_length_202_cov_5.170543_g40127_i0 | PRJNA934472 | 40505 | 202 | 5.170543 | 10.44449686 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 7.149999999999999e-96 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g40127 | i0 | 99.01 | 33.2722772277228 | 202 | 2 | 100 | 0 | 1 | 202 | 2699 | 2900 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 6721 | 363 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 9838722 | 9838722 | PRJNA934472_P_NODE_14228_length_379_cov_8.212418_g13851_i0 | PRJNA934472 | 14228 | 379 | 8.212418 | 31.12506422 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 695 | 0 | NTclustered | gi|197723521|gb|EF681900.2| | 458884 | g13851 | i0 | 99.736 | 2 | 379 | 1 | 100 | 0 | 1 | 379 | 332 | 710 | Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence | blastn | 758 | 695 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 9839254 | 9839254 | PRJNA934472_P_NODE_40448_length_205_cov_11.303030_g40070_i0 | PRJNA934472 | 40448 | 205 | 11.30303 | 23.1712115 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 3.4600000000000006e-79 | NTclustered | gi|238617604|gb|FJ973379.1| | 646463 | g40070 | i0 | 93.659 | 97.6682926829268 | 205 | 13 | 100 | 0 | 1 | 205 | 2022 | 1818 | Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence | blastn | 20022 | 307 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 12389875 | 12389875 | PRJNA934472_P_NODE_11930_length_412_cov_120.233038_g11553_i0 | PRJNA934472 | 11930 | 412 | 120.233038 | 495.36011656 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 702 | 0 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g11553 | i0 | 97.349 | 100.597087378641 | 415 | 8 | 100 | 3 | 1 | 412 | 2561 | 2147 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 41446 | 702 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 12390082 | 12390082 | PRJNA934472_P_NODE_22150_length_310_cov_11.434599_g21772_i0 | PRJNA934472 | 22150 | 310 | 11.434599 | 35.4472569 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 3.32e-86 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g21772 | i0 | 86.129 | 79.7129032258065 | 310 | 40 | 100 | 3 | 1 | 310 | 1279 | 1585 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 24711 | 331 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 13664790 | 13664790 | PRJNA934472_P_NODE_36391_length_247_cov_83.718391_g36013_i0 | PRJNA934472 | 36391 | 247 | 83.718391 | 206.78442577 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 457 | 4.05e-124 | NTclustered | gi|571959503|gb|KF994989.1| | 175275 | g36013 | i0 | 100 | 100 | 247 | 0 | 100 | 0 | 1 | 247 | 384 | 138 | Uncultured cercozoan isolate DGGE gel band 1c-7 18S ribosomal RNA gene, partial sequence | blastn | 24700 | 457 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 14938956 | 14938956 | PRJNA934472_P_NODE_28432_length_277_cov_14.254902_g28054_i0 | PRJNA934472 | 28432 | 277 | 14.254902 | 39.48607854 | Cercomonas sp. | 1979794 | SAR_Eukaryotes | SAR_Eukaryotes | 364 | 2.879999999999999e-96 | NTclustered | gi|2651357794|gb|PP174308.1| | 1979794 | g28054 | i0 | 90.714 | 99.8628158844765 | 280 | 17 | 99 | 9 | 1 | 276 | 4059 | 3785 | 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 | 27662 | 364 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. | |||
| 17489306 | 17489306 | PRJNA934472_P_NODE_27354_length_282_cov_6.789474_g26976_i0 | PRJNA934472 | 27354 | 282 | 6.789474 | 19.14631668 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 4.06e-50 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g26976 | i0 | 81.295 | 32.7730496453901 | 278 | 37 | 98 | 9 | 6 | 282 | 4000 | 3737 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 9242 | 211 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 18762873 | 18762873 | PRJNA934472_P_NODE_36635_length_247_cov_1.160920_g36257_i0 | PRJNA934472 | 36635 | 247 | 1.16092 | 2.8674724 | Lotharella vacuolata | 74820 | SAR_Eukaryotes | SAR_Eukaryotes | 89.8 | 1.7e-13 | NTclustered | gi|290760484|gb|GQ144687.1| | 74820 | g36257 | i0 | 89.855 | 0.558704453441296 | 69 | 7 | 28 | 0 | 111 | 179 | 1732 | 1664 | Lotharella vacuolata large subunit ribosomal RNA gene, partial sequence | blastn | 138 | 89.8 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Lotharella | Lotharella vacuolata | ||||
| 20037562 | 20037562 | PRJNA934472_P_NODE_22836_length_306_cov_5.201717_g22458_i0 | PRJNA934472 | 22836 | 306 | 5.201717 | 15.91725402 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 481 | 3.069999999999999e-131 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g22458 | i0 | 95.098 | 98.8954248366013 | 306 | 13 | 99 | 2 | 2 | 306 | 1277 | 1581 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 30262 | 481 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 22587896 | 22587896 | PRJNA934472_P_NODE_22678_length_307_cov_4.632479_g22300_i0 | PRJNA934472 | 22678 | 307 | 4.632479 | 14.22171053 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 484 | 2.3799999999999994e-132 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g22300 | i0 | 95.41 | 93.3745928338762 | 305 | 13 | 99 | 1 | 4 | 307 | 1277 | 1581 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 28666 | 484 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 23863134 | 23863134 | PRJNA934472_P_NODE_16119_length_358_cov_13.364912_g15742_i0 | PRJNA934472 | 16119 | 358 | 13.364912 | 47.84638496 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 542 | 1.6499999999999999e-149 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g15742 | i0 | 93.923 | 1.01117318435754 | 362 | 17 | 100 | 5 | 1 | 358 | 768 | 408 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 362 | 542 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 23863313 | 23863313 | PRJNA934472_P_NODE_25659_length_290_cov_7.198157_g25281_i0 | PRJNA934472 | 25659 | 290 | 7.198157 | 20.8746553 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 1.14e-65 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g25281 | i0 | 84.043 | 60.7758620689655 | 282 | 36 | 97 | 8 | 9 | 290 | 3968 | 3696 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 17625 | 263 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 25136991 | 25136991 | PRJNA934472_P_NODE_19200_length_331_cov_33.496124_g18823_i0 | PRJNA934472 | 19200 | 331 | 33.496124 | 110.87217044 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 479 | 1.2099999999999996e-130 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g18823 | i0 | 92.749 | 96.8398791540785 | 331 | 24 | 100 | 0 | 1 | 331 | 1271 | 1601 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 32054 | 479 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa |
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);;