contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA772154" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12227338 | 12227338 | PRJNA772154_P_NODE_9250_length_379_cov_1.326797_g9065_i0 | PRJNA772154 | 9250 | 379 | 1.326797 | 5.02856063 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 9.29e-58 | NTclustered | gi|829192616|ref|XM_001029813.3| | 312017 | g9065 | i0 | 78.378 | 2.85751978891821 | 370 | 76 | 97 | 4 | 3 | 370 | 1 | 368 | Tetrahymena thermophila SB210 60S ribosomal protein L15 partial mRNA | blastn | 1083 | 237 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 15235328 | 15235328 | PRJNA772154_P_NODE_23172_length_219_cov_2.390411_g22987_i0 | PRJNA772154 | 23172 | 219 | 2.390411 | 5.23500009 | Globigerinidae | 45998 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 2.29e-66 | NTclustered | gi|406781098|gb|JQ004156.1| | 45991 | g22987 | i0 | 100 | 69.8538812785388 | 143 | 0 | 87 | 0 | 27 | 169 | 405 | 263 | Globigerinoides sacculifer isolate AO0154 18S ribosomal RNA gene, partial sequence | blastn | 15298 | 265 | 1 | Eukaryota | Sar | Foraminifera | Rotaliida | Globigerinidae | Globigerinoides | Globigerinoides sacculifer | |||
| 16050142 | 16050142 | PRJNA772154_P_NODE_4953_length_579_cov_2.594862_g4770_i0 | PRJNA772154 | 4953 | 579 | 2.594862 | 15.02425098 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 1051 | 0 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g4770 | i0 | 99.481 | 66.7910189982729 | 578 | 3 | 99 | 0 | 1 | 578 | 3404 | 3981 | Colpoda sp. isolate CIL1 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 | 38672 | 1051 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 21608961 | 21608961 | PRJNA772154_P_NODE_15117_length_279_cov_1.470874_g14932_i0 | PRJNA772154 | 15117 | 279 | 1.470874 | 4.10373846 | Colpodidae | 5978 | SAR_Eukaryotes | SAR_Eukaryotes | 514 | 2.73e-141 | NTclustered | gi|2067012198|gb|MZ557838.1| | 5980 | g14932 | i0 | 100 | 99.4516129032258 | 278 | 0 | 99 | 0 | 1 | 278 | 65 | 342 | Colpoda inflata isolate ZL20210414 small subunit ribosomal RNA gene, partial sequence | blastn | 27747 | 514 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda inflata | ||
| 22424577 | 22424577 | PRJNA772154_P_NODE_16138_length_267_cov_1.608247_g15953_i0 | PRJNA772154 | 16138 | 267 | 1.608247 | 4.29401949 | Sterkiella histriomuscorum | 94289 | SAR_Eukaryotes | SAR_Eukaryotes | 78.7 | 4.03e-10 | NTclustered | gi|47175615|gb|AY617195.1| | 94289 | g15953 | i0 | 83.721 | 0.468164794007491 | 86 | 11 | 31 | 1 | 184 | 266 | 198 | 283 | Sterkiella histriomuscorum clone UGC1O0001_D01_F genomic sequence | blastn | 125 | 78.7 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 22424795 | 22424795 | PRJNA772154_P_NODE_4518_length_618_cov_1.715596_g4337_i0 | PRJNA772154 | 4518 | 618 | 1.715596 | 10.60238328 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 1031 | 0 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g4337 | i0 | 96.764 | 92.0258899676375 | 618 | 20 | 100 | 0 | 1 | 618 | 1885 | 2502 | Colpoda sp. isolate CIL1 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 | 56872 | 1031 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. |
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);;