contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA1139127" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24511059 | 24511059 | PRJNA1139127_P_NODE_30700_length_315_cov_1.285124_g30208_i0 | PRJNA1139127 | 30700 | 315 | 1.285124 | 4.0481406 | Durusdinium trenchii | 1381693 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 5.26e-33 | NR | CAK9114403.1 | 1381693 | g30208 | i0 | 63.5 | 3.54285714285714 | 96 | 33 | 89.5 | 1 | 282 | 1 | 6 | 101 | CAK9114403.1 40S ribosomal protein S11-2 [Durusdinium trenchii] | diamond | 1116 | 122 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Durusdinium | Durusdinium trenchii | |||
| 26658643 | 26658643 | PRJNA1139127_P_NODE_36001_length_282_cov_1.110048_g35508_i0 | PRJNA1139127 | 36001 | 282 | 1.110048 | 3.13033536 | Pseudo-nitzschia multistriata | 183589 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 1.87e-5 | NR | VEU37424.1 | 183589 | g35508 | i0 | 56.3 | 0.51063829787234 | 48 | 17 | 51.1 | 1 | 1 | 144 | 1227 | 1270 | VEU37424.1 unnamed protein product [Pseudo-nitzschia multistriata] | diamond | 144 | 52.8 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Pseudo-nitzschia | Pseudo-nitzschia multistriata | ||
| 30228292 | 30228292 | PRJNA1139127_P_NODE_37372_length_274_cov_2.776119_g36879_i0 | PRJNA1139127 | 37372 | 274 | 2.776119 | 7.60656606 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 7.66e-10 | NR | KAJ1389255.1 | 483371 | g36879 | i0 | 46.7 | 0.656934306569343 | 60 | 32 | 65.7 | 0 | 270 | 91 | 143 | 202 | KAJ1389255.1 hypothetical protein B484DRAFT_459702 [Ochromonadaceae sp. CCMP2298] | diamond | 180 | 63.5 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 30860309 | 30860309 | PRJNA1139127_P_NODE_32974_length_299_cov_3.296460_g32481_i0 | PRJNA1139127 | 32974 | 299 | 3.29646 | 9.8564154 | Chaetoceros tenuissimus | 426638 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 2.74e-4 | NR | GFH58591.1 | 426638 | g32481 | i0 | 34.9 | 0.632107023411371 | 63 | 41 | 63.2 | 0 | 194 | 6 | 10 | 72 | GFH58591.1 hypothetical protein CTEN210_15067 [Chaetoceros tenuissimus] | diamond | 189 | 49.7 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Chaetocerotales | Chaetocerotaceae | Chaetoceros | Chaetoceros tenuissimus | ||
| 31397736 | 31397736 | PRJNA1139127_P_NODE_20756_length_413_cov_1.588235_g20265_i0 | PRJNA1139127 | 20756 | 413 | 1.588235 | 6.55941055 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 232 | 1.17e-69 | NR | XP_001033325.2 | 312017 | g20265 | i0 | 98.3 | 0.835351089588378 | 115 | 2 | 83.5 | 0 | 69 | 413 | 262 | 376 | XP_001033325.2 kinesin motor catalytic domain protein [Tetrahymena thermophila SB210] | diamond | 345 | 232 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 31461101 | 31461101 | PRJNA1139127_P_NODE_41916_length_253_cov_1.011111_g41423_i0 | PRJNA1139127 | 41916 | 253 | 1.011111 | 2.55811083 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 2.34e-24 | NR | KAF1330494.1 | 82926 | g41423 | i0 | 59 | 1.96837944664032 | 83 | 34 | 98.4 | 0 | 5 | 253 | 291 | 373 | KAF1330494.1 Adenosine kinase, partial [Globisporangium splendens] | diamond | 498 | 104 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens |
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);;