contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA438572" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1709986 | 1709986 | PRJNA438572_P_NODE_4142_length_483_cov_1.631707_g4024_i0 | PRJNA438572 | 4142 | 483 | 1.631707 | 7.88114481 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 893 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g4024 | i0 | 100 | 23.1821946169772 | 483 | 0 | 100 | 0 | 1 | 483 | 322 | 804 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 11197 | 893 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 2985643 | 2985643 | PRJNA438572_P_NODE_163_length_1727_cov_3.273881_g142_i0 | PRJNA438572 | 163 | 1727 | 3.273881 | 56.53992487 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1633 | 0 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g142 | i0 | 99.664 | 72.8239722061378 | 893 | 3 | 52 | 0 | 496 | 1388 | 893 | 1 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 125767 | 1633 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 2985661 | 2985661 | PRJNA438572_P_NODE_17583_length_252_cov_0.871508_g17464_i0 | PRJNA438572 | 17583 | 252 | 0.871508 | 2.19620016 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 2.72e-61 | NTclustered | gi|1389527547|dbj|LC383946.1| | 1928728 | g17464 | i0 | 87.156 | 154.519841269841 | 218 | 28 | 87 | 0 | 18 | 235 | 662 | 445 | Paulinella micropora gene for polyubiquitin, complete cds | blastn | 38939 | 248 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 5538873 | 5538873 | PRJNA438572_P_NODE_6305_length_399_cov_6.297546_g6186_i0 | PRJNA438572 | 6305 | 399 | 6.297546 | 25.12720854 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 1.1499999999999999e-126 | NTclustered | gi|238617666|gb|FJ973412.1| | 188950 | g6186 | i0 | 99.225 | 37.874686716792 | 258 | 2 | 65 | 0 | 1 | 258 | 258 | 1 | Bodomorpha minima strain ATCC 50339 alpha-tubulin (atub) gene, partial cds | blastn | 15112 | 466 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 15737491 | 15737491 | PRJNA438572_P_NODE_10573_length_315_cov_2.185950_g10454_i0 | PRJNA438572 | 10573 | 315 | 2.18595 | 6.8857425 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 5.78e-69 | NTclustered | gi|300676716|gb|GQ377714.1| | 323453 | g10454 | i0 | 84.672 | 61.9460317460317 | 274 | 42 | 87 | 0 | 42 | 315 | 54 | 327 | Heteromita sp. PRA-74 rps22a (rps22a) mRNA, complete cds | blastn | 19513 | 274 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 15737836 | 15737836 | PRJNA438572_P_NODE_6613_length_390_cov_1.473186_g6494_i0 | PRJNA438572 | 6613 | 390 | 1.473186 | 5.7454254 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 4.4e-66 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g6494 | i0 | 80.157 | 53.3435897435897 | 383 | 53 | 94 | 22 | 23 | 390 | 4038 | 3664 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20804 | 265 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 17668721 | 17668721 | PRJNA438572_P_NODE_2294_length_645_cov_1.202797_g2180_i0 | PRJNA438572 | 2294 | 645 | 1.202797 | 7.75804065 | Verrucomonas | 2545269 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 1.67e-47 | NTclustered | gi|290760488|gb|GQ144691.1| | 629763 | g2180 | i0 | 82.041 | 23.6 | 245 | 38 | 38 | 6 | 221 | 463 | 1487 | 1247 | Cercozoa sp. CC-2009e large subunit ribosomal RNA gene, partial sequence | blastn | 15222 | 204 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Ventricleftida | Verrucomonas | Verrucomonas bifida | |||
| 18286742 | 18286742 | PRJNA438572_P_NODE_3215_length_549_cov_1.302521_g3097_i0 | PRJNA438572 | 3215 | 549 | 1.302521 | 7.15084029 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 907 | 0 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g3097 | i0 | 96.552 | 14.0892531876138 | 551 | 13 | 100 | 5 | 1 | 549 | 579 | 33 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 7735 | 907 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 18286845 | 18286845 | PRJNA438572_P_NODE_8095_length_357_cov_1.940141_g7976_i0 | PRJNA438572 | 8095 | 357 | 1.940141 | 6.92630337 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 6.58e-74 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g7976 | i0 | 82.621 | 50.7759103641457 | 351 | 39 | 98 | 14 | 6 | 354 | 3691 | 4021 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 18127 | 291 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 21492796 | 21492796 | PRJNA438572_P_NODE_13177_length_285_cov_1.471698_g13058_i0 | PRJNA438572 | 13177 | 285 | 1.471698 | 4.1943393 | Glissomonadida | 1238681 | SAR_Eukaryotes | SAR_Eukaryotes | 521 | 1.6699999999999996e-143 | NTclustered | gi|2030163897|gb|MZ044034.1| | 1808984 | g13058 | i0 | 99.649 | 67.4245614035088 | 285 | 1 | 100 | 0 | 1 | 285 | 577 | 293 | Rosculus terrestris isolate S14D1 small subunit ribosomal RNA gene, partial sequence | blastn | 19216 | 521 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus terrestris | ||||
| 22111589 | 22111589 | PRJNA438572_P_NODE_16538_length_255_cov_1.285714_g16419_i0 | PRJNA438572 | 16538 | 255 | 1.285714 | 3.2785707 | Cryothecomonas sp. APCC MC5-1Cryo | 741088 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 9.359999999999998e-101 | NTclustered | gi|290760480|gb|GQ144683.1| | 741088 | g16419 | i0 | 93.385 | 103.580392156863 | 257 | 13 | 100 | 4 | 1 | 255 | 1820 | 1566 | Cryothecomonas sp. APCC MC5-1Cryo large subunit ribosomal RNA gene, partial sequence | blastn | 26413 | 379 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Cryomonadida | Protaspidae | Cryothecomonas | Cryothecomonas sp. APCC MC5-1Cryo |
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);;