contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA788929" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4597543 | 4597543 | PRJNA788929_P_NODE_25564_length_316_cov_12.259259_g24903_i0 | PRJNA788929 | 25564 | 316 | 12.259259 | 38.73925844 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 390 | 5.5199999999999996e-104 | NTclustered | gi|161209|gb|M21501.1|SLMACT5 | 5791 | g24903 | i0 | 93.536 | 76.4113924050633 | 263 | 16 | 83 | 1 | 54 | 316 | 24 | 285 | P.polycephalum actin (Ppa5) mRNA, complete cds | blastn | 24146 | 390 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 4597830 | 4597830 | PRJNA788929_P_NODE_44364_length_232_cov_7.031447_g43703_i0 | PRJNA788929 | 44364 | 232 | 7.031447 | 16.31295704 | Phalansterium filosum | 857046 | Evosea | other_Eukaryota | 108 | 4.37e-19 | NTclustered | gi|300078501|gb|GU001163.1| | 857046 | g43703 | i0 | 93.151 | 28.0301724137931 | 73 | 5 | 31 | 0 | 1 | 73 | 3100 | 3028 | Phalansterium sp. EEG-2010/THA 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 6503 | 108 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium filosum | ||||
| 7147653 | 7147653 | PRJNA788929_P_NODE_16986_length_403_cov_81.739394_g16327_i0 | PRJNA788929 | 16986 | 403 | 81.739394 | 329.40975782 | Polyschismium peyerimhoffii | 2911783 | Evosea | other_Eukaryota | 285 | 3.5e-72 | NTclustered | gi|2161226355|gb|MZ313553.1| | 2911783 | g16327 | i0 | 82.682 | 29.5037220843672 | 358 | 27 | 83 | 26 | 56 | 390 | 6687 | 7032 | 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 | 11890 | 285 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Polyschismium | Polyschismium peyerimhoffii | ||
| 7148259 | 7148259 | PRJNA788929_P_NODE_9306_length_594_cov_55.479846_g8655_i0 | PRJNA788929 | 9306 | 594 | 55.479846 | 329.55028524 | Didymium spongiosum | 289992 | Evosea | other_Eukaryota | 422 | 3.89e-113 | NTclustered | gi|2161226356|gb|MZ313554.1| | 289992 | g8655 | i0 | 90.184 | 23.1043771043771 | 326 | 28 | 73 | 3 | 247 | 570 | 7850 | 7527 | Mucilago crustacea 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 | 13724 | 422 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium spongiosum | ||
| 11418134 | 11418134 | PRJNA788929_P_NODE_20949_length_356_cov_18.293286_g20289_i0 | PRJNA788929 | 20949 | 356 | 18.293286 | 65.12409816 | Didymium | 5792 | Evosea | other_Eukaryota | 616 | 9.53e-172 | NTclustered | gi|25989341|gb|AY062881.1| | 181200 | g20289 | i0 | 100 | 86.2303370786517 | 333 | 0 | 94 | 0 | 24 | 356 | 841 | 1173 | Hyperamoeba dachnaya small subunit ribosomal RNA gene, partial sequence | blastn | 30698 | 616 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium dachnayum | ||
| 11418382 | 11418382 | PRJNA788929_P_NODE_8669_length_621_cov_61.346715_g8019_i0 | PRJNA788929 | 8669 | 621 | 61.346715 | 380.96310015 | Physariida | 5789 | Evosea | other_Eukaryota | 564 | 6.4e-156 | NTclustered | gi|3221|emb|V01159.1| | 5791 | g8019 | i0 | 84.193 | 27.4347826086957 | 601 | 74 | 95 | 19 | 11 | 598 | 3201 | 2609 | Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA | blastn | 17037 | 569 | 0.991212653778559 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 18620568 | 18620568 | PRJNA788929_P_NODE_12155_length_498_cov_33.044706_g11498_i0 | PRJNA788929 | 12155 | 498 | 33.044706 | 164.56263588 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 106 | 3.68e-18 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g11498 | i0 | 77.033 | 7.50401606425703 | 209 | 33 | 42 | 9 | 1 | 207 | 5054 | 5249 | D.iridis LSU rRNA gene | blastn | 3737 | 106 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 18620746 | 18620746 | PRJNA788929_P_NODE_22795_length_339_cov_7.078947_g22134_i0 | PRJNA788929 | 22795 | 339 | 7.078947 | 23.99763033 | Phalansterium filosum | 857046 | Evosea | other_Eukaryota | 135 | 3.0900000000000003e-27 | NTclustered | gi|300078501|gb|GU001163.1| | 857046 | g22134 | i0 | 89.72 | 29.8407079646018 | 107 | 10 | 51 | 1 | 228 | 334 | 3046 | 3151 | Phalansterium sp. EEG-2010/THA 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 10116 | 135 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium filosum |
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);;