contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA577580" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 564079 | 564079 | PRJNA577580_P_NODE_1641_length_708_cov_6.151181_g1567_i0 | PRJNA577580 | 1641 | 708 | 6.151181 | 43.55036148 | Placocista sp. CC-Grouse Mountain | 741089 | SAR_Eukaryotes | SAR_Eukaryotes | 968 | 0 | NTclustered | gi|290760485|gb|GQ144688.1| | 741089 | g1567 | i0 | 91.48 | 73.6271186440678 | 716 | 44 | 100 | 15 | 1 | 708 | 1646 | 2352 | Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence | blastn | 52128 | 968 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Placocista | Placocista sp. CC-Grouse Mountain | ||
| 4391464 | 4391464 | PRJNA577580_P_NODE_12324_length_264_cov_1.518325_g12246_i0 | PRJNA577580 | 12324 | 264 | 1.518325 | 4.008378 | uncultured Euglyphidae sp. | 1764557 | SAR_Eukaryotes | SAR_Eukaryotes | 477 | 3.359999999999999e-130 | NTclustered | gi|959360330|gb|KT272503.1| | 1764557 | g12246 | i0 | 99.242 | 100.003787878788 | 264 | 2 | 100 | 0 | 1 | 264 | 541 | 804 | Uncultured Euglyphidae sp. clone CM2_2_4 18S ribosomal RNA gene, partial sequence | blastn | 26401 | 477 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | uncultured Euglyphidae sp. | |||
| 4391530 | 4391530 | PRJNA577580_P_NODE_5204_length_392_cov_3.727273_g5126_i0 | PRJNA577580 | 5204 | 392 | 3.727273 | 14.61091016 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 719 | 0 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g5126 | i0 | 99.745 | 100.65306122449 | 392 | 1 | 100 | 0 | 1 | 392 | 1555 | 1946 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 39456 | 719 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 5667735 | 5667735 | PRJNA577580_P_NODE_16965_length_230_cov_3.477707_g16887_i0 | PRJNA577580 | 16965 | 230 | 3.477707 | 7.9987261 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 1.07e-104 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g16887 | i0 | 97.391 | 51.095652173913 | 230 | 6 | 100 | 0 | 1 | 230 | 1967 | 2196 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 11752 | 392 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 5667743 | 5667743 | PRJNA577580_P_NODE_1885_length_662_cov_3.073005_g1810_i0 | PRJNA577580 | 1885 | 662 | 3.073005 | 20.3432931 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 7.61e-81 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g1810 | i0 | 83.427 | 34.9033232628399 | 356 | 42 | 94 | 12 | 1 | 355 | 3655 | 3994 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 23106 | 315 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 18415973 | 18415973 | PRJNA577580_P_NODE_6075_length_364_cov_3.859107_g5997_i0 | PRJNA577580 | 6075 | 364 | 3.859107 | 14.04714948 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 510 | 4.74e-140 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g5997 | i0 | 91.848 | 1.15934065934066 | 368 | 26 | 100 | 4 | 1 | 364 | 17656 | 18023 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 422 | 510 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 20264628 | 20264628 | PRJNA577580_P_NODE_14556_length_249_cov_0.886364_g14478_i0 | PRJNA577580 | 14556 | 249 | 0.886364 | 2.20704636 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 5.919999999999998e-43 | NTclustered | gi|33089911|gb|AY283754.1| | 238774 | g14478 | i0 | 81.858 | 64.9076305220884 | 226 | 37 | 90 | 4 | 1 | 224 | 271 | 494 | Clathrulina elegans isolate Cla70_1 actin mRNA, partial cds | blastn | 16162 | 187 | 1 | Eukaryota | Sar | Cercozoa | Clathrulinidae | Clathrulina | Clathrulina elegans | ||||
| 24790202 | 24790202 | PRJNA577580_P_NODE_5580_length_379_cov_1.424837_g5502_i0 | PRJNA577580 | 5580 | 379 | 1.424837 | 5.40013223 | Mesofila limnetica | 1979842 | SAR_Eukaryotes | SAR_Eukaryotes | 560 | 4.85e-155 | NTclustered | gi|88792585|gb|DQ386166.1| | 1979842 | g5502 | i0 | 93.931 | 77.9709762532981 | 379 | 9 | 100 | 8 | 1 | 379 | 1857 | 1493 | Dimorpha-like sp. ATCC 50522 28S ribosomal RNA gene, partial sequence | blastn | 29551 | 560 | 1 | Eukaryota | Sar | Cercozoa | Mesofilidae | Mesofila | Mesofila limnetica |
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);;