contig_metadata
11 rows where bioproject = "PRJNA788929", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6318251 | 6318251 | PRJNA788929_P_NODE_26125_length_312_cov_8.589958_g25464_i0 | PRJNA788929 | 26125 | 312 | 8.589958 | 26.80066896 | Guttulinopsis | 1144921 | SAR_Eukaryotes | SAR_Eukaryotes | 494 | 4.03e-135 | NTclustered | gi|1402550487|gb|MH488773.1| | 2231167 | g25464 | i0 | 97.578 | 29.9102564102564 | 289 | 5 | 93 | 2 | 1 | 289 | 1284 | 998 | Guttulinopsis sp. isolate STA small subunit ribosomal RNA gene, partial sequence | blastn | 9332 | 494 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis sp. | ||||
| 8422581 | 8422581 | PRJNA788929_P_NODE_35647_length_260_cov_3.368984_g34986_i0 | PRJNA788929 | 35647 | 260 | 3.368984 | 8.7593584 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.94e-5 | NTclustered | gi|1767048364|dbj|LC490352.1| | 1928728 | g34986 | i0 | 95 | 0.307692307692308 | 40 | 1 | 15 | 1 | 183 | 221 | 12195 | 12234 | Paulinella micropora MYN1 mitochondrial DNA, complete sequence | blastn | 80 | 62.1 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 14798326 | 14798326 | PRJNA788929_P_NODE_6892_length_723_cov_32.861538_g6264_i0 | PRJNA788929 | 6892 | 723 | 32.861538 | 237.58891974 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 508 | 3.57e-139 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g6264 | i0 | 83.848 | 73.7053941908714 | 551 | 71 | 76 | 16 | 46 | 592 | 1400 | 864 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 53289 | 508 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 17792059 | 17792059 | PRJNA788929_P_NODE_4234_length_988_cov_85.463388_g3733_i0 | PRJNA788929 | 4234 | 988 | 85.463388 | 844.37827344 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 3.22e-81 | NTclustered | gi|2651357781|gb|PP174297.1| | 1979794 | g3733 | i0 | 77.436 | 40.7783400809717 | 585 | 96 | 63 | 27 | 182 | 752 | 3680 | 4242 | Cercomonas sp. isolate JGP16 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 | 40289 | 318 | 0.993710691823899 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. | |||
| 18621073 | 18621073 | PRJNA788929_P_NODE_43975_length_234_cov_7.260870_g43314_i0 | PRJNA788929 | 43975 | 234 | 7.26087 | 16.9904358 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 394 | 3.02e-105 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g43314 | i0 | 100 | 12.4316239316239 | 213 | 0 | 91 | 0 | 1 | 213 | 1363 | 1151 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 2909 | 394 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 22446468 | 22446468 | PRJNA788929_P_NODE_17118_length_401_cov_29.161585_g16459_i0 | PRJNA788929 | 17118 | 401 | 29.161585 | 116.93795585 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 1.5699999999999999e-90 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g16459 | i0 | 83.636 | 33.8628428927681 | 385 | 45 | 95 | 14 | 1 | 379 | 2569 | 2197 | Rosculus vulgaris isolate CCA sequence | blastn | 13579 | 346 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris | ||||
| 22446632 | 22446632 | PRJNA788929_P_NODE_27758_length_301_cov_17.048246_g27097_i0 | PRJNA788929 | 27758 | 301 | 17.048246 | 51.31522046 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 2.5e-82 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g27097 | i0 | 87.063 | 56.3388704318937 | 286 | 31 | 93 | 3 | 22 | 301 | 1610 | 1895 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 16958 | 318 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 23722081 | 23722081 | PRJNA788929_P_NODE_23959_length_328_cov_19.941176_g23298_i0 | PRJNA788929 | 23959 | 328 | 19.941176 | 65.40705728 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.36e-40 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g23298 | i0 | 86.957 | 49.0091463414634 | 161 | 19 | 49 | 2 | 41 | 201 | 3694 | 3852 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 16075 | 180 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 25440989 | 25440989 | PRJNA788929_P_NODE_30680_length_284_cov_10.630332_g30019_i0 | PRJNA788929 | 30680 | 284 | 10.630332 | 30.19014288 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 2.53e-27 | NTclustered | gi|2915662207|gb|PV134975.1| | 1821257 | g30019 | i0 | 85.385 | 12.9577464788732 | 130 | 19 | 46 | 0 | 130 | 259 | 6273 | 6144 | Uncultured Endomyxa isolate IOM_2014_45 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 | 3680 | 135 | 1 | Eukaryota | Sar | Cercozoa | uncultured Endomyxa | ||||||
| 28948738 | 28948738 | PRJNA788929_P_NODE_7608_length_677_cov_31.930464_g6967_i0 | PRJNA788929 | 7608 | 677 | 31.930464 | 216.16924128 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 2.28e-39 | NR | AAT09077.1 | 227086 | g6967 | i0 | 61.6 | 0.496307237813885 | 112 | 43 | 49.6 | 0 | 669 | 334 | 42 | 153 | AAT09077.1 transcription factor BTF3 [Bigelowiella natans] | diamond | 336 | 143 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 30780389 | 30780389 | PRJNA788929_P_NODE_46674_length_219_cov_10.061644_g46013_i0 | PRJNA788929 | 46674 | 219 | 10.061644 | 22.03500036 | Lotharella oceanica | 641309 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 2.61e-10 | NR | AIB09582.1 | 641309 | g46013 | i0 | 59.2 | 0.671232876712329 | 49 | 20 | 67.1 | 0 | 196 | 50 | 6 | 54 | AIB09582.1 hypothetical protein M951_chr1100 [Lotharella oceanica] | diamond | 147 | 60.5 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Lotharella | Lotharella oceanica |
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);;