contig_metadata
20 rows where bioproject = "PRJNA1148190" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17612914 | 17612914 | PRJNA1148190_P_NODE_41694_length_980_cov_1.785006_g31207_i0 | PRJNA1148190 | 41694 | 980 | 1.785006 | 17.4930588 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 2.03e-40 | NR | ETO01547.1 | 46433 | g31207 | i0 | 55.6 | 2.3234693877551 | 142 | 61 | 42.9 | 2 | 424 | 5 | 20 | 161 | ETO01547.1 hypothetical protein RFI_35896 [Reticulomyxa filosa] | diamond | 2277 | 151 | 0.993377483443709 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26882133 | 26882133 | PRJNA1148190_P_NODE_787181_length_241_cov_0.916667_g776008_i0 | PRJNA1148190 | 787181 | 241 | 0.916667 | 2.20916747 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 2.16e-11 | NR | ETO14419.1 | 46433 | g776008 | i0 | 35 | 0.995850622406639 | 80 | 52 | 99.6 | 0 | 240 | 1 | 250 | 329 | ETO14419.1 hypothetical protein RFI_22950 [Reticulomyxa filosa] | diamond | 240 | 68.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27596804 | 27596804 | PRJNA1148190_P_NODE_327984_length_309_cov_0.927966_g316811_i0 | PRJNA1148190 | 327984 | 309 | 0.927966 | 2.86741494 | root | 1 | Root_unresolved | Root_unresolved | 87 | 2.43e-17 | NR | ETO16136.1 | 46433 | g316811 | i0 | 39.6 | 3.84466019417476 | 101 | 61 | 98.1 | 0 | 7 | 309 | 1873 | 1973 | ETO16136.1 Ubiquitin carboxyl-terminal hydrolase family protein, partial [Reticulomyxa filosa] | diamond | 1188 | 87 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27924250 | 27924250 | PRJNA1148190_P_NODE_540065_length_259_cov_1.241935_g528892_i0 | PRJNA1148190 | 540065 | 259 | 1.241935 | 3.21661165 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 5.3399999999999996e-24 | NR | ETO19354.1 | 46433 | g528892 | i0 | 56.4 | 2.79150579150579 | 78 | 34 | 90.3 | 0 | 258 | 25 | 43 | 120 | ETO19354.1 hypothetical protein RFI_17876 [Reticulomyxa filosa] | diamond | 723 | 100 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28354455 | 28354455 | PRJNA1148190_P_NODE_585846_length_251_cov_0.865169_g574673_i0 | PRJNA1148190 | 585846 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 74.3 | 1.33e-13 | NR | ETO09160.1 | 46433 | g574673 | i0 | 44.4 | 4.98406374501992 | 63 | 35 | 75.3 | 0 | 27 | 215 | 124 | 186 | ETO09160.1 hypothetical protein RFI_28228 [Reticulomyxa filosa] | diamond | 1251 | 74.7 | 0.994645247657296 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28586705 | 28586705 | PRJNA1148190_P_NODE_130887_length_460_cov_2.069767_g119724_i0 | PRJNA1148190 | 130887 | 460 | 2.069767 | 9.5209282 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 2.01e-25 | NR | ETN97116.1 | 46433 | g119724 | i0 | 42.4 | 3.22826086956522 | 165 | 79 | 99.8 | 4 | 460 | 2 | 300 | 460 | ETN97116.1 hypothetical protein RFI_40415, partial [Reticulomyxa filosa] | diamond | 1485 | 111 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29187781 | 29187781 | PRJNA1148190_P_NODE_7629_length_4057_cov_19.391566_g3745_i0 | PRJNA1148190 | 7629 | 4057 | 19.391566 | 786.71583262 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 366 | 1.4799999999999995e-112 | NR | ETO03760.1 | 46433 | g3745 | i0 | 55.3 | 0.224796647769288 | 304 | 136 | 22.5 | 0 | 1468 | 2379 | 1 | 304 | ETO03760.1 hypothetical protein RFI_33642, partial [Reticulomyxa filosa] | diamond | 912 | 366 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29344695 | 29344695 | PRJNA1148190_P_NODE_282509_length_327_cov_1.905512_g271338_i0 | PRJNA1148190 | 282509 | 327 | 1.905512 | 6.23102424 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 85.5 | 1.06e-17 | NR | ETO03763.1 | 46433 | g271338 | i0 | 76 | 0.917431192660551 | 50 | 12 | 45.9 | 0 | 323 | 174 | 98 | 147 | ETO03763.1 hypothetical protein RFI_33639, partial [Reticulomyxa filosa] | diamond | 300 | 85.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29533737 | 29533737 | PRJNA1148190_P_NODE_11670_length_2890_cov_19.107561_g3745_i1 | PRJNA1148190 | 11670 | 2890 | 19.107561 | 552.2085129 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 366 | 2.87e-115 | NR | ETO03760.1 | 46433 | g3745 | i1 | 55.3 | 0.315570934256055 | 304 | 136 | 31.6 | 0 | 591 | 1502 | 1 | 304 | ETO03760.1 hypothetical protein RFI_33642, partial [Reticulomyxa filosa] | diamond | 912 | 366 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29755129 | 29755129 | PRJNA1148190_P_NODE_41371_length_985_cov_2.803728_g30902_i0 | PRJNA1148190 | 41371 | 985 | 2.803728 | 27.6167208 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 9.73e-37 | NR | ETO03763.1 | 46433 | g30902 | i0 | 63.8 | 0.319796954314721 | 105 | 34 | 31.4 | 2 | 501 | 809 | 75 | 177 | ETO03763.1 hypothetical protein RFI_33639, partial [Reticulomyxa filosa] | diamond | 315 | 142 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29817811 | 29817811 | PRJNA1148190_P_NODE_167071_length_408_cov_0.919403_g155903_i0 | PRJNA1148190 | 167071 | 408 | 0.919403 | 3.75116424 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 4.3499999999999997e-23 | NR | ETO16908.1 | 46433 | g155903 | i0 | 51.9 | 2.27941176470588 | 104 | 43 | 74.3 | 2 | 372 | 70 | 39 | 138 | ETO16908.1 hypothetical protein RFI_20428 [Reticulomyxa filosa] | diamond | 930 | 99.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30197579 | 30197579 | PRJNA1148190_P_NODE_550732_length_257_cov_1.255435_g539559_i0 | PRJNA1148190 | 550732 | 257 | 1.255435 | 3.22646795 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 1.73e-10 | NR | ETO12588.1 | 46433 | g539559 | i0 | 45.2 | 0.852140077821012 | 73 | 40 | 85.2 | 0 | 4 | 222 | 317 | 389 | ETO12588.1 adaptor-related protein complex 2, alpha subunit, partial [Reticulomyxa filosa] | diamond | 219 | 66.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31239570 | 31239570 | PRJNA1148190_P_NODE_12655_length_2700_cov_26.630377_g3745_i2 | PRJNA1148190 | 12655 | 2700 | 26.630377 | 719.020179 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 366 | 5.14e-116 | NR | ETO03760.1 | 46433 | g3745 | i2 | 55.3 | 0.337777777777778 | 304 | 136 | 33.8 | 0 | 1468 | 2379 | 1 | 304 | ETO03760.1 hypothetical protein RFI_33642, partial [Reticulomyxa filosa] | diamond | 912 | 366 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31366367 | 31366367 | PRJNA1148190_P_NODE_102896_length_526_cov_1.331126_g91739_i0 | PRJNA1148190 | 102896 | 526 | 1.331126 | 7.00172276 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 2.58e-22 | NR | ETO28819.1 | 46433 | g91739 | i0 | 39.1 | 1.72813688212928 | 151 | 79 | 78.7 | 4 | 86 | 499 | 534 | 684 | ETO28819.1 hypothetical protein RFI_08308 [Reticulomyxa filosa] | diamond | 909 | 104 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31714647 | 31714647 | PRJNA1148190_P_NODE_399757_length_286_cov_1.643192_g388584_i0 | PRJNA1148190 | 399757 | 286 | 1.643192 | 4.69952912 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 1.27e-4 | NR | ETO32083.1 | 46433 | g388584 | i0 | 36.3 | 8.64335664335664 | 91 | 51 | 91.3 | 3 | 10 | 270 | 806 | 893 | ETO32083.1 WD-40 repeat protein [Reticulomyxa filosa] | diamond | 2472 | 50.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31714859 | 31714859 | PRJNA1148190_P_NODE_532257_length_260_cov_1.647059_g521084_i0 | PRJNA1148190 | 532257 | 260 | 1.647059 | 4.2823534 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 7.1e-4 | NR | ETN97288.1 | 46433 | g521084 | i0 | 36.4 | 0.634615384615385 | 55 | 35 | 63.5 | 0 | 77 | 241 | 60 | 114 | ETN97288.1 Helicase conserved domain containing protein, partial [Reticulomyxa filosa] | diamond | 165 | 46.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32347285 | 32347285 | PRJNA1148190_P_NODE_17879_length_2023_cov_12.953333_g493_i2 | PRJNA1148190 | 17879 | 2023 | 12.953333 | 262.04592659 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 0.0205 | NR | ETN97658.1 | 46433 | g493 | i2 | 28.6 | 0.385565991102323 | 133 | 90 | 19.7 | 2 | 1285 | 1683 | 132 | 259 | ETN97658.1 hypothetical protein RFI_39866 [Reticulomyxa filosa] | diamond | 780 | 50.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32568780 | 32568780 | PRJNA1148190_P_NODE_191459_length_383_cov_2.364516_g180289_i0 | PRJNA1148190 | 191459 | 383 | 2.364516 | 9.05609628 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 77 | 6.01e-14 | NR | ETO03050.1 | 46433 | g180289 | i0 | 34.9 | 1.8798955613577 | 129 | 79 | 99.5 | 3 | 382 | 2 | 92 | 217 | ETO03050.1 putative VV A32 ATPase, partial [Reticulomyxa filosa] | diamond | 720 | 77 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32695436 | 32695436 | PRJNA1148190_P_NODE_89320_length_571_cov_2.403614_g78184_i0 | PRJNA1148190 | 89320 | 571 | 2.403614 | 13.72463594 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 2.69e-68 | NR | ETO03760.1 | 46433 | g78184 | i0 | 51.9 | 0.992994746059545 | 189 | 91 | 99.3 | 0 | 571 | 5 | 33 | 221 | ETO03760.1 hypothetical protein RFI_33642, partial [Reticulomyxa filosa] | diamond | 567 | 220 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32903700 | 32903700 | PRJNA1148190_P_NODE_714160_length_244_cov_1.754386_g702987_i0 | PRJNA1148190 | 714160 | 244 | 1.754386 | 4.28070184 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 1.21e-10 | NR | ETO26906.1 | 46433 | g702987 | i0 | 56.6 | 9.92213114754098 | 53 | 23 | 65.2 | 0 | 212 | 54 | 145 | 197 | ETO26906.1 hypothetical protein RFI_10226 [Reticulomyxa filosa] | diamond | 2421 | 65.5 | 0.993893129770992 | 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);;