contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJEB4632" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3887688 | 3887688 | PRJEB4632_P_NODE_724_length_256_cov_3.092896_g686_i0 | PRJEB4632 | 724 | 256 | 3.092896 | 7.91781376 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 185 | 2.2e-42 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g686 | i0 | 81.349 | 3.83203125 | 252 | 26 | 98 | 10 | 5 | 255 | 4008 | 3777 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 981 | 185 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 3887692 | 3887692 | PRJEB4632_P_NODE_884_length_245_cov_3.866279_g846_i0 | PRJEB4632 | 884 | 245 | 3.866279 | 9.47238355 | Cercomonas sp. | 1979794 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.1e-37 | NTclustered | gi|2651357797|gb|PP174310.1| | 1979794 | g846 | i0 | 79.921 | 65.0530612244898 | 254 | 31 | 100 | 17 | 1 | 245 | 4106 | 4348 | Cercomonas sp. isolate 1-1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 15938 | 169 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. | |||
| 10264390 | 10264390 | PRJEB4632_P_NODE_1069_length_213_cov_6.207143_g1031_i0 | PRJEB4632 | 1069 | 213 | 6.207143 | 13.22121459 | Placocista sp. CC-Grouse Mountain | 741089 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 4.75e-68 | NTclustered | gi|290760485|gb|GQ144688.1| | 741089 | g1031 | i0 | 89.593 | 79.7934272300469 | 221 | 11 | 100 | 8 | 1 | 213 | 1860 | 1644 | Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence | blastn | 16996 | 270 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Placocista | Placocista sp. CC-Grouse Mountain | ||
| 10264398 | 10264398 | PRJEB4632_P_NODE_429_length_335_cov_2.736641_g391_i0 | PRJEB4632 | 429 | 335 | 2.736641 | 9.16774735 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 547 | 3.3099999999999984e-151 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g391 | i0 | 96.119 | 100.358208955224 | 335 | 13 | 100 | 0 | 1 | 335 | 1579 | 1245 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 33620 | 547 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 11539791 | 11539791 | PRJEB4632_P_NODE_1050_length_226_cov_4.836601_g1012_i0 | PRJEB4632 | 1050 | 226 | 4.836601 | 10.93071826 | Placocista sp. CC-Grouse Mountain | 741089 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 1.3799999999999998e-88 | NTclustered | gi|290760485|gb|GQ144688.1| | 741089 | g1012 | i0 | 93.805 | 99.3495575221239 | 226 | 13 | 100 | 1 | 1 | 226 | 2042 | 1818 | Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence | blastn | 22453 | 339 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Placocista | Placocista sp. CC-Grouse Mountain | ||
| 17913086 | 17913086 | PRJEB4632_P_NODE_1035_length_229_cov_2.660256_g997_i0 | PRJEB4632 | 1035 | 229 | 2.660256 | 6.09198624 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 1.49e-43 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g997 | i0 | 81.974 | 29.5021834061135 | 233 | 32 | 100 | 9 | 1 | 229 | 3994 | 3768 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 6756 | 189 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 20462428 | 20462428 | PRJEB4632_P_NODE_377_length_362_cov_5.813149_g339_i0 | PRJEB4632 | 377 | 362 | 5.813149 | 21.04359938 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 5.17e-75 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g339 | i0 | 82.535 | 55.8453038674033 | 355 | 43 | 97 | 15 | 1 | 350 | 3658 | 3998 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20216 | 294 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 20462433 | 20462433 | PRJEB4632_P_NODE_677_length_267_cov_2.716495_g639_i0 | PRJEB4632 | 677 | 267 | 2.716495 | 7.25304165 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 1.76e-53 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g639 | i0 | 82.657 | 17.4007490636704 | 271 | 27 | 100 | 11 | 1 | 267 | 3994 | 3740 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 4646 | 222 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 24287381 | 24287381 | PRJEB4632_P_NODE_1040_length_228_cov_2.948387_g1002_i0 | PRJEB4632 | 1040 | 228 | 2.948387 | 6.72232236 | Placocista sp. CC-Grouse Mountain | 741089 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 5.38e-38 | NTclustered | gi|290760485|gb|GQ144688.1| | 741089 | g1002 | i0 | 80.87 | 21.5350877192982 | 230 | 33 | 100 | 11 | 1 | 228 | 2373 | 2153 | Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence | blastn | 4910 | 171 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Placocista | Placocista sp. CC-Grouse Mountain |
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);;