contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1022139" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16306028 | 16306028 | PRJNA1022139_P_NODE_20993_length_306_cov_0.944206_g20888_i0 | PRJNA1022139 | 20993 | 306 | 0.944206 | 2.88927036 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 168 | 7.36e-46 | NR | ETO05095.1 | 46433 | g20888 | i0 | 73.5 | 2 | 102 | 27 | 100 | 0 | 306 | 1 | 560 | 661 | ETO05095.1 hypothetical protein RFI_32303 [Reticulomyxa filosa] | diamond | 612 | 168 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 19287273 | 19287273 | PRJNA1022139_P_NODE_19256_length_318_cov_1.220408_g19151_i0 | PRJNA1022139 | 19256 | 318 | 1.220408 | 3.88089744 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 95.1 | 3.62e-20 | NR | ETO22562.1 | 46433 | g19151 | i0 | 53.2 | 2.20754716981132 | 77 | 36 | 72.6 | 0 | 317 | 87 | 467 | 543 | ETO22562.1 hypothetical protein RFI_14635 [Reticulomyxa filosa] | diamond | 702 | 95.5 | 0.995811518324607 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27982520 | 27982520 | PRJNA1022139_P_NODE_11545_length_395_cov_1.434783_g11440_i0 | PRJNA1022139 | 11545 | 395 | 1.434783 | 5.66739285 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 88.6 | 1.84e-17 | NR | ETO23176.1 | 46433 | g11440 | i0 | 45.6 | 0.683544303797468 | 90 | 47 | 67.6 | 2 | 267 | 1 | 1 | 89 | ETO23176.1 hypothetical protein RFI_14010 [Reticulomyxa filosa] | diamond | 270 | 88.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28701050 | 28701050 | PRJNA1022139_P_NODE_11147_length_401_cov_1.527439_g11042_i0 | PRJNA1022139 | 11147 | 401 | 1.527439 | 6.12503039 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 78.2 | 8.77e-14 | NR | ETO33024.1 | 46433 | g11042 | i0 | 55.2 | 3.12718204488778 | 58 | 26 | 43.4 | 0 | 227 | 400 | 659 | 716 | ETO33024.1 hypothetical protein RFI_04084, partial [Reticulomyxa filosa] | diamond | 1254 | 78.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29687223 | 29687223 | PRJNA1022139_P_NODE_39350_length_245_cov_0.895349_g39245_i0 | PRJNA1022139 | 39350 | 245 | 0.895349 | 2.19360505 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00442 | NR | ETO14021.1 | 46433 | g39245 | i0 | 32.1 | 1.95918367346939 | 81 | 49 | 99.2 | 2 | 1 | 243 | 81 | 155 | ETO14021.1 Ubiquitin carboxyl-terminal hydrolase family protein [Reticulomyxa filosa] | diamond | 480 | 45.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29940364 | 29940364 | PRJNA1022139_P_NODE_43611_length_232_cov_3.415094_g43506_i0 | PRJNA1022139 | 43611 | 232 | 3.415094 | 7.92301808 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0121 | NR | ETO30854.1 | 46433 | g43506 | i0 | 29.4 | 1.6551724137931 | 68 | 48 | 87.9 | 0 | 18 | 221 | 223 | 290 | ETO30854.1 hypothetical protein RFI_06265 [Reticulomyxa filosa] | diamond | 384 | 43.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30161065 | 30161065 | PRJNA1022139_P_NODE_14052_length_363_cov_1.593103_g13947_i0 | PRJNA1022139 | 14052 | 363 | 1.593103 | 5.78296389 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 8.85e-18 | NR | ETO32881.1 | 46433 | g13947 | i0 | 37.5 | 0.925619834710744 | 112 | 70 | 92.6 | 0 | 3 | 338 | 313 | 424 | ETO32881.1 hypothetical protein RFI_04239 [Reticulomyxa filosa] | diamond | 336 | 89 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30501067 | 30501067 | PRJNA1022139_P_NODE_26673_length_279_cov_1.194175_g26568_i0 | PRJNA1022139 | 26673 | 279 | 1.194175 | 3.33174825 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 2.72e-14 | NR | ETO24993.1 | 46433 | g26568 | i0 | 44.1 | 1.94623655913978 | 93 | 48 | 95.7 | 1 | 270 | 4 | 97 | 189 | ETO24993.1 hypothetical protein RFI_12152, partial [Reticulomyxa filosa] | diamond | 543 | 77.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31140388 | 31140388 | PRJNA1022139_P_NODE_34635_length_251_cov_0.865169_g34530_i0 | PRJNA1022139 | 34635 | 251 | 0.865169 | 2.17157419 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 5.43e-12 | NR | ETO07263.1 | 46433 | g34530 | i0 | 63.5 | 1.54183266932271 | 52 | 19 | 62.2 | 0 | 4 | 159 | 168 | 219 | ETO07263.1 Ras family protein [Reticulomyxa filosa] | diamond | 387 | 69.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31994829 | 31994829 | PRJNA1022139_P_NODE_9998_length_421_cov_1.307471_g9893_i0 | PRJNA1022139 | 9998 | 421 | 1.307471 | 5.50445291 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 9.46e-8 | NR | ETO23063.1 | 46433 | g9893 | i0 | 31.7 | 1.57482185273159 | 123 | 83 | 87.6 | 1 | 20 | 388 | 558 | 679 | ETO23063.1 hypothetical protein RFI_14122, partial [Reticulomyxa filosa] | diamond | 663 | 61.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32057989 | 32057989 | PRJNA1022139_P_NODE_14898_length_354_cov_3.462633_g14793_i0 | PRJNA1022139 | 14898 | 354 | 3.462633 | 12.25772082 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 5.06e-35 | NR | ETO34651.1 | 46433 | g14793 | i0 | 70.6 | 0.720338983050847 | 85 | 25 | 72 | 0 | 349 | 95 | 111 | 195 | ETO34651.1 beta-hexosaminidase [Reticulomyxa filosa] | diamond | 255 | 129 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32879161 | 32879161 | PRJNA1022139_P_NODE_9280_length_436_cov_0.763085_g9175_i0 | PRJNA1022139 | 9280 | 436 | 0.763085 | 3.3270506 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 4.5e-4 | NR | ETO16473.1 | 46433 | g9175 | i0 | 44.4 | 1.19724770642202 | 63 | 34 | 42.7 | 1 | 4 | 189 | 60 | 122 | ETO16473.1 hypothetical protein RFI_20867 [Reticulomyxa filosa] | diamond | 522 | 50.4 | 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);;