contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA695140" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 676161 | 676161 | PRJNA695140_S_NODE_8101_length_185_cov_14.432432_g7920_i0 | PRJNA695140 | 8101 | 185 | 14.432432 | 26.6999992 | Condylostoma curvum | 511823 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 2.59e-15 | NTclustered | gi|1483259818|gb|MH985304.1| | 511823 | g7920 | i0 | 87.805 | 35.0648648648649 | 82 | 8 | 44 | 2 | 56 | 136 | 800 | 880 | Condylostoma curvum isolate 385 large subunit ribosomal RNA gene, partial sequence | blastn | 6487 | 95.3 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Condylostomatidae | Condylostoma | Condylostoma curvum | ||
| 1952058 | 1952058 | PRJNA695140_S_NODE_2702_length_318_cov_2.427046_g2521_i0 | PRJNA695140 | 2702 | 318 | 2.427046 | 7.71800628 | Amphifilidae sp. E-1 | 1755132 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 4.24e-115 | NTclustered | gi|1024846373|dbj|LC096096.1| | 1755132 | g2521 | i0 | 90.881 | 58.0314465408805 | 318 | 29 | 100 | 0 | 1 | 318 | 359 | 42 | Amphifilidae sp. E-1 gene for 18S ribosomal RNA, partial sequence | blastn | 18454 | 427 | 1 | Eukaryota | Sar | Bigyra | Amphifilida | Amphifilaceae | Amphifilidae sp. E-1 | ||||
| 3227133 | 3227133 | PRJNA695140_S_NODE_9183_length_175_cov_2.224638_g9002_i0 | PRJNA695140 | 9183 | 175 | 2.224638 | 3.8931165 | Rhizidiomyces hirsutus | 2290959 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 2.83e-84 | NTclustered | gi|1435243924|gb|MH685377.1| | 2290959 | g9002 | i0 | 100 | 27.6971428571429 | 175 | 0 | 100 | 0 | 1 | 175 | 944 | 770 | Rhizidiomyces hirsutus isolate BHU-BOT-MMT-09 large subunit ribosomal RNA gene, partial sequence | blastn | 4847 | 324 | 1 | Eukaryota | Sar | Hyphochytriomycetes | Hyphochytriales | Rhizidiomycetaceae | Rhizidiomyces | Rhizidiomyces hirsutus | |||
| 5779597 | 5779597 | PRJNA695140_S_NODE_2885_length_308_cov_4.760148_g2704_i0 | PRJNA695140 | 2885 | 308 | 4.760148 | 14.66125584 | Rosculus piscicus | 2231164 | SAR_Eukaryotes | SAR_Eukaryotes | 473 | 5.179999999999999e-129 | NTclustered | gi|1402550472|gb|MH488758.1| | 2231164 | g2704 | i0 | 96.831 | 39.1883116883117 | 284 | 7 | 92 | 2 | 13 | 295 | 1180 | 898 | Rosculus piscicus isolate GS5C small subunit ribosomal RNA gene, partial sequence | blastn | 12070 | 473 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus piscicus | ||||
| 7054718 | 7054718 | PRJNA695140_S_NODE_4506_length_247_cov_1.852381_g4325_i0 | PRJNA695140 | 4506 | 247 | 1.852381 | 4.57538107 | Rosculus sp. VDelafont-2023a | 3079709 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 7.38e-62 | NTclustered | gi|2589370978|gb|OR644361.1| | 3079709 | g4325 | i0 | 85.957 | 13.1255060728745 | 235 | 31 | 95 | 2 | 13 | 246 | 430 | 663 | Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence | blastn | 3242 | 250 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. VDelafont-2023a | ||||
| 9604551 | 9604551 | PRJNA695140_S_NODE_1668_length_409_cov_4.903226_g1487_i0 | PRJNA695140 | 1668 | 409 | 4.903226 | 20.05419434 | Rosculus sp. VDelafont-2023a | 3079709 | SAR_Eukaryotes | SAR_Eukaryotes | 573 | 6.779999999999999e-159 | NTclustered | gi|2589370978|gb|OR644361.1| | 3079709 | g1487 | i0 | 91.951 | 6.61124694376528 | 410 | 32 | 100 | 1 | 1 | 409 | 441 | 32 | Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence | blastn | 2704 | 573 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. VDelafont-2023a | ||||
| 12660906 | 12660906 | PRJNA695140_S_NODE_12190_length_155_cov_1.627119_g12009_i0 | PRJNA695140 | 12190 | 155 | 1.627119 | 2.52203445 | Rosculus | 373137 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 1.49e-71 | NTclustered | gi|1002343679|gb|KU738557.1| | 175275 | g12009 | i0 | 99.355 | 41.6 | 155 | 1 | 100 | 0 | 1 | 155 | 165 | 319 | Uncultured Cercozoa clone agricultural_soil21 18S ribosomal RNA gene, partial sequence | blastn | 6448 | 281 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 17253979 | 17253979 | PRJNA695140_S_NODE_734_length_634_cov_2.651591_g574_i0 | PRJNA695140 | 734 | 634 | 2.651591 | 16.81108694 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 91.6 | 1.33e-13 | NTclustered | gi|1027949921|ref|XR_001678647.1| | 31271 | g574 | i0 | 77.64 | 0.253943217665615 | 161 | 28 | 25 | 6 | 4 | 161 | 1310 | 1465 | Plasmodium chabaudi chabaudi 28S ribosomal RNA (PCHAS_0521461), rRNA | blastn | 161 | 91.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 21078504 | 21078504 | PRJNA695140_S_NODE_2317_length_343_cov_7.558824_g2136_i0 | PRJNA695140 | 2317 | 343 | 7.558824 | 25.92676632 | Rhizidiomyces hirsutus | 2290959 | SAR_Eukaryotes | SAR_Eukaryotes | 634 | 2.5299999999999996e-177 | NTclustered | gi|1435243924|gb|MH685377.1| | 2290959 | g2136 | i0 | 100 | 9.73469387755102 | 343 | 0 | 100 | 0 | 1 | 343 | 741 | 399 | Rhizidiomyces hirsutus isolate BHU-BOT-MMT-09 large subunit ribosomal RNA gene, partial sequence | blastn | 3339 | 634 | 1 | Eukaryota | Sar | Hyphochytriomycetes | Hyphochytriales | Rhizidiomycetaceae | Rhizidiomyces | Rhizidiomyces hirsutus | |||
| 24133422 | 24133422 | PRJNA695140_S_NODE_9639_length_171_cov_1.895522_g9458_i0 | PRJNA695140 | 9639 | 171 | 1.895522 | 3.24134262 | Rosculus | 373137 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 8.38e-20 | NTclustered | gi|1336609552|gb|MG859939.1| | 175275 | g9458 | i0 | 79.141 | 5.21637426900585 | 163 | 30 | 94 | 4 | 1 | 160 | 684 | 523 | Uncultured Cercozoa isolate 1_map+ small subunit ribosomal RNA gene, partial sequence | blastn | 892 | 110 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa |
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);;