contig_metadata
16 rows where bioproject = "PRJNA1120771", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2827296 | 2827296 | PRJNA1120771_S_NODE_27403_length_230_cov_2.374332_g27003_i0 | PRJNA1120771 | 27403 | 230 | 2.374332 | 5.4609636 | Cercomonas sp. | 1979794 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 1.85e-77 | NTclustered | gi|2651357794|gb|PP174308.1| | 1979794 | g27003 | i0 | 90.517 | 100.604347826087 | 232 | 16 | 100 | 6 | 1 | 230 | 3711 | 3938 | 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 | 23139 | 302 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. | |||
| 4103713 | 4103713 | PRJNA1120771_S_NODE_30164_length_221_cov_2.640449_g29764_i0 | PRJNA1120771 | 30164 | 221 | 2.640449 | 5.83539229 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 3.8900000000000003e-59 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g29764 | i0 | 94.268 | 69.0859728506787 | 157 | 9 | 71 | 0 | 3 | 159 | 3700 | 3856 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 15268 | 241 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 4103782 | 4103782 | PRJNA1120771_S_NODE_6644_length_388_cov_2.443478_g6244_i0 | PRJNA1120771 | 6644 | 388 | 2.443478 | 9.48069464 | Cercomonas agilis | 310805 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 9.47e-63 | NTclustered | gi|58414956|gb|AY748813.1| | 310805 | g6244 | i0 | 86.784 | 98 | 227 | 30 | 59 | 0 | 153 | 379 | 227 | 1 | Cercomonas agilis polyubiquitin (UBQ) gene, partial cds | blastn | 38024 | 254 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas agilis | |||
| 6131446 | 6131446 | PRJNA1120771_S_NODE_32265_length_215_cov_2.529070_g31865_i0 | PRJNA1120771 | 32265 | 215 | 2.52907 | 5.4375005 | Cercomonadidae | 45108 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 9.83e-105 | NTclustered | gi|62184287|gb|AY884341.1| | 321452 | g31865 | i0 | 99.535 | 99.553488372093 | 215 | 1 | 100 | 0 | 1 | 215 | 891 | 677 | Cercomonas sp. strain 19-5C small subunit ribosomal RNA gene, partial sequence | blastn | 21404 | 392 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. strain 19-5C | |||
| 11231901 | 11231901 | PRJNA1120771_S_NODE_5709_length_409_cov_17.672131_g5309_i0 | PRJNA1120771 | 5709 | 409 | 17.672131 | 72.27901579 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 756 | 0 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g5309 | i0 | 100 | 100.19804400978 | 409 | 0 | 100 | 0 | 1 | 409 | 620 | 1028 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 40981 | 756 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 11755097 | 11755097 | PRJNA1120771_S_NODE_16570_length_280_cov_9.911392_g16170_i0 | PRJNA1120771 | 16570 | 280 | 9.911392 | 27.7518976 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 512 | 9.85e-141 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g16170 | i0 | 99.643 | 99.4 | 280 | 1 | 100 | 0 | 1 | 280 | 1839 | 2118 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 27832 | 512 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 11755149 | 11755149 | PRJNA1120771_S_NODE_2490_length_566_cov_58.221797_g2130_i0 | PRJNA1120771 | 2490 | 566 | 58.221797 | 329.53537102 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 1.39e-82 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g2130 | i0 | 82.687 | 36.9399293286219 | 387 | 42 | 68 | 17 | 183 | 566 | 4039 | 3675 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20908 | 320 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 14305492 | 14305492 | PRJNA1120771_S_NODE_27252_length_230_cov_10.588235_g26852_i0 | PRJNA1120771 | 27252 | 230 | 10.588235 | 24.3529405 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.05e-114 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g26852 | i0 | 100 | 97.6739130434783 | 230 | 0 | 100 | 0 | 1 | 230 | 2687 | 2916 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 22465 | 425 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 15056260 | 15056260 | PRJNA1120771_S_NODE_38492_length_195_cov_4.565789_g38092_i0 | PRJNA1120771 | 38492 | 195 | 4.565789 | 8.90328855 | Thaumatomastigidae | 45098 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 2.74e-20 | NTclustered | gi|88792586|gb|DQ386167.1| | 188980 | g38092 | i0 | 100 | 26.0512820512821 | 60 | 0 | 31 | 0 | 1 | 60 | 2009 | 2068 | Thaumatomastix sp. ATCC 50250 28S ribosomal RNA gene, partial sequence | blastn | 5080 | 111 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomastix | Thaumatomastix sp. ATCC 50250 | ||
| 16853967 | 16853967 | PRJNA1120771_S_NODE_5354_length_419_cov_13.728723_g4954_i0 | PRJNA1120771 | 5354 | 419 | 13.728723 | 57.52334937 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 3.479999999999999e-107 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g4954 | i0 | 86.305 | 50.0453460620525 | 387 | 32 | 92 | 13 | 35 | 419 | 4042 | 3675 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20969 | 401 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 19402594 | 19402594 | PRJNA1120771_S_NODE_8296_length_359_cov_3.965190_g7896_i0 | PRJNA1120771 | 8296 | 359 | 3.96519 | 14.2350321 | Paracercomonas crassicauda | 466266 | SAR_Eukaryotes | SAR_Eukaryotes | 573 | 5.87e-159 | NTclustered | gi|262262832|gb|FJ790725.1| | 466266 | g7896 | i0 | 96.542 | 94.8189415041783 | 347 | 10 | 96 | 2 | 1 | 346 | 383 | 38 | Paracercomonas crassicauda strain ATCC 50316 18S ribosomal RNA gene, partial sequence | blastn | 34040 | 573 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas crassicauda | |||
| 20678084 | 20678084 | PRJNA1120771_S_NODE_26457_length_233_cov_5.147368_g26057_i0 | PRJNA1120771 | 26457 | 233 | 5.147368 | 11.99336744 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 431 | 2.2899999999999996e-116 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g26057 | i0 | 100 | 83.8755364806867 | 233 | 0 | 100 | 0 | 1 | 233 | 1693 | 1461 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 19543 | 431 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 20678154 | 20678154 | PRJNA1120771_S_NODE_35117_length_207_cov_4.243902_g34717_i0 | PRJNA1120771 | 35117 | 207 | 4.243902 | 8.78487714 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 364 | 2.0499999999999993e-96 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g34717 | i0 | 100 | 95.5410628019324 | 197 | 0 | 95 | 0 | 11 | 207 | 1015 | 819 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 19777 | 364 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 21953532 | 21953532 | PRJNA1120771_S_NODE_9058_length_348_cov_1.888525_g8658_i0 | PRJNA1120771 | 9058 | 348 | 1.888525 | 6.572067 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 7.96e-103 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g8658 | i0 | 86.857 | 100.864942528736 | 350 | 40 | 100 | 5 | 1 | 348 | 1246 | 1591 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 35101 | 387 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 29785713 | 29785713 | PRJNA1120771_S_NODE_14491_length_294_cov_4.159363_g14091_i0 | PRJNA1120771 | 14491 | 294 | 4.159363 | 12.22852722 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 79.3 | 2.27e-17 | NR | MES1911722.1 | 1215613 | g14091 | i0 | 73.9 | 0.469387755102041 | 46 | 12 | 46.9 | 0 | 2 | 139 | 8 | 53 | MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 138 | 79.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32378097 | 32378097 | PRJNA1120771_S_NODE_17639_length_274_cov_1.852814_g17239_i0 | PRJNA1120771 | 17639 | 274 | 1.852814 | 5.07671036 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 2.55e-16 | NR | MES1915627.1 | 1215613 | g17239 | i0 | 51.9 | 1.67518248175182 | 77 | 37 | 84.3 | 0 | 272 | 42 | 351 | 427 | MES1915627.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 459 | 83.2 | 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);;