contig_metadata
15 rows where bioproject = "PRJNA768450" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 746122 | 746122 | PRJNA768450_S_NODE_761_length_600_cov_3.165154_g723_i0 | PRJNA768450 | 761 | 600 | 3.165154 | 18.990924 | Nitzschia anatoliensis | 2862141 | SAR_Eukaryotes | SAR_Eukaryotes | 867 | 0 | NTclustered | gi|2072715385|gb|MT740317.1| | 2862141 | g723 | i0 | 94.211 | 90.1316666666667 | 570 | 29 | 95 | 4 | 1 | 568 | 6080 | 5513 | Nitzschia anatoliensis clone SZCZ E372 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 | 54079 | 867 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Nitzschia | Nitzschia anatoliensis | ||
| 3758071 | 3758071 | PRJNA768450_S_NODE_3103_length_349_cov_6.426667_g3054_i0 | PRJNA768450 | 3103 | 349 | 6.426667 | 22.42906783 | Bacillariophyta | 2836 | SAR_Eukaryotes | SAR_Eukaryotes | 640 | 5.529999999999999e-179 | NTclustered | gi|1134427466|gb|KX229689.1| | 44446 | g3054 | i0 | 99.713 | 100.022922636103 | 349 | 1 | 100 | 0 | 1 | 349 | 9 | 357 | Pseudo-nitzschia americana strain UNC1412 18S ribosomal RNA gene, partial sequence | blastn | 34908 | 645 | 0.992248062015504 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Pseudo-nitzschia | Pseudo-nitzschia americana | ||
| 9674034 | 9674034 | PRJNA768450_S_NODE_16628_length_182_cov_3.992481_g16579_i0 | PRJNA768450 | 16628 | 182 | 3.992481 | 7.26631542 | Nitzschia sp. (in: diatoms) | 1884248 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 5.01e-77 | NTclustered | gi|2632235302|gb|OR922684.1| | 1884248 | g16579 | i0 | 100 | 89.4395604395604 | 162 | 0 | 89 | 0 | 1 | 162 | 2973 | 2812 | Nitzschia sp. (in: diatoms) strain AGSB0041 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 | 16278 | 300 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Nitzschia | Nitzschia sp. (in: diatoms) | ||
| 10134775 | 10134775 | PRJNA768450_S_NODE_16128_length_184_cov_4.066667_g16079_i0 | PRJNA768450 | 16128 | 184 | 4.066667 | 7.48266728 | Bacillariaceae | 33852 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 3.0300000000000004e-79 | NTclustered | gi|2202538963|gb|OM891869.1| | 2856 | g16079 | i0 | 100 | 90.0489130434783 | 166 | 0 | 90 | 0 | 1 | 166 | 3618 | 3453 | Cylindrotheca closterium 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 | 16569 | 307 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Cylindrotheca | Cylindrotheca closterium | ||
| 12225063 | 12225063 | PRJNA768450_S_NODE_12070_length_206_cov_0.910828_g12021_i0 | PRJNA768450 | 12070 | 206 | 0.910828 | 1.87630568 | Phaeodactylum tricornutum | 2850 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 2.93e-20 | NTclustered | gi|219123891|ref|XM_002182214.1| | 556484 | g12021 | i0 | 85.714 | 1.01941747572816 | 105 | 15 | 51 | 0 | 35 | 139 | 425 | 321 | Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA | blastn | 210 | 111 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Phaeodactylaceae | Phaeodactylum | Phaeodactylum tricornutum | ||
| 16047995 | 16047995 | PRJNA768450_S_NODE_12253_length_204_cov_9.916129_g12204_i0 | PRJNA768450 | 12253 | 204 | 9.916129 | 20.22890316 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 1.59e-82 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g12204 | i0 | 97.34 | 79.9019607843137 | 188 | 4 | 92 | 1 | 4 | 190 | 17680 | 17493 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 16300 | 318 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 16048345 | 16048345 | PRJNA768450_S_NODE_21253_length_166_cov_3.000000_g21204_i0 | PRJNA768450 | 21253 | 166 | 3 | 4.98 | Leukarachnion sp. ATCC PRA-24 | 568390 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 1.7199999999999995e-31 | NTclustered | gi|2727570083|gb|PP760457.1| | 568390 | g21204 | i0 | 88.525 | 3.6566265060241 | 122 | 14 | 73 | 0 | 12 | 133 | 2355 | 2476 | Leukarachnion sp. ATCC PRA-24 culture ATCC:BJ-24B2 mitochondrion, complete genome | blastn | 607 | 148 | 1 | Eukaryota | Sar | Leukarachnion sp. ATCC PRA-24 | |||||||
| 16048552 | 16048552 | PRJNA768450_S_NODE_3613_length_328_cov_7.390681_g3564_i0 | PRJNA768450 | 3613 | 328 | 7.390681 | 24.24143368 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 534 | 2.51e-147 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g3564 | i0 | 99.322 | 56.9085365853659 | 295 | 2 | 90 | 0 | 2 | 296 | 15828 | 15534 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 18666 | 534 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 17323977 | 17323977 | PRJNA768450_S_NODE_18434_length_175_cov_12.642857_g18385_i0 | PRJNA768450 | 18434 | 175 | 12.642857 | 22.12499975 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 6.13e-81 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g18385 | i0 | 99.419 | 54.44 | 172 | 1 | 98 | 0 | 1 | 172 | 15840 | 16011 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 9527 | 313 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 18597083 | 18597083 | PRJNA768450_S_NODE_1055_length_535_cov_4.777778_g1012_i0 | PRJNA768450 | 1055 | 535 | 4.777778 | 25.5611123 | Protohalopteris sp. | 2843287 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 6.65e-16 | NTclustered | gi|2049952236|gb|MZ156028.1| | 2843287 | g1012 | i0 | 83.636 | 18.803738317757 | 110 | 13 | 20 | 4 | 112 | 219 | 3061 | 3167 | Protohalopteris sp. plastid, complete genome | blastn | 10060 | 99 | 1 | Eukaryota | Sar | Phaeophyceae | Sphacelariales | Stypocaulaceae | Protohalopteris | Protohalopteris sp. | |||
| 19872548 | 19872548 | PRJNA768450_S_NODE_21536_length_166_cov_1.128205_g21487_i0 | PRJNA768450 | 21536 | 166 | 1.128205 | 1.8728203 | Rhoicosphenia cf. abbreviata EWT-2016 | 1827007 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 1.2500000000000001e-77 | NTclustered | gi|1016106667|gb|KU965576.1| | 1827007 | g21487 | i0 | 99.398 | 51.3674698795181 | 166 | 1 | 100 | 0 | 1 | 166 | 298 | 133 | Rhoicosphenia cf. abbreviata EWT-2016 isolate 94_LSU large subunit ribosomal RNA gene, partial sequence | blastn | 8527 | 302 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Cymbellales | Rhoicospheniaceae | Rhoicosphenia | Rhoicosphenia cf. abbreviata EWT-2016 | ||
| 20332650 | 20332650 | PRJNA768450_S_NODE_20456_length_169_cov_0.858333_g20407_i0 | PRJNA768450 | 20456 | 169 | 0.858333 | 1.45058277 | root | 1 | Root_unresolved | Root_unresolved | 279 | 5.95e-71 | NTclustered | gi|345541658|gb|JN547815.1| | 5911 | g20407 | i0 | 97.006 | 40.1715976331361 | 167 | 4 | 99 | 1 | 1 | 167 | 2441 | 2276 | Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence | blastn | 6789 | 279 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 22422794 | 22422794 | PRJNA768450_S_NODE_14658_length_191_cov_2.873239_g14609_i0 | PRJNA768450 | 14658 | 191 | 2.873239 | 5.48788649 | Nitzschia anatoliensis | 2862141 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 8.95e-70 | NTclustered | gi|2072715385|gb|MT740317.1| | 2862141 | g14609 | i0 | 96.951 | 38.979057591623 | 164 | 5 | 86 | 0 | 28 | 191 | 7080 | 7243 | Nitzschia anatoliensis clone SZCZ E372 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 | 7445 | 276 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Nitzschia | Nitzschia anatoliensis | ||
| 22423473 | 22423473 | PRJNA768450_S_NODE_8818_length_231_cov_1279.412088_g8769_i0 | PRJNA768450 | 8818 | 231 | 1279.412088 | 2955.44192328 | Spongosphaera streptacantha | 1329067 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 1.17e-44 | NTclustered | gi|1862625731|gb|MT670490.1| | 1329067 | g8769 | i0 | 87.5 | 65.4848484848485 | 168 | 20 | 72 | 1 | 50 | 216 | 514 | 347 | Spongosphaera streptacantha voucher Mge17-82 small subunit ribosomal RNA gene, partial sequence | blastn | 15127 | 193 | 1 | Eukaryota | Sar | Polycystinea | Spumellaria | Actinommidae | Spongosphaera | Spongosphaera streptacantha | |||
| 24972447 | 24972447 | PRJNA768450_S_NODE_23520_length_162_cov_1.327434_g23471_i0 | PRJNA768450 | 23520 | 162 | 1.327434 | 2.15044308 | Proschkinia sp. SZCZR1824 | 2588390 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 3.72e-8 | NTclustered | gi|1681061561|gb|MH800316.1| | 2588390 | g23471 | i0 | 77.966 | 0.728395061728395 | 118 | 22 | 72 | 4 | 44 | 160 | 4566 | 4452 | Proschkinia sp. SZCZR1824 mitochondrion, complete genome | blastn | 118 | 71.3 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Proschkiniaceae | Proschkinia | Proschkinia sp. SZCZR1824 |
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);;