contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA515078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 486933 | 486933 | PRJNA515078_P_NODE_8201_length_320_cov_1.802120_g7968_i0 | PRJNA515078 | 8201 | 320 | 1.80212 | 5.766784 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 217 | 1.01e-51 | NTclustered | gi|167377343|ref|XM_001734312.1| | 370354 | g7968 | i0 | 84.234 | 20.66875 | 222 | 35 | 69 | 0 | 4 | 225 | 247 | 26 | Entamoeba dispar SAW760 ADP-ribosylation factor, arf, putative (EDI_275790), partial mRNA | blastn | 6614 | 217 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 1762047 | 1762047 | PRJNA515078_P_NODE_2282_length_644_cov_5.276771_g2076_i0 | PRJNA515078 | 2282 | 644 | 5.276771 | 33.98240524 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 375 | 3.339999999999999e-99 | NTclustered | gi|1160573488|ref|XM_020576922.1| | 670386 | g2076 | i0 | 82.127 | 2.08074534161491 | 442 | 75 | 68 | 4 | 13 | 452 | 1 | 440 | Polysphondylium pallidum PN500 Ras GTPase (rasG), partial mRNA | blastn | 1340 | 375 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 1762132 | 1762132 | PRJNA515078_P_NODE_3422_length_523_cov_2.705761_g3192_i0 | PRJNA515078 | 3422 | 523 | 2.705761 | 14.15113003 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 327 | 7.610000000000001e-85 | NTclustered | gi|330845407|ref|XM_003294531.1| | 5786 | g3192 | i0 | 79.526 | 16.1625239005736 | 464 | 91 | 88 | 4 | 38 | 499 | 526 | 65 | Dictyostelium purpureum uncharacterized protein (rapA), mRNA | blastn | 8453 | 327 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 3037799 | 3037799 | PRJNA515078_P_NODE_10243_length_282_cov_1.424490_g10010_i0 | PRJNA515078 | 10243 | 282 | 1.42449 | 4.0170618 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|831754795|ref|XM_012892771.1| | 1410327 | g10010 | i0 | 100 | 0.106382978723404 | 30 | 0 | 11 | 0 | 38 | 67 | 222 | 193 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 6864714 | 6864714 | PRJNA515078_P_NODE_6186_length_378_cov_1.988270_g5953_i0 | PRJNA515078 | 6186 | 378 | 1.98827 | 7.5156606 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 287 | 9.07e-73 | NTclustered | gi|330805726|ref|XM_003290782.1| | 5786 | g5953 | i0 | 81.337 | 19.1111111111111 | 359 | 61 | 94 | 6 | 11 | 366 | 1531 | 1886 | Dictyostelium purpureum cell division cycle protein 48 (DICPUDRAFT_81538), partial mRNA | blastn | 7224 | 287 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 8139940 | 8139940 | PRJNA515078_P_NODE_27867_length_165_cov_1.218750_g27634_i0 | PRJNA515078 | 27867 | 165 | 1.21875 | 2.0109375 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|66821092|ref|XM_638977.1| | 352472 | g27634 | i0 | 100 | 0.16969696969697 | 28 | 0 | 17 | 0 | 31 | 58 | 3554 | 3581 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0274537) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 11965557 | 11965557 | PRJNA515078_P_NODE_20850_length_190_cov_1.274510_g20617_i0 | PRJNA515078 | 20850 | 190 | 1.27451 | 2.421569 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|330794860|ref|XM_003285447.1| | 5786 | g20617 | i0 | 100 | 0.3 | 29 | 0 | 15 | 0 | 54 | 82 | 3621 | 3593 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_76420), partial mRNA | blastn | 57 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 13240786 | 13240786 | PRJNA515078_P_NODE_30451_length_158_cov_2.900826_g30218_i0 | PRJNA515078 | 30451 | 158 | 2.900826 | 4.58330508 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 117 | 4.570000000000001e-22 | NTclustered | gi|831768525|ref|XM_012896976.1| | 1410327 | g30218 | i0 | 82.222 | 0.854430379746835 | 135 | 24 | 85 | 0 | 1 | 135 | 248 | 382 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 135 | 117 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 18338581 | 18338581 | PRJNA515078_P_NODE_33055_length_153_cov_1.284483_g32822_i0 | PRJNA515078 | 33055 | 153 | 1.284483 | 1.96525899 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 54.7 | 0.003 | NTclustered | gi|1160571680|ref|XM_020575334.1| | 670386 | g32822 | i0 | 100 | 0.555555555555556 | 29 | 0 | 19 | 0 | 117 | 145 | 75 | 47 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 85 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 19612807 | 19612807 | PRJNA515078_P_NODE_13056_length_245_cov_1.697115_g12823_i0 | PRJNA515078 | 13056 | 245 | 1.697115 | 4.15793175 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 60.2 | 1.32e-4 | NTclustered | gi|330797680|ref|XM_003286839.1| | 5786 | g12823 | i0 | 100 | 1.02448979591837 | 32 | 0 | 13 | 0 | 173 | 204 | 856 | 887 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_77768), partial mRNA | blastn | 251 | 60.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 20888870 | 20888870 | PRJNA515078_P_NODE_15977_length_218_cov_3.348066_g15744_i0 | PRJNA515078 | 15977 | 218 | 3.348066 | 7.29878388 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 178 | 3.0499999999999993e-40 | NTclustered | gi|330840718|ref|XM_003292310.1| | 5786 | g15744 | i0 | 81.905 | 15.9495412844037 | 210 | 38 | 96 | 0 | 1 | 210 | 629 | 420 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_50380), mRNA | blastn | 3477 | 178 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 23439280 | 23439280 | PRJNA515078_P_NODE_24019_length_177_cov_1.392857_g23786_i0 | PRJNA515078 | 24019 | 177 | 1.392857 | 2.46535689 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 119 | 1.45e-22 | NTclustered | gi|831770792|ref|XM_012897653.1| | 1410327 | g23786 | i0 | 88 | 0.564971751412429 | 100 | 12 | 56 | 0 | 78 | 177 | 1501 | 1402 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 100 | 119 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum |
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);;