contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA278119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 371520 | 371520 | PRJNA278119_P_NODE_5281_length_519_cov_1.687234_g5037_i0 | PRJNA278119 | 5281 | 519 | 1.687234 | 8.75674446 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 272 | 3.59e-68 | NTclustered | gi|330818907|ref|XM_003291484.1| | 5786 | g5037 | i0 | 80.267 | 40.1059730250482 | 375 | 62 | 71 | 11 | 118 | 485 | 377 | 8 | Dictyostelium purpureum ribosomal protein L10E (DICPUDRAFT_92700), mRNA | blastn | 20815 | 272 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 4198616 | 4198616 | PRJNA278119_P_NODE_46124_length_162_cov_1.840708_g45875_i0 | PRJNA278119 | 46124 | 162 | 1.840708 | 2.98194696 | Dictydiaethalium plumbeum | 1334544 | Evosea | other_Eukaryota | 84.2 | 4.78e-12 | NTclustered | gi|501417078|gb|JX481292.1| | 1334544 | g45875 | i0 | 88 | 25.9753086419753 | 75 | 4 | 45 | 5 | 81 | 153 | 2153 | 2224 | Dictydiaethalium plumbeum voucher MM 30150 18S ribosomal RNA gene, partial sequence | blastn | 4208 | 84.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Liceales | Dictydiaethaliaceae | Dictydiaethalium | Dictydiaethalium plumbeum | ||
| 6749086 | 6749086 | PRJNA278119_P_NODE_37006_length_168_cov_0.873950_g36757_i0 | PRJNA278119 | 37006 | 168 | 0.87395 | 1.468236 | Entamoeba invadens | 33085 | Evosea | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|28274794|gb|AY190083.1| | 33085 | g36757 | i0 | 100 | 0.178571428571429 | 30 | 0 | 18 | 0 | 40 | 69 | 12487 | 12516 | Entamoeba invadens rDNA-containing episome sequence | blastn | 30 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 9986962 | 9986962 | PRJNA278119_P_NODE_37568_length_167_cov_1.762712_g37319_i0 | PRJNA278119 | 37568 | 167 | 1.762712 | 2.94372904 | root | 1 | Root_unresolved | Root_unresolved | 309 | 7.53e-80 | NTclustered | gi|167377751|ref|XM_001734473.1| | 370354 | g37319 | i0 | 100 | 21.5449101796407 | 167 | 0 | 100 | 0 | 1 | 167 | 328 | 162 | Entamoeba dispar SAW760 uncharacterized protein (EDI_314460), partial mRNA | blastn | 3598 | 309 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 10575022 | 10575022 | PRJNA278119_P_NODE_12749_length_316_cov_3.434457_g12501_i0 | PRJNA278119 | 12749 | 316 | 3.434457 | 10.85288412 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 231 | 3.5399999999999997e-56 | NTclustered | gi|831783421|ref|XM_012901593.1| | 1410327 | g12501 | i0 | 89.189 | 59.9778481012658 | 185 | 20 | 59 | 0 | 132 | 316 | 265 | 449 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 18953 | 231 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 10575470 | 10575470 | PRJNA278119_P_NODE_47649_length_162_cov_0.893805_g47400_i0 | PRJNA278119 | 47649 | 162 | 0.893805 | 1.4479641 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 87.9 | 3.7e-13 | NTclustered | gi|831757464|ref|XM_012893584.1| | 1410327 | g47400 | i0 | 78.358 | 2.44444444444444 | 134 | 29 | 83 | 0 | 1 | 134 | 485 | 352 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 396 | 87.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 13124945 | 13124945 | PRJNA278119_P_NODE_19011_length_232_cov_0.868852_g18762_i0 | PRJNA278119 | 19011 | 232 | 0.868852 | 2.01573664 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 302 | 1.87e-77 | NTclustered | gi|66804710|ref|XM_630996.1| | 352472 | g18762 | i0 | 90.393 | 95.926724137931 | 229 | 22 | 99 | 0 | 1 | 229 | 683 | 911 | Dictyostelium discoideum AX4 hypothetical protein (act5) mRNA, complete cds | blastn | 22255 | 302 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 24597142 | 24597142 | PRJNA278119_P_NODE_12300_length_325_cov_1.380435_g12052_i0 | PRJNA278119 | 12300 | 325 | 1.380435 | 4.48641375 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 429 | 1.2099999999999999e-115 | NTclustered | gi|66804710|ref|XM_630996.1| | 352472 | g12052 | i0 | 90.462 | 98.0430769230769 | 325 | 31 | 100 | 0 | 1 | 325 | 990 | 666 | Dictyostelium discoideum AX4 hypothetical protein (act5) mRNA, complete cds | blastn | 31864 | 429 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 24597317 | 24597317 | PRJNA278119_P_NODE_24400_length_200_cov_1.185430_g24151_i0 | PRJNA278119 | 24400 | 200 | 1.18543 | 2.37086 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 145 | 2.79e-30 | NTclustered | gi|330822624|ref|XM_003291701.1| | 5786 | g24151 | i0 | 85.926 | 13.375 | 135 | 19 | 68 | 0 | 4 | 138 | 518 | 652 | Dictyostelium purpureum vacuolar H+ ATPase B subunit (DICPUDRAFT_50012), mRNA | blastn | 2675 | 145 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 25284842 | 25284842 | PRJNA278119_P_NODE_19680_length_226_cov_1.175141_g19431_i0 | PRJNA278119 | 19680 | 226 | 1.175141 | 2.65581866 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 161 | 3.2e-35 | NTclustered | gi|7274|emb|X55973.1| | 44689 | g19431 | i0 | 79.556 | 76.5752212389381 | 225 | 46 | 99 | 0 | 2 | 226 | 1361 | 1137 | D. discoideum EF1-I gene for elongation factor 1 alpha | blastn | 17306 | 161 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum |
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);;