contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA724011" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2469118 | 2469118 | PRJNA724011_P_NODE_23742_length_586_cov_2.994152_g22727_i0 | PRJNA724011 | 23742 | 586 | 2.994152 | 17.54573072 | Tremula | 1938488 | SAR_Eukaryotes | SAR_Eukaryotes | 418 | 4.959999999999998e-112 | NTclustered | gi|194272494|gb|EU567287.1| | 175275 | g22727 | i0 | 84.813 | 71.6262798634812 | 428 | 51 | 72 | 11 | 166 | 586 | 648 | 1068 | Uncultured cercozoan isolate lb9 18S ribosomal RNA gene, partial sequence | blastn | 41973 | 418 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 3745495 | 3745495 | PRJNA724011_P_NODE_108783_length_241_cov_175.755952_g107760_i0 | PRJNA724011 | 108783 | 241 | 175.755952 | 423.57184432 | root | 1 | Root_unresolved | Root_unresolved | 381 | 2.4399999999999996e-101 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g107760 | i0 | 95.436 | 99.7676348547718 | 241 | 8 | 99 | 3 | 4 | 241 | 2386 | 2146 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 24044 | 381 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 7089691 | 7089691 | PRJNA724011_P_NODE_86446_length_264_cov_2.141361_g85423_i0 | PRJNA724011 | 86446 | 264 | 2.141361 | 5.65319304 | Euglypha rotunda | 39714 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 3.55e-90 | NTclustered | gi|145558660|gb|EF517356.1| | 39714 | g85423 | i0 | 90.152 | 15.6174242424242 | 264 | 26 | 100 | 0 | 1 | 264 | 482 | 745 | Euglypha rotunda strain CCAP 1520/1 actin gene, partial cds | blastn | 4123 | 344 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Euglypha | Euglypha rotunda | ||
| 10914792 | 10914792 | PRJNA724011_P_NODE_60509_length_327_cov_2.425197_g59486_i0 | PRJNA724011 | 60509 | 327 | 2.425197 | 7.93039419 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 9.27e-127 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g59486 | i0 | 92.355 | 99.3761467889908 | 327 | 25 | 100 | 0 | 1 | 327 | 1241 | 1567 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 32496 | 466 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 12190086 | 12190086 | PRJNA724011_P_NODE_62630_length_321_cov_1.403226_g61607_i0 | PRJNA724011 | 62630 | 321 | 1.403226 | 4.50435546 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 7.580000000000001e-73 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g61607 | i0 | 83.912 | 58.0560747663551 | 317 | 34 | 98 | 9 | 1 | 315 | 3685 | 3986 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 18636 | 287 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 14739972 | 14739972 | PRJNA724011_P_NODE_85812_length_265_cov_4.619792_g84789_i0 | PRJNA724011 | 85812 | 265 | 4.619792 | 12.2424488 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 2.22e-62 | NTclustered | gi|1389527545|dbj|LC383945.1| | 1928728 | g84789 | i0 | 87.85 | 81.6943396226415 | 214 | 26 | 81 | 0 | 1 | 214 | 462 | 249 | Paulinella micropora gene for actin, complete cds | blastn | 21649 | 252 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 16012920 | 16012920 | PRJNA724011_P_NODE_111233_length_234_cov_2.434783_g110210_i0 | PRJNA724011 | 111233 | 234 | 2.434783 | 5.69739222 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 2.49e-61 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g110210 | i0 | 90.909 | 64.9444444444444 | 187 | 14 | 79 | 3 | 1 | 186 | 3685 | 3869 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 15197 | 248 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 16013100 | 16013100 | PRJNA724011_P_NODE_35833_length_452_cov_3.292876_g34811_i0 | PRJNA724011 | 35833 | 452 | 3.292876 | 14.88379952 | Euglypha rotunda | 39714 | SAR_Eukaryotes | SAR_Eukaryotes | 625 | 2.06e-174 | NTclustered | gi|145558660|gb|EF517356.1| | 39714 | g34811 | i0 | 91.759 | 96.9181415929203 | 449 | 37 | 99 | 0 | 3 | 451 | 299 | 747 | Euglypha rotunda strain CCAP 1520/1 actin gene, partial cds | blastn | 43807 | 625 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Euglypha | Euglypha rotunda | ||
| 17288960 | 17288960 | PRJNA724011_P_NODE_89614_length_258_cov_1.664865_g88591_i0 | PRJNA724011 | 89614 | 258 | 1.664865 | 4.2953517 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 1.04e-35 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g88591 | i0 | 79.424 | 18.9767441860465 | 243 | 41 | 94 | 8 | 16 | 258 | 4018 | 3785 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 4896 | 163 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 19837574 | 19837574 | PRJNA724011_P_NODE_45036_length_390_cov_4.495268_g44013_i0 | PRJNA724011 | 45036 | 390 | 4.495268 | 17.5315452 | Euglypha rotunda | 39714 | SAR_Eukaryotes | SAR_Eukaryotes | 483 | 1.12e-131 | NTclustered | gi|145558660|gb|EF517356.1| | 39714 | g44013 | i0 | 89.147 | 95.9615384615385 | 387 | 42 | 99 | 0 | 1 | 387 | 349 | 735 | Euglypha rotunda strain CCAP 1520/1 actin gene, partial cds | blastn | 37425 | 483 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Euglypha | Euglypha rotunda | ||
| 19837664 | 19837664 | PRJNA724011_P_NODE_56036_length_343_cov_0.851852_g55013_i0 | PRJNA724011 | 56036 | 343 | 0.851852 | 2.92185236 | Cercomonas sp. ATCC 50316 | 45110 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 8.11e-78 | NTclustered | gi|27734378|gb|AY099144.1| | 45110 | g55013 | i0 | 91.743 | 194.419825072886 | 218 | 18 | 64 | 0 | 122 | 339 | 426 | 209 | Cercomonas ATCC50316 isolate pub6 polyubiquitin gene, partial cds | blastn | 66686 | 303 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. ATCC 50316 | |||
| 23664043 | 23664043 | PRJNA724011_P_NODE_96719_length_249_cov_0.875000_g95696_i0 | PRJNA724011 | 96719 | 249 | 0.875 | 2.17875 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 3.5399999999999996e-45 | NTclustered | gi|116222176|gb|DQ980464.1| | 407209 | g95696 | i0 | 80.972 | 30.1044176706827 | 247 | 45 | 99 | 2 | 4 | 249 | 964 | 719 | Thaumatomonas sp. TMT002 Hsp90 mRNA, partial cds | blastn | 7496 | 195 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 |
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);;