contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1195374" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4148337 | 4148337 | PRJNA1195374_P_NODE_32104_length_398_cov_16.920000_g31760_i0 | PRJNA1195374 | 32104 | 398 | 16.92 | 67.3416 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 612 | 1.39e-170 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g31760 | i0 | 94.486 | 98.4824120603015 | 399 | 19 | 99 | 3 | 2 | 398 | 2572 | 2175 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 39196 | 612 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 4148986 | 4148986 | PRJNA1195374_P_NODE_65444_length_265_cov_1.500000_g65100_i0 | PRJNA1195374 | 65444 | 265 | 1.5 | 3.975 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 285 | 2.19e-72 | NTclustered | gi|193875699|gb|EU812202.1| | 407209 | g65100 | i0 | 86.09 | 77.1094339622641 | 266 | 35 | 100 | 2 | 1 | 265 | 68 | 332 | Thaumatomonas sp. TMT002 clone tshsp70-1 70 kDa heat shock protein mRNA, partial cds | blastn | 20434 | 285 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 10524918 | 10524918 | PRJNA1195374_P_NODE_22529_length_478_cov_4.602469_g22185_i0 | PRJNA1195374 | 22529 | 478 | 4.602469 | 21.99980182 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 326 | 2.4799999999999997e-84 | NTclustered | gi|301014702|gb|GQ377715.1| | 323453 | g22185 | i0 | 87.9 | 56.7468619246862 | 281 | 29 | 58 | 5 | 1 | 278 | 213 | 491 | Heteromita sp. PRA-74 ribosomal protein S23a (rps23a) mRNA, complete cds | blastn | 27125 | 326 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 11799513 | 11799513 | PRJNA1195374_P_NODE_10330_length_689_cov_2.917208_g10011_i0 | PRJNA1195374 | 10330 | 689 | 2.917208 | 20.09956312 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 686 | 0 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g10011 | i0 | 99.469 | 68.8476052249637 | 377 | 2 | 55 | 0 | 313 | 689 | 893 | 517 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 47436 | 686 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 11799664 | 11799664 | PRJNA1195374_P_NODE_17110_length_547_cov_4.837553_g16768_i0 | PRJNA1195374 | 17110 | 547 | 4.837553 | 26.46141491 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 3.5100000000000005e-123 | NTclustered | gi|300676716|gb|GQ377714.1| | 323453 | g16768 | i0 | 86.538 | 61.819012797075 | 416 | 52 | 76 | 3 | 16 | 431 | 43 | 454 | Heteromita sp. PRA-74 rps22a (rps22a) mRNA, complete cds | blastn | 33815 | 455 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 16899355 | 16899355 | PRJNA1195374_P_NODE_74674_length_248_cov_2.200000_g74330_i0 | PRJNA1195374 | 74674 | 248 | 2.2 | 5.456 | Proleptomonas faecicola | 149084 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 3.42e-65 | NTclustered | gi|300676734|gb|GQ377664.1| | 149084 | g74330 | i0 | 86.498 | 88.4637096774194 | 237 | 32 | 96 | 0 | 1 | 237 | 794 | 1030 | Proleptomonas faecicola alpha-tubulin (Atub) gene, partial cds | blastn | 21939 | 261 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Proleptomonas | Proleptomonas faecicola |
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);;