contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJEB64798" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26844127 | 26844127 | PRJEB64798_P_NODE_238921_length_155_cov_8.216981_g237155_i0 | PRJEB64798 | 238921 | 155 | 8.216981 | 12.73632055 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 84 | 2.78e-17 | NR | ETO29104.1 | 46433 | g237155 | i0 | 73.5 | 0.948387096774194 | 49 | 13 | 94.8 | 0 | 154 | 8 | 238 | 286 | ETO29104.1 hypothetical protein RFI_08022 [Reticulomyxa filosa] | diamond | 147 | 84 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27279815 | 27279815 | PRJEB64798_P_NODE_222443_length_161_cov_11.803571_g220677_i0 | PRJEB64798 | 222443 | 161 | 11.803571 | 19.00374931 | Ochromonadales | 98652 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 8.18e-5 | NR | ETO06965.1 | 46433 | g220677 | i0 | 54.3 | 1.45341614906832 | 35 | 16 | 65.2 | 0 | 106 | 2 | 109 | 143 | ETO06965.1 hypothetical protein RFI_30425 [Reticulomyxa filosa] | diamond | 234 | 48.1 | 0.993762993762994 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27318285 | 27318285 | PRJEB64798_P_NODE_122223_length_205_cov_2.070513_g120457_i0 | PRJEB64798 | 122223 | 205 | 2.070513 | 4.24455165 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 82.8 | 1.56e-16 | NR | ETO29218.1 | 46433 | g120457 | i0 | 57.4 | 0.892682926829268 | 61 | 26 | 89.3 | 0 | 184 | 2 | 299 | 359 | ETO29218.1 CCR4-NOT transcription complex subunit 8, partial [Reticulomyxa filosa] | diamond | 183 | 82.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 27507907 | 27507907 | PRJEB64798_P_NODE_17223_length_480_cov_8.559165_g15516_i0 | PRJEB64798 | 17223 | 480 | 8.559165 | 41.083992 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 2.07e-11 | NR | ETO27996.1 | 46433 | g15516 | i0 | 34.6 | 0.66875 | 107 | 70 | 66.9 | 0 | 476 | 156 | 60 | 166 | ETO27996.1 5'-3' exoribonuclease 1, partial [Reticulomyxa filosa] | diamond | 321 | 72.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 28707747 | 28707747 | PRJEB64798_P_NODE_250707_length_151_cov_11.666667_g248941_i0 | PRJEB64798 | 250707 | 151 | 11.666667 | 17.61666717 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 55.8 | 2.42e-7 | NR | ETO10243.1 | 46433 | g248941 | i0 | 53.2 | 3.73509933774834 | 47 | 22 | 93.4 | 0 | 143 | 3 | 26 | 72 | ETO10243.1 hypothetical protein RFI_27134, partial [Reticulomyxa filosa] | diamond | 564 | 55.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30002294 | 30002294 | PRJEB64798_P_NODE_176411_length_176_cov_1.944882_g174645_i0 | PRJEB64798 | 176411 | 176 | 1.944882 | 3.42299232 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 1.3e-12 | NR | ETO23157.1 | 46433 | g174645 | i0 | 63 | 0.920454545454545 | 54 | 20 | 92 | 0 | 10 | 171 | 144 | 197 | ETO23157.1 putative hydrolase [Reticulomyxa filosa] | diamond | 162 | 70.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30128176 | 30128176 | PRJEB64798_P_NODE_124592_length_202_cov_7.771242_g122826_i0 | PRJEB64798 | 124592 | 202 | 7.771242 | 15.69790884 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 2.97e-9 | NR | ETO08387.1 | 46433 | g122826 | i0 | 74.3 | 2.73267326732673 | 35 | 9 | 52 | 0 | 5 | 109 | 55 | 89 | ETO08387.1 S-Adenosyl homocysteine hydrolase [Reticulomyxa filosa] | diamond | 552 | 60.1 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 30563671 | 30563671 | PRJEB64798_P_NODE_213013_length_164_cov_1.391304_g211247_i0 | PRJEB64798 | 213013 | 164 | 1.391304 | 2.28173856 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 5.15e-9 | NR | ETO33799.1 | 46433 | g211247 | i0 | 65 | 2.35975609756098 | 40 | 14 | 73.2 | 0 | 121 | 2 | 192 | 231 | ETO33799.1 Protein kinase domain containing protein [Reticulomyxa filosa] | diamond | 387 | 60.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31107866 | 31107866 | PRJEB64798_P_NODE_185435_length_172_cov_3.406504_g183669_i0 | PRJEB64798 | 185435 | 172 | 3.406504 | 5.85918688 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 6.23e-9 | NR | ETO03611.1 | 46433 | g183669 | i0 | 55.3 | 0.819767441860465 | 47 | 21 | 82 | 0 | 146 | 6 | 176 | 222 | ETO03611.1 translation initiation factor if-2 betam beta subunit ZnR [Reticulomyxa filosa] | diamond | 141 | 60.1 | 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);;