contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA797475" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1216872 | 1216872 | PRJNA797475_P_NODE_2241_length_650_cov_2.213172_g2144_i0 | PRJNA797475 | 2241 | 650 | 2.213172 | 14.385618 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 736 | 0 | NTclustered | gi|161207|gb|M21500.1|SLMACT35 | 5791 | g2144 | i0 | 87.097 | 99.8030769230769 | 651 | 82 | 100 | 2 | 1 | 650 | 443 | 1092 | P.polycephalum actin (Ppa35) mRNA, complete cds | blastn | 64872 | 743 | 0.990578734858681 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 2492362 | 2492362 | PRJNA797475_P_NODE_20362_length_256_cov_1.262295_g20263_i0 | PRJNA797475 | 20362 | 256 | 1.262295 | 3.2314752 | Entamoeba | 5758 | Evosea | other_Eukaryota | 76.8 | 1.38e-9 | NTclustered | gi|511090867|dbj|AK422769.1| | 33085 | g20263 | i0 | 88.889 | 1.9609375 | 63 | 5 | 24 | 2 | 195 | 256 | 975 | 914 | Entamoeba invadens cDNA clone: Xei-006M17, 60S ribosomal protein L3, putative, complete cds, strain: IP1 | blastn | 502 | 76.8 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 5885007 | 5885007 | PRJNA797475_P_NODE_27285_length_244_cov_1.766082_g27186_i0 | PRJNA797475 | 27285 | 244 | 1.766082 | 4.30924008 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 296 | 9.21e-76 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g27186 | i0 | 88.525 | 7.35245901639344 | 244 | 28 | 100 | 0 | 1 | 244 | 2552 | 2309 | D.iridis LSU rRNA gene | blastn | 1794 | 296 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 5885069 | 5885069 | PRJNA797475_P_NODE_3685_length_515_cov_1.719457_g3587_i0 | PRJNA797475 | 3685 | 515 | 1.719457 | 8.85520355 | Telaepolella tubasferens | 1346289 | Evosea | other_Eukaryota | 459 | 2.54e-124 | NTclustered | gi|167859713|gb|EU273436.1| | 1346289 | g3587 | i0 | 82.785 | 100.497087378641 | 517 | 85 | 100 | 4 | 1 | 515 | 230 | 744 | Telaepolella tubasferens clone 2 actin gene, partial cds | blastn | 51756 | 459 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Telaepolella | Telaepolella tubasferens | |||
| 5885124 | 5885124 | PRJNA797475_P_NODE_9085_length_345_cov_1.294118_g8986_i0 | PRJNA797475 | 9085 | 345 | 1.294118 | 4.4647071 | Polyschismium peyerimhoffii | 2911783 | Evosea | other_Eukaryota | 143 | 1.88e-29 | NTclustered | gi|2161226355|gb|MZ313553.1| | 2911783 | g8986 | i0 | 75.342 | 3.58550724637681 | 365 | 55 | 99 | 24 | 1 | 343 | 6259 | 6610 | Polyschismium peyerimhoffii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 1237 | 143 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Polyschismium | Polyschismium peyerimhoffii | ||
| 5885126 | 5885126 | PRJNA797475_P_NODE_9485_length_339_cov_1.135338_g9386_i0 | PRJNA797475 | 9485 | 339 | 1.135338 | 3.84879582 | Polyschismium peyerimhoffii | 2911783 | Evosea | other_Eukaryota | 303 | 8e-78 | NTclustered | gi|2161226355|gb|MZ313553.1| | 2911783 | g9386 | i0 | 83.333 | 55.2330383480826 | 360 | 28 | 99 | 23 | 2 | 339 | 7079 | 6730 | Polyschismium peyerimhoffii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 18724 | 303 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Polyschismium | Polyschismium peyerimhoffii | ||
| 10985451 | 10985451 | PRJNA797475_P_NODE_27109_length_245_cov_0.895349_g27010_i0 | PRJNA797475 | 27109 | 245 | 0.895349 | 2.19360505 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 117 | 7.73e-22 | NTclustered | gi|831760976|ref|XM_012894663.1| | 1410327 | g27010 | i0 | 82.353 | 0.555102040816327 | 136 | 22 | 55 | 2 | 39 | 173 | 1258 | 1392 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 136 | 117 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 14810103 | 14810103 | PRJNA797475_P_NODE_752_length_1060_cov_2.933131_g686_i0 | PRJNA797475 | 752 | 1060 | 2.933131 | 31.0911886 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 603 | 2.3699999999999996e-167 | NTclustered | gi|831784126|ref|XM_012901914.1| | 1410327 | g686 | i0 | 77.557 | 70.9094339622641 | 1056 | 200 | 97 | 28 | 22 | 1054 | 1290 | 249 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 75164 | 603 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 21184017 | 21184017 | PRJNA797475_P_NODE_9237_length_343_cov_0.996296_g9138_i0 | PRJNA797475 | 9237 | 343 | 0.996296 | 3.41729528 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 433 | 9.909999999999998e-117 | NTclustered | gi|66804710|ref|XM_630996.1| | 352472 | g9138 | i0 | 89.474 | 96.9533527696793 | 342 | 36 | 99 | 0 | 1 | 342 | 1002 | 661 | Dictyostelium discoideum AX4 hypothetical protein (act5) mRNA, complete cds | blastn | 33255 | 433 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 22458593 | 22458593 | PRJNA797475_P_NODE_26438_length_245_cov_1.575581_g26339_i0 | PRJNA797475 | 26438 | 245 | 1.575581 | 3.86017345 | Grellamoeba robusta | 690712 | Evosea | other_Eukaryota | 113 | 1e-20 | NTclustered | gi|268549249|gb|GQ438741.1| | 690712 | g26339 | i0 | 82.836 | 27.3673469387755 | 134 | 16 | 54 | 6 | 1 | 132 | 45 | 173 | Amoebozoa sp. 4168 clone 122 small subunit ribosomal RNA gene, partial sequence | blastn | 6705 | 113 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Fractovitellida | Soliformoviidae | Grellamoeba | Grellamoeba robusta | ||
| 25007833 | 25007833 | PRJNA797475_P_NODE_23700_length_249_cov_0.875000_g23601_i0 | PRJNA797475 | 23700 | 249 | 0.875 | 2.17875 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 128 | 3.64e-25 | NTclustered | gi|175957|gb|M19232.1|SLMRRMPP | 5791 | g23601 | i0 | 83.217 | 1.14859437751004 | 143 | 20 | 57 | 4 | 1 | 141 | 352 | 212 | Slime mold (P.polycephalum) 28S large subunit rRNA, 5' end | blastn | 286 | 128 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum |
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);;