contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA715462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3256910 | 3256910 | PRJNA715462_P_NODE_23983_length_370_cov_1.269360_g23187_i0 | PRJNA715462 | 23983 | 370 | 1.26936 | 4.696632 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 8.669999999999998e-88 | NTclustered | gi|116222176|gb|DQ980464.1| | 407209 | g23187 | i0 | 83.155 | 97.6567567567568 | 374 | 58 | 100 | 5 | 1 | 370 | 1012 | 640 | Thaumatomonas sp. TMT002 Hsp90 mRNA, partial cds | blastn | 36133 | 337 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 9634304 | 9634304 | PRJNA715462_P_NODE_32368_length_312_cov_1.334728_g31572_i0 | PRJNA715462 | 32368 | 312 | 1.334728 | 4.16435136 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.9e-123 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g31572 | i0 | 94 | 87.775641025641 | 300 | 18 | 96 | 0 | 13 | 312 | 397 | 98 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 27386 | 455 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 9634470 | 9634470 | PRJNA715462_P_NODE_40568_length_279_cov_1.495146_g39772_i0 | PRJNA715462 | 40568 | 279 | 1.495146 | 4.17145734 | Paulinella chromatophora | 39717 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 8.310000000000001e-77 | NTclustered | gi|302563026|dbj|AB546336.1| | 39717 | g39772 | i0 | 86.022 | 81.5770609318996 | 279 | 37 | 99 | 2 | 1 | 278 | 232 | 509 | Paulinella chromatophora EF-1a mRNA for elongation factor 1alpha, partial cds | blastn | 22760 | 300 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella chromatophora | ||
| 13460255 | 13460255 | PRJNA715462_P_NODE_7971_length_795_cov_2.923823_g7247_i0 | PRJNA715462 | 7971 | 795 | 2.923823 | 23.24439285 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 998 | 0 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g7247 | i0 | 94.969 | 82.6729559748428 | 636 | 32 | 80 | 0 | 160 | 795 | 765 | 130 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 65725 | 998 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 16008664 | 16008664 | PRJNA715462_P_NODE_46873_length_261_cov_0.920213_g46077_i0 | PRJNA715462 | 46873 | 261 | 0.920213 | 2.40175593 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.31e-64 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g46077 | i0 | 86.122 | 80.6973180076628 | 245 | 28 | 92 | 6 | 21 | 261 | 3901 | 3659 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 21062 | 259 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 16495140 | 16495140 | PRJNA715462_P_NODE_23233_length_377_cov_1.115132_g22437_i0 | PRJNA715462 | 23233 | 377 | 1.115132 | 4.20404764 | Verrucomonas | 2545269 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 4.36e-46 | NTclustered | gi|290760488|gb|GQ144691.1| | 629763 | g22437 | i0 | 81.633 | 55.3660477453581 | 245 | 39 | 64 | 6 | 135 | 377 | 1487 | 1247 | Cercozoa sp. CC-2009e large subunit ribosomal RNA gene, partial sequence | blastn | 20873 | 200 | 0.99 | Eukaryota | Sar | Cercozoa | Thecofilosea | Ventricleftida | Verrucomonas | Verrucomonas bifida | |||
| 17283847 | 17283847 | PRJNA715462_P_NODE_33794_length_304_cov_2.099567_g32998_i0 | PRJNA715462 | 33794 | 304 | 2.099567 | 6.38268368 | Cercomonas agilis | 310805 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 3.27e-81 | NTclustered | gi|58414956|gb|AY748813.1| | 310805 | g32998 | i0 | 86.62 | 150.542763157895 | 284 | 38 | 93 | 0 | 1 | 284 | 284 | 1 | Cercomonas agilis polyubiquitin (UBQ) gene, partial cds | blastn | 45765 | 315 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas agilis | |||
| 23659030 | 23659030 | PRJNA715462_P_NODE_42439_length_273_cov_2.230000_g41643_i0 | PRJNA715462 | 42439 | 273 | 2.23 | 6.0879 | Capsellina sp. ATCC 50039 | 862254 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 2.92e-76 | NTclustered | gi|300676756|gb|GQ377681.1| | 862254 | g41643 | i0 | 86.842 | 87.2490842490842 | 266 | 35 | 97 | 0 | 7 | 272 | 772 | 507 | Capsellina sp. ATCC 50039 actin gene, partial cds | blastn | 23819 | 298 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Cryomonadida | Rhogostomidae | Capsellina | Capsellina sp. ATCC 50039 | ||
| 24932537 | 24932537 | PRJNA715462_P_NODE_4200_length_1237_cov_5.766323_g3684_i0 | PRJNA715462 | 4200 | 1237 | 5.766323 | 71.32941551 | Viridiuvalis adhaerens | 1977046 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 3.32e-42 | NTclustered | gi|1248454657|dbj|LC229572.1| | 1977046 | g3684 | i0 | 80.303 | 11.0549717057397 | 264 | 38 | 30 | 11 | 1 | 258 | 810 | 1065 | Viridiuvalis adhaerens gene for 28S ribosomal RNA, partial sequence | blastn | 13675 | 187 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Viridiuvalis | Viridiuvalis adhaerens |
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);;