contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA766854" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020990 | 2020990 | PRJNA766854_P_NODE_782_length_457_cov_4.242991_g672_i0 | PRJNA766854 | 782 | 457 | 4.242991 | 19.39046887 | Chlorellidium tetrabotrys | 243652 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 4.07e-62 | NTclustered | gi|223029651|gb|FJ030881.1| | 243652 | g672 | i0 | 95.541 | 632.571115973742 | 157 | 7 | 63 | 0 | 4 | 160 | 1570 | 1726 | Chlorellidium tetrabotrys strain SAG811-1 28S ribosomal RNA gene, partial sequence | blastn | 289085 | 252 | 1 | Eukaryota | Sar | Xanthophyceae | Mischococcales | Botryochloridaceae | Chlorellidium | Chlorellidium tetrabotrys | |||
| 2481406 | 2481406 | PRJNA766854_P_NODE_2042_length_299_cov_1.403704_g1916_i0 | PRJNA766854 | 2042 | 299 | 1.403704 | 4.19707496 | Sargassum | 3015 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.5999999999999999e-29 | NTclustered | gi|2307923332|ref|NC_066457.1| | 3016 | g1916 | i0 | 91.429 | 55.1939799331104 | 105 | 8 | 35 | 1 | 196 | 299 | 119279 | 119175 | Sargassum fulvellum chloroplast, complete genome | blastn | 16503 | 143 | 1 | Eukaryota | Sar | Phaeophyceae | Fucales | Sargassaceae | Sargassum | Sargassum fulvellum | |||
| 4573289 | 4573289 | PRJNA766854_P_NODE_664_length_485_cov_3.866228_g558_i0 | PRJNA766854 | 664 | 485 | 3.866228 | 18.7512058 | Botrydiopsis callosa | 240385 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 3.2399999999999997e-88 | NTclustered | gi|46019697|emb|AJ579340.1| | 240385 | g558 | i0 | 100 | 59.9505154639175 | 183 | 0 | 76 | 0 | 303 | 485 | 782 | 964 | Botrydiopsis callosa partial 18S rRNA gene, strain SAG 30.83 | blastn | 29076 | 339 | 1 | Eukaryota | Sar | Xanthophyceae | Mischococcales | Botrydiopsidaceae | Botrydiopsis | Botrydiopsis callosa | |||
| 7584014 | 7584014 | PRJNA766854_P_NODE_18606_length_216_cov_3.518717_g18479_i0 | PRJNA766854 | 18606 | 216 | 3.518717 | 7.60042872 | Rosculus | 373137 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 3.84e-49 | NTclustered | gi|1336609552|gb|MG859939.1| | 175275 | g18479 | i0 | 99.13 | 46.1296296296296 | 115 | 1 | 99 | 0 | 102 | 216 | 974 | 860 | Uncultured Cercozoa isolate 1_map+ small subunit ribosomal RNA gene, partial sequence | blastn | 9964 | 207 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 12224645 | 12224645 | PRJNA766854_P_NODE_790_length_455_cov_2.061033_g680_i0 | PRJNA766854 | 790 | 455 | 2.061033 | 9.37770015 | Chlorellidium tetrabotrys | 243652 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 4.05e-62 | NTclustered | gi|223029651|gb|FJ030881.1| | 243652 | g680 | i0 | 95.541 | 38.3868131868132 | 157 | 7 | 72 | 0 | 299 | 455 | 1570 | 1726 | Chlorellidium tetrabotrys strain SAG811-1 28S ribosomal RNA gene, partial sequence | blastn | 17466 | 252 | 1 | Eukaryota | Sar | Xanthophyceae | Mischococcales | Botryochloridaceae | Chlorellidium | Chlorellidium tetrabotrys | |||
| 12685594 | 12685594 | PRJNA766854_P_NODE_1570_length_331_cov_1.619205_g1445_i0 | PRJNA766854 | 1570 | 331 | 1.619205 | 5.35956855 | Hydruraceae | 98655 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 3.89e-26 | NTclustered | gi|219903754|emb|FM955257.1| | 2996 | g1445 | i0 | 97.403 | 4.26283987915408 | 77 | 2 | 23 | 0 | 194 | 270 | 3396 | 3320 | Hydrurus foetidus partial 28S rRNA gene | blastn | 1411 | 132 | 1 | Eukaryota | Sar | Chrysophyceae | Hydrurales | Hydruraceae | Hydrurus | Hydrurus foetidus | |||
| 23697920 | 23697920 | PRJNA766854_P_NODE_18779_length_172_cov_5.286713_g18652_i0 | PRJNA766854 | 18779 | 172 | 5.286713 | 9.09314636 | Rosculus sp. VDelafont-2023a | 3079709 | SAR_Eukaryotes | SAR_Eukaryotes | 182 | 1.76e-41 | NTclustered | gi|2589370978|gb|OR644361.1| | 3079709 | g18652 | i0 | 93.443 | 2.38372093023256 | 122 | 8 | 98 | 0 | 1 | 122 | 404 | 283 | Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence | blastn | 410 | 182 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. VDelafont-2023a |
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);;