contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA744060" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 723020 | 723020 | PRJNA744060_P_NODE_19301_length_367_cov_10.102041_g18972_i0 | PRJNA744060 | 19301 | 367 | 10.102041 | 37.07449047 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 4.35e-26 | NTclustered | gi|27734406|gb|AY099118.1| | 227086 | g18972 | i0 | 90.909 | 33.6594005449591 | 99 | 7 | 27 | 2 | 270 | 367 | 272 | 175 | Chlorarachnion CCMP621 isolate pub1 polyubiquitin mRNA, complete cds | blastn | 12353 | 132 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 8377039 | 8377039 | PRJNA744060_P_NODE_7267_length_590_cov_7.205029_g6944_i0 | PRJNA744060 | 7267 | 590 | 7.205029 | 42.5096711 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 185 | 5.509999999999999e-42 | NTclustered | gi|47028284|gb|AY542983.1| | 227086 | g6944 | i0 | 81.696 | 10.6118644067797 | 224 | 39 | 38 | 2 | 368 | 590 | 461 | 239 | Bigelowiella natans calmodulin mRNA, complete cds | blastn | 6261 | 185 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 9652185 | 9652185 | PRJNA744060_P_NODE_8728_length_540_cov_12.231263_g8403_i0 | PRJNA744060 | 8728 | 540 | 12.231263 | 66.0488202 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 599 | 1.51e-166 | NTclustered | gi|238617638|gb|FJ973398.1| | 646463 | g8403 | i0 | 87.03 | 99.4481481481481 | 532 | 67 | 98 | 2 | 10 | 540 | 837 | 307 | Gymnophrys sp. ATCC 50923 actin (act) gene, partial cds | blastn | 53702 | 599 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 14751953 | 14751953 | PRJNA744060_P_NODE_17972_length_380_cov_2.576547_g17643_i0 | PRJNA744060 | 17972 | 380 | 2.576547 | 9.7908786 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 5.189999999999999e-110 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g17643 | i0 | 87.297 | 50.6368421052632 | 370 | 33 | 97 | 7 | 12 | 380 | 4021 | 3665 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 19242 | 411 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 14752332 | 14752332 | PRJNA744060_P_NODE_39692_length_264_cov_1.340314_g39363_i0 | PRJNA744060 | 39692 | 264 | 1.340314 | 3.53842896 | Proleptomonas faecicola | 149084 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 5.99e-83 | NTclustered | gi|302026150|gb|GQ377654.1| | 149084 | g39363 | i0 | 88.889 | 37.7424242424242 | 261 | 28 | 99 | 1 | 4 | 264 | 867 | 608 | Proleptomonas faecicola beta-tubulin (Btub) gene, partial cds | blastn | 9964 | 320 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Proleptomonas | Proleptomonas faecicola | ||||
| 21126263 | 21126263 | PRJNA744060_P_NODE_6337_length_629_cov_53.994604_g6017_i0 | PRJNA744060 | 6337 | 629 | 53.994604 | 339.62605916 | Chlorarachniophyceae sp. | 2303673 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 1.26e-48 | NTclustered | gi|2071061694|gb|MZ611732.1| | 2303673 | g6017 | i0 | 79.479 | 45.3068362480127 | 307 | 51 | 63 | 12 | 172 | 475 | 664 | 961 | Chlorarachniophyceae sp. isolate AL-FL05 small subunit ribosomal RNA gene, partial sequence | blastn | 28498 | 207 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Chlorarachniophyceae sp. | |||||
| 23676532 | 23676532 | PRJNA744060_P_NODE_4399_length_750_cov_1.639586_g4104_i0 | PRJNA744060 | 4399 | 750 | 1.639586 | 12.296895 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 918 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g4104 | i0 | 88.8 | 96.6013333333333 | 750 | 82 | 99 | 2 | 1 | 749 | 16 | 764 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 72451 | 918 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima |
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);;