contig_metadata
23 rows where bioproject = "PRJNA741997" and tax_phylum = "Foraminifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7100055 | 7100055 | PRJNA741997_P_NODE_25926_length_436_cov_2.201102_g24806_i0 | PRJNA741997 | 25926 | 436 | 2.201102 | 9.59680472 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 9.529999999999999e-30 | NR | ETO05736.1 | 46433 | g24806 | i0 | 44 | 2.79357798165138 | 141 | 61 | 97 | 2 | 435 | 13 | 189 | 311 | ETO05736.1 hypothetical protein RFI_31659 [Reticulomyxa filosa] | diamond | 1218 | 124 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 10925663 | 10925663 | PRJNA741997_P_NODE_8829_length_882_cov_1.384425_g7911_i0 | PRJNA741997 | 8829 | 882 | 1.384425 | 12.2106285 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 418 | 1.28e-141 | NR | ETO14870.1 | 46433 | g7911 | i0 | 69 | 2 | 294 | 90 | 99.7 | 1 | 881 | 3 | 154 | 447 | ETO14870.1 hypothetical protein RFI_22497 [Reticulomyxa filosa] | diamond | 1764 | 418 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 12200774 | 12200774 | PRJNA741997_P_NODE_27290_length_422_cov_4.277937_g26170_i0 | PRJNA741997 | 27290 | 422 | 4.277937 | 18.05289414 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 160 | 2.0899999999999999e-47 | NR | ETO03324.1 | 46433 | g26170 | i0 | 60.3 | 0.966824644549763 | 136 | 51 | 94.5 | 2 | 400 | 2 | 32 | 167 | ETO03324.1 40S ribosomal protein S15 [Reticulomyxa filosa] | diamond | 408 | 160 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 17775869 | 17775869 | PRJNA741997_P_NODE_16534_length_580_cov_1.822485_g15428_i0 | PRJNA741997 | 16534 | 580 | 1.822485 | 10.570413 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 288 | 2.81e-92 | NR | ETN98485.1 | 46433 | g15428 | i0 | 76.1 | 6.63620689655172 | 184 | 44 | 95.2 | 0 | 28 | 579 | 128 | 311 | ETN98485.1 hypothetical protein RFI_39013 [Reticulomyxa filosa] | diamond | 3849 | 290 | 0.993103448275862 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 17775912 | 17775912 | PRJNA741997_P_NODE_66494_length_263_cov_1.215789_g65374_i0 | PRJNA741997 | 66494 | 263 | 1.215789 | 3.19752507 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 77 | 2.56e-14 | NR | ETO28969.1 | 46433 | g65374 | i0 | 64.8 | 0.615969581749049 | 54 | 19 | 61.6 | 0 | 166 | 5 | 32 | 85 | ETO28969.1 hypothetical protein RFI_08155 [Reticulomyxa filosa] | diamond | 162 | 77 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27052631 | 27052631 | PRJNA741997_P_NODE_58122_length_282_cov_1.344498_g57002_i0 | PRJNA741997 | 58122 | 282 | 1.344498 | 3.79148436 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 1.34e-27 | NR | ETO22507.1 | 46433 | g57002 | i0 | 63.9 | 1.88297872340426 | 83 | 27 | 88.3 | 1 | 34 | 282 | 35 | 114 | ETO22507.1 mitochondrial dicarboxylate carrier protein [Reticulomyxa filosa] | diamond | 531 | 112 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27631464 | 27631464 | PRJNA741997_P_NODE_80284_length_246_cov_1.381503_g79164_i0 | PRJNA741997 | 80284 | 246 | 1.381503 | 3.39849738 | root | 1 | Root_unresolved | Root_unresolved | 74.3 | 2.6e-13 | NR | ETO11680.1 | 46433 | g79164 | i0 | 51.4 | 6.76829268292683 | 70 | 34 | 85.4 | 0 | 221 | 12 | 56 | 125 | ETO11680.1 apoptosis-promoting RNA-binding protein TIA-1/TIAR, partial [Reticulomyxa filosa] | diamond | 1665 | 74.7 | 0.994645247657296 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27968514 | 27968514 | PRJNA741997_P_NODE_58945_length_280_cov_1.487923_g57825_i0 | PRJNA741997 | 58945 | 280 | 1.487923 | 4.1661844 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 2.49e-25 | NR | ETO09499.1 | 46433 | g57825 | i0 | 48.9 | 0.964285714285714 | 90 | 46 | 96.4 | 0 | 278 | 9 | 104 | 193 | ETO09499.1 splicing factor U2AF 35 kDa subunit [Reticulomyxa filosa] | diamond | 270 | 107 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28158258 | 28158258 | PRJNA741997_P_NODE_72445_length_251_cov_0.865169_g71325_i0 | PRJNA741997 | 72445 | 251 | 0.865169 | 2.17157419 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 6.860000000000001e-27 | NR | ETO04401.1 | 46433 | g71325 | i0 | 68.7 | 1.9840637450199201 | 83 | 26 | 99.2 | 0 | 2 | 250 | 651 | 733 | ETO04401.1 clathrin heavy chain, partial [Reticulomyxa filosa] | diamond | 498 | 113 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28789318 | 28789318 | PRJNA741997_P_NODE_83887_length_244_cov_0.900585_g82767_i0 | PRJNA741997 | 83887 | 244 | 0.900585 | 2.1974274 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 1.97e-11 | NR | ETO34266.1 | 46433 | g82767 | i0 | 52.5 | 2.29918032786885 | 61 | 29 | 75 | 0 | 1 | 183 | 87 | 147 | ETO34266.1 Cmp24/gp25L/p24 family protein [Reticulomyxa filosa] | diamond | 561 | 68.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29020904 | 29020904 | PRJNA741997_P_NODE_29508_length_404_cov_0.930514_g28388_i0 | PRJNA741997 | 29508 | 404 | 0.930514 | 3.75927656 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 84.7 | 4.48e-16 | NR | ETO11489.1 | 46433 | g28388 | i0 | 39.8 | 3.28960396039604 | 98 | 57 | 72 | 2 | 375 | 85 | 176 | 272 | ETO11489.1 hypothetical protein RFI_25888 [Reticulomyxa filosa] | diamond | 1329 | 85.1 | 0.995299647473561 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29262880 | 29262880 | PRJNA741997_P_NODE_65489_length_265_cov_1.604167_g64369_i0 | PRJNA741997 | 65489 | 265 | 1.604167 | 4.25104255 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 2.51e-30 | NR | ETO05095.1 | 46433 | g64369 | i0 | 66.7 | 1.96981132075472 | 87 | 29 | 98.5 | 0 | 263 | 3 | 517 | 603 | ETO05095.1 hypothetical protein RFI_32303 [Reticulomyxa filosa] | diamond | 522 | 123 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29367984 | 29367984 | PRJNA741997_P_NODE_65869_length_264_cov_1.612565_g64749_i0 | PRJNA741997 | 65869 | 264 | 1.612565 | 4.2571716 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 1.13e-24 | NR | ETO01022.1 | 46433 | g64749 | i0 | 57.6 | 4.90909090909091 | 85 | 36 | 96.6 | 0 | 1 | 255 | 121 | 205 | ETO01022.1 protein-transport Sec61 protein subunit alpha, partial [Reticulomyxa filosa] | diamond | 1296 | 103 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29641646 | 29641646 | PRJNA741997_P_NODE_67710_length_260_cov_1.336898_g66590_i0 | PRJNA741997 | 67710 | 260 | 1.336898 | 3.4759348 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 61.6 | 1.04e-8 | NR | ETO05095.1 | 46433 | g66590 | i0 | 45.9 | 0.980769230769231 | 85 | 34 | 98.1 | 3 | 257 | 3 | 389 | 461 | ETO05095.1 hypothetical protein RFI_32303 [Reticulomyxa filosa] | diamond | 255 | 61.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29673254 | 29673254 | PRJNA741997_P_NODE_83030_length_245_cov_0.895349_g81910_i0 | PRJNA741997 | 83030 | 245 | 0.895349 | 2.19360505 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 2.54e-4 | NR | ETO31334.1 | 46433 | g81910 | i0 | 63.2 | 0.46530612244898 | 38 | 14 | 46.5 | 0 | 115 | 2 | 177 | 214 | ETO31334.1 hypothetical protein RFI_05786, partial [Reticulomyxa filosa] | diamond | 114 | 48.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29704702 | 29704702 | PRJNA741997_P_NODE_69390_length_256_cov_1.404372_g68270_i0 | PRJNA741997 | 69390 | 256 | 1.404372 | 3.59519232 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 4.01e-20 | NR | ETO24993.1 | 46433 | g68270 | i0 | 51.3 | 1.8515625 | 76 | 37 | 89.1 | 0 | 17 | 244 | 86 | 161 | ETO24993.1 hypothetical protein RFI_12152, partial [Reticulomyxa filosa] | diamond | 474 | 94 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30115619 | 30115619 | PRJNA741997_P_NODE_40472_length_341_cov_1.503731_g39352_i0 | PRJNA741997 | 40472 | 341 | 1.503731 | 5.12772271 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 6.56e-10 | NR | ETO36871.1 | 46433 | g39352 | i0 | 45 | 1.03812316715543 | 60 | 33 | 52.8 | 0 | 160 | 339 | 3 | 62 | ETO36871.1 hypothetical protein RFI_00191 [Reticulomyxa filosa] | diamond | 354 | 62.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30557899 | 30557899 | PRJNA741997_P_NODE_88033_length_242_cov_0.911243_g86913_i0 | PRJNA741997 | 88033 | 242 | 0.911243 | 2.20520806 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 4.95e-12 | NR | ETO31853.1 | 46433 | g86913 | i0 | 48.1 | 2.9504132231405 | 79 | 39 | 97.9 | 1 | 2 | 238 | 167 | 243 | ETO31853.1 hypothetical protein RFI_05259 [Reticulomyxa filosa] | diamond | 714 | 69.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31358336 | 31358336 | PRJNA741997_P_NODE_52716_length_296_cov_1.192825_g51596_i0 | PRJNA741997 | 52716 | 296 | 1.192825 | 3.530762 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 2.11e-12 | NR | ETO09631.1 | 46433 | g51596 | i0 | 39.5 | 3.66891891891892 | 86 | 52 | 87.2 | 0 | 38 | 295 | 52 | 137 | ETO09631.1 hypothetical protein RFI_27747, partial [Reticulomyxa filosa] | diamond | 1086 | 72.8 | 0.994505494505495 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31664300 | 31664300 | PRJNA741997_P_NODE_86037_length_243_cov_0.905882_g84917_i0 | PRJNA741997 | 86037 | 243 | 0.905882 | 2.20129326 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.73e-39 | NR | ETO35298.1 | 46433 | g84917 | i0 | 73.8 | 0.987654320987654 | 80 | 21 | 98.8 | 0 | 241 | 2 | 106 | 185 | ETO35298.1 hypothetical protein RFI_01766, partial [Reticulomyxa filosa] | diamond | 240 | 139 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32107249 | 32107249 | PRJNA741997_P_NODE_40538_length_341_cov_1.149254_g39418_i0 | PRJNA741997 | 40538 | 341 | 1.149254 | 3.91895614 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 1.6999999999999996e-38 | NR | ETO11361.1 | 46433 | g39418 | i0 | 59.6 | 1.99706744868035 | 114 | 45 | 99.4 | 1 | 340 | 2 | 64 | 177 | ETO11361.1 trans-2,3-enoyl-CoA reductase [Reticulomyxa filosa] | diamond | 681 | 138 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32234153 | 32234153 | PRJNA741997_P_NODE_58518_length_281_cov_1.475962_g57398_i0 | PRJNA741997 | 58518 | 281 | 1.475962 | 4.14745322 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 8.11e-9 | NR | ETO35625.1 | 46433 | g57398 | i0 | 33.8 | 0.822064056939502 | 77 | 45 | 82.2 | 1 | 281 | 51 | 108 | 178 | ETO35625.1 alpha-1,3-mannosylglycoprotein 2-beta-N-acetylglucosaminyltransferase [Reticulomyxa filosa] | diamond | 231 | 62 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32329156 | 32329156 | PRJNA741997_P_NODE_69719_length_255_cov_1.692308_g68599_i0 | PRJNA741997 | 69719 | 255 | 1.692308 | 4.3153854 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 7.49e-27 | NR | ETO05095.1 | 46433 | g68599 | i0 | 67.1 | 2 | 85 | 28 | 100 | 0 | 255 | 1 | 517 | 601 | ETO05095.1 hypothetical protein RFI_32303 [Reticulomyxa filosa] | diamond | 510 | 113 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa |
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);;