contig_metadata
15 rows where bioproject = "PRJNA908278", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6353127 | 6353127 | PRJNA908278_P_NODE_6785_length_452_cov_2.815303_g6682_i0 | PRJNA908278 | 6785 | 452 | 2.815303 | 12.72516956 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.63e-50 | NR | ETO27122.1 | 46433 | g6682 | i0 | 52.9 | 1.0287610619469 | 155 | 68 | 99.6 | 2 | 451 | 2 | 9 | 163 | ETO27122.1 citrate synthase [Reticulomyxa filosa] | diamond | 465 | 169 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 9818328 | 9818328 | PRJNA908278_P_NODE_6528_length_461_cov_2.028351_g6425_i0 | PRJNA908278 | 6528 | 461 | 2.028351 | 9.35069811 | Brizalina sp. 1 RS-2013 | 1368626 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 8.47e-94 | NTclustered | gi|529159331|gb|KF170435.1| | 1368626 | g6425 | i0 | 82.185 | 92.7353579175705 | 421 | 69 | 91 | 6 | 44 | 461 | 579 | 162 | Brizalina sp. 1 RS-2013 beta-tubulin type 1 isoform 1 gene, partial cds | blastn | 42751 | 357 | 1 | Eukaryota | Sar | Foraminifera | Rotaliida | Bolivinitidae | Brizalina | Brizalina sp. 1 RS-2013 | |||
| 28129972 | 28129972 | PRJNA908278_P_NODE_18545_length_297_cov_1.102679_g18442_i0 | PRJNA908278 | 18545 | 297 | 1.102679 | 3.27495663 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 5.550000000000001e-29 | NR | ETO35216.1 | 46433 | g18442 | i0 | 60 | 0.95959595959596 | 95 | 38 | 96 | 0 | 295 | 11 | 221 | 315 | ETO35216.1 coagulation factor 5/8 type domain-containing protein [Reticulomyxa filosa] | diamond | 285 | 119 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28256022 | 28256022 | PRJNA908278_P_NODE_28586_length_249_cov_0.875000_g28483_i0 | PRJNA908278 | 28586 | 249 | 0.875 | 2.17875 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 1.13e-10 | NR | ETO15620.1 | 46433 | g28483 | i0 | 40 | 0.963855421686747 | 80 | 44 | 91.6 | 1 | 237 | 10 | 208 | 287 | ETO15620.1 hypothetical protein RFI_21748 [Reticulomyxa filosa] | diamond | 240 | 67 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28350803 | 28350803 | PRJNA908278_P_NODE_11226_length_365_cov_2.561644_g11123_i0 | PRJNA908278 | 11226 | 365 | 2.561644 | 9.3500006 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 6.2e-17 | NR | ETO36728.1 | 46433 | g11123 | i0 | 41.3 | 0.854794520547945 | 104 | 60 | 85.5 | 1 | 54 | 365 | 43 | 145 | ETO36728.1 hypothetical protein RFI_00333 [Reticulomyxa filosa] | diamond | 312 | 82.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28421692 | 28421692 | PRJNA908278_P_NODE_17046_length_308_cov_1.310638_g16943_i0 | PRJNA908278 | 17046 | 308 | 1.310638 | 4.03676504 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 1.3499999999999999e-34 | NR | ETO32231.1 | 46433 | g16943 | i0 | 62.7 | 14.9025974025974 | 102 | 37 | 99.4 | 1 | 3 | 308 | 177 | 277 | ETO32231.1 ATP citrate lyase [Reticulomyxa filosa] | diamond | 4590 | 131 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29108831 | 29108831 | PRJNA908278_P_NODE_9868_length_385_cov_0.987179_g9765_i0 | PRJNA908278 | 9868 | 385 | 0.987179 | 3.80063915 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 98.6 | 6.81e-22 | NR | ETO16281.1 | 46433 | g9765 | i0 | 40.6 | 6.54545454545455 | 106 | 62 | 81.8 | 1 | 385 | 71 | 23 | 128 | ETO16281.1 hypothetical protein RFI_21073 [Reticulomyxa filosa] | diamond | 2520 | 98.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29305479 | 29305479 | PRJNA908278_P_NODE_12269_length_352_cov_1.931900_g12166_i0 | PRJNA908278 | 12269 | 352 | 1.9319 | 6.800288 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 97.8 | 6.6300000000000006e-21 | NR | ETO31638.1 | 46433 | g12166 | i0 | 42.4 | 2.76136363636364 | 118 | 65 | 99.7 | 2 | 1 | 351 | 487 | 602 | ETO31638.1 hypothetical protein RFI_05481 [Reticulomyxa filosa] | diamond | 972 | 98.2 | 0.995926680244399 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29739882 | 29739882 | PRJNA908278_P_NODE_25430_length_256_cov_1.562842_g25327_i0 | PRJNA908278 | 25430 | 256 | 1.562842 | 4.00087552 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 8.5e-5 | NR | ETO11887.1 | 46433 | g25327 | i0 | 35.2 | 1.03125 | 88 | 47 | 91.4 | 3 | 249 | 16 | 297 | 384 | ETO11887.1 hypothetical protein RFI_25489 [Reticulomyxa filosa] | diamond | 264 | 50.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29771540 | 29771540 | PRJNA908278_P_NODE_13491_length_339_cov_1.714286_g13388_i0 | PRJNA908278 | 13491 | 339 | 1.714286 | 5.81142954 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 1.01e-17 | NR | ETO28447.1 | 46433 | g13388 | i0 | 40.6 | 0.938053097345133 | 106 | 63 | 93.8 | 0 | 323 | 6 | 37 | 142 | ETO28447.1 hydroxylamine reductase, partial [Reticulomyxa filosa] | diamond | 318 | 87 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29834804 | 29834804 | PRJNA908278_P_NODE_12511_length_349_cov_2.847826_g12408_i0 | PRJNA908278 | 12511 | 349 | 2.847826 | 9.93891274 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 2.84e-15 | NR | ETO30124.1 | 46433 | g12408 | i0 | 55.4 | 0.636103151862464 | 74 | 30 | 61 | 3 | 126 | 338 | 191 | 264 | ETO30124.1 carboxylesterase, partial [Reticulomyxa filosa] | diamond | 222 | 81.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30435426 | 30435426 | PRJNA908278_P_NODE_32913_length_244_cov_0.900585_g32810_i0 | PRJNA908278 | 32913 | 244 | 0.900585 | 2.1974274 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00211 | NR | ETO13815.1 | 46433 | g32810 | i0 | 42.6 | 1.77049180327869 | 47 | 27 | 57.8 | 0 | 180 | 40 | 221 | 267 | ETO13815.1 hypothetical protein RFI_23552 [Reticulomyxa filosa] | diamond | 432 | 46.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31129883 | 31129883 | PRJNA908278_P_NODE_11075_length_367_cov_2.591837_g10972_i0 | PRJNA908278 | 11075 | 367 | 2.591837 | 9.51204179 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 97.8 | 9.28e-22 | NR | ETO19641.1 | 46433 | g10972 | i0 | 40.7 | 1.7983651226158 | 118 | 56 | 90.7 | 4 | 9 | 341 | 175 | 285 | ETO19641.1 hypothetical protein RFI_17588 [Reticulomyxa filosa] | diamond | 660 | 97.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32174276 | 32174276 | PRJNA908278_P_NODE_17578_length_304_cov_1.471861_g17475_i0 | PRJNA908278 | 17578 | 304 | 1.471861 | 4.47445744 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 2.72e-39 | NR | ETO05861.1 | 46433 | g17475 | i0 | 64 | 0.986842105263158 | 100 | 36 | 98.7 | 0 | 303 | 4 | 44 | 143 | ETO05861.1 fimbrin [Reticulomyxa filosa] | diamond | 300 | 141 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32237684 | 32237684 | PRJNA908278_P_NODE_24178_length_263_cov_1.931579_g24075_i0 | PRJNA908278 | 24178 | 263 | 1.931579 | 5.08005277 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 52 | 2.47e-5 | NR | ETO17107.1 | 46433 | g24075 | i0 | 48.9 | 1.01520912547529 | 45 | 20 | 47.9 | 1 | 34 | 159 | 113 | 157 | ETO17107.1 calcium-dependent protein kinase 21 [Reticulomyxa filosa] | diamond | 267 | 52 | 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);;