contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA939370" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6017841 | 6017841 | PRJNA939370_S_NODE_165_length_641_cov_81.106419_g122_i0 | PRJNA939370 | 165 | 641 | 81.106419 | 519.89214579 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 920 | 0 | NTclustered | gi|262262912|gb|FJ766455.1| | 472931 | g122 | i0 | 98.106 | 54.5210608424337 | 528 | 10 | 82 | 0 | 112 | 639 | 2 | 529 | Protostelium mycophagum strain MFB-b small subunit ribosomal RNA gene, partial sequence | blastn | 34948 | 920 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 6017848 | 6017848 | PRJNA939370_S_NODE_205_length_584_cov_48.147664_g158_i0 | PRJNA939370 | 205 | 584 | 48.147664 | 281.18235776 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 950 | 0 | NTclustered | gi|262262910|gb|FJ766453.1| | 472931 | g158 | i0 | 97.163 | 57.5479452054795 | 564 | 13 | 96 | 3 | 22 | 584 | 1107 | 546 | Protostelium mycophagum strain OMBS04-1-1 small subunit ribosomal RNA gene, partial sequence | blastn | 33608 | 950 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 7292790 | 7292790 | PRJNA939370_S_NODE_1866_length_200_cov_0.927152_g1814_i0 | PRJNA939370 | 1866 | 200 | 0.927152 | 1.854304 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 315 | 2.0099999999999999e-81 | NTclustered | gi|3221|emb|V01159.1| | 5791 | g1814 | i0 | 95.05 | 75.635 | 202 | 6 | 99 | 1 | 3 | 200 | 1900 | 1699 | Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA | blastn | 15127 | 315 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 7292806 | 7292806 | PRJNA939370_S_NODE_386_length_469_cov_19.485714_g334_i0 | PRJNA939370 | 386 | 469 | 19.485714 | 91.38799866 | Cavostelium apophysatum | 435410 | Evosea | other_Eukaryota | 268 | 4.16e-67 | NTclustered | gi|260909290|gb|FJ766476.1| | 435410 | g334 | i0 | 84.043 | 38.4051172707889 | 282 | 41 | 59 | 4 | 45 | 323 | 962 | 682 | Cavostelium apophysatum culture-collection ATCC:38567 clone 9 18S ribosomal RNA gene, partial sequence | blastn | 18012 | 268 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Cavostelium | Cavostelium apophysatum | ||
| 8567618 | 8567618 | PRJNA939370_S_NODE_27_length_1130_cov_6.959297_g18_i0 | PRJNA939370 | 27 | 1130 | 6.959297 | 78.6400561 | Tubulinea group 04 sp. P18 | 1215998 | Tubulinea | other_Eukaryota | 1993 | 0 | NTclustered | gi|399764278|gb|JQ271789.1| | 1215998 | g18 | i0 | 98.496 | 33.4938053097345 | 1130 | 17 | 100 | 0 | 1 | 1130 | 1141 | 12 | Tubulinea group 04 sp. P18 18S ribosomal RNA gene, partial sequence | blastn | 37848 | 1993 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. P18 | ||||||
| 9842662 | 9842662 | PRJNA939370_S_NODE_1848_length_201_cov_0.973684_g1796_i0 | PRJNA939370 | 1848 | 201 | 0.973684 | 1.95710484 | Ripella tribonemae | 2047823 | Discosea | other_Eukaryota | 333 | 5.569999999999999e-87 | NTclustered | gi|1269228456|gb|MF683581.1| | 2047823 | g1796 | i0 | 96.552 | 99.273631840796 | 203 | 3 | 100 | 3 | 1 | 201 | 299 | 499 | Ripella tribonemae clone 70.1.16 18S ribosomal RNA gene, partial sequence | blastn | 19954 | 333 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella tribonemae | |||
| 9842691 | 9842691 | PRJNA939370_S_NODE_928_length_297_cov_26.524194_g876_i0 | PRJNA939370 | 928 | 297 | 26.524194 | 78.77685618 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 529 | 1.0499999999999996e-145 | NTclustered | gi|262262912|gb|FJ766455.1| | 472931 | g876 | i0 | 98.983 | 47.3670033670034 | 295 | 3 | 99 | 0 | 1 | 295 | 1237 | 1531 | Protostelium mycophagum strain MFB-b small subunit ribosomal RNA gene, partial sequence | blastn | 14068 | 529 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 11118328 | 11118328 | PRJNA939370_S_NODE_3369_length_156_cov_5.710280_g3317_i0 | PRJNA939370 | 3369 | 156 | 5.71028 | 8.9080368 | Tubulinea sp. 4790 | 1216002 | Tubulinea | other_Eukaryota | 255 | 9.12e-64 | NTclustered | gi|399764273|gb|JQ271784.1| | 1216002 | g3317 | i0 | 96.154 | 30.4935897435897 | 156 | 6 | 100 | 0 | 1 | 156 | 1441 | 1286 | Tubulinea sp. 4790 18S ribosomal RNA gene, partial sequence | blastn | 4757 | 255 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea sp. 4790 | ||||||
| 12393822 | 12393822 | PRJNA939370_S_NODE_130_length_694_cov_6.254264_g91_i0 | PRJNA939370 | 130 | 694 | 6.254264 | 43.40459216 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 346 | 2.84e-90 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g91 | i0 | 83.812 | 24.6671469740634 | 383 | 43 | 53 | 14 | 262 | 632 | 376 | 1 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 17119 | 346 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 13668279 | 13668279 | PRJNA939370_S_NODE_1511_length_222_cov_38.086705_g1459_i0 | PRJNA939370 | 1511 | 222 | 38.086705 | 84.5524851 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 394 | 2.839999999999999e-105 | NTclustered | gi|290886113|gb|GU477649.1| | 472931 | g1459 | i0 | 98.649 | 101.184684684685 | 222 | 3 | 100 | 0 | 1 | 222 | 401 | 180 | Protostelium mycophagum strain SI04-01A-1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence | blastn | 22463 | 394 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 18766418 | 18766418 | PRJNA939370_S_NODE_2175_length_186_cov_1.240876_g2123_i0 | PRJNA939370 | 2175 | 186 | 1.240876 | 2.30802936 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 84.2 | 5.64e-12 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g2123 | i0 | 97.917 | 0.698924731182796 | 48 | 1 | 26 | 0 | 2 | 49 | 5216 | 5263 | D.iridis LSU rRNA gene | blastn | 130 | 84.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 20041288 | 20041288 | PRJNA939370_S_NODE_176_length_631_cov_3.214777_g133_i0 | PRJNA939370 | 176 | 631 | 3.214777 | 20.28524287 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 213 | 2.72e-50 | NTclustered | gi|290886113|gb|GU477649.1| | 472931 | g133 | i0 | 92.053 | 0.450079239302694 | 151 | 12 | 24 | 0 | 477 | 627 | 788 | 638 | Protostelium mycophagum strain SI04-01A-1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence | blastn | 284 | 213 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 20041313 | 20041313 | PRJNA939370_S_NODE_636_length_363_cov_30.531847_g584_i0 | PRJNA939370 | 636 | 363 | 30.531847 | 110.83060461 | Cavostelium apophysatum | 435410 | Evosea | other_Eukaryota | 211 | 5.37e-50 | NTclustered | gi|260909290|gb|FJ766476.1| | 435410 | g584 | i0 | 77.989 | 17.9807162534435 | 368 | 60 | 99 | 16 | 1 | 362 | 6 | 358 | Cavostelium apophysatum culture-collection ATCC:38567 clone 9 18S ribosomal RNA gene, partial sequence | blastn | 6527 | 211 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Cavostelium | Cavostelium apophysatum | ||
| 21316734 | 21316734 | PRJNA939370_S_NODE_1557_length_219_cov_3.782353_g1505_i0 | PRJNA939370 | 1557 | 219 | 3.782353 | 8.28335307 | Tubulinea group 04 sp. P18 | 1215998 | Tubulinea | other_Eukaryota | 366 | 6.09e-97 | NTclustered | gi|399764278|gb|JQ271789.1| | 1215998 | g1505 | i0 | 96.847 | 57.1050228310502 | 222 | 1 | 100 | 6 | 1 | 219 | 1657 | 1439 | Tubulinea group 04 sp. P18 18S ribosomal RNA gene, partial sequence | blastn | 12506 | 366 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. P18 | ||||||
| 21316748 | 21316748 | PRJNA939370_S_NODE_2677_length_169_cov_1.275000_g2625_i0 | PRJNA939370 | 2677 | 169 | 1.275 | 2.15475 | Metatrichia vesparium | 208474 | Evosea | other_Eukaryota | 82.4 | 1.8e-11 | NTclustered | gi|501417089|gb|JX481303.1| | 208474 | g2625 | i0 | 87.324 | 0.420118343195266 | 71 | 9 | 42 | 0 | 1 | 71 | 1785 | 1715 | Metatrichia vesparium voucher DWM7019 18S ribosomal RNA gene, partial sequence | blastn | 71 | 82.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Metatrichia | Metatrichia vesparium | ||
| 22591705 | 22591705 | PRJNA939370_S_NODE_1478_length_225_cov_17.107955_g1426_i0 | PRJNA939370 | 1478 | 225 | 17.107955 | 38.49289875 | Cavostelium apophysatum | 435410 | Evosea | other_Eukaryota | 257 | 3.95e-64 | NTclustered | gi|146448820|gb|EF513172.1| | 435410 | g1426 | i0 | 87.5 | 99.9555555555555 | 224 | 26 | 99 | 1 | 4 | 225 | 1388 | 1611 | Cavostelium apophysatum small subunit ribosomal RNA gene, partial sequence | blastn | 22490 | 257 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Cavostelium | Cavostelium apophysatum | ||
| 22591708 | 22591708 | PRJNA939370_S_NODE_1718_length_208_cov_25.742138_g1666_i0 | PRJNA939370 | 1718 | 208 | 25.742138 | 53.54364704 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 298 | 2.12e-76 | NTclustered | gi|262262909|gb|FJ766452.1| | 472931 | g1666 | i0 | 98.235 | 70.7259615384615 | 170 | 3 | 100 | 0 | 39 | 208 | 1801 | 1632 | Protostelium mycophagum strain KA-T15-3 small subunit ribosomal RNA gene, partial sequence | blastn | 14711 | 298 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 23867078 | 23867078 | PRJNA939370_S_NODE_3419_length_152_cov_6.126214_g3367_i0 | PRJNA939370 | 3419 | 152 | 6.126214 | 9.31184528 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 259 | 6.82e-65 | NTclustered | gi|262262910|gb|FJ766453.1| | 472931 | g3367 | i0 | 97.368 | 101.171052631579 | 152 | 4 | 100 | 0 | 1 | 152 | 1107 | 1258 | Protostelium mycophagum strain OMBS04-1-1 small subunit ribosomal RNA gene, partial sequence | blastn | 15378 | 259 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum |
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);;