contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA800053" and tax_phylum = "Arthropoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26896105 | 26896105 | PRJNA800053_P_NODE_23321_length_242_cov_0.911243_g23157_i0 | PRJNA800053 | 23321 | 242 | 0.911243 | 2.20520806 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 87.4 | 7.05e-19 | NR | XP_065568921.1 | 6661 | g23157 | i0 | 49.4 | 0.954545454545455 | 77 | 39 | 95.5 | 0 | 237 | 7 | 125 | 201 | XP_065568921.1 uncharacterized protein LOC136032579 [Artemia franciscana] | diamond | 231 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 26990551 | 26990551 | PRJNA800053_P_NODE_18802_length_249_cov_0.875000_g18638_i0 | PRJNA800053 | 18802 | 249 | 0.875 | 2.17875 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 48.1 | 4.82e-4 | NR | XP_065578525.1 | 6661 | g18638 | i0 | 81.5 | 0.325301204819277 | 27 | 5 | 32.5 | 0 | 248 | 168 | 141 | 167 | XP_065578525.1 inositol hexakisphosphate kinase 3-like isoform X2 [Artemia franciscana] | diamond | 81 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 28348922 | 28348922 | PRJNA800053_P_NODE_16686_length_255_cov_0.846154_g16522_i0 | PRJNA800053 | 16686 | 255 | 0.846154 | 2.1576927 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 118 | 4.73e-29 | NR | KAK2723307.1 | 6661 | g16522 | i0 | 67.1 | 0.964705882352941 | 82 | 27 | 96.5 | 0 | 250 | 5 | 209 | 290 | KAK2723307.1 hypothetical protein QYM36_001832 [Artemia franciscana] | diamond | 246 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 28412177 | 28412177 | PRJNA800053_P_NODE_14926_length_266_cov_1.196891_g14762_i0 | PRJNA800053 | 14926 | 266 | 1.196891 | 3.18373006 | Lepeophtheirus salmonis | 72036 | Arthropoda | Arthropoda | 145 | 1.68e-41 | NR | ADD38871.1 | 72036 | g14762 | i0 | 82.8 | 2.94360902255639 | 87 | 15 | 98.1 | 0 | 6 | 266 | 86 | 172 | ADD38871.1 40S ribosomal protein S3-B [Lepeophtheirus salmonis] | diamond | 783 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Hexanauplia | Siphonostomatoida | Caligidae | Lepeophtheirus | Lepeophtheirus salmonis | |
| 28664759 | 28664759 | PRJNA800053_P_NODE_23947_length_241_cov_0.916667_g23783_i0 | PRJNA800053 | 23947 | 241 | 0.916667 | 2.20916747 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 47.8 | 5.81e-4 | NR | CAG4635606.1 | 6661 | g23783 | i0 | 55.6 | 0.83402489626556 | 36 | 16 | 44.8 | 0 | 155 | 48 | 228 | 263 | CAG4635606.1 EOG090X0A2Q, partial [Artemia franciscana] | diamond | 201 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 29021292 | 29021292 | PRJNA800053_P_NODE_17488_length_251_cov_0.865169_g17324_i0 | PRJNA800053 | 17488 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Arthropoda | Arthropoda | 55.5 | 1.35e-6 | NR | XP_065581722.1 | 6661 | g17324 | i0 | 38 | 5.9402390438247 | 71 | 44 | 84.9 | 0 | 33 | 245 | 383 | 453 | XP_065581722.1 uncharacterized protein LOC136041097 [Artemia franciscana] | diamond | 1491 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 29264404 | 29264404 | PRJNA800053_P_NODE_15209_length_264_cov_1.308901_g15045_i0 | PRJNA800053 | 15209 | 264 | 1.308901 | 3.45549864 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 80.1 | 5.75e-16 | NR | XP_065569304.1 | 6661 | g15045 | i0 | 75 | 1.63636363636364 | 48 | 12 | 54.5 | 0 | 29 | 172 | 111 | 158 | XP_065569304.1 uncharacterized protein LOC136032824 [Artemia franciscana] | diamond | 432 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 29517048 | 29517048 | PRJNA800053_P_NODE_22550_length_243_cov_0.905882_g22386_i0 | PRJNA800053 | 22550 | 243 | 0.905882 | 2.20129326 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 90.5 | 2.15e-19 | NR | XP_065583912.1 | 6661 | g22386 | i0 | 60 | 1.60493827160494 | 65 | 26 | 80.2 | 0 | 47 | 241 | 65 | 129 | XP_065583912.1 GATA zinc finger domain-containing protein 4-like [Artemia franciscana] | diamond | 390 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 31191159 | 31191159 | PRJNA800053_P_NODE_17895_length_250_cov_1.355932_g17731_i0 | PRJNA800053 | 17895 | 250 | 1.355932 | 3.38983 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 126 | 1.3e-31 | NR | XP_065561868.1 | 6661 | g17731 | i0 | 72.5 | 2.928 | 80 | 22 | 96 | 0 | 5 | 244 | 874 | 953 | XP_065561868.1 uncharacterized protein LOC136028139 isoform X1 [Artemia franciscana] | diamond | 732 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 32645983 | 32645983 | PRJNA800053_P_NODE_23760_length_241_cov_0.916667_g23596_i0 | PRJNA800053 | 23760 | 241 | 0.916667 | 2.20916747 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 53.5 | 5.62e-6 | NR | KAK2706587.1 | 6661 | g23596 | i0 | 33.3 | 5.82572614107884 | 78 | 52 | 97.1 | 0 | 4 | 237 | 216 | 293 | KAK2706587.1 hypothetical protein QYM36_016578 [Artemia franciscana] | diamond | 1404 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 32898061 | 32898061 | PRJNA800053_P_NODE_23640_length_241_cov_0.916667_g23476_i0 | PRJNA800053 | 23640 | 241 | 0.916667 | 2.20916747 | Trichogramma brassicae | 86971 | Arthropoda | Arthropoda | 43.1 | 0.0256 | NR | CAB0039094.1 | 86971 | g23476 | i0 | 56.7 | 0.37344398340249 | 30 | 13 | 37.3 | 0 | 174 | 85 | 125 | 154 | CAB0039094.1 unnamed protein product [Trichogramma brassicae] | diamond | 90 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Trichogrammatidae | Trichogramma | Trichogramma brassicae |
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);;