contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJEB83101" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7794071 | 7794071 | PRJEB83101_P_NODE_35327_length_312_cov_1.966527_g35022_i0 | PRJEB83101 | 35327 | 312 | 1.966527 | 6.13556424 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 166 | 2.81e-51 | NR | KAL0582086.1 | 65357 | g35022 | i0 | 100 | 0.846153846153846 | 88 | 0 | 84.6 | 0 | 265 | 2 | 1 | 88 | KAL0582086.1 hypothetical protein ABG067_008272, partial [Albugo candida] | diamond | 264 | 166 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 24367790 | 24367790 | PRJEB83101_P_NODE_44980_length_285_cov_1.334906_g44675_i0 | PRJEB83101 | 44980 | 285 | 1.334906 | 3.8044821 | Ochromonas danica | 2986 | SAR_Eukaryotes | SAR_Eukaryotes | 155 | 7.839999999999999e-43 | NR | NP_066417.1 | 2986 | g44675 | i0 | 84.2 | 2 | 95 | 15 | 100 | 0 | 285 | 1 | 252 | 346 | NP_066417.1 NADH dehydrogenase subunit 4 [Ochromonas danica] | diamond | 570 | 155 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Ochromonas | Ochromonas danica | |||
| 26900509 | 26900509 | PRJEB83101_P_NODE_60041_length_260_cov_1.401070_g59736_i0 | PRJEB83101 | 60041 | 260 | 1.40107 | 3.642782 | Eimeria | 5800 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 2.95e-19 | NR | XP_013230538.1 | 5802 | g59736 | i0 | 58.2 | 2.16923076923077 | 91 | 33 | 99.2 | 2 | 260 | 3 | 2101 | 2191 | XP_013230538.1 leucine rich repeat containing protein / ankyrin repeat containing protein, putative [Eimeria tenella] | diamond | 564 | 91.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 27666371 | 27666371 | PRJEB83101_P_NODE_85944_length_242_cov_0.923077_g85639_i0 | PRJEB83101 | 85944 | 242 | 0.923077 | 2.23384634 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 92 | 1.66e-19 | NR | KAJ1438196.1 | 483371 | g85639 | i0 | 57.3 | 0.929752066115702 | 75 | 32 | 93 | 0 | 242 | 18 | 797 | 871 | KAJ1438196.1 RNA dependent RNA polymerase-domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 225 | 92 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 27666373 | 27666373 | PRJEB83101_P_NODE_88604_length_235_cov_2.074074_g88299_i0 | PRJEB83101 | 88604 | 235 | 2.074074 | 4.8740739 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00377 | NR | KAF1326870.1 | 82926 | g88299 | i0 | 41.3 | 1.60851063829787 | 63 | 33 | 75.3 | 1 | 188 | 12 | 102 | 164 | KAF1326870.1 reverse transcriptase, partial [Globisporangium splendens] | diamond | 378 | 45.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 28171317 | 28171317 | PRJEB83101_P_NODE_43686_length_287_cov_1.822430_g43381_i0 | PRJEB83101 | 43686 | 287 | 1.82243 | 5.2303741 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 90.5 | 7.26e-19 | NR | XP_001022895.3 | 312017 | g43381 | i0 | 42.1 | 0.993031358885017 | 95 | 55 | 99.3 | 0 | 286 | 2 | 329 | 423 | XP_001022895.3 26S proteasome non-ATPase regulatory subunit [Tetrahymena thermophila SB210] | diamond | 285 | 90.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 29087143 | 29087143 | PRJEB83101_P_NODE_70468_length_250_cov_0.881356_g70163_i0 | PRJEB83101 | 70468 | 250 | 0.881356 | 2.20339 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 1.11e-6 | NR | KAJ1435638.1 | 483371 | g70163 | i0 | 66.7 | 0.396 | 33 | 11 | 39.6 | 0 | 152 | 250 | 68 | 100 | KAJ1435638.1 hypothetical protein B484DRAFT_393444 [Ochromonadaceae sp. CCMP2298] | diamond | 99 | 53.5 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 29143069 | 29143069 | PRJEB83101_P_NODE_53449_length_270_cov_1.807107_g53144_i0 | PRJEB83101 | 53449 | 270 | 1.807107 | 4.8791889 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.4299999999999998e-37 | NR | KAL4453968.1 | 5901 | g53144 | i0 | 74.4 | 6.97777777777778 | 90 | 23 | 100 | 0 | 1 | 270 | 401 | 490 | KAL4453968.1 hypothetical protein ABPG74_003851 [Tetrahymena malaccensis] | diamond | 1884 | 143 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 29489982 | 29489982 | PRJEB83101_P_NODE_78270_length_246_cov_0.901734_g77965_i0 | PRJEB83101 | 78270 | 246 | 0.901734 | 2.21826564 | Symbiodiniaceae | 252141 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 2.79e-26 | NR | CAE7529802.1 | 631055 | g77965 | i0 | 58.5 | 4.97560975609756 | 82 | 34 | 100 | 0 | 1 | 246 | 103 | 184 | CAE7529802.1 DEGP1 [Symbiodinium sp. CCMP2592] | diamond | 1224 | 109 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium sp. CCMP2592 | |||
| 29710778 | 29710778 | PRJEB83101_P_NODE_73270_length_249_cov_0.886364_g72965_i0 | PRJEB83101 | 73270 | 249 | 0.886364 | 2.20704636 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 73.6 | 5.41e-13 | NR | XP_024571821.1 | 4781 | g72965 | i0 | 52.8 | 29.9397590361446 | 72 | 29 | 86.7 | 2 | 32 | 247 | 194 | 260 | XP_024571821.1 -dimethylguanosine trna methyltransferase [Plasmopara halstedii] | diamond | 7455 | 74.3 | 0.990578734858681 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 30792573 | 30792573 | PRJEB83101_P_NODE_85854_length_242_cov_0.923077_g85549_i0 | PRJEB83101 | 85854 | 242 | 0.923077 | 2.23384634 | Symbiodinium sp. CCMP2456 | 1519616 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.00795 | NR | CAE7722823.1 | 1519616 | g85549 | i0 | 35.5 | 1.88429752066116 | 76 | 34 | 76.9 | 2 | 56 | 241 | 724 | 798 | CAE7722823.1 unnamed protein product, partial [Symbiodinium sp. CCMP2456] | diamond | 456 | 44.7 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium sp. CCMP2456 | |||
| 32152397 | 32152397 | PRJEB83101_P_NODE_33078_length_321_cov_1.741935_g32773_i0 | PRJEB83101 | 33078 | 321 | 1.741935 | 5.59161135 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 151 | 1.68e-45 | NR | KAL0570125.1 | 65357 | g32773 | i0 | 90.5 | 0.785046728971963 | 84 | 8 | 78.5 | 0 | 305 | 54 | 1 | 84 | KAL0570125.1 hypothetical protein ABG067_009442, partial [Albugo candida] | diamond | 252 | 151 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 32366679 | 32366679 | PRJEB83101_P_NODE_86579_length_242_cov_0.923077_g86274_i0 | PRJEB83101 | 86579 | 242 | 0.923077 | 2.23384634 | Symbiodiniaceae | 252141 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0369 | NR | OLQ01661.1 | 2951 | g86274 | i0 | 38.2 | 1.48760330578512 | 68 | 31 | 84.3 | 1 | 240 | 37 | 382 | 438 | OLQ01661.1 Pentatricopeptide repeat-containing protein, chloroplastic [Symbiodinium microadriaticum] | diamond | 360 | 42.7 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum |
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);;