contig_metadata
16 rows where bioproject = "PRJNA1035005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2719039 | 2719039 | PRJNA1035005_P_NODE_10183_length_362_cov_1.605536_g9778_i0 | PRJNA1035005 | 10183 | 362 | 1.605536 | 5.81204032 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 652 | 0 | NTclustered | gi|817491030|gb|KP273902.1| | 175275 | g9778 | i0 | 99.171 | 99.5082872928177 | 362 | 3 | 100 | 0 | 1 | 362 | 17 | 378 | Uncultured cercozoan clone EHUR-35 18S ribosomal RNA gene, partial sequence | blastn | 36022 | 652 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 2719088 | 2719088 | PRJNA1035005_P_NODE_1583_length_987_cov_5.768053_g1258_i0 | PRJNA1035005 | 1583 | 987 | 5.768053 | 56.93068311 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 1.12e-103 | NR | MES1912193.1 | 1215613 | g1258 | i0 | 67.9 | 7.96656534954407 | 234 | 75 | 71.1 | 0 | 904 | 203 | 6 | 239 | MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] | diamond | 7863 | 313 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 3995315 | 3995315 | PRJNA1035005_P_NODE_33004_length_278_cov_2.658537_g32598_i0 | PRJNA1035005 | 33004 | 278 | 2.658537 | 7.39073286 | Paulinella chromatophora | 39717 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.49e-24 | NTclustered | gi|238617606|gb|FJ973381.1| | 39717 | g32598 | i0 | 86.441 | 29.3201438848921 | 118 | 13 | 42 | 2 | 102 | 218 | 1937 | 1822 | Paulinella chromatophora strain FK01 28S ribosomal RNA gene, partial sequence | blastn | 8151 | 126 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella chromatophora | ||
| 6546759 | 6546759 | PRJNA1035005_P_NODE_20186_length_299_cov_3.867257_g19780_i0 | PRJNA1035005 | 20186 | 299 | 3.867257 | 11.56309843 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 6.95e-78 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g19780 | i0 | 85.382 | 51.5819397993311 | 301 | 34 | 99 | 10 | 1 | 296 | 3713 | 4008 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 15423 | 303 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 14197296 | 14197296 | PRJNA1035005_P_NODE_1452_length_1053_cov_4.357143_g1147_i0 | PRJNA1035005 | 1452 | 1053 | 4.357143 | 45.880715790000004 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 1.3099999999999994e-119 | NR | MES1911029.1 | 1215613 | g1147 | i0 | 61.6 | 0.897435897435897 | 315 | 106 | 88.3 | 5 | 36 | 965 | 1 | 305 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 945 | 357 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 19294508 | 19294508 | PRJNA1035005_P_NODE_2356_length_752_cov_7.863034_g1981_i0 | PRJNA1035005 | 2356 | 752 | 7.863034 | 59.13001568 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 286 | 1.53e-95 | NR | ADK47156.1 | 323453 | g1981 | i0 | 96.6 | 0.578457446808511 | 145 | 5 | 57.8 | 0 | 707 | 273 | 1 | 145 | ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] | diamond | 435 | 286 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 19294681 | 19294681 | PRJNA1035005_P_NODE_4696_length_492_cov_1.116945_g4296_i0 | PRJNA1035005 | 4696 | 492 | 1.116945 | 5.4953694 | Gymnochlora stellata | 67809 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 1.2500000000000001e-77 | NR | ACF24562.1 | 67809 | g4296 | i0 | 73.8 | 0.975609756097561 | 160 | 42 | 97.6 | 0 | 3 | 482 | 57 | 216 | ACF24562.1 proteasome alpha 5 subunit [Gymnochlora stellata] | diamond | 480 | 241 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Gymnochlora | Gymnochlora stellata | ||||
| 19294747 | 19294747 | PRJNA1035005_P_NODE_5576_length_450_cov_1.843501_g5176_i0 | PRJNA1035005 | 5576 | 450 | 1.843501 | 8.2957545 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 638 | 2.63e-178 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g5176 | i0 | 92.222 | 100.748888888889 | 450 | 35 | 100 | 0 | 1 | 450 | 2106 | 1657 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 45337 | 638 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 20569933 | 20569933 | PRJNA1035005_P_NODE_3037_length_633_cov_7.450000_g2648_i0 | PRJNA1035005 | 3037 | 633 | 7.45 | 47.1585 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 256 | 1.0699999999999999e-84 | NR | ADK26622.1 | 323453 | g2648 | i0 | 94.6 | 0.616113744075829 | 130 | 7 | 61.6 | 0 | 584 | 195 | 1 | 130 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 390 | 256 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 24394824 | 24394824 | PRJNA1035005_P_NODE_29920_length_282_cov_3.196172_g29514_i0 | PRJNA1035005 | 29920 | 282 | 3.196172 | 9.01320504 | Amorphochlora amoebiformis | 1561963 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 8.41e-77 | NTclustered | gi|33346934|gb|AY251797.1| | 1561963 | g29514 | i0 | 88.889 | 81.1950354609929 | 243 | 27 | 86 | 0 | 40 | 282 | 227 | 469 | Lotharella amoeboformis ubiquitin/actin fusion protein 2 gene, partial cds | blastn | 22897 | 300 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Amorphochlora | Amorphochlora amoebiformis | ||||
| 27951243 | 27951243 | PRJNA1035005_P_NODE_42285_length_266_cov_2.404145_g41879_i0 | PRJNA1035005 | 42285 | 266 | 2.404145 | 6.3950257 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 89.4 | 5.12e-19 | NR | MES1911486.1 | 1215613 | g41879 | i0 | 52.3 | 0.992481203007519 | 88 | 40 | 99.2 | 1 | 264 | 1 | 127 | 212 | MES1911486.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 264 | 89.4 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28898244 | 28898244 | PRJNA1035005_P_NODE_3248_length_608_cov_3.345794_g2858_i0 | PRJNA1035005 | 3248 | 608 | 3.345794 | 20.34242752 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 181 | 2.2299999999999998e-54 | NR | AAT09077.1 | 227086 | g2858 | i0 | 59 | 0.769736842105263 | 156 | 62 | 77 | 1 | 32 | 499 | 1 | 154 | AAT09077.1 transcription factor BTF3 [Bigelowiella natans] | diamond | 468 | 181 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 29498261 | 29498261 | PRJNA1035005_P_NODE_30590_length_282_cov_1.110048_g30184_i0 | PRJNA1035005 | 30590 | 282 | 1.110048 | 3.13033536 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 1.09e-9 | NR | MES1914001.1 | 1215613 | g30184 | i0 | 46.7 | 0.978723404255319 | 92 | 46 | 97.9 | 2 | 6 | 281 | 298 | 386 | MES1914001.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 276 | 64.7 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29719034 | 29719034 | PRJNA1035005_P_NODE_11130_length_352_cov_2.075269_g10725_i0 | PRJNA1035005 | 11130 | 352 | 2.075269 | 7.30494688 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 4.25e-27 | NR | MES1909771.1 | 1215613 | g10725 | i0 | 47.3 | 0.954545454545455 | 112 | 59 | 95.5 | 0 | 345 | 10 | 52 | 163 | MES1909771.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 336 | 114 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31267484 | 31267484 | PRJNA1035005_P_NODE_62795_length_250_cov_0.881356_g62389_i0 | PRJNA1035005 | 62795 | 250 | 0.881356 | 2.20339 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 6.129999999999999e-32 | NR | MES1911740.1 | 1215613 | g62389 | i0 | 74.4 | 1.968 | 82 | 21 | 98.4 | 0 | 3 | 248 | 253 | 334 | MES1911740.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 492 | 125 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32469816 | 32469816 | PRJNA1035005_P_NODE_17359_length_312_cov_2.422594_g16953_i0 | PRJNA1035005 | 17359 | 312 | 2.422594 | 7.55849328 | Gymnochlora stellata | 67809 | SAR_Eukaryotes | SAR_Eukaryotes | 97.4 | 9.36e-23 | NR | ACF24574.1 | 67809 | g16953 | i0 | 93.9 | 0.471153846153846 | 49 | 3 | 47.1 | 0 | 3 | 149 | 11 | 59 | ACF24574.1 Ras-related small GTPase Rab5 [Gymnochlora stellata] | diamond | 147 | 97.4 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Gymnochlora | Gymnochlora stellata |
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);;