contig_metadata
13 rows where bioproject = "PRJNA715462", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1982080 | 1982080 | PRJNA715462_P_NODE_46622_length_261_cov_1.638298_g45826_i0 | PRJNA715462 | 46622 | 261 | 1.638298 | 4.27595778 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 6.84e-45 | NR | ETO17530.1 | 46433 | g45826 | i0 | 88.4 | 0.988505747126437 | 86 | 10 | 98.9 | 0 | 2 | 259 | 101 | 186 | ETO17530.1 hypothetical protein RFI_19788 [Reticulomyxa filosa] | diamond | 258 | 152 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 4534712 | 4534712 | PRJNA715462_P_NODE_60624_length_246_cov_0.890173_g59828_i0 | PRJNA715462 | 60624 | 246 | 0.890173 | 2.18982558 | Foraminifera sp. fruitcake | 1414771 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 1.25e-44 | NTclustered | gi|745794612|gb|KF728652.1| | 1414771 | g59828 | i0 | 82.589 | 65.5406504065041 | 224 | 34 | 90 | 4 | 13 | 233 | 235 | 456 | Foraminifera sp. fruitcake clone Fruit29 actin (act) gene, partial cds | blastn | 16123 | 193 | 1 | Eukaryota | Sar | Foraminifera | Foraminifera sp. fruitcake | ||||||
| 5020600 | 5020600 | PRJNA715462_P_NODE_65224_length_243_cov_0.905882_g64428_i0 | PRJNA715462 | 65224 | 243 | 0.905882 | 2.20129326 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 1.17e-25 | NR | ETO32962.1 | 46433 | g64428 | i0 | 62.5 | 8.88888888888889 | 80 | 30 | 98.8 | 0 | 242 | 3 | 143 | 222 | ETO32962.1 vacuolar ATP synthase subunit B [Reticulomyxa filosa] | diamond | 2160 | 106 | 0.990566037735849 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 14735459 | 14735459 | PRJNA715462_P_NODE_68432_length_241_cov_0.916667_g67636_i0 | PRJNA715462 | 68432 | 241 | 0.916667 | 2.20916747 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 89.4 | 1.2e-18 | NR | ETO26662.1 | 46433 | g67636 | i0 | 46.3 | 8.14107883817427 | 80 | 43 | 99.6 | 0 | 240 | 1 | 72 | 151 | ETO26662.1 hypothetical protein RFI_10472, partial [Reticulomyxa filosa] | diamond | 1962 | 89.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26988476 | 26988476 | PRJNA715462_P_NODE_70462_length_216_cov_5.790210_g69666_i0 | PRJNA715462 | 70462 | 216 | 5.79021 | 12.5068536 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 1.22e-6 | NR | ETO10995.1 | 46433 | g69666 | i0 | 39 | 2.95833333333333 | 77 | 37 | 95.8 | 2 | 216 | 10 | 547 | 621 | ETO10995.1 hypothetical protein RFI_26379, partial [Reticulomyxa filosa] | diamond | 639 | 55.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27589200 | 27589200 | PRJNA715462_P_NODE_8324_length_773_cov_3.035714_g7593_i0 | PRJNA715462 | 8324 | 773 | 3.035714 | 23.46606922 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 5.29e-4 | NR | ETO26716.1 | 46433 | g7593 | i0 | 33.7 | 0.838292367399741 | 101 | 59 | 36.1 | 3 | 478 | 756 | 82 | 182 | ETO26716.1 hypothetical protein RFI_10417 [Reticulomyxa filosa] | diamond | 648 | 51.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29052176 | 29052176 | PRJNA715462_P_NODE_69908_length_237_cov_2.500000_g69112_i0 | PRJNA715462 | 69908 | 237 | 2.5 | 5.925 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 2.01e-19 | NR | ETO19934.1 | 46433 | g69112 | i0 | 55.6 | 6.0253164556962 | 81 | 34 | 100 | 1 | 237 | 1 | 7 | 87 | ETO19934.1 hypothetical protein RFI_17287, partial [Reticulomyxa filosa] | diamond | 1428 | 92 | 0.996739130434783 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 29325510 | 29325510 | PRJNA715462_P_NODE_46309_length_262_cov_1.629630_g45513_i0 | PRJNA715462 | 46309 | 262 | 1.62963 | 4.2696306 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 79.3 | 7.12e-16 | NR | ETO27231.1 | 46433 | g45513 | i0 | 44.8 | 0.99618320610687 | 87 | 45 | 99.6 | 1 | 1 | 261 | 103 | 186 | ETO27231.1 hypothetical protein RFI_09902, partial [Reticulomyxa filosa] | diamond | 261 | 79.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30030980 | 30030980 | PRJNA715462_P_NODE_52931_length_250_cov_0.870056_g52135_i0 | PRJNA715462 | 52931 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 3.48e-27 | NR | ETO13922.1 | 46433 | g52135 | i0 | 62.1 | 19.836 | 87 | 28 | 98.4 | 1 | 5 | 250 | 65 | 151 | ETO13922.1 hypothetical protein RFI_23446, partial [Reticulomyxa filosa] | diamond | 4959 | 110 | 0.990909090909091 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31189009 | 31189009 | PRJNA715462_P_NODE_26695_length_348_cov_0.756364_g25899_i0 | PRJNA715462 | 26695 | 348 | 0.756364 | 2.63214672 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 186 | 8.1e-54 | NR | ETO30355.1 | 46433 | g25899 | i0 | 71.1 | 1.96551724137931 | 114 | 33 | 98.3 | 0 | 346 | 5 | 163 | 276 | ETO30355.1 hypothetical protein RFI_06765, partial [Reticulomyxa filosa] | diamond | 684 | 186 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31632121 | 31632121 | PRJNA715462_P_NODE_65956_length_243_cov_0.905882_g65160_i0 | PRJNA715462 | 65956 | 243 | 0.905882 | 2.20129326 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 1.3e-11 | NR | ETO36871.1 | 46433 | g65160 | i0 | 43.4 | 1.87654320987654 | 76 | 40 | 93.8 | 1 | 241 | 14 | 24 | 96 | ETO36871.1 hypothetical protein RFI_00191 [Reticulomyxa filosa] | diamond | 456 | 65.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31737473 | 31737473 | PRJNA715462_P_NODE_55897_length_248_cov_0.880000_g55101_i0 | PRJNA715462 | 55897 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 6.34e-4 | NR | ETO14552.1 | 46433 | g55101 | i0 | 44.4 | 1.24596774193548 | 54 | 30 | 65.3 | 0 | 246 | 85 | 115 | 168 | ETO14552.1 hypothetical protein RFI_22816 [Reticulomyxa filosa] | diamond | 309 | 47.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32148999 | 32148999 | PRJNA715462_P_NODE_39258_length_283_cov_1.466667_g38462_i0 | PRJNA715462 | 39258 | 283 | 1.466667 | 4.15066761 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 2.6099999999999996e-32 | NR | ETO05798.1 | 46433 | g38462 | i0 | 58.2 | 1.90812720848057 | 91 | 38 | 96.5 | 0 | 279 | 7 | 227 | 317 | ETO05798.1 hypothetical protein RFI_31597 [Reticulomyxa filosa] | diamond | 540 | 125 | 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);;