contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1035005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6547122 | 6547122 | PRJNA1035005_P_NODE_6746_length_415_cov_2.219298_g6344_i0 | PRJNA1035005 | 6746 | 415 | 2.219298 | 9.2100867 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 274 | 7.819999999999998e-69 | NTclustered | gi|330799393|ref|XM_003287682.1| | 5786 | g6344 | i0 | 79.639 | 9.86506024096385 | 388 | 73 | 93 | 5 | 10 | 395 | 201 | 584 | Dictyostelium purpureum 40S ribosomal protein S2 (DICPUDRAFT_32959), partial mRNA | blastn | 4094 | 274 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 7821228 | 7821228 | PRJNA1035005_P_NODE_10607_length_358_cov_1.091228_g10202_i0 | PRJNA1035005 | 10607 | 358 | 1.091228 | 3.90659624 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 401 | 2.9199999999999995e-107 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g10202 | i0 | 87.079 | 98.3184357541899 | 356 | 45 | 99 | 1 | 4 | 358 | 796 | 441 | Platyamoeba placida actin mRNA, partial cds | blastn | 35198 | 401 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 10371896 | 10371896 | PRJNA1035005_P_NODE_15049_length_323_cov_1.376000_g14643_i0 | PRJNA1035005 | 15049 | 323 | 1.376 | 4.44448 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 124 | 6.34e-24 | NTclustered | gi|167380911|ref|XM_001735454.1| | 370354 | g14643 | i0 | 80.347 | 1.24458204334365 | 173 | 27 | 52 | 7 | 113 | 281 | 67 | 236 | Entamoeba dispar SAW760 14-3-3 protein (EDI_244420), partial mRNA | blastn | 402 | 124 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 12922760 | 12922760 | PRJNA1035005_P_NODE_6691_length_417_cov_0.906977_g6289_i0 | PRJNA1035005 | 6691 | 417 | 0.906977 | 3.78209409 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 254 | 1.02e-62 | NTclustered | gi|330804280|ref|XM_003290077.1| | 5786 | g6289 | i0 | 79.339 | 6.07913669064748 | 363 | 73 | 87 | 2 | 30 | 391 | 478 | 117 | Dictyostelium purpureum ubiquitin-conjugating enzyme E2-17 kDa (DICPUDRAFT_56481), mRNA | blastn | 2535 | 254 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 14197828 | 14197828 | PRJNA1035005_P_NODE_9992_length_364_cov_2.144330_g9587_i0 | PRJNA1035005 | 9992 | 364 | 2.14433 | 7.8053612 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 562 | 1.29e-155 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g9587 | i0 | 94.55 | 72.0164835164835 | 367 | 14 | 100 | 6 | 1 | 364 | 1467 | 1104 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 26214 | 562 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 16310271 | 16310271 | PRJNA1035005_P_NODE_50833_length_256_cov_1.355191_g50427_i0 | PRJNA1035005 | 50833 | 256 | 1.355191 | 3.46928896 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 148 | 2.89e-31 | NTclustered | gi|887421|emb|Z37109.1| | 44689 | g50427 | i0 | 82.635 | 1.95703125 | 167 | 29 | 65 | 0 | 11 | 177 | 1870 | 2036 | D.discoideum mRNA for major vault protein B | blastn | 501 | 148 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 16746208 | 16746208 | PRJNA1035005_P_NODE_9774_length_367_cov_1.105442_g9369_i0 | PRJNA1035005 | 9774 | 367 | 1.105442 | 4.05697214 | Telaepolella tubasferens | 1346289 | Evosea | other_Eukaryota | 427 | 4.9599999999999985e-115 | NTclustered | gi|167859711|gb|EU273435.1| | 1346289 | g9369 | i0 | 88.089 | 95.6948228882834 | 361 | 41 | 98 | 2 | 4 | 363 | 426 | 785 | Telaepolella tubasferens clone 1 actin gene, partial cds | blastn | 35120 | 427 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Telaepolella | Telaepolella tubasferens | |||
| 18021097 | 18021097 | PRJNA1035005_P_NODE_9875_length_366_cov_1.061433_g9470_i0 | PRJNA1035005 | 9875 | 366 | 1.061433 | 3.88484478 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 235 | 3.2099999999999996e-57 | NTclustered | gi|1160557950|ref|XM_020575808.1| | 670386 | g9470 | i0 | 85.65 | 66.5874316939891 | 223 | 32 | 61 | 0 | 144 | 366 | 1332 | 1110 | Polysphondylium pallidum PN500 ubiquitin (ubqI), partial mRNA | blastn | 24371 | 235 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 18859437 | 18859437 | PRJNA1035005_P_NODE_3135_length_621_cov_1.994526_g2745_i0 | PRJNA1035005 | 3135 | 621 | 1.994526 | 12.38600646 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 108 | 1.3e-18 | NTclustered | gi|3186|emb|X07792.1| | 5791 | g2745 | i0 | 93.151 | 11.0112721417069 | 73 | 5 | 12 | 0 | 2 | 74 | 1435 | 1507 | Physarum polycephalum actin gene | blastn | 6838 | 108 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 21845705 | 21845705 | PRJNA1035005_P_NODE_32718_length_279_cov_1.368932_g32312_i0 | PRJNA1035005 | 32718 | 279 | 1.368932 | 3.81932028 | Vexillifera bacillipedes | 1105345 | Discosea | other_Eukaryota | 490 | 4.59e-134 | NTclustered | gi|399764261|gb|JQ271772.1| | 1105345 | g32312 | i0 | 98.221 | 31.3799283154122 | 281 | 3 | 100 | 1 | 1 | 279 | 446 | 166 | Vexillifera bacillipedes strain 6HZM 18S ribosomal RNA gene, partial sequence | blastn | 8755 | 490 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera bacillipedes | ||
| 21845785 | 21845785 | PRJNA1035005_P_NODE_4258_length_518_cov_2.098876_g3860_i0 | PRJNA1035005 | 4258 | 518 | 2.098876 | 10.87217768 | Diachea leucopodia | 385471 | Evosea | other_Eukaryota | 340 | 9.67e-89 | NTclustered | gi|2049856273|gb|MG963476.1| | 385471 | g3860 | i0 | 78.654 | 99.5173745173745 | 520 | 105 | 99 | 4 | 2 | 518 | 560 | 44 | Diachea leucopodia strain MA-Fungi 86465 elongation factor 1A (EF1a) gene, partial cds | blastn | 51550 | 340 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Diachea | Diachea leucopodia | ||
| 23960305 | 23960305 | PRJNA1035005_P_NODE_799_length_1602_cov_12.758012_g616_i0 | PRJNA1035005 | 799 | 1602 | 12.758012 | 204.38335224 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 289 | 1.15e-72 | NTclustered | gi|28194618|gb|AF479562.1| | 29195 | g616 | i0 | 73.042 | 24.6011235955056 | 983 | 201 | 59 | 50 | 509 | 1453 | 433 | 1389 | Acanthamoeba griffini strain S7 16S small subunit ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product | blastn | 39411 | 291 | 0.993127147766323 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba griffini |
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);;