contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA715461" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 705126 | 705126 | PRJNA715461_S_NODE_821_length_278_cov_374.209756_g747_i0 | PRJNA715461 | 821 | 278 | 374.209756 | 1040.30312168 | Ripella sp. GP2 | 1217115 | Discosea | other_Eukaryota | 291 | 4.98e-74 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g747 | i0 | 98.193 | 42.5287769784173 | 166 | 3 | 60 | 0 | 107 | 272 | 168 | 3 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 11823 | 291 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 1981133 | 1981133 | PRJNA715461_S_NODE_1022_length_246_cov_27620.306358_g948_i0 | PRJNA715461 | 1022 | 246 | 27620.306358 | 67945.95364068 | Ripella sp. GP2 | 1217115 | Discosea | other_Eukaryota | 279 | 9.36e-71 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g948 | i0 | 97.546 | 46.6463414634146 | 163 | 4 | 66 | 0 | 7 | 169 | 3 | 165 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 11475 | 279 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 1981141 | 1981141 | PRJNA715461_S_NODE_402_length_431_cov_6615.044693_g328_i0 | PRJNA715461 | 402 | 431 | 6615.044693 | 28510.84262683 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 566 | 1.2e-156 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g328 | i0 | 97.866 | 76.6821345707657 | 328 | 6 | 76 | 1 | 21 | 347 | 225 | 552 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 33050 | 566 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 5808778 | 5808778 | PRJNA715461_S_NODE_365_length_452_cov_23.931398_g99_i2 | PRJNA715461 | 365 | 452 | 23.931398 | 108.16991896 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 137 | 1.18e-27 | NTclustered | gi|1583105587|ref|NC_040955.1| | 1443144 | g99 | i2 | 76.071 | 32.8694690265487 | 280 | 57 | 60 | 9 | 178 | 450 | 50189 | 49913 | Paravannella minima mitochondrion, complete genome | blastn | 14857 | 137 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima | |||
| 5808790 | 5808790 | PRJNA715461_S_NODE_985_length_249_cov_27219.721591_g911_i0 | PRJNA715461 | 985 | 249 | 27219.721591 | 67777.10676159 | Ripella sp. GP2 | 1217115 | Discosea | other_Eukaryota | 285 | 2.0399999999999997e-72 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g911 | i0 | 98.16 | 46.289156626506 | 163 | 3 | 65 | 0 | 81 | 243 | 165 | 3 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 11526 | 285 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 7083794 | 7083794 | PRJNA715461_S_NODE_1866_length_200_cov_36.000000_g1792_i0 | PRJNA715461 | 1866 | 200 | 36 | 72 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 311 | 2.6e-80 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g1792 | i0 | 95 | 103.21 | 200 | 7 | 99 | 3 | 3 | 200 | 619 | 817 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 20642 | 311 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 7570067 | 7570067 | PRJNA715461_S_NODE_566_length_360_cov_44.700348_g492_i0 | PRJNA715461 | 566 | 360 | 44.700348 | 160.9212528 | Ripella | 1217112 | Discosea | other_Eukaryota | 505 | 2.18e-138 | NTclustered | gi|1269228349|gb|MF683474.1| | 2047821 | g492 | i0 | 97.635 | 82.1111111111111 | 296 | 3 | 82 | 4 | 67 | 360 | 993 | 700 | Ripella platypodia clone 23.4.22 18S ribosomal RNA gene, partial sequence | blastn | 29560 | 507 | 0.996055226824458 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella platypodia | |||
| 8358459 | 8358459 | PRJNA715461_S_NODE_307_length_496_cov_160.179669_g99_i1 | PRJNA715461 | 307 | 496 | 160.179669 | 794.49115824 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 137 | 1.3e-27 | NTclustered | gi|1583105587|ref|NC_040955.1| | 1443144 | g99 | i1 | 76.071 | 29.9395161290323 | 280 | 57 | 55 | 9 | 222 | 494 | 50189 | 49913 | Paravannella minima mitochondrion, complete genome | blastn | 14850 | 137 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima | |||
| 8845188 | 8845188 | PRJNA715461_S_NODE_767_length_290_cov_21955.912442_g693_i0 | PRJNA715461 | 767 | 290 | 21955.912442 | 63672.1460818 | Vannellidae | 95227 | Discosea | other_Eukaryota | 348 | 3.06e-91 | NTclustered | gi|62865947|gb|AY929922.1| | 325065 | g693 | i0 | 98.485 | 65.9896551724138 | 198 | 2 | 68 | 1 | 81 | 277 | 427 | 230 | Platyamoeba sp. strain CAZ7/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 19137 | 351 | 0.991452991452991 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba sp. strain CAZ7/I | |||
| 9633677 | 9633677 | PRJNA715461_S_NODE_688_length_309_cov_10317.872881_g614_i0 | PRJNA715461 | 688 | 309 | 10317.872881 | 31882.22720229 | Ripella sp. GP2 | 1217115 | Discosea | other_Eukaryota | 385 | 2.499999999999999e-102 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g614 | i0 | 98.19 | 65.9611650485437 | 221 | 3 | 72 | 1 | 83 | 303 | 222 | 3 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 20382 | 385 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 10120778 | 10120778 | PRJNA715461_S_NODE_568_length_359_cov_17274.629371_g494_i0 | PRJNA715461 | 568 | 359 | 17274.629371 | 62015.91944189 | Vannellidae | 95227 | Discosea | other_Eukaryota | 488 | 2.19e-133 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g494 | i0 | 99.625 | 75.0779944289694 | 267 | 1 | 74 | 0 | 81 | 347 | 1675 | 1409 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 26953 | 488 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 13458840 | 13458840 | PRJNA715461_S_NODE_931_length_259_cov_37.118280_g857_i0 | PRJNA715461 | 931 | 259 | 37.11828 | 96.1363452 | Ripella sp. GP2 | 1217115 | Discosea | other_Eukaryota | 407 | 4.37e-109 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g857 | i0 | 95.019 | 100.880308880309 | 261 | 9 | 100 | 4 | 1 | 259 | 846 | 588 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 26128 | 407 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 17283197 | 17283197 | PRJNA715461_S_NODE_1114_length_237_cov_33388.536585_g1040_i0 | PRJNA715461 | 1114 | 237 | 33388.536585 | 79130.83170645 | Ripella platypodia | 2047821 | Discosea | other_Eukaryota | 193 | 1.1999999999999998e-44 | NTclustered | gi|1269228348|gb|MF683473.1| | 2047821 | g1040 | i0 | 93.846 | 50.9704641350211 | 130 | 4 | 54 | 3 | 4 | 131 | 1142 | 1269 | Ripella platypodia clone 21702 18S ribosomal RNA gene, partial sequence | blastn | 12080 | 193 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella platypodia | |||
| 17283210 | 17283210 | PRJNA715461_S_NODE_534_length_370_cov_16046.528620_g460_i0 | PRJNA715461 | 534 | 370 | 16046.52862 | 59372.155894 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 457 | 6.38e-124 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g460 | i0 | 97.398 | 67.7567567567568 | 269 | 6 | 72 | 1 | 21 | 288 | 225 | 493 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 25070 | 457 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 17283214 | 17283214 | PRJNA715461_S_NODE_874_length_268_cov_371.353846_g800_i0 | PRJNA715461 | 874 | 268 | 371.353846 | 995.22830728 | Ripella sp. GP2 | 1217115 | Discosea | other_Eukaryota | 274 | 4.81e-69 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g800 | i0 | 96.933 | 41.910447761194 | 163 | 5 | 61 | 0 | 7 | 169 | 3 | 165 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 11232 | 274 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 18556976 | 18556976 | PRJNA715461_S_NODE_875_length_268_cov_328.830769_g801_i0 | PRJNA715461 | 875 | 268 | 328.830769 | 881.26646092 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 204 | 6.4e-48 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g801 | i0 | 99.115 | 46.9216417910448 | 113 | 1 | 42 | 0 | 156 | 268 | 683 | 571 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 12575 | 204 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 18556977 | 18556977 | PRJNA715461_S_NODE_915_length_262_cov_1.190476_g841_i0 | PRJNA715461 | 915 | 262 | 1.190476 | 3.11904712 | Balamuthia mandrillaris | 66527 | Discosea | other_Eukaryota | 89.8 | 1.82e-13 | NTclustered | gi|2241228763|gb|OM994889.1| | 66527 | g841 | i0 | 77.632 | 6.90076335877863 | 152 | 30 | 57 | 4 | 72 | 221 | 40304 | 40155 | Balamuthia mandrillaris strain KM-20 mitochondrion, complete genome | blastn | 1808 | 89.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Balamuthiidae | Balamuthia | Balamuthia mandrillaris | |||
| 20318621 | 20318621 | PRJNA715461_S_NODE_576_length_357_cov_805.950704_g502_i0 | PRJNA715461 | 576 | 357 | 805.950704 | 2877.24401328 | Vannellidae | 95227 | Discosea | other_Eukaryota | 416 | 1.04e-111 | NTclustered | gi|62865947|gb|AY929922.1| | 325065 | g502 | i0 | 98.723 | 63.9831932773109 | 235 | 2 | 66 | 1 | 111 | 344 | 464 | 230 | Platyamoeba sp. strain CAZ7/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 22842 | 420 | 0.990476190476191 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba sp. strain CAZ7/I | |||
| 22382700 | 22382700 | PRJNA715461_S_NODE_398_length_432_cov_13275.571031_g324_i0 | PRJNA715461 | 398 | 432 | 13275.571031 | 57350.46685392 | Ripella sp. GP2 | 1217115 | Discosea | other_Eukaryota | 562 | 1.56e-155 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g324 | i0 | 97.576 | 76.6666666666667 | 330 | 5 | 76 | 3 | 21 | 348 | 242 | 570 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 33120 | 562 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 24143824 | 24143824 | PRJNA715461_S_NODE_639_length_329_cov_18674.265625_g565_i0 | PRJNA715461 | 639 | 329 | 18674.265625 | 61438.33390625 | Vannellidae | 95227 | Discosea | other_Eukaryota | 416 | 9.529999999999997e-112 | NTclustered | gi|62865947|gb|AY929922.1| | 325065 | g565 | i0 | 98.723 | 69.4285714285714 | 235 | 2 | 71 | 1 | 83 | 316 | 464 | 230 | Platyamoeba sp. strain CAZ7/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 22842 | 420 | 0.990476190476191 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba sp. strain CAZ7/I | |||
| 24931700 | 24931700 | PRJNA715461_S_NODE_920_length_261_cov_45.085106_g846_i0 | PRJNA715461 | 920 | 261 | 45.085106 | 117.67212666 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 381 | 2.669999999999999e-101 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g846 | i0 | 93.87 | 100.318007662835 | 261 | 2 | 100 | 6 | 1 | 261 | 817 | 571 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 26183 | 381 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 |
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);;