contig_metadata
9 rows where bioproject = "PRJNA492280", tax_clade = "Sar" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 451927 | 451927 | PRJNA492280_P_NODE_11901_length_164_cov_7.858268_g11794_i0 | PRJNA492280 | 11901 | 164 | 7.858268 | 12.88755952 | Phytocercomonas venanatans | 2065209 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 3.78e-8 | NTclustered | gi|1315527750|gb|MF034900.1| | 2065209 | g11794 | i0 | 88.525 | 0.371951219512195 | 61 | 3 | 36 | 4 | 1 | 59 | 9701 | 9643 | Phytocercomonas venanatans 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 61 | 71.3 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Phytocercomonas | Phytocercomonas venanatans | |||
| 452214 | 452214 | PRJNA492280_P_NODE_6821_length_199_cov_6.709877_g6714_i0 | PRJNA492280 | 6821 | 199 | 6.709877 | 13.35265523 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 3.3899999999999997e-69 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g6714 | i0 | 92.228 | 18.9698492462312 | 193 | 15 | 97 | 0 | 5 | 197 | 1804 | 1996 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 3775 | 274 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 2374386 | 2374386 | PRJNA492280_P_NODE_2042_length_319_cov_11.421986_g1935_i0 | PRJNA492280 | 2042 | 319 | 11.421986 | 36.43613534 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 418 | 2.559999999999999e-112 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g1935 | i0 | 99.138 | 92.6739811912226 | 232 | 2 | 95 | 0 | 4 | 235 | 780 | 1011 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 29563 | 418 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 4278953 | 4278953 | PRJNA492280_P_NODE_14564_length_164_cov_4.763780_g14457_i0 | PRJNA492280 | 14564 | 164 | 4.76378 | 7.8125992 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.21e-25 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g14457 | i0 | 97.368 | 53.0914634146341 | 76 | 1 | 46 | 1 | 89 | 164 | 2812 | 2738 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 8707 | 128 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 4279049 | 4279049 | PRJNA492280_P_NODE_25824_length_164_cov_2.346457_g25717_i0 | PRJNA492280 | 25824 | 164 | 2.346457 | 3.84818948 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 2.84e-29 | NTclustered | gi|300676732|gb|GQ377662.1| | 188950 | g25717 | i0 | 100 | 27.640243902439 | 76 | 0 | 91 | 0 | 1 | 76 | 890 | 815 | Bodomorpha minima alpha-tubulin (Atub) gene, partial cds | blastn | 4533 | 141 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 5555738 | 5555738 | PRJNA492280_P_NODE_7405_length_192_cov_14.974194_g7298_i0 | PRJNA492280 | 7405 | 192 | 14.974194 | 28.75045248 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 348 | 1.88e-91 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g7298 | i0 | 100 | 43.9947916666667 | 188 | 0 | 98 | 0 | 4 | 191 | 1910 | 1723 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 8447 | 348 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 9380002 | 9380002 | PRJNA492280_P_NODE_6008_length_210_cov_4.398844_g5901_i0 | PRJNA492280 | 6008 | 210 | 4.398844 | 9.2375724 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 375 | 9.63e-100 | NTclustered | gi|224996436|gb|FJ654268.1| | 188950 | g5901 | i0 | 100 | 84.2095238095238 | 203 | 0 | 97 | 0 | 4 | 206 | 517 | 719 | Bodomorpha minima 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 17684 | 375 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 14480736 | 14480736 | PRJNA492280_P_NODE_5272_length_222_cov_13.016216_g5165_i0 | PRJNA492280 | 5272 | 222 | 13.016216 | 28.89599952 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 6.099999999999999e-107 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g5165 | i0 | 99.543 | 65.0990990990991 | 219 | 1 | 99 | 0 | 4 | 222 | 2674 | 2892 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 14452 | 399 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 19577697 | 19577697 | PRJNA492280_P_NODE_1296_length_387_cov_22.434286_g1196_i0 | PRJNA492280 | 1296 | 387 | 22.434286 | 86.82068682 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 704 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g1196 | i0 | 100 | 21.0826873385013 | 381 | 0 | 98 | 0 | 4 | 384 | 350 | 730 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 8159 | 704 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima |
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);;