contig_metadata
15 rows where bioproject = "PRJNA867519" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20363367 | 20363367 | PRJNA867519_P_NODE_4136_length_519_cov_3.419283_g3984_i0 | PRJNA867519 | 4136 | 519 | 3.419283 | 17.74607877 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 9.9e-41 | NR | ETO09453.1 | 46433 | g3984 | i0 | 67.2 | 0.670520231213873 | 116 | 35 | 67.1 | 2 | 514 | 167 | 210 | 322 | ETO09453.1 hypothetical protein RFI_27925 [Reticulomyxa filosa] | diamond | 348 | 152 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27411190 | 27411190 | PRJNA867519_P_NODE_25243_length_251_cov_1.685393_g25089_i0 | PRJNA867519 | 25243 | 251 | 1.685393 | 4.23033643 | root | 1 | Root_unresolved | Root_unresolved | 89 | 2.11e-19 | NR | ETO06653.1 | 46433 | g25089 | i0 | 50 | 8.9402390438247 | 84 | 41 | 99.2 | 1 | 2 | 250 | 102 | 185 | ETO06653.1 hypothetical protein RFI_30739, partial [Reticulomyxa filosa] | diamond | 2244 | 89 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28034446 | 28034446 | PRJNA867519_P_NODE_6885_length_418_cov_1.350725_g6731_i0 | PRJNA867519 | 6885 | 418 | 1.350725 | 5.6460305 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 94.4 | 2.12e-19 | NR | ETO24993.1 | 46433 | g6731 | i0 | 45.5 | 0.631578947368421 | 88 | 48 | 63.2 | 0 | 81 | 344 | 437 | 524 | ETO24993.1 hypothetical protein RFI_12152, partial [Reticulomyxa filosa] | diamond | 264 | 94.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28263258 | 28263258 | PRJNA867519_P_NODE_5586_length_458_cov_1.400000_g5432_i0 | PRJNA867519 | 5586 | 458 | 1.4 | 6.412 | root | 1 | Root_unresolved | Root_unresolved | 112 | 1.02e-26 | NR | ETO36993.1 | 46433 | g5432 | i0 | 39.5 | 2.98689956331878 | 152 | 90 | 99.6 | 1 | 457 | 2 | 132 | 281 | ETO36993.1 monoamine oxidase B-like protein [Reticulomyxa filosa] | diamond | 1368 | 113 | 0.991150442477876 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28894769 | 28894769 | PRJNA867519_P_NODE_23988_length_258_cov_1.054054_g23834_i0 | PRJNA867519 | 23988 | 258 | 1.054054 | 2.71945932 | root | 1 | Root_unresolved | Root_unresolved | 60.1 | 3.36e-8 | NR | ETO12617.1 | 46433 | g23834 | i0 | 50.7 | 1.47674418604651 | 67 | 23 | 70.9 | 3 | 44 | 226 | 385 | 447 | ETO12617.1 hypothetical protein RFI_24758, partial [Reticulomyxa filosa] | diamond | 381 | 60.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28918142 | 28918142 | PRJNA867519_P_NODE_14168_length_312_cov_0.966527_g14014_i0 | PRJNA867519 | 14168 | 312 | 0.966527 | 3.01556424 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00462 | NR | ETO16381.1 | 46433 | g14014 | i0 | 31.3 | 1.75961538461538 | 96 | 60 | 88.5 | 2 | 3 | 278 | 140 | 233 | ETO16381.1 hypothetical protein RFI_20967, partial [Reticulomyxa filosa] | diamond | 549 | 46.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29139644 | 29139644 | PRJNA867519_P_NODE_25349_length_251_cov_1.123596_g25195_i0 | PRJNA867519 | 25349 | 251 | 1.123596 | 2.82022596 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 8.48e-11 | NR | ETO25790.1 | 46433 | g25195 | i0 | 43.3 | 1.80478087649402 | 67 | 36 | 77.7 | 1 | 229 | 35 | 92 | 158 | ETO25790.1 P450 (cytochrome) oxidoreductase [Reticulomyxa filosa] | diamond | 453 | 67.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29423310 | 29423310 | PRJNA867519_P_NODE_19569_length_277_cov_3.406863_g19415_i0 | PRJNA867519 | 19569 | 277 | 3.406863 | 9.43701051 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 1.71e-11 | NR | ETO28241.1 | 46433 | g19415 | i0 | 43.8 | 0.790613718411552 | 73 | 34 | 71.5 | 2 | 2 | 199 | 130 | 202 | ETO28241.1 hypothetical protein RFI_08889 [Reticulomyxa filosa] | diamond | 219 | 69.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29612626 | 29612626 | PRJNA867519_P_NODE_21190_length_270_cov_1.954315_g21036_i0 | PRJNA867519 | 21190 | 270 | 1.954315 | 5.2766505 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 89.4 | 9.91e-19 | NR | ETO14116.1 | 46433 | g21036 | i0 | 53 | 0.922222222222222 | 83 | 37 | 90 | 2 | 244 | 2 | 219 | 301 | ETO14116.1 hypothetical protein RFI_23252 [Reticulomyxa filosa] | diamond | 249 | 89.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29707269 | 29707269 | PRJNA867519_P_NODE_31330_length_244_cov_0.900585_g31176_i0 | PRJNA867519 | 31330 | 244 | 0.900585 | 2.1974274 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 73.6 | 2.72e-13 | NR | ETO32916.1 | 46433 | g31176 | i0 | 62 | 0.614754098360656 | 50 | 17 | 59 | 1 | 217 | 74 | 83 | 132 | ETO32916.1 hypothetical protein RFI_04200 [Reticulomyxa filosa] | diamond | 150 | 73.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30054965 | 30054965 | PRJNA867519_P_NODE_1191_length_868_cov_6.514465_g1058_i0 | PRJNA867519 | 1191 | 868 | 6.514465 | 56.5455562 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 177 | 1.18e-49 | NR | ETO28241.1 | 46433 | g1058 | i0 | 37.3 | 0.964285714285714 | 279 | 139 | 84 | 9 | 868 | 140 | 38 | 316 | ETO28241.1 hypothetical protein RFI_08889 [Reticulomyxa filosa] | diamond | 837 | 177 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30181450 | 30181450 | PRJNA867519_P_NODE_17192_length_288_cov_1.432558_g17038_i0 | PRJNA867519 | 17192 | 288 | 1.432558 | 4.12576704 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 77 | 3.3e-14 | NR | ETO20721.1 | 46433 | g17038 | i0 | 48.9 | 0.9375 | 90 | 45 | 93.8 | 1 | 276 | 7 | 156 | 244 | ETO20721.1 hypothetical protein RFI_16496 [Reticulomyxa filosa] | diamond | 270 | 77 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30781820 | 30781820 | PRJNA867519_P_NODE_26174_length_250_cov_1.305085_g26020_i0 | PRJNA867519 | 26174 | 250 | 1.305085 | 3.2627125 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 79 | 7.44e-15 | NR | ETO14536.1 | 46433 | g26020 | i0 | 51.9 | 4.872 | 81 | 36 | 96 | 2 | 5 | 244 | 771 | 849 | ETO14536.1 hypothetical protein RFI_22832, partial [Reticulomyxa filosa] | diamond | 1218 | 79 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30971544 | 30971544 | PRJNA867519_P_NODE_16154_length_294_cov_2.090498_g16000_i0 | PRJNA867519 | 16154 | 294 | 2.090498 | 6.14606412 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 4.78e-5 | NR | ETO29153.1 | 46433 | g16000 | i0 | 34.3 | 3.07142857142857 | 99 | 62 | 99 | 2 | 291 | 1 | 136 | 233 | ETO29153.1 hypothetical protein RFI_07969, partial [Reticulomyxa filosa] | diamond | 903 | 51.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31003065 | 31003065 | PRJNA867519_P_NODE_12894_length_324_cov_1.637450_g12740_i0 | PRJNA867519 | 12894 | 324 | 1.63745 | 5.305338 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 1.37e-4 | NR | ETO04451.1 | 46433 | g12740 | i0 | 26.5 | 0.944444444444444 | 102 | 71 | 94.4 | 1 | 19 | 324 | 97 | 194 | ETO04451.1 hypothetical protein RFI_32946, partial [Reticulomyxa filosa] | diamond | 306 | 50.8 | 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);;