contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1195374" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 322030 | 322030 | PRJNA1195374_P_NODE_63981_length_269_cov_1.454082_g63637_i0 | PRJNA1195374 | 63981 | 269 | 1.454082 | 3.91148058 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 130 | 1.11e-25 | NTclustered | gi|183230617|ref|XM_646205.2| | 294381 | g63637 | i0 | 81.212 | 4.29739776951673 | 165 | 27 | 61 | 4 | 69 | 231 | 245 | 407 | Entamoeba histolytica HM-1:IMSS 60S ribosomal protein L23, putative (EHI_196920), partial mRNA | blastn | 1156 | 130 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 1595619 | 1595619 | PRJNA1195374_P_NODE_10702_length_679_cov_2.655116_g10381_i0 | PRJNA1195374 | 10702 | 679 | 2.655116 | 18.02823764 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 387 | 1.63e-102 | NTclustered | gi|330842539|ref|XM_003293186.1| | 5786 | g10381 | i0 | 84.935 | 46.6450662739323 | 385 | 55 | 56 | 3 | 295 | 677 | 495 | 112 | Dictyostelium purpureum calmodulin (DICPUDRAFT_93011), mRNA | blastn | 31672 | 387 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 2872843 | 2872843 | PRJNA1195374_P_NODE_63643_length_270_cov_1.274112_g63299_i0 | PRJNA1195374 | 63643 | 270 | 1.274112 | 3.4401024 | Synstelium polycarpum | 361085 | Evosea | other_Eukaryota | 108 | 5.21e-19 | NTclustered | gi|1057487789|gb|KX539455.1| | 361085 | g63299 | i0 | 87.912 | 0.337037037037037 | 91 | 11 | 34 | 0 | 2 | 92 | 1811 | 1901 | Dictyostelium polycarpum strain OhioWILDS phosphoenolpyruvate carboxykinase (gtp) gene, complete cds | blastn | 91 | 108 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Synstelium | Synstelium polycarpum | ||||
| 4148445 | 4148445 | PRJNA1195374_P_NODE_37284_length_367_cov_3.132653_g36940_i0 | PRJNA1195374 | 37284 | 367 | 3.132653 | 11.49683651 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 97.1 | 1.59e-15 | NTclustered | gi|66820157|ref|XM_638626.1| | 352472 | g36940 | i0 | 77.987 | 1.06539509536785 | 159 | 31 | 43 | 4 | 133 | 289 | 211 | 55 | Dictyostelium discoideum AX4 FKBP-type peptidylprolyl cis-trans isomerase (DDB_G0275227) mRNA, complete cds | blastn | 391 | 97.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 5425188 | 5425188 | PRJNA1195374_P_NODE_63185_length_271_cov_1.545455_g62841_i0 | PRJNA1195374 | 63185 | 271 | 1.545455 | 4.18818305 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 191 | 5.05e-44 | NTclustered | gi|470246255|ref|XM_004366224.1| | 261658 | g62841 | i0 | 82.051 | 51.3616236162362 | 234 | 32 | 85 | 7 | 1 | 229 | 1583 | 1811 | Cavenderia fasciculata heat shock protein Hsp90 family protein (hspD), partial mRNA | blastn | 13919 | 191 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 9249407 | 9249407 | PRJNA1195374_P_NODE_36888_length_370_cov_1.037037_g36544_i0 | PRJNA1195374 | 36888 | 370 | 1.037037 | 3.8370369 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 243 | 1.94e-59 | NTclustered | gi|831770792|ref|XM_012897653.1| | 1410327 | g36544 | i0 | 79.063 | 7.44054054054054 | 363 | 69 | 97 | 6 | 8 | 366 | 1601 | 1242 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 2753 | 243 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 10525506 | 10525506 | PRJNA1195374_P_NODE_51629_length_305_cov_1.314655_g51285_i0 | PRJNA1195374 | 51629 | 305 | 1.314655 | 4.00969775 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 198 | 3.45e-46 | NTclustered | gi|470252539|ref|XM_004359310.1| | 261658 | g51285 | i0 | 78.548 | 30.3868852459016 | 303 | 63 | 99 | 2 | 3 | 304 | 482 | 181 | Cavenderia fasciculata ADP-ribosylation factor (arfA), partial mRNA | blastn | 9268 | 198 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 13075324 | 13075324 | PRJNA1195374_P_NODE_48131_length_318_cov_1.253061_g47787_i0 | PRJNA1195374 | 48131 | 318 | 1.253061 | 3.98473398 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 73.1 | 2.29e-8 | NTclustered | gi|66809808|ref|XM_633536.1| | 352472 | g47787 | i0 | 97.619 | 13.8616352201258 | 42 | 1 | 13 | 0 | 8 | 49 | 664 | 705 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0284459) mRNA, complete cds | blastn | 4408 | 73.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 17620642 | 17620642 | PRJNA1195374_P_NODE_61014_length_277_cov_1.328431_g60670_i0 | PRJNA1195374 | 61014 | 277 | 1.328431 | 3.67975387 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|66824240|ref|XM_640383.1| | 352472 | g60670 | i0 | 100 | 0.472924187725632 | 30 | 0 | 11 | 0 | 154 | 183 | 1110 | 1081 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0271690) mRNA, complete cds | blastn | 131 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 18174035 | 18174035 | PRJNA1195374_P_NODE_81735_length_243_cov_1.352941_g81391_i0 | PRJNA1195374 | 81735 | 243 | 1.352941 | 3.28764663 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 110 | 1.28e-19 | NTclustered | gi|831757464|ref|XM_012893584.1| | 1410327 | g81391 | i0 | 80.42 | 1.4156378600823 | 143 | 28 | 59 | 0 | 7 | 149 | 370 | 512 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 344 | 110 | 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);;