contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA929922" and tax_phylum = "Cnidaria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27372887 | 27372887 | PRJNA929922_P_NODE_131703_length_247_cov_0.885057_g131163_i0 | PRJNA929922 | 131703 | 247 | 0.885057 | 2.18609079 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 47 | 0.00126 | NR | CAB3994205.1 | 317549 | g131163 | i0 | 54.5 | 2.73279352226721 | 33 | 15 | 40.1 | 0 | 216 | 118 | 463 | 495 | CAB3994205.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 675 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 28958594 | 28958594 | PRJNA929922_P_NODE_119088_length_249_cov_0.875000_g118548_i0 | PRJNA929922 | 119088 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.5 | 3.55e-4 | NR | KAK2562587.1 | 6130 | g118548 | i0 | 42.9 | 2.2289156626506 | 49 | 27 | 59 | 1 | 172 | 26 | 96 | 143 | KAK2562587.1 hypothetical protein P5673_014272 [Acropora cervicornis] | diamond | 555 | 48.9 | 0.991820040899796 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 29109315 | 29109315 | PRJNA929922_P_NODE_118008_length_249_cov_0.875000_g117468_i0 | PRJNA929922 | 118008 | 249 | 0.875 | 2.17875 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 60.1 | 3.2e-8 | NR | PFX15504.1 | 50429 | g117468 | i0 | 41 | 2.85542168674699 | 78 | 46 | 94 | 0 | 240 | 7 | 469 | 546 | PFX15504.1 putative RNA-directed DNA polymerase from transposon BS [Stylophora pistillata] | diamond | 711 | 60.5 | 0.993388429752066 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30025089 | 30025089 | PRJNA929922_P_NODE_162811_length_241_cov_0.916667_g162271_i0 | PRJNA929922 | 162811 | 241 | 0.916667 | 2.20916747 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 43.9 | 0.0141 | NR | CAB4032949.1 | 317549 | g162271 | i0 | 36.3 | 1.43153526970954 | 80 | 48 | 99.6 | 2 | 2 | 241 | 349 | 425 | CAB4032949.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 345 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 30088012 | 30088012 | PRJNA929922_P_NODE_145612_length_244_cov_0.900585_g145072_i0 | PRJNA929922 | 145612 | 244 | 0.900585 | 2.1974274 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 84.3 | 8.81e-17 | NR | CAB3977153.1 | 317549 | g145072 | i0 | 56.2 | 12.8237704918033 | 73 | 32 | 89.8 | 0 | 1 | 219 | 411 | 483 | CAB3977153.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 3129 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 31162056 | 31162056 | PRJNA929922_P_NODE_120715_length_249_cov_0.875000_g120175_i0 | PRJNA929922 | 120715 | 249 | 0.875 | 2.17875 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 43.1 | 0.0288 | NR | XP_048582196.1 | 45351 | g120175 | i0 | 32.9 | 0.91566265060241 | 76 | 46 | 85.5 | 2 | 234 | 22 | 52 | 127 | XP_048582196.1 LOW QUALITY PROTEIN: uncharacterized protein LOC5500105 [Nematostella vectensis] | diamond | 228 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 31668319 | 31668319 | PRJNA929922_P_NODE_31437_length_370_cov_1.555556_g30897_i0 | PRJNA929922 | 31437 | 370 | 1.555556 | 5.7555572 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 49.7 | 5.56e-4 | NR | CAB4040946.1 | 317549 | g30897 | i0 | 31.8 | 0.867567567567568 | 107 | 67 | 84.3 | 2 | 312 | 1 | 379 | 482 | CAB4040946.1 Transposon TX1 uncharacterized 149 kDa, partial [Paramuricea clavata] | diamond | 321 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 31763243 | 31763243 | PRJNA929922_P_NODE_158517_length_242_cov_0.911243_g157977_i0 | PRJNA929922 | 158517 | 242 | 0.911243 | 2.20520806 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 53.9 | 4.25e-6 | NR | KAK3753750.1 | 3060491 | g157977 | i0 | 37.2 | 0.966942148760331 | 78 | 47 | 96.7 | 2 | 8 | 241 | 360 | 435 | KAK3753750.1 hypothetical protein QZH41_005245 [Actinostola sp. cb2023] | diamond | 234 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 |
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);;