contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA358049" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5502443 | 5502443 | PRJNA358049_S_NODE_8445_length_217_cov_1.589286_g8397_i0 | PRJNA358049 | 8445 | 217 | 1.589286 | 3.44875062 | Cercozoa sp. YPF501 | 552662 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.07e-54 | NTclustered | gi|220983376|dbj|AB453012.1| | 552662 | g8397 | i0 | 86.239 | 56.6820276497696 | 218 | 19 | 96 | 8 | 3 | 210 | 2730 | 2946 | Cercozoa sp. YPF501 gene for nuclear large subunit ribosomal RNA, partial sequence | blastn | 12300 | 226 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. YPF501 | ||||||
| 11276382 | 11276382 | PRJNA358049_S_NODE_3589_length_314_cov_10.343396_g3541_i0 | PRJNA358049 | 3589 | 314 | 10.343396 | 32.47826344 | Navicula | 50949 | SAR_Eukaryotes | SAR_Eukaryotes | 553 | 6.609999999999998e-153 | NTclustered | gi|18698478|gb|AF417679.1| | 186032 | g3541 | i0 | 98.408 | 99.7898089171974 | 314 | 5 | 100 | 0 | 1 | 314 | 351 | 38 | Navicula cf. erifuga strain Navicula large subunit ribosomal RNA gene, partial sequence | blastn | 31334 | 558 | 0.991039426523297 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Navicula | Navicula cf. erifuga | ||
| 15100914 | 15100914 | PRJNA358049_S_NODE_18772_length_161_cov_2.535714_g18724_i0 | PRJNA358049 | 18772 | 161 | 2.535714 | 4.08249954 | Fragilaria | 33644 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 2.04e-65 | NTclustered | gi|18698483|gb|AF417684.1| | 185980 | g18724 | i0 | 98 | 93.9192546583851 | 150 | 3 | 93 | 0 | 10 | 159 | 137 | 286 | Fragilaria capucina strain M1767 large subunit ribosomal RNA gene, partial sequence | blastn | 15121 | 261 | 1 | Eukaryota | Sar | Bacillariophyta | Fragilariophyceae | Fragilariales | Fragilariaceae | Fragilaria | Fragilaria capucina | ||
| 16375591 | 16375591 | PRJNA358049_S_NODE_14273_length_177_cov_1.898438_g14225_i0 | PRJNA358049 | 14273 | 177 | 1.898438 | 3.36023526 | Pseudovorticella | 310678 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 6.26e-76 | NTclustered | gi|2217167748|gb|ON157273.1| | 1892842 | g14225 | i0 | 98.225 | 95.3898305084746 | 169 | 3 | 95 | 0 | 1 | 169 | 339 | 171 | Pseudovorticella sp. isolate DP127 small subunit ribosomal RNA gene, partial sequence | blastn | 16884 | 296 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Pseudovorticella | Pseudovorticella sp. | ||
| 18250263 | 18250263 | PRJNA358049_S_NODE_17955_length_163_cov_1.807018_g17907_i0 | PRJNA358049 | 17955 | 163 | 1.807018 | 2.94543934 | Encyonema minutum | 431330 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 7.51e-60 | NTclustered | gi|168145881|emb|AM710515.1| | 431330 | g17907 | i0 | 97.857 | 69.4662576687117 | 140 | 3 | 86 | 0 | 15 | 154 | 474 | 335 | Encyonema minutum partial 28S rRNA gene, strain AT-137.13 | blastn | 11323 | 243 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Cymbellales | Cymbellaceae | Encyonema | Encyonema minutum | ||
| 18924590 | 18924590 | PRJNA358049_S_NODE_19155_length_153_cov_2.201923_g19107_i0 | PRJNA358049 | 19155 | 153 | 2.201923 | 3.36894219 | Sessilida | 1974272 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 1.93e-60 | NTclustered | gi|115353909|gb|DQ868349.1| | 404948 | g19107 | i0 | 95.484 | 100.647058823529 | 155 | 4 | 100 | 2 | 1 | 153 | 1448 | 1601 | Vorticella sp. JCC-2006-4 18S small subunit ribosomal RNA gene, partial sequence | blastn | 15399 | 244 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. JCC-2006-4 | ||
| 20800222 | 20800222 | PRJNA358049_S_NODE_4917_length_273_cov_9.196429_g4869_i0 | PRJNA358049 | 4917 | 273 | 9.196429 | 25.10625117 | Encyonema minutum | 431330 | SAR_Eukaryotes | SAR_Eukaryotes | 496 | 9.63e-136 | NTclustered | gi|168145881|emb|AM710515.1| | 431330 | g4869 | i0 | 99.631 | 99.7838827838828 | 271 | 1 | 99 | 0 | 3 | 273 | 27 | 297 | Encyonema minutum partial 28S rRNA gene, strain AT-137.13 | blastn | 27241 | 496 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Cymbellales | Cymbellaceae | Encyonema | Encyonema minutum | ||
| 22075358 | 22075358 | PRJNA358049_S_NODE_7498_length_228_cov_1.715084_g7450_i0 | PRJNA358049 | 7498 | 228 | 1.715084 | 3.91039152 | Pfiesteria-like sp. HR1SSeptA5 | 290075 | SAR_Eukaryotes | SAR_Eukaryotes | 416 | 6.259999999999998e-112 | NTclustered | gi|51847969|gb|AY590483.1| | 290075 | g7450 | i0 | 99.561 | 99.0964912280702 | 228 | 1 | 100 | 0 | 1 | 228 | 2700 | 2473 | Pfiesteria-like sp. HR1SSeptA5 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 | 22594 | 416 | 1 | Eukaryota | Sar | Dinophyceae | Peridiniales | Pfiesteriaceae | Pfiesteria-like sp. HR1SSeptA5 | ||||
| 24024866 | 24024866 | PRJNA358049_S_NODE_14979_length_173_cov_2.435484_g14931_i0 | PRJNA358049 | 14979 | 173 | 2.435484 | 4.21338732 | Naviculaceae | 67474 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 1.7e-71 | NTclustered | gi|2301268953|ref|NC_066075.1| | 355634 | g14931 | i0 | 100 | 173.28323699422 | 152 | 0 | 88 | 0 | 1 | 152 | 9969 | 9818 | Navicula arenaria isolate Jiaozhou Bay in China chloroplast, complete genome | blastn | 29978 | 281 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Navicula | Navicula arenaria | ||
| 24624964 | 24624964 | PRJNA358049_S_NODE_5000_length_271_cov_14.076577_g4952_i0 | PRJNA358049 | 5000 | 271 | 14.076577 | 38.14752367 | Pseudovorticella sp. FG-2015 | 1607895 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 3.4799999999999997e-125 | NTclustered | gi|759083559|gb|KM222176.1| | 1607895 | g4952 | i0 | 98.106 | 95.5387453874539 | 264 | 5 | 97 | 0 | 1 | 264 | 169 | 432 | Pseudovorticella sp. FG-2015 voucher SZ2010032108 large subunit ribosomal RNA gene, partial sequence | blastn | 25891 | 460 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Pseudovorticella | Pseudovorticella sp. FG-2015 |
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);;