contig_metadata
24 rows where bioproject = "PRJNA438572", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1709986 | 1709986 | PRJNA438572_P_NODE_4142_length_483_cov_1.631707_g4024_i0 | PRJNA438572 | 4142 | 483 | 1.631707 | 7.88114481 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 893 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g4024 | i0 | 100 | 23.1821946169772 | 483 | 0 | 100 | 0 | 1 | 483 | 322 | 804 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 11197 | 893 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 2985574 | 2985574 | PRJNA438572_P_NODE_12983_length_287_cov_1.280374_g12864_i0 | PRJNA438572 | 12983 | 287 | 1.280374 | 3.67467338 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 7.01e-25 | NR | MES1906893.1 | 1215613 | g12864 | i0 | 70.8 | 1.34843205574913 | 65 | 19 | 67.9 | 0 | 3 | 197 | 94 | 158 | MES1906893.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 387 | 107 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 2985643 | 2985643 | PRJNA438572_P_NODE_163_length_1727_cov_3.273881_g142_i0 | PRJNA438572 | 163 | 1727 | 3.273881 | 56.53992487 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1633 | 0 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g142 | i0 | 99.664 | 72.8239722061378 | 893 | 3 | 52 | 0 | 496 | 1388 | 893 | 1 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 125767 | 1633 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 2985661 | 2985661 | PRJNA438572_P_NODE_17583_length_252_cov_0.871508_g17464_i0 | PRJNA438572 | 17583 | 252 | 0.871508 | 2.19620016 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 2.72e-61 | NTclustered | gi|1389527547|dbj|LC383946.1| | 1928728 | g17464 | i0 | 87.156 | 154.519841269841 | 218 | 28 | 87 | 0 | 18 | 235 | 662 | 445 | Paulinella micropora gene for polyubiquitin, complete cds | blastn | 38939 | 248 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 2985765 | 2985765 | PRJNA438572_P_NODE_2563_length_611_cov_5.254647_g2447_i0 | PRJNA438572 | 2563 | 611 | 5.254647 | 32.10589317 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 182 | 8.109999999999997e-55 | NR | AAT09077.1 | 227086 | g2447 | i0 | 71.2 | 0.613747954173486 | 125 | 36 | 61.4 | 0 | 582 | 208 | 1 | 125 | AAT09077.1 transcription factor BTF3 [Bigelowiella natans] | diamond | 375 | 182 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 4261949 | 4261949 | PRJNA438572_P_NODE_144_length_1804_cov_24.692663_g124_i0 | PRJNA438572 | 144 | 1804 | 24.692663 | 445.45564052 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 695 | 9.319999999999995e-247 | NR | MES1909605.1 | 1215613 | g124 | i0 | 77.1 | 4.40853658536585 | 433 | 99 | 72 | 0 | 1781 | 483 | 1 | 433 | MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 7953 | 701 | 0.991440798858773 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 5538873 | 5538873 | PRJNA438572_P_NODE_6305_length_399_cov_6.297546_g6186_i0 | PRJNA438572 | 6305 | 399 | 6.297546 | 25.12720854 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 1.1499999999999999e-126 | NTclustered | gi|238617666|gb|FJ973412.1| | 188950 | g6186 | i0 | 99.225 | 37.874686716792 | 258 | 2 | 65 | 0 | 1 | 258 | 258 | 1 | Bodomorpha minima strain ATCC 50339 alpha-tubulin (atub) gene, partial cds | blastn | 15112 | 466 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 10019184 | 10019184 | PRJNA438572_P_NODE_24688_length_240_cov_2.778443_g24569_i0 | PRJNA438572 | 24688 | 240 | 2.778443 | 6.6682632 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 5.63e-40 | NR | ADK47156.1 | 323453 | g24569 | i0 | 90.4 | 0.9125 | 73 | 7 | 91.3 | 0 | 219 | 1 | 1 | 73 | ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] | diamond | 219 | 138 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 15737491 | 15737491 | PRJNA438572_P_NODE_10573_length_315_cov_2.185950_g10454_i0 | PRJNA438572 | 10573 | 315 | 2.18595 | 6.8857425 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 5.78e-69 | NTclustered | gi|300676716|gb|GQ377714.1| | 323453 | g10454 | i0 | 84.672 | 61.9460317460317 | 274 | 42 | 87 | 0 | 42 | 315 | 54 | 327 | Heteromita sp. PRA-74 rps22a (rps22a) mRNA, complete cds | blastn | 19513 | 274 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 15737836 | 15737836 | PRJNA438572_P_NODE_6613_length_390_cov_1.473186_g6494_i0 | PRJNA438572 | 6613 | 390 | 1.473186 | 5.7454254 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 4.4e-66 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g6494 | i0 | 80.157 | 53.3435897435897 | 383 | 53 | 94 | 22 | 23 | 390 | 4038 | 3664 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20804 | 265 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 17012285 | 17012285 | PRJNA438572_P_NODE_1654_length_744_cov_3.071535_g1550_i0 | PRJNA438572 | 1654 | 744 | 3.071535 | 22.8522204 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 246 | 8.07e-80 | NR | ADK26622.1 | 323453 | g1550 | i0 | 88.5 | 0.524193548387097 | 130 | 15 | 52.4 | 0 | 25 | 414 | 1 | 130 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 390 | 246 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 17668721 | 17668721 | PRJNA438572_P_NODE_2294_length_645_cov_1.202797_g2180_i0 | PRJNA438572 | 2294 | 645 | 1.202797 | 7.75804065 | Verrucomonas | 2545269 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 1.67e-47 | NTclustered | gi|290760488|gb|GQ144691.1| | 629763 | g2180 | i0 | 82.041 | 23.6 | 245 | 38 | 38 | 6 | 221 | 463 | 1487 | 1247 | Cercozoa sp. CC-2009e large subunit ribosomal RNA gene, partial sequence | blastn | 15222 | 204 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Ventricleftida | Verrucomonas | Verrucomonas bifida | |||
| 18286742 | 18286742 | PRJNA438572_P_NODE_3215_length_549_cov_1.302521_g3097_i0 | PRJNA438572 | 3215 | 549 | 1.302521 | 7.15084029 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 907 | 0 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g3097 | i0 | 96.552 | 14.0892531876138 | 551 | 13 | 100 | 5 | 1 | 549 | 579 | 33 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 7735 | 907 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 18286845 | 18286845 | PRJNA438572_P_NODE_8095_length_357_cov_1.940141_g7976_i0 | PRJNA438572 | 8095 | 357 | 1.940141 | 6.92630337 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 6.58e-74 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g7976 | i0 | 82.621 | 50.7759103641457 | 351 | 39 | 98 | 14 | 6 | 354 | 3691 | 4021 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 18127 | 291 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 21492796 | 21492796 | PRJNA438572_P_NODE_13177_length_285_cov_1.471698_g13058_i0 | PRJNA438572 | 13177 | 285 | 1.471698 | 4.1943393 | Glissomonadida | 1238681 | SAR_Eukaryotes | SAR_Eukaryotes | 521 | 1.6699999999999996e-143 | NTclustered | gi|2030163897|gb|MZ044034.1| | 1808984 | g13058 | i0 | 99.649 | 67.4245614035088 | 285 | 1 | 100 | 0 | 1 | 285 | 577 | 293 | Rosculus terrestris isolate S14D1 small subunit ribosomal RNA gene, partial sequence | blastn | 19216 | 521 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus terrestris | ||||
| 22111589 | 22111589 | PRJNA438572_P_NODE_16538_length_255_cov_1.285714_g16419_i0 | PRJNA438572 | 16538 | 255 | 1.285714 | 3.2785707 | Cryothecomonas sp. APCC MC5-1Cryo | 741088 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 9.359999999999998e-101 | NTclustered | gi|290760480|gb|GQ144683.1| | 741088 | g16419 | i0 | 93.385 | 103.580392156863 | 257 | 13 | 100 | 4 | 1 | 255 | 1820 | 1566 | Cryothecomonas sp. APCC MC5-1Cryo large subunit ribosomal RNA gene, partial sequence | blastn | 26413 | 379 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Cryomonadida | Protaspidae | Cryothecomonas | Cryothecomonas sp. APCC MC5-1Cryo | ||
| 26917805 | 26917805 | PRJNA438572_P_NODE_20942_length_247_cov_0.896552_g20823_i0 | PRJNA438572 | 20942 | 247 | 0.896552 | 2.21448344 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 7.310000000000001e-27 | NR | AAO89069.1 | 227086 | g20823 | i0 | 67.1 | 0.959514170040486 | 79 | 25 | 96 | 1 | 3 | 239 | 89 | 166 | AAO89069.1 cytosolic class I fructose-1,6-bisphosphate aldolase [Bigelowiella natans] | diamond | 237 | 110 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 28844285 | 28844285 | PRJNA438572_P_NODE_12528_length_291_cov_1.431193_g12409_i0 | PRJNA438572 | 12528 | 291 | 1.431193 | 4.16477163 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 5.600000000000001e-30 | NR | MES1909879.1 | 1215613 | g12409 | i0 | 60.4 | 3.88659793814433 | 96 | 36 | 99 | 1 | 289 | 2 | 111 | 204 | MES1909879.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1131 | 119 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29428884 | 29428884 | PRJNA438572_P_NODE_7309_length_374_cov_1.036545_g7190_i0 | PRJNA438572 | 7309 | 374 | 1.036545 | 3.8766783 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 7.39e-24 | NR | AAT09089.1 | 227086 | g7190 | i0 | 49.5 | 1.67647058823529 | 103 | 50 | 81 | 1 | 311 | 9 | 8 | 110 | AAT09089.1 calmodulin like myosin light chain [Bigelowiella natans] | diamond | 627 | 103 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 29444143 | 29444143 | PRJNA438572_P_NODE_22590_length_244_cov_1.824561_g22471_i0 | PRJNA438572 | 22590 | 244 | 1.824561 | 4.45192884 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 7.66e-19 | NR | MES1913326.1 | 1215613 | g22471 | i0 | 58.8 | 1.9672131147541 | 80 | 33 | 98.4 | 0 | 240 | 1 | 366 | 445 | MES1913326.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 480 | 90.1 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30486833 | 30486833 | PRJNA438572_P_NODE_3313_length_541_cov_1.000000_g3195_i0 | PRJNA438572 | 3313 | 541 | 1 | 5.41 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 88.2 | 2.1e-17 | NR | MES1908730.1 | 1215613 | g3195 | i0 | 48.7 | 0.432532347504621 | 78 | 40 | 43.3 | 0 | 8 | 241 | 169 | 246 | MES1908730.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 234 | 88.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31940758 | 31940758 | PRJNA438572_P_NODE_18737_length_250_cov_0.966102_g18618_i0 | PRJNA438572 | 18737 | 250 | 0.966102 | 2.415255 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 98.2 | 9.52e-24 | NR | AAT09077.1 | 227086 | g18618 | i0 | 60.8 | 0.888 | 74 | 29 | 88.8 | 0 | 225 | 4 | 1 | 74 | AAT09077.1 transcription factor BTF3 [Bigelowiella natans] | diamond | 222 | 98.2 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 31940765 | 31940765 | PRJNA438572_P_NODE_6977_length_381_cov_1.672078_g6858_i0 | PRJNA438572 | 6977 | 381 | 1.672078 | 6.37061718 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 4.43e-28 | NR | MES1909771.1 | 1215613 | g6858 | i0 | 46 | 1.97637795275591 | 126 | 68 | 99.2 | 0 | 1 | 378 | 38 | 163 | MES1909771.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 753 | 117 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32115588 | 32115588 | PRJNA438572_P_NODE_13618_length_281_cov_1.995192_g13499_i0 | PRJNA438572 | 13618 | 281 | 1.995192 | 5.60648952 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 1.34e-11 | NR | MES1916036.1 | 1215613 | g13499 | i0 | 42.7 | 3.5017793594306 | 82 | 46 | 87.5 | 1 | 255 | 10 | 6 | 86 | MES1916036.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 984 | 70.1 | 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);;