contig_metadata
10 rows where bioproject = "PRJNA704949", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 701065 | 701065 | PRJNA704949_P_NODE_82161_length_854_cov_6.648447_g70237_i0 | PRJNA704949 | 82161 | 854 | 6.648447 | 56.77773738 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 1437 | 0 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g70237 | i0 | 96.977 | 32.5749414519906 | 860 | 18 | 100 | 8 | 1 | 854 | 685 | 1542 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 27819 | 1437 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 7077427 | 7077427 | PRJNA704949_P_NODE_555206_length_365_cov_1.791139_g539897_i0 | PRJNA704949 | 555206 | 365 | 1.791139 | 6.53765735 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 638 | 2.0899999999999996e-178 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g539897 | i0 | 100 | 4.67123287671233 | 345 | 0 | 95 | 0 | 1 | 345 | 559 | 215 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 1705 | 638 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 8341820 | 8341820 | PRJNA704949_P_NODE_133087_length_695_cov_2.902477_g119927_i0 | PRJNA704949 | 133087 | 695 | 2.902477 | 20.17221515 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 514 | 7.36e-141 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g119927 | i0 | 81.324 | 29.0690647482014 | 680 | 86 | 96 | 30 | 1 | 669 | 2218 | 2867 | Rosculus vulgaris isolate CCA sequence | blastn | 20203 | 514 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris | ||||
| 11390940 | 11390940 | PRJNA704949_P_NODE_1759649_length_180_cov_1.984733_g1744310_i0 | PRJNA704949 | 1759649 | 180 | 1.984733 | 3.5725194 | Cercomonadidae | 45108 | SAR_Eukaryotes | SAR_Eukaryotes | 333 | 4.87e-87 | NTclustered | gi|1002343613|gb|KU738491.1| | 175275 | g1744310 | i0 | 100 | 98.3277777777778 | 180 | 0 | 100 | 0 | 1 | 180 | 45 | 224 | Uncultured Cercozoa clone OTU_433 18S ribosomal RNA gene, partial sequence | blastn | 17699 | 333 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 12665179 | 12665179 | PRJNA704949_P_NODE_1166470_length_236_cov_2.037433_g1151133_i0 | PRJNA704949 | 1166470 | 236 | 2.037433 | 4.80834188 | Imbricatea | 1736114 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 9.37e-36 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g1151133 | i0 | 80.365 | 37.6525423728814 | 219 | 39 | 92 | 4 | 21 | 236 | 2097 | 2314 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 8886 | 163 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 13940919 | 13940919 | PRJNA704949_P_NODE_1634711_length_190_cov_1.191489_g1619372_i0 | PRJNA704949 | 1634711 | 190 | 1.191489 | 2.2638291 | Cercomonas | 45109 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 5.24e-82 | NTclustered | gi|88792584|gb|DQ386165.1| | 372078 | g1619372 | i0 | 100 | 90.021052631579 | 171 | 0 | 90 | 0 | 1 | 171 | 2933 | 2763 | Cercomonas sp. C59 28S ribosomal RNA gene, partial sequence | blastn | 17104 | 316 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. C59 | |||
| 14720649 | 14720649 | PRJNA704949_P_NODE_1712192_length_184_cov_1.370370_g1696853_i0 | PRJNA704949 | 1712192 | 184 | 1.37037 | 2.5214808 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 8.490000000000001e-75 | NTclustered | gi|219524907|gb|EU709270.1| | 175275 | g1696853 | i0 | 95.161 | 100.065217391304 | 186 | 7 | 100 | 1 | 1 | 184 | 226 | 41 | Uncultured cercozoan isolate AH47p81p118t33 18S ribosomal RNA gene, partial sequence | blastn | 18412 | 292 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 15216457 | 15216457 | PRJNA704949_P_NODE_1953112_length_168_cov_1.747899_g1937773_i0 | PRJNA704949 | 1953112 | 168 | 1.747899 | 2.93647032 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 2.11e-80 | NTclustered | gi|33309623|gb|AF411268.1| | 188953 | g1937773 | i0 | 100 | 100 | 168 | 0 | 100 | 0 | 1 | 168 | 1649 | 1482 | Cercomonas plasmodialis 18S ribosomal RNA gene, complete sequence | blastn | 16800 | 311 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas plasmodialis | |||
| 17280547 | 17280547 | PRJNA704949_P_NODE_987874_length_262_cov_1.807512_g972539_i0 | PRJNA704949 | 987874 | 262 | 1.807512 | 4.73568144 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 3.5199999999999992e-90 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g972539 | i0 | 91.304 | 95.3320610687023 | 253 | 20 | 96 | 2 | 1 | 252 | 1322 | 1573 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 24977 | 344 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 27347108 | 27347108 | PRJNA704949_P_NODE_687943_length_325_cov_1.695652_g672615_i0 | PRJNA704949 | 687943 | 325 | 1.695652 | 5.510869 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.4e-43 | NR | ACF24562.1 | 67809 | g672615 | i0 | 69.2 | 2.98153846153846 | 104 | 32 | 96 | 0 | 323 | 12 | 112 | 215 | ACF24562.1 proteasome alpha 5 subunit [Gymnochlora stellata] | diamond | 969 | 152 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Gymnochlora | Gymnochlora stellata |
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);;