contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA692200" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 672568 | 672568 | PRJNA692200_S_NODE_11421_length_211_cov_2.228395_g11364_i0 | PRJNA692200 | 11421 | 211 | 2.228395 | 4.70191345 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 3.56e-84 | NTclustered | gi|300676732|gb|GQ377662.1| | 188950 | g11364 | i0 | 99.438 | 93.2796208530806 | 178 | 1 | 84 | 0 | 4 | 181 | 943 | 1120 | Bodomorpha minima alpha-tubulin (Atub) gene, partial cds | blastn | 19682 | 324 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 672755 | 672755 | PRJNA692200_S_NODE_1961_length_380_cov_1236.377644_g1904_i0 | PRJNA692200 | 1961 | 380 | 1236.377644 | 4698.2350472 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 560 | 4.87e-155 | NTclustered | gi|224996436|gb|FJ654268.1| | 188950 | g1904 | i0 | 96.254 | 18.5342105263158 | 347 | 3 | 89 | 3 | 43 | 380 | 475 | 130 | Bodomorpha minima 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 7043 | 560 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 3223845 | 3223845 | PRJNA692200_S_NODE_5963_length_271_cov_510.441441_g5906_i0 | PRJNA692200 | 5963 | 271 | 510.441441 | 1383.29630511 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 496 | 9.55e-136 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g5906 | i0 | 100 | 99.1070110701107 | 268 | 0 | 99 | 0 | 4 | 271 | 61 | 328 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 26858 | 496 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 4500540 | 4500540 | PRJNA692200_S_NODE_10784_length_216_cov_3.712575_g10727_i0 | PRJNA692200 | 10784 | 216 | 3.712575 | 8.019162 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 394 | 2.75e-105 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g10727 | i0 | 99.537 | 20.6990740740741 | 216 | 1 | 100 | 0 | 1 | 216 | 2404 | 2189 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 4471 | 394 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 5776514 | 5776514 | PRJNA692200_S_NODE_865_length_456_cov_33.368550_g825_i0 | PRJNA692200 | 865 | 456 | 33.36855 | 152.160588 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 5.18e-71 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g825 | i0 | 81.522 | 39.4890350877193 | 368 | 44 | 80 | 16 | 85 | 449 | 4039 | 3693 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 18007 | 281 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 7051586 | 7051586 | PRJNA692200_S_NODE_706_length_473_cov_1044.040094_g668_i0 | PRJNA692200 | 706 | 473 | 1044.040094 | 4938.30964462 | Verrucomonas longifila | 629764 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 1.2e-47 | NTclustered | gi|290760489|gb|GQ144692.1| | 629764 | g668 | i0 | 81.673 | 44.3298097251586 | 251 | 40 | 53 | 6 | 161 | 409 | 1245 | 1491 | Cercozoa sp. CC-2009f large subunit ribosomal RNA gene, partial sequence | blastn | 20968 | 204 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Ventricleftida | Verrucomonas | Verrucomonas longifila | |||
| 8325751 | 8325751 | PRJNA692200_S_NODE_15267_length_186_cov_3.481752_g15210_i0 | PRJNA692200 | 15267 | 186 | 3.481752 | 6.47605872 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 1.0899999999999998e-88 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g15210 | i0 | 99.465 | 39.1989247311828 | 187 | 0 | 100 | 1 | 1 | 186 | 2706 | 2892 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 7291 | 339 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 9601223 | 9601223 | PRJNA692200_S_NODE_22128_length_162_cov_0.893805_g22071_i0 | PRJNA692200 | 22128 | 162 | 0.893805 | 1.4479641 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 7.83e-25 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g22071 | i0 | 96.104 | 42.9382716049383 | 77 | 3 | 48 | 0 | 2 | 78 | 2068 | 2144 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 6956 | 126 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 12151804 | 12151804 | PRJNA692200_S_NODE_13950_length_193_cov_383.409722_g13893_i0 | PRJNA692200 | 13950 | 193 | 383.409722 | 739.98076346 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 4.31e-53 | NTclustered | gi|224996436|gb|FJ654268.1| | 188950 | g13893 | i0 | 93.506 | 24.8704663212435 | 154 | 0 | 75 | 3 | 47 | 190 | 178 | 25 | Bodomorpha minima 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 4800 | 220 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 12152039 | 12152039 | PRJNA692200_S_NODE_30_length_831_cov_655.675192_g21_i0 | PRJNA692200 | 30 | 831 | 655.675192 | 5448.66084552 | Rosculus hawesi | 2231161 | SAR_Eukaryotes | SAR_Eukaryotes | 1397 | 0 | NTclustered | gi|1402550477|gb|MH488763.1| | 2231161 | g21 | i0 | 98.731 | 18.0685920577617 | 788 | 6 | 95 | 2 | 45 | 830 | 1358 | 573 | Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence | blastn | 15015 | 1397 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus hawesi | ||||
| 12152056 | 12152056 | PRJNA692200_S_NODE_3510_length_324_cov_11.930909_g3453_i0 | PRJNA692200 | 3510 | 324 | 11.930909 | 38.65614516 | Rosculus hawesi | 2231161 | SAR_Eukaryotes | SAR_Eukaryotes | 446 | 1.1899999999999999e-120 | NTclustered | gi|1402550478|gb|MH488764.1| | 2231161 | g3453 | i0 | 99.194 | 3.99691358024691 | 248 | 1 | 77 | 1 | 1 | 248 | 329 | 575 | Rosculus hawesi isolate MSUPP161R small subunit ribosomal RNA gene, partial sequence | blastn | 1295 | 446 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus hawesi | ||||
| 13426498 | 13426498 | PRJNA692200_S_NODE_1991_length_379_cov_418.815152_g1934_i0 | PRJNA692200 | 1991 | 379 | 418.815152 | 1587.30942608 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 560 | 4.85e-155 | NTclustered | gi|224996436|gb|FJ654268.1| | 188950 | g1934 | i0 | 96.254 | 18.5831134564644 | 347 | 3 | 89 | 3 | 42 | 379 | 475 | 130 | Bodomorpha minima 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 7043 | 560 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 13426604 | 13426604 | PRJNA692200_S_NODE_31_length_830_cov_609.801536_g21_i1 | PRJNA692200 | 31 | 830 | 609.801536 | 5061.3527488 | Rosculus hawesi | 2231161 | SAR_Eukaryotes | SAR_Eukaryotes | 1391 | 0 | NTclustered | gi|1402550477|gb|MH488763.1| | 2231161 | g21 | i1 | 98.604 | 18.0903614457831 | 788 | 7 | 95 | 2 | 44 | 829 | 1358 | 573 | Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence | blastn | 15015 | 1391 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus hawesi | ||||
| 15975291 | 15975291 | PRJNA692200_S_NODE_12853_length_200_cov_20.695364_g12796_i0 | PRJNA692200 | 12853 | 200 | 20.695364 | 41.390728 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 3.29e-94 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g12796 | i0 | 99 | 23.915 | 200 | 1 | 99 | 1 | 2 | 200 | 574 | 375 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 4783 | 357 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 16482081 | 16482081 | PRJNA692200_S_NODE_16453_length_180_cov_168.969466_g16396_i0 | PRJNA692200 | 16453 | 180 | 168.969466 | 304.1450388 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 1.08e-63 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g16396 | i0 | 98.611 | 80.0166666666667 | 144 | 2 | 80 | 0 | 6 | 149 | 1015 | 1158 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 14403 | 255 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 19799589 | 19799589 | PRJNA692200_S_NODE_1716_length_394_cov_3.504348_g1659_i0 | PRJNA692200 | 1716 | 394 | 3.504348 | 13.80713112 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 712 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g1659 | i0 | 99.239 | 86.2309644670051 | 394 | 3 | 100 | 0 | 1 | 394 | 2114 | 1721 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 33975 | 712 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 23625502 | 23625502 | PRJNA692200_S_NODE_22919_length_157_cov_8.833333_g22862_i0 | PRJNA692200 | 22919 | 157 | 8.833333 | 13.86833281 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 9.07e-74 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g22862 | i0 | 100 | 42.5987261146497 | 156 | 0 | 99 | 0 | 1 | 156 | 1667 | 1512 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 6688 | 289 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 24899065 | 24899065 | PRJNA692200_S_NODE_20880_length_164_cov_9.452174_g20823_i0 | PRJNA692200 | 20880 | 164 | 9.452174 | 15.50156536 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.43e-77 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g20823 | i0 | 100 | 99.7378048780488 | 162 | 0 | 99 | 0 | 3 | 164 | 836 | 997 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 16357 | 300 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 25405743 | 25405743 | PRJNA692200_S_NODE_7300_length_252_cov_1018.221675_g7243_i0 | PRJNA692200 | 7300 | 252 | 1018.221675 | 2565.918621 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 3.2e-125 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g7243 | i0 | 99.603 | 99.9007936507936 | 252 | 1 | 100 | 0 | 1 | 252 | 783 | 1034 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 25175 | 460 | 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);;