contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA407087" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3632507 | 3632507 | PRJNA407087_S_NODE_3863_length_285_cov_12.417969_g3400_i0 | PRJNA407087 | 3863 | 285 | 12.417969 | 35.39121165 | Phalansterium | 136498 | Evosea | other_Eukaryota | 340 | 5.02e-89 | NTclustered | gi|539395531|gb|KF539978.1| | 1395795 | g3400 | i0 | 88.356 | 100.066666666667 | 292 | 22 | 99 | 8 | 3 | 285 | 413 | 125 | Phalansterium sp. 1 JFP-2013 18S ribosomal RNA gene, partial sequence | blastn | 28519 | 340 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium sp. 1 JFP-2013 | ||||
| 3632517 | 3632517 | PRJNA407087_S_NODE_6383_length_197_cov_4.976190_g5920_i0 | PRJNA407087 | 6383 | 197 | 4.97619 | 9.8030943 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 239 | 1.22e-58 | NTclustered | gi|330795966|ref|XM_003285993.1| | 5786 | g5920 | i0 | 88.718 | 96.6243654822335 | 195 | 22 | 99 | 0 | 1 | 195 | 268 | 462 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_46519), mRNA | blastn | 19035 | 239 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 4242044 | 4242044 | PRJNA407087_S_NODE_3444_length_315_cov_12.681818_g2981_i0 | PRJNA407087 | 3444 | 315 | 12.681818 | 39.9477267 | Phalansterium solitarium | 136499 | Evosea | other_Eukaryota | 311 | 4.41e-80 | NTclustered | gi|300078500|gb|GU001162.1| | 136499 | g2981 | i0 | 90.041 | 75.1047619047619 | 241 | 22 | 76 | 2 | 1 | 240 | 3154 | 3393 | Phalansterium solitarium 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 | 23658 | 311 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium | ||||
| 5518732 | 5518732 | PRJNA407087_S_NODE_5045_length_232_cov_19.714286_g4582_i0 | PRJNA407087 | 5045 | 232 | 19.714286 | 45.73714352 | Phalansterium solitarium | 136499 | Evosea | other_Eukaryota | 309 | 1.11e-79 | NTclustered | gi|300078500|gb|GU001162.1| | 136499 | g4582 | i0 | 90.948 | 61.5775862068966 | 232 | 18 | 99 | 2 | 3 | 232 | 4089 | 3859 | Phalansterium solitarium 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 | 14286 | 309 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium | ||||
| 5518754 | 5518754 | PRJNA407087_S_NODE_9705_length_153_cov_1.967742_g9242_i0 | PRJNA407087 | 9705 | 153 | 1.967742 | 3.01064526 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 89.8 | 9.55e-14 | NTclustered | gi|831785082|ref|XM_012902221.1| | 1410327 | g9242 | i0 | 85.057 | 0.568627450980392 | 87 | 13 | 57 | 0 | 59 | 145 | 554 | 468 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 87 | 89.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 8068273 | 8068273 | PRJNA407087_S_NODE_4887_length_238_cov_16.875598_g4424_i0 | PRJNA407087 | 4887 | 238 | 16.875598 | 40.16392324 | Phalansterium solitarium | 136499 | Evosea | other_Eukaryota | 185 | 2.0199999999999998e-42 | NTclustered | gi|300078500|gb|GU001162.1| | 136499 | g4424 | i0 | 80.992 | 16.0210084033613 | 242 | 34 | 98 | 6 | 3 | 236 | 3348 | 3585 | Phalansterium solitarium 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 | 3813 | 185 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium | ||||
| 9343113 | 9343113 | PRJNA407087_S_NODE_3788_length_289_cov_13.615385_g3325_i0 | PRJNA407087 | 3788 | 289 | 13.615385 | 39.34846265 | Phalansterium solitarium | 136499 | Evosea | other_Eukaryota | 381 | 2.9999999999999997e-101 | NTclustered | gi|300078500|gb|GU001162.1| | 136499 | g3325 | i0 | 91.429 | 67.2871972318339 | 280 | 20 | 96 | 4 | 12 | 289 | 3121 | 2844 | Phalansterium solitarium 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 | 19446 | 381 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium | ||||
| 9343155 | 9343155 | PRJNA407087_S_NODE_9288_length_156_cov_7.503937_g8825_i0 | PRJNA407087 | 9288 | 156 | 7.503937 | 11.70614172 | Phalansterium sp. SMalavin-2023a | 3078203 | Evosea | other_Eukaryota | 219 | 1.2e-52 | NTclustered | gi|2583707790|gb|OR613015.1| | 3078203 | g8825 | i0 | 92.208 | 93.5897435897436 | 154 | 12 | 99 | 0 | 3 | 156 | 1846 | 1693 | Phalansterium sp. SMalavin-2023a strain SCCAP Ph185 small subunit ribosomal RNA gene, partial sequence | blastn | 14600 | 219 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium sp. SMalavin-2023a | ||||
| 10618907 | 10618907 | PRJNA407087_S_NODE_6949_length_186_cov_27.452229_g6486_i0 | PRJNA407087 | 6949 | 186 | 27.452229 | 51.06114594 | Phalansterium arcticum | 1958825 | Evosea | other_Eukaryota | 333 | 5.069999999999999e-87 | NTclustered | gi|2489686157|gb|KX844828.2| | 1958825 | g6486 | i0 | 98.925 | 99.8817204301075 | 186 | 2 | 100 | 0 | 1 | 186 | 1672 | 1487 | Phalansterium arcticum strain SCL-Parc 18S ribosomal RNA gene, partial sequence | blastn | 18578 | 333 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium arcticum | ||||
| 15717638 | 15717638 | PRJNA407087_S_NODE_2993_length_353_cov_24.589506_g2531_i0 | PRJNA407087 | 2993 | 353 | 24.589506 | 86.80095618 | Phalansterium sp. 1 JFP-2013 | 1395795 | Evosea | other_Eukaryota | 592 | 1.5899999999999997e-164 | NTclustered | gi|539395531|gb|KF539978.1| | 1395795 | g2531 | i0 | 97.151 | 99.9886685552408 | 351 | 8 | 99 | 2 | 1 | 351 | 65 | 413 | Phalansterium sp. 1 JFP-2013 18S ribosomal RNA gene, partial sequence | blastn | 35296 | 592 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium sp. 1 JFP-2013 | ||||
| 15717676 | 15717676 | PRJNA407087_S_NODE_893_length_775_cov_23.699732_g578_i0 | PRJNA407087 | 893 | 775 | 23.699732 | 183.672923 | Phalansterium solitarium | 136499 | Evosea | other_Eukaryota | 294 | 1.17e-74 | NTclustered | gi|300078500|gb|GU001162.1| | 136499 | g578 | i0 | 81.769 | 26.0877419354839 | 373 | 49 | 91 | 9 | 1 | 357 | 4439 | 4808 | Phalansterium solitarium 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 | 20218 | 294 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium | ||||
| 16384065 | 16384065 | PRJNA407087_S_NODE_3673_length_297_cov_25.876866_g3210_i0 | PRJNA407087 | 3673 | 297 | 25.876866 | 76.85429202 | Phalansterium | 136498 | Evosea | other_Eukaryota | 333 | 8.8e-87 | NTclustered | gi|300078500|gb|GU001162.1| | 136499 | g3210 | i0 | 87.043 | 97.5286195286195 | 301 | 31 | 99 | 6 | 2 | 297 | 1556 | 1259 | Phalansterium solitarium 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 | 28966 | 333 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium | ||||
| 18933140 | 18933140 | PRJNA407087_S_NODE_5755_length_211_cov_23.016484_g5292_i0 | PRJNA407087 | 5755 | 211 | 23.016484 | 48.56478124 | Phalansterium | 136498 | Evosea | other_Eukaryota | 254 | 4.73e-63 | NTclustered | gi|2489686157|gb|KX844828.2| | 1958825 | g5292 | i0 | 88.571 | 37.2274881516588 | 210 | 23 | 99 | 1 | 1 | 209 | 1307 | 1516 | Phalansterium arcticum strain SCL-Parc 18S ribosomal RNA gene, partial sequence | blastn | 7855 | 254 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium arcticum | ||||
| 20816613 | 20816613 | PRJNA407087_S_NODE_5757_length_211_cov_15.032967_g5294_i0 | PRJNA407087 | 5757 | 211 | 15.032967 | 31.71956037 | Phalansterium filosum | 857046 | Evosea | other_Eukaryota | 335 | 1.6399999999999994e-87 | NTclustered | gi|300078501|gb|GU001163.1| | 857046 | g5294 | i0 | 95.261 | 100.981042654028 | 211 | 10 | 100 | 0 | 1 | 211 | 2130 | 1920 | 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 | 21307 | 335 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium filosum | ||||
| 22758604 | 22758604 | PRJNA407087_S_NODE_8158_length_168_cov_20.985612_g7695_i0 | PRJNA407087 | 8158 | 168 | 20.985612 | 35.25582816 | Phalansterium | 136498 | Evosea | other_Eukaryota | 222 | 1.02e-53 | NTclustered | gi|300078500|gb|GU001162.1| | 136499 | g7695 | i0 | 90.476 | 122.47619047619 | 168 | 16 | 100 | 0 | 1 | 168 | 2698 | 2865 | Phalansterium solitarium 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 | 20576 | 222 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium |
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);;