contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA560932" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1820245 | 1820245 | PRJNA560932_P_NODE_23002_length_369_cov_15.807432_g22646_i0 | PRJNA560932 | 23002 | 369 | 15.807432 | 58.32942408 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 8.709999999999998e-83 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g22646 | i0 | 83.288 | 53.6585365853659 | 371 | 39 | 99 | 16 | 3 | 369 | 4020 | 3669 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 19800 | 320 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 6922767 | 6922767 | PRJNA560932_P_NODE_50766_length_254_cov_1.662983_g50410_i0 | PRJNA560932 | 50766 | 254 | 1.662983 | 4.22397682 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 7.3e-92 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g50410 | i0 | 91.221 | 56.251968503937 | 262 | 15 | 100 | 1 | 1 | 254 | 2210 | 1949 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 14288 | 350 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 10748788 | 10748788 | PRJNA560932_P_NODE_14209_length_464_cov_2.982097_g13854_i0 | PRJNA560932 | 14209 | 464 | 2.982097 | 13.83693008 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 632 | 1.2699999999999995e-176 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g13854 | i0 | 91.361 | 100.159482758621 | 463 | 39 | 99 | 1 | 1 | 463 | 1581 | 1120 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 46474 | 632 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 13298789 | 13298789 | PRJNA560932_P_NODE_46591_length_268_cov_0.774359_g46235_i0 | PRJNA560932 | 46591 | 268 | 0.774359 | 2.07528212 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1.0599999999999998e-55 | NTclustered | gi|300676750|gb|GQ377668.1| | 45107 | g46235 | i0 | 82.443 | 86.4029850746269 | 262 | 46 | 98 | 0 | 7 | 268 | 638 | 899 | Heteromita globosa actin gene, partial cds | blastn | 23156 | 230 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 14573674 | 14573674 | PRJNA560932_P_NODE_43572_length_277_cov_1.132353_g43216_i0 | PRJNA560932 | 43572 | 277 | 1.132353 | 3.13661781 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 1.3700000000000003e-79 | NTclustered | gi|302026186|gb|GQ377653.1| | 646463 | g43216 | i0 | 87.594 | 84.9819494584838 | 266 | 33 | 96 | 0 | 9 | 274 | 514 | 249 | Gymnophrys sp. ATCC 50923 HSP90 gene, partial cds | blastn | 23540 | 309 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 15158560 | 15158560 | PRJNA560932_P_NODE_13912_length_469_cov_2.083333_g13557_i0 | PRJNA560932 | 13912 | 469 | 2.083333 | 9.77083177 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 854 | 0 | NTclustered | gi|319659368|gb|GU320605.1| | 943207 | g13557 | i0 | 99.574 | 99.6396588486141 | 469 | 1 | 100 | 1 | 1 | 469 | 1345 | 1812 | Reticulamoeba sp. COHH 9 18S ribosomal RNA gene, partial sequence | blastn | 46731 | 854 | 1 | Eukaryota | Sar | Cercozoa | Reticulamoeba | Reticulamoeba sp. COHH 9 | |||||
| 15847401 | 15847401 | PRJNA560932_P_NODE_23713_length_364_cov_3.608247_g23357_i0 | PRJNA560932 | 23713 | 364 | 3.608247 | 13.13401908 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 407 | 6.399999999999999e-109 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g23357 | i0 | 87.293 | 50.3406593406593 | 362 | 39 | 99 | 6 | 1 | 360 | 3666 | 4022 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 18324 | 407 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 15847698 | 15847698 | PRJNA560932_P_NODE_60313_length_245_cov_2.848837_g59957_i0 | PRJNA560932 | 60313 | 245 | 2.848837 | 6.97965065 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 3.3000000000000003e-80 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g59957 | i0 | 89.683 | 113.224489795918 | 252 | 15 | 100 | 10 | 1 | 245 | 2674 | 2921 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 27740 | 311 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 19671396 | 19671396 | PRJNA560932_P_NODE_7276_length_641_cov_2.184859_g6924_i0 | PRJNA560932 | 7276 | 641 | 2.184859 | 14.00494619 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 649 | 0 | NTclustered | gi|238617670|gb|FJ973414.1| | 646463 | g6924 | i0 | 91.793 | 79.5304212168487 | 463 | 38 | 72 | 0 | 179 | 641 | 1 | 463 | Gymnophrys sp. ATCC 50923 alpha-tubulin (atub) gene, partial cds | blastn | 50979 | 649 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 20946670 | 20946670 | PRJNA560932_P_NODE_19257_length_401_cov_1.771341_g18901_i0 | PRJNA560932 | 19257 | 401 | 1.771341 | 7.10307741 | Cercomonas sp. HFCC53 | 458867 | SAR_Eukaryotes | SAR_Eukaryotes | 719 | 0 | NTclustered | gi|161015705|gb|EF681939.1| | 458867 | g18901 | i0 | 99.002 | 27.2643391521197 | 401 | 4 | 100 | 0 | 1 | 401 | 628 | 228 | Cercomonas sp. HFCC53 28S ribosomal RNA gene, partial sequence | blastn | 10933 | 719 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC53 | |||
| 21532555 | 21532555 | PRJNA560932_P_NODE_38777_length_292_cov_1.059361_g38421_i0 | PRJNA560932 | 38777 | 292 | 1.059361 | 3.09333412 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 2.52e-52 | NTclustered | gi|15216730|gb|AF363539.1| | 45113 | g38421 | i0 | 86.139 | 69.4623287671233 | 202 | 28 | 69 | 0 | 91 | 292 | 732 | 531 | Cercomonas sp. ATCC 50319 actin (act) gene, partial cds | blastn | 20283 | 219 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. ATCC 50319 | |||
| 22221689 | 22221689 | PRJNA560932_P_NODE_28658_length_335_cov_4.927481_g28302_i0 | PRJNA560932 | 28658 | 335 | 4.927481 | 16.50706135 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 593 | 4.189999999999999e-165 | NTclustered | gi|512134091|gb|KC575315.1| | 175275 | g28302 | i0 | 98.799 | 99.865671641791 | 333 | 4 | 99 | 0 | 1 | 333 | 54 | 386 | Uncultured cercozoan clone A.3.2 18S ribosomal RNA gene, partial sequence | blastn | 33455 | 593 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 23497097 | 23497097 | PRJNA560932_P_NODE_45039_length_272_cov_1.713568_g44683_i0 | PRJNA560932 | 45039 | 272 | 1.713568 | 4.66090496 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 1.38e-59 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g44683 | i0 | 83.696 | 16.8125 | 276 | 25 | 100 | 11 | 1 | 272 | 3752 | 4011 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 4573 | 243 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 24770756 | 24770756 | PRJNA560932_P_NODE_15120_length_451_cov_1.415344_g14765_i0 | PRJNA560932 | 15120 | 451 | 1.415344 | 6.38320144 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 813 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g14765 | i0 | 99.332 | 90.7671840354767 | 449 | 3 | 99 | 0 | 3 | 451 | 725 | 277 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 40936 | 813 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima |
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);;