contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA407087" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 10618892 | 10618892 | PRJNA407087_S_NODE_4449_length_257_cov_3.982456_g3986_i0 | PRJNA407087 | 4449 | 257 | 3.982456 | 10.23491192 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 154 | 6.23e-33 | NTclustered | gi|470505078|ref|XM_004348480.1| | 1257118 | g3986 | i0 | 77.778 | 12.2217898832685 | 261 | 50 | 100 | 8 | 1 | 257 | 3383 | 3127 | Acanthamoeba castellanii str. Neff DNAdirected RNA polymerase, beta subunit (ACA1_158460), partial mRNA | blastn | 3141 | 154 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 10618896 | 10618896 | PRJNA407087_S_NODE_4869_length_239_cov_5.176190_g4406_i0 | PRJNA407087 | 4869 | 239 | 5.17619 | 12.3710941 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 287 | 5.409999999999999e-73 | NTclustered | gi|330902891|gb|JF298270.1| | 313997 | g4406 | i0 | 88.608 | 96.1087866108787 | 237 | 25 | 99 | 2 | 2 | 237 | 1053 | 818 | Cochliopodium minus clone 5201 actin gene, partial cds | blastn | 22970 | 287 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 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 | ||||
| 11893777 | 11893777 | PRJNA407087_S_NODE_2710_length_381_cov_3.375000_g2248_i0 | PRJNA407087 | 2710 | 381 | 3.375 | 12.85875 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 58.4 | 7.81e-4 | NTclustered | gi|470469416|ref|XM_004341948.1| | 1257118 | g2248 | i0 | 83.077 | 0.170603674540682 | 65 | 9 | 17 | 2 | 179 | 242 | 884 | 821 | Acanthamoeba castellanii str. Neff MORN repeatcontaining protein (ACA1_050500), partial mRNA | blastn | 65 | 58.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 13835158 | 13835158 | PRJNA407087_S_NODE_5451_length_219_cov_3.915789_g4988_i0 | PRJNA407087 | 5451 | 219 | 3.915789 | 8.57557791 | Ripella | 1217112 | Discosea | other_Eukaryota | 377 | 2.81e-100 | NTclustered | gi|2666517889|gb|PP259000.1| | 1973050 | g4988 | i0 | 98.598 | 93.4520547945205 | 214 | 2 | 97 | 1 | 7 | 219 | 939 | 726 | Ripella sp. strain CHIESE83/2 small subunit ribosomal RNA gene, partial sequence | blastn | 20466 | 377 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. | |||
| 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 | ||||
| 22758607 | 22758607 | PRJNA407087_S_NODE_8998_length_159_cov_2.892308_g8535_i0 | PRJNA407087 | 8998 | 159 | 2.892308 | 4.59876972 | Vannellidae | 95227 | Discosea | other_Eukaryota | 294 | 1.98e-75 | NTclustered | gi|62865939|gb|AY929914.1| | 325077 | g8535 | i0 | 100 | 100.031446540881 | 159 | 0 | 100 | 0 | 1 | 159 | 408 | 250 | Vannella sp. strain CAZ6/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 15905 | 294 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain CAZ6/I |
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);;