contig_metadata
20 rows where bioproject = "PRJNA611476", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6967328 | 6967328 | PRJNA611476_P_NODE_115446_length_241_cov_0.916667_g114655_i0 | PRJNA611476 | 115446 | 241 | 0.916667 | 2.20916747 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 1e-24 | NR | ETO07542.1 | 46433 | g114655 | i0 | 59.5 | 0.983402489626556 | 79 | 32 | 98.3 | 0 | 238 | 2 | 36 | 114 | ETO07542.1 hypothetical protein RFI_29850 [Reticulomyxa filosa] | diamond | 237 | 103 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26827126 | 26827126 | PRJNA611476_P_NODE_102701_length_245_cov_0.895349_g101910_i0 | PRJNA611476 | 102701 | 245 | 0.895349 | 2.19360505 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 6.2e-12 | NR | ETO24498.1 | 46433 | g101910 | i0 | 44.3 | 2.14285714285714 | 88 | 39 | 98 | 3 | 243 | 4 | 122 | 207 | ETO24498.1 mitogen activated kinase-like protein, partial [Reticulomyxa filosa] | diamond | 525 | 69.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26859026 | 26859026 | PRJNA611476_P_NODE_25081_length_404_cov_1.293051_g24290_i0 | PRJNA611476 | 25081 | 404 | 1.293051 | 5.22392604 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 9.29e-37 | NR | ETO25964.1 | 46433 | g24290 | i0 | 53 | 0.995049504950495 | 134 | 61 | 98.8 | 2 | 2 | 400 | 355 | 487 | ETO25964.1 peptidase S15 [Reticulomyxa filosa] | diamond | 402 | 142 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27409534 | 27409534 | PRJNA611476_P_NODE_100183_length_245_cov_1.750000_g99392_i0 | PRJNA611476 | 100183 | 245 | 1.75 | 4.2875 | Pelagomonadales | 54409 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0278 | NR | ETO26740.1 | 46433 | g99392 | i0 | 31.3 | 3.85714285714286 | 80 | 45 | 91.8 | 3 | 21 | 245 | 184 | 258 | ETO26740.1 hypothetical protein RFI_10394 [Reticulomyxa filosa] | diamond | 945 | 43.5 | 0.990804597701149 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27428087 | 27428087 | PRJNA611476_P_NODE_66223_length_274_cov_0.995025_g65432_i0 | PRJNA611476 | 66223 | 274 | 0.995025 | 2.7263685 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 1.54e-19 | NR | ETO35417.1 | 46433 | g65432 | i0 | 46.1 | 0.974452554744526 | 89 | 48 | 97.4 | 0 | 6 | 272 | 270 | 358 | ETO35417.1 hypothetical protein RFI_01646 [Reticulomyxa filosa] | diamond | 267 | 91.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27522483 | 27522483 | PRJNA611476_P_NODE_30963_length_371_cov_1.453020_g30172_i0 | PRJNA611476 | 30963 | 371 | 1.45302 | 5.3907042 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 1.23e-4 | NR | ETO06651.1 | 46433 | g30172 | i0 | 45.3 | 1.73854447439353 | 53 | 29 | 42.9 | 0 | 1 | 159 | 746 | 798 | ETO06651.1 hypothetical protein RFI_30741, partial [Reticulomyxa filosa] | diamond | 645 | 51.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27553847 | 27553847 | PRJNA611476_P_NODE_111884_length_242_cov_0.911243_g111093_i0 | PRJNA611476 | 111884 | 242 | 0.911243 | 2.20520806 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 77.4 | 2.23e-14 | NR | ETO23319.1 | 46433 | g111093 | i0 | 53.7 | 0.669421487603306 | 54 | 25 | 66.9 | 0 | 3 | 164 | 214 | 267 | ETO23319.1 hypothetical protein RFI_13860 [Reticulomyxa filosa] | diamond | 162 | 77.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27617404 | 27617404 | PRJNA611476_P_NODE_22404_length_424_cov_1.096866_g21613_i0 | PRJNA611476 | 22404 | 424 | 1.096866 | 4.65071184 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 170 | 1.22e-48 | NR | ETO17058.1 | 46433 | g21613 | i0 | 62.4 | 0.941037735849057 | 133 | 48 | 94.1 | 1 | 25 | 423 | 30 | 160 | ETO17058.1 hypothetical protein RFI_20276 [Reticulomyxa filosa] | diamond | 399 | 170 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27806967 | 27806967 | PRJNA611476_P_NODE_48224_length_313_cov_0.891667_g47433_i0 | PRJNA611476 | 48224 | 313 | 0.891667 | 2.79091771 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 1.19e-25 | NR | ETO00451.1 | 46433 | g47433 | i0 | 47.6 | 1.00638977635783 | 105 | 53 | 98.7 | 2 | 310 | 2 | 255 | 359 | ETO00451.1 Beta-galactosidase [Reticulomyxa filosa] | diamond | 315 | 109 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27882916 | 27882916 | PRJNA611476_P_NODE_29865_length_376_cov_2.033003_g29074_i0 | PRJNA611476 | 29865 | 376 | 2.033003 | 7.64409128 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 78.2 | 2.52e-15 | NR | ETO14766.1 | 46433 | g29074 | i0 | 65.4 | 4.01329787234043 | 52 | 18 | 41.5 | 0 | 374 | 219 | 104 | 155 | ETO14766.1 hypothetical protein RFI_22603 [Reticulomyxa filosa] | diamond | 1509 | 78.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27996227 | 27996227 | PRJNA611476_P_NODE_103005_length_245_cov_0.895349_g102214_i0 | PRJNA611476 | 103005 | 245 | 0.895349 | 2.19360505 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 9.37e-8 | NR | ETO25717.1 | 46433 | g102214 | i0 | 39.5 | 2.95102040816327 | 81 | 48 | 99.2 | 1 | 245 | 3 | 19 | 98 | ETO25717.1 hypothetical protein RFI_11421 [Reticulomyxa filosa] | diamond | 723 | 58.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27996308 | 27996308 | PRJNA611476_P_NODE_67805_length_271_cov_1.161616_g67014_i0 | PRJNA611476 | 67805 | 271 | 1.161616 | 3.14797936 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 6.76e-37 | NR | ETO11489.1 | 46433 | g67014 | i0 | 62.2 | 0.996309963099631 | 90 | 33 | 99.6 | 1 | 271 | 2 | 450 | 538 | ETO11489.1 hypothetical protein RFI_25888 [Reticulomyxa filosa] | diamond | 270 | 140 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28659350 | 28659350 | PRJNA611476_P_NODE_52747_length_301_cov_1.013158_g51956_i0 | PRJNA611476 | 52747 | 301 | 1.013158 | 3.04960558 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 4.14e-8 | NR | ETO05960.1 | 46433 | g51956 | i0 | 34.1 | 3.27906976744186 | 88 | 57 | 87.7 | 1 | 21 | 284 | 121 | 207 | ETO05960.1 hypothetical protein RFI_31437, partial [Reticulomyxa filosa] | diamond | 987 | 60.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28690962 | 28690962 | PRJNA611476_P_NODE_105167_length_244_cov_0.900585_g104376_i0 | PRJNA611476 | 105167 | 244 | 0.900585 | 2.1974274 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 2.23e-19 | NR | ETO24993.1 | 46433 | g104376 | i0 | 50 | 1.00819672131148 | 82 | 40 | 99.6 | 1 | 243 | 1 | 55 | 136 | ETO24993.1 hypothetical protein RFI_12152, partial [Reticulomyxa filosa] | diamond | 246 | 91.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28924756 | 28924756 | PRJNA611476_P_NODE_66468_length_273_cov_1.440000_g65677_i0 | PRJNA611476 | 66468 | 273 | 1.44 | 3.9312 | root | 1 | Root_unresolved | Root_unresolved | 67.4 | 1.15e-10 | NR | ETO34622.1 | 46433 | g65677 | i0 | 43.8 | 1.87912087912088 | 80 | 44 | 87.9 | 1 | 240 | 1 | 399 | 477 | ETO34622.1 hypothetical protein RFI_02467 [Reticulomyxa filosa] | diamond | 513 | 67.8 | 0.994100294985251 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29385572 | 29385572 | PRJNA611476_P_NODE_97769_length_246_cov_0.890173_g96978_i0 | PRJNA611476 | 97769 | 246 | 0.890173 | 2.18982558 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 2.54e-4 | NR | ETO25807.1 | 46433 | g96978 | i0 | 45.8 | 0.585365853658537 | 48 | 25 | 57.3 | 1 | 196 | 56 | 7 | 54 | ETO25807.1 hypothetical protein RFI_11329, partial [Reticulomyxa filosa] | diamond | 144 | 48.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30535601 | 30535601 | PRJNA611476_P_NODE_24813_length_406_cov_1.051051_g24022_i0 | PRJNA611476 | 24813 | 406 | 1.051051 | 4.26726706 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 7.54e-5 | NR | ETO32916.1 | 46433 | g24022 | i0 | 48.9 | 1.43349753694581 | 47 | 22 | 33.3 | 1 | 259 | 125 | 81 | 127 | ETO32916.1 hypothetical protein RFI_04200 [Reticulomyxa filosa] | diamond | 582 | 52.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30598658 | 30598658 | PRJNA611476_P_NODE_105753_length_244_cov_0.900585_g104962_i0 | PRJNA611476 | 105753 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 5.56e-10 | NR | ETO06965.1 | 46433 | g104962 | i0 | 41.3 | 3.61475409836066 | 75 | 40 | 87.3 | 2 | 222 | 10 | 66 | 140 | ETO06965.1 hypothetical protein RFI_30425 [Reticulomyxa filosa] | diamond | 882 | 62.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31280844 | 31280844 | PRJNA611476_P_NODE_57115_length_290_cov_1.221198_g56324_i0 | PRJNA611476 | 57115 | 290 | 1.221198 | 3.5414742 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 74.3 | 5.24e-13 | NR | ETO28195.1 | 46433 | g56324 | i0 | 38.7 | 1.9551724137931 | 93 | 56 | 95.2 | 1 | 276 | 1 | 705 | 797 | ETO28195.1 Ubiquitin carboxyl-terminal hydrolase family protein, partial [Reticulomyxa filosa] | diamond | 567 | 74.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32261900 | 32261900 | PRJNA611476_P_NODE_63418_length_279_cov_1.121359_g62627_i0 | PRJNA611476 | 63418 | 279 | 1.121359 | 3.12859161 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 0.0015 | NR | ETO21940.1 | 46433 | g62627 | i0 | 26.1 | 0.989247311827957 | 92 | 68 | 98.9 | 0 | 279 | 4 | 13 | 104 | ETO21940.1 hypothetical protein RFI_15264 [Reticulomyxa filosa] | diamond | 276 | 47 | 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);;