contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA763243" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 743724 | 743724 | PRJNA763243_P_NODE_58401_length_245_cov_1.319767_g58055_i0 | PRJNA763243 | 58401 | 245 | 1.319767 | 3.23342915 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|470243459|ref|XM_004355407.1| | 261658 | g58055 | i0 | 100 | 0.248979591836735 | 29 | 0 | 12 | 0 | 2 | 30 | 694 | 722 | Cavenderia fasciculata uncharacterized protein (DFA_07959), partial mRNA | blastn | 61 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 2019365 | 2019365 | PRJNA763243_P_NODE_41002_length_274_cov_3.333333_g40656_i0 | PRJNA763243 | 41002 | 274 | 3.333333 | 9.13333242 | Tychosporium acutostipes | 668358 | Evosea | other_Eukaryota | 172 | 1.85e-38 | NTclustered | gi|2467140639|dbj|LC720133.1| | 668358 | g40656 | i0 | 90.152 | 17.2919708029197 | 132 | 13 | 48 | 0 | 5 | 136 | 926 | 795 | Tychosporium acutostipes YIP-60 gene for 18S rRNA, partial sequence | blastn | 4738 | 172 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Tychosporium | Tychosporium acutostipes | |||
| 4572080 | 4572080 | PRJNA763243_P_NODE_59344_length_244_cov_2.269006_g58998_i0 | PRJNA763243 | 59344 | 244 | 2.269006 | 5.53637464 | Polyschismium peyerimhoffii | 2911783 | Evosea | other_Eukaryota | 281 | 2.58e-71 | NTclustered | gi|2161226355|gb|MZ313553.1| | 2911783 | g58998 | i0 | 89.27 | 58.0696721311475 | 233 | 13 | 93 | 10 | 6 | 231 | 6563 | 6790 | 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 | 14169 | 281 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Polyschismium | Polyschismium peyerimhoffii | ||
| 5846774 | 5846774 | PRJNA763243_P_NODE_37245_length_284_cov_1.611374_g36899_i0 | PRJNA763243 | 37245 | 284 | 1.611374 | 4.57630216 | uncultured Physarum sp. | 1173722 | Evosea | other_Eukaryota | 462 | 1.02e-125 | NTclustered | gi|787987708|gb|KP075088.1| | 1173722 | g36899 | i0 | 100 | 80.7394366197183 | 250 | 0 | 88 | 0 | 30 | 279 | 1 | 250 | Uncultured Physarum sp. clone HQ4TV3T01B5N2R_AEG48 18S ribosomal RNA gene, partial sequence | blastn | 22930 | 462 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | uncultured Physarum sp. | |||
| 16046182 | 16046182 | PRJNA763243_P_NODE_51093_length_252_cov_1.782123_g50747_i0 | PRJNA763243 | 51093 | 252 | 1.782123 | 4.49094996 | Tychosporium acutostipes | 668358 | Evosea | other_Eukaryota | 355 | 1.56e-93 | NTclustered | gi|256550195|gb|FJ792703.1| | 668358 | g50747 | i0 | 92.369 | 59.3888888888889 | 249 | 19 | 99 | 0 | 4 | 252 | 18 | 266 | Tychosporium acutostipes strain KE11AL small subunit ribosomal RNA gene, partial sequence | blastn | 14966 | 355 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Tychosporium | Tychosporium acutostipes | |||
| 17322424 | 17322424 | PRJNA763243_P_NODE_75234_length_197_cov_5.975806_g74888_i0 | PRJNA763243 | 75234 | 197 | 5.975806 | 11.77233782 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 75 | 3.64e-9 | NTclustered | gi|183236658|ref|XM_001914464.1| | 294381 | g74888 | i0 | 82.292 | 0.974619289340102 | 96 | 8 | 49 | 6 | 26 | 121 | 942 | 856 | Entamoeba histolytica HM-1:IMSS uncharacterized protein (EHI_033450), partial mRNA | blastn | 192 | 75 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 17782930 | 17782930 | PRJNA763243_P_NODE_61714_length_242_cov_3.106509_g61368_i0 | PRJNA763243 | 61714 | 242 | 3.106509 | 7.51775178 | Didymium | 5792 | Evosea | other_Eukaryota | 121 | 5.889999999999999e-23 | NTclustered | gi|25989341|gb|AY062881.1| | 181200 | g61368 | i0 | 78.218 | 2.44628099173554 | 202 | 35 | 82 | 8 | 8 | 205 | 874 | 678 | Hyperamoeba dachnaya small subunit ribosomal RNA gene, partial sequence | blastn | 592 | 121 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium dachnayum | ||
| 18594378 | 18594378 | PRJNA763243_P_NODE_16435_length_383_cov_2.338710_g16090_i0 | PRJNA763243 | 16435 | 383 | 2.33871 | 8.9572593 | Tychosporium acutostipes | 668358 | Evosea | other_Eukaryota | 617 | 2.8699999999999997e-172 | NTclustered | gi|256550195|gb|FJ792703.1| | 668358 | g16090 | i0 | 96.042 | 33.490861618799 | 379 | 15 | 99 | 0 | 5 | 383 | 569 | 947 | Tychosporium acutostipes strain KE11AL small subunit ribosomal RNA gene, partial sequence | blastn | 12827 | 617 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Tychosporium | Tychosporium acutostipes | |||
| 18594943 | 18594943 | PRJNA763243_P_NODE_40735_length_275_cov_1.504950_g40389_i0 | PRJNA763243 | 40735 | 275 | 1.50495 | 4.1386125 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 191 | 5.13e-44 | NTclustered | gi|470267192|ref|XM_004361922.1| | 261658 | g40389 | i0 | 80.315 | 52.6654545454545 | 254 | 48 | 92 | 2 | 5 | 257 | 665 | 917 | Cavenderia fasciculata succinate-CoA ligase (scsC), partial mRNA | blastn | 14483 | 191 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 21145242 | 21145242 | PRJNA763243_P_NODE_14457_length_404_cov_4.317221_g14112_i0 | PRJNA763243 | 14457 | 404 | 4.317221 | 17.44157284 | Entamoeba invadens | 33085 | Evosea | other_Eukaryota | 62.1 | 6.44e-5 | NTclustered | gi|511091352|dbj|AK423018.1| | 33085 | g14112 | i0 | 78.723 | 8.39356435643564 | 94 | 18 | 23 | 2 | 204 | 296 | 857 | 765 | Entamoeba invadens cDNA clone: Xei-008C04, hypothetical protein, complete cds, strain: IP1 | blastn | 3391 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens |
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);;