contig_metadata
16 rows where bioproject = "PRJNA724039", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1987169 | 1987169 | PRJNA724039_S_NODE_18162_length_150_cov_1.353982_g17955_i0 | PRJNA724039 | 18162 | 150 | 1.353982 | 2.030973 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 3.23e-38 | NTclustered | gi|238617604|gb|FJ973379.1| | 646463 | g17955 | i0 | 86.875 | 71.0466666666667 | 160 | 11 | 100 | 4 | 1 | 150 | 1849 | 1690 | Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence | blastn | 10657 | 171 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 2469454 | 2469454 | PRJNA724039_S_NODE_1382_length_690_cov_5.545176_g1215_i0 | PRJNA724039 | 1382 | 690 | 5.545176 | 38.2617144 | Cercozoa sp. DMV | 1342330 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.7199999999999995e-118 | NR | BAN37425.1 | 1342330 | g1215 | i0 | 73.7 | 2.92173913043478 | 224 | 59 | 97.4 | 0 | 1 | 672 | 204 | 427 | BAN37425.1 elongation factor 1-alpha [Cercozoa sp. DMV] | diamond | 2016 | 355 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. DMV | ||||||
| 3262404 | 3262404 | PRJNA724039_S_NODE_15403_length_162_cov_4.392000_g15196_i0 | PRJNA724039 | 15403 | 162 | 4.392 | 7.11504 | Rosculus piscicus | 2231164 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 2.74e-44 | NTclustered | gi|1402550472|gb|MH488758.1| | 2231164 | g15196 | i0 | 95.763 | 6.55555555555556 | 118 | 5 | 73 | 0 | 1 | 118 | 1015 | 898 | Rosculus piscicus isolate GS5C small subunit ribosomal RNA gene, partial sequence | blastn | 1062 | 191 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus piscicus | ||||
| 3745983 | 3745983 | PRJNA724039_S_NODE_963_length_898_cov_10.746806_g831_i0 | PRJNA724039 | 963 | 898 | 10.746806 | 96.50631788 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 8.69e-32 | NTclustered | gi|1315527750|gb|MF034900.1| | 2065209 | g831 | i0 | 90.517 | 14.1236080178174 | 116 | 9 | 13 | 2 | 161 | 275 | 8288 | 8174 | Phytocercomonas venanatans 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 12683 | 152 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Phytocercomonas | Phytocercomonas venanatans | |||
| 4539507 | 4539507 | PRJNA724039_S_NODE_16704_length_156_cov_1.546218_g16497_i0 | PRJNA724039 | 16704 | 156 | 1.546218 | 2.41210008 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 9.059999999999999e-69 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g16497 | i0 | 98.077 | 81.7435897435897 | 156 | 3 | 100 | 0 | 1 | 156 | 1443 | 1288 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 12752 | 272 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 6298192 | 6298192 | PRJNA724039_S_NODE_1685_length_607_cov_34.082456_g1506_i0 | PRJNA724039 | 1685 | 607 | 34.082456 | 206.88050792 | Cercomonadida | 188941 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 9.57e-35 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g1506 | i0 | 92.241 | 19.1070840197694 | 116 | 6 | 19 | 3 | 413 | 527 | 1917 | 2030 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 11598 | 161 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 7571991 | 7571991 | PRJNA724039_S_NODE_16926_length_155_cov_1.711864_g16719_i0 | PRJNA724039 | 16926 | 155 | 1.711864 | 2.6533892 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 4.55e-7 | NTclustered | gi|1270185586|gb|MG266087.1| | 175275 | g16719 | i0 | 97.5 | 7.8 | 40 | 0 | 25 | 1 | 22 | 60 | 608 | 569 | Uncultured Cercozoa clone MossITSLSU910 large subunit ribosomal RNA gene, partial sequence | blastn | 1209 | 67.6 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 8364331 | 8364331 | PRJNA724039_S_NODE_10507_length_200_cov_0.914110_g10300_i0 | PRJNA724039 | 10507 | 200 | 0.91411 | 1.82822 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 7.59e-46 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g10300 | i0 | 89.677 | 39.81 | 155 | 14 | 77 | 2 | 47 | 200 | 3873 | 3720 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 7962 | 196 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 9639620 | 9639620 | PRJNA724039_S_NODE_17008_length_155_cov_0.974576_g16801_i0 | PRJNA724039 | 17008 | 155 | 0.974576 | 1.5105928 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 1.21e-37 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g16801 | i0 | 86.842 | 97.8258064516129 | 152 | 18 | 97 | 2 | 5 | 155 | 3701 | 3851 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 15163 | 169 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 10915142 | 10915142 | PRJNA724039_S_NODE_13749_length_172_cov_3.488889_g13542_i0 | PRJNA724039 | 13749 | 172 | 3.488889 | 6.00088908 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 1.42e-12 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g13542 | i0 | 88.571 | 0.406976744186047 | 70 | 8 | 41 | 0 | 44 | 113 | 4021 | 3952 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 70 | 86.1 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 10915335 | 10915335 | PRJNA724039_S_NODE_7629_length_241_cov_8.426471_g7422_i0 | PRJNA724039 | 7629 | 241 | 8.426471 | 20.30779511 | Rosculus sp. VDelafont-2023a | 3079709 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 1.1499999999999999e-89 | NTclustered | gi|2589370978|gb|OR644361.1| | 3079709 | g7422 | i0 | 92.5 | 5.12863070539419 | 240 | 17 | 99 | 1 | 1 | 239 | 41 | 280 | Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence | blastn | 1236 | 342 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. VDelafont-2023a | ||||
| 19045888 | 19045888 | PRJNA724039_S_NODE_10895_length_195_cov_10.373418_g10688_i0 | PRJNA724039 | 10895 | 195 | 10.373418 | 20.2281651 | Rosculus | 373137 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 1.5e-82 | NTclustered | gi|1336609552|gb|MG859939.1| | 175275 | g10688 | i0 | 100 | 54.4153846153846 | 172 | 0 | 88 | 0 | 24 | 195 | 1033 | 862 | Uncultured Cercozoa isolate 1_map+ small subunit ribosomal RNA gene, partial sequence | blastn | 10611 | 318 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 19838108 | 19838108 | PRJNA724039_S_NODE_3196_length_408_cov_6.741240_g2989_i0 | PRJNA724039 | 3196 | 408 | 6.74124 | 27.5042592 | Rosculus sp. VDelafont-2023a | 3079709 | SAR_Eukaryotes | SAR_Eukaryotes | 479 | 1.5199999999999996e-130 | NTclustered | gi|2589370978|gb|OR644361.1| | 3079709 | g2989 | i0 | 88.119 | 17.5171568627451 | 404 | 46 | 99 | 2 | 6 | 408 | 259 | 661 | Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence | blastn | 7147 | 479 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. VDelafont-2023a | ||||
| 24937644 | 24937644 | PRJNA724039_S_NODE_17120_length_154_cov_1.923077_g16913_i0 | PRJNA724039 | 17120 | 154 | 1.923077 | 2.96153858 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.2099999999999999e-32 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g16913 | i0 | 87.786 | 10.7922077922078 | 131 | 14 | 84 | 2 | 23 | 152 | 2394 | 2523 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 1662 | 152 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 27621035 | 27621035 | PRJNA724039_S_NODE_3464_length_390_cov_2.371105_g3257_i0 | PRJNA724039 | 3464 | 390 | 2.371105 | 9.2473095 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 4.35e-31 | NR | ADK47156.1 | 323453 | g3257 | i0 | 100 | 0.438461538461538 | 57 | 0 | 43.8 | 0 | 389 | 219 | 89 | 145 | ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] | diamond | 171 | 118 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 32518611 | 32518611 | PRJNA724039_S_NODE_8399_length_228_cov_2.340314_g8192_i0 | PRJNA724039 | 8399 | 228 | 2.340314 | 5.33591592 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 6.4e-44 | NR | ADK26622.1 | 323453 | g8192 | i0 | 93.3 | 0.986842105263158 | 75 | 5 | 98.7 | 0 | 226 | 2 | 46 | 120 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 225 | 147 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 |
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);;