contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJEB28062" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2573867 | 2573867 | PRJEB28062_P_NODE_127683_length_245_cov_3.860465_g125319_i0 | PRJEB28062 | 127683 | 245 | 3.860465 | 9.45813925 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 5.73e-53 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g125319 | i0 | 83.004 | 42.7959183673469 | 253 | 34 | 100 | 6 | 1 | 245 | 1622 | 1873 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 10485 | 220 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 3851283 | 3851283 | PRJEB28062_P_NODE_59144_length_456_cov_3.553525_g56785_i0 | PRJEB28062 | 59144 | 456 | 3.553525 | 16.204074 | Cercomonas sp. HFCC540 | 458868 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 1.3699999999999998e-106 | NTclustered | gi|161015708|gb|EF681942.1| | 458868 | g56785 | i0 | 85.112 | 38.9254385964912 | 403 | 46 | 88 | 9 | 36 | 435 | 765 | 374 | Cercomonas sp. HFCC540 28S ribosomal RNA gene, partial sequence | blastn | 17750 | 399 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC540 | |||
| 7676624 | 7676624 | PRJEB28062_P_NODE_24747_length_748_cov_6.376296_g22530_i0 | PRJEB28062 | 24747 | 748 | 6.376296 | 47.69469408 | Phytocercomonas venanatans | 2065209 | SAR_Eukaryotes | SAR_Eukaryotes | 366 | 2.359999999999999e-96 | NTclustered | gi|1315527750|gb|MF034900.1| | 2065209 | g22530 | i0 | 82.339 | 59.3917112299465 | 436 | 63 | 100 | 12 | 322 | 748 | 9756 | 9326 | Phytocercomonas venanatans 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 44425 | 366 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Phytocercomonas | Phytocercomonas venanatans | |||
| 12777341 | 12777341 | PRJEB28062_P_NODE_117251_length_267_cov_3.056701_g114888_i0 | PRJEB28062 | 117251 | 267 | 3.056701 | 8.16139167 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 390 | 4.56e-104 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g114888 | i0 | 94.902 | 93.7003745318352 | 255 | 3 | 96 | 1 | 1 | 255 | 1526 | 1282 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 25018 | 390 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 15015741 | 15015741 | PRJEB28062_P_NODE_84592_length_362_cov_4.560554_g82230_i0 | PRJEB28062 | 84592 | 362 | 4.560554 | 16.50920548 | Thaumatomonas | 45099 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 1.19e-26 | NTclustered | gi|160688658|gb|EU138880.1| | 352461 | g82230 | i0 | 81.111 | 31.5055248618785 | 180 | 23 | 64 | 9 | 24 | 202 | 2001 | 2170 | Thaumatomonas coloniensis strain HFCC93 28S ribosomal RNA gene, partial sequence | blastn | 11405 | 135 | 0.992592592592593 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas coloniensis | ||
| 15015858 | 15015858 | PRJEB28062_P_NODE_97652_length_322_cov_1.819277_g95290_i0 | PRJEB28062 | 97652 | 322 | 1.819277 | 5.85807194 | Cercomonadida | 188941 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 4.710000000000001e-50 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g95290 | i0 | 80.797 | 57.6335403726708 | 276 | 47 | 85 | 6 | 50 | 322 | 1317 | 1589 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 18558 | 213 | 0.990610328638498 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 16600597 | 16600597 | PRJEB28062_P_NODE_117294_length_267_cov_2.360825_g114931_i0 | PRJEB28062 | 117294 | 267 | 2.360825 | 6.30340275 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 2.2799999999999993e-52 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g114931 | i0 | 82.09 | 57.3670411985019 | 268 | 36 | 97 | 12 | 1 | 258 | 1881 | 1616 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 15317 | 219 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 17875603 | 17875603 | PRJEB28062_P_NODE_129255_length_243_cov_1.605882_g126891_i0 | PRJEB28062 | 129255 | 243 | 1.605882 | 3.90229326 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 366 | 6.89e-97 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g126891 | i0 | 93.827 | 98.7777777777778 | 243 | 15 | 100 | 0 | 1 | 243 | 1594 | 1352 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 24003 | 366 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 18838879 | 18838879 | PRJEB28062_P_NODE_135955_length_217_cov_5.756944_g133591_i0 | PRJEB28062 | 135955 | 217 | 5.756944 | 12.49256848 | Cercomonas | 45109 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 4.829999999999999e-73 | NTclustered | gi|161015708|gb|EF681942.1| | 458868 | g133591 | i0 | 94.18 | 73.3133640552995 | 189 | 9 | 86 | 1 | 31 | 217 | 1 | 189 | Cercomonas sp. HFCC540 28S ribosomal RNA gene, partial sequence | blastn | 15909 | 287 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC540 | |||
| 20426438 | 20426438 | PRJEB28062_P_NODE_90877_length_342_cov_5.312268_g88515_i0 | PRJEB28062 | 90877 | 342 | 5.312268 | 18.16795656 | Cryothecomonas sp. APCC MC5-1Cryo | 741088 | SAR_Eukaryotes | SAR_Eukaryotes | 394 | 4.66e-105 | NTclustered | gi|290760480|gb|GQ144683.1| | 741088 | g88515 | i0 | 88.82 | 61.0584795321637 | 322 | 35 | 94 | 1 | 22 | 342 | 1924 | 2245 | Cryothecomonas sp. APCC MC5-1Cryo large subunit ribosomal RNA gene, partial sequence | blastn | 20882 | 394 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Cryomonadida | Protaspidae | Cryothecomonas | Cryothecomonas sp. APCC MC5-1Cryo | ||
| 22977636 | 22977636 | PRJEB28062_P_NODE_86179_length_357_cov_10.419014_g83817_i0 | PRJEB28062 | 86179 | 357 | 10.419014 | 37.19587998 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 403 | 8.099999999999998e-108 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g83817 | i0 | 88.988 | 35.0056022408964 | 336 | 23 | 93 | 7 | 4 | 336 | 2292 | 1968 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 12497 | 403 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 24249539 | 24249539 | PRJEB28062_P_NODE_113980_length_276_cov_1.137931_g111617_i0 | PRJEB28062 | 113980 | 276 | 1.137931 | 3.14068956 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 4.84e-89 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g111617 | i0 | 89.416 | 43.7971014492754 | 274 | 23 | 98 | 5 | 1 | 270 | 1895 | 1624 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 12088 | 340 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 24251237 | 24251237 | PRJEB28062_P_NODE_74000_length_397_cov_7.354938_g71638_i0 | PRJEB28062 | 74000 | 397 | 7.354938 | 29.19910386 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 3.62e-37 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g71638 | i0 | 82.979 | 33.7531486146096 | 188 | 30 | 47 | 2 | 38 | 224 | 1527 | 1713 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 13400 | 169 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa |
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);;