contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA891846" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2518679 | 2518679 | PRJNA891846_P_NODE_22282_length_323_cov_1.432000_g22063_i0 | PRJNA891846 | 22282 | 323 | 1.432 | 4.62536 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 462 | 1.18e-125 | NTclustered | gi|695467811|ref|XM_009541420.1| | 67593 | g22063 | i0 | 92.401 | 86.0061919504644 | 329 | 17 | 100 | 6 | 1 | 323 | 341 | 15 | Phytophthora sojae hypothetical protein mRNA | blastn | 27780 | 462 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 4695704 | 4695704 | PRJNA891846_P_NODE_35964_length_253_cov_1.283333_g35744_i0 | PRJNA891846 | 35964 | 253 | 1.283333 | 3.24683249 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 7.689999999999999e-52 | NTclustered | gi|695381515|ref|XM_009518817.1| | 67593 | g35744 | i0 | 82.47 | 14.3122529644269 | 251 | 40 | 98 | 3 | 5 | 253 | 495 | 247 | Phytophthora sojae hypothetical protein mRNA | blastn | 3621 | 217 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 5071195 | 5071195 | PRJNA891846_P_NODE_36324_length_251_cov_2.539326_g36104_i0 | PRJNA891846 | 36324 | 251 | 2.539326 | 6.37370826 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 464 | 2.47e-126 | NTclustered | gi|14495562|gb|L21708.2|PFA34K | 5821 | g36104 | i0 | 100 | 99.9482071713147 | 251 | 0 | 100 | 0 | 1 | 251 | 1232 | 982 | Plasmodium berghei p23-like protein mRNA, partial cds | blastn | 25087 | 464 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 12346473 | 12346473 | PRJNA891846_P_NODE_43130_length_245_cov_0.895349_g42910_i0 | PRJNA891846 | 43130 | 245 | 0.895349 | 2.19360505 | Thalassiosira pseudonana | 35128 | SAR_Eukaryotes | SAR_Eukaryotes | 75 | 4.72e-9 | NTclustered | gi|223993350|ref|XM_002286323.1| | 296543 | g42910 | i0 | 87.5 | 0.261224489795918 | 64 | 8 | 26 | 0 | 41 | 104 | 358 | 421 | Thalassiosira pseudonana CCMP1335 predicted protein partial mRNA | blastn | 64 | 75 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Thalassiosirales | Thalassiosiraceae | Thalassiosira | Thalassiosira pseudonana | ||
| 16545685 | 16545685 | PRJNA891846_P_NODE_40173_length_248_cov_0.880000_g39953_i0 | PRJNA891846 | 40173 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|676381124|ref|XM_009035593.1| | 44056 | g39953 | i0 | 100 | 0.233870967741935 | 29 | 0 | 12 | 0 | 99 | 127 | 507 | 535 | Aureococcus anophagefferens hypothetical protein mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagomonadales | Pelagomonadaceae | Aureococcus | Aureococcus anophagefferens | |||
| 17445760 | 17445760 | PRJNA891846_P_NODE_48114_length_206_cov_5.902256_g47894_i0 | PRJNA891846 | 48114 | 206 | 5.902256 | 12.15864736 | Cryothecomonas sp. APCC MC5-1Cryo | 741088 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 7.479999999999998e-81 | NTclustered | gi|290760480|gb|GQ144683.1| | 741088 | g47894 | i0 | 94.146 | 100.087378640777 | 205 | 10 | 99 | 2 | 3 | 206 | 1805 | 1602 | Cryothecomonas sp. APCC MC5-1Cryo large subunit ribosomal RNA gene, partial sequence | blastn | 20618 | 313 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Cryomonadida | Protaspidae | Cryothecomonas | Cryothecomonas sp. APCC MC5-1Cryo | ||
| 18718130 | 18718130 | PRJNA891846_P_NODE_12755_length_423_cov_1.282857_g12536_i0 | PRJNA891846 | 12755 | 423 | 1.282857 | 5.42648511 | Phaeodactylum tricornutum | 2850 | SAR_Eukaryotes | SAR_Eukaryotes | 597 | 4.1699999999999986e-166 | NTclustered | gi|146762526|gb|EF553458.1| | 2850 | g12536 | i0 | 92.217 | 100.709219858156 | 424 | 30 | 100 | 3 | 1 | 423 | 4065 | 4486 | Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 42600 | 597 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Phaeodactylaceae | Phaeodactylum | Phaeodactylum tricornutum | ||
| 19094616 | 19094616 | PRJNA891846_P_NODE_25775_length_299_cov_2.628319_g25556_i0 | PRJNA891846 | 25775 | 299 | 2.628319 | 7.85867381 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.028 | NTclustered | gi|915136483|ref|XM_013481102.1| | 5804 | g25556 | i0 | 100 | 0.280936454849498 | 28 | 0 | 9 | 0 | 217 | 244 | 3627 | 3654 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 21268682 | 21268682 | PRJNA891846_P_NODE_14357_length_400_cov_1.162080_g14138_i0 | PRJNA891846 | 14357 | 400 | 1.16208 | 4.64832 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 6.02e-45 | NTclustered | gi|695434857|ref|XM_009533226.1| | 67593 | g14138 | i0 | 80.723 | 5.9475 | 249 | 48 | 62 | 0 | 140 | 388 | 88 | 336 | Phytophthora sojae hypothetical protein mRNA | blastn | 2379 | 195 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 21645277 | 21645277 | PRJNA891846_P_NODE_32977_length_266_cov_1.341969_g32758_i0 | PRJNA891846 | 32977 | 266 | 1.341969 | 3.56963754 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 486 | 5.629999999999999e-133 | NTclustered | gi|505574761|gb|AY598625.2| | 82937 | g32758 | i0 | 99.624 | 99.6691729323308 | 266 | 1 | 100 | 0 | 1 | 266 | 2597 | 2862 | Pythium graminicola strain CBS 327.62 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 26512 | 486 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium graminicola |
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);;