contig_metadata
9 rows where bioproject = "PRJNA685607", tax_kingdom = "Metazoa" and tax_phylum = "Rotifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 666344 | 666344 | PRJNA685607_P_NODE_52341_length_273_cov_2.390000_g51982_i0 | PRJNA685607 | 52341 | 273 | 2.39 | 6.5247 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 126 | 8.35e-35 | NR | RMZ94042.1 | 10195 | g51982 | i0 | 68.9 | 2.76923076923077 | 90 | 27 | 98.9 | 1 | 3 | 272 | 1 | 89 | RMZ94042.1 40S ribosomal S18 [Brachionus plicatilis] | diamond | 756 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 12145576 | 12145576 | PRJNA685607_P_NODE_18310_length_388_cov_1.955556_g17952_i0 | PRJNA685607 | 18310 | 388 | 1.955556 | 7.58755728 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 175 | 1.38e-53 | NR | RMZ94042.1 | 10195 | g17952 | i0 | 70.6 | 3.71134020618557 | 119 | 35 | 92 | 0 | 360 | 4 | 10 | 128 | RMZ94042.1 40S ribosomal S18 [Brachionus plicatilis] | diamond | 1440 | 176 | 0.994318181818182 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 27093755 | 27093755 | PRJNA685607_P_NODE_35222_length_313_cov_1.429167_g34863_i0 | PRJNA685607 | 35222 | 313 | 1.429167 | 4.47329271 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 117 | 1.95e-28 | NR | CAF0992289.1 | 104777 | g34863 | i0 | 53.8 | 14.6549520766773 | 104 | 48 | 99.7 | 0 | 312 | 1 | 63 | 166 | CAF0992289.1 unnamed protein product [Brachionus calyciflorus] | diamond | 4587 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27714444 | 27714444 | PRJNA685607_P_NODE_31624_length_324_cov_1.521912_g31265_i0 | PRJNA685607 | 31624 | 324 | 1.521912 | 4.93099488 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 42.7 | 0.0123 | NR | CAF1597002.1 | 249248 | g31265 | i0 | 57.9 | 0.351851851851852 | 38 | 15 | 35.2 | 1 | 322 | 209 | 13 | 49 | CAF1597002.1 unnamed protein product [Adineta ricciae] | diamond | 114 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27935127 | 27935127 | PRJNA685607_P_NODE_49365_length_279_cov_1.834951_g49006_i0 | PRJNA685607 | 49365 | 279 | 1.834951 | 5.11951329 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 154 | 3.77e-41 | NR | CAF0821892.1 | 1234261 | g49006 | i0 | 77.4 | 35 | 93 | 21 | 100 | 0 | 1 | 279 | 659 | 751 | CAF0821892.1 unnamed protein product [Didymodactylos carnosus] | diamond | 9765 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 28388603 | 28388603 | PRJNA685607_P_NODE_45706_length_287_cov_1.084112_g45347_i0 | PRJNA685607 | 45706 | 287 | 1.084112 | 3.11140144 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 93.6 | 8.44e-20 | NR | UJR15719.1 | 104782 | g45347 | i0 | 46.8 | 2.82229965156794 | 94 | 45 | 98.3 | 1 | 2 | 283 | 63 | 151 | UJR15719.1 hypothetical protein I4U23_002654 [Adineta vaga] | diamond | 810 | 94.4 | 0.991525423728813 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29071887 | 29071887 | PRJNA685607_P_NODE_86028_length_244_cov_0.900585_g85669_i0 | PRJNA685607 | 86028 | 244 | 0.900585 | 2.1974274 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 50.1 | 9.98e-5 | NR | CAF0791719.1 | 1234261 | g85669 | i0 | 40 | 0.614754098360656 | 50 | 30 | 61.5 | 0 | 243 | 94 | 488 | 537 | CAF0791719.1 unnamed protein product [Didymodactylos carnosus] | diamond | 150 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 31124495 | 31124495 | PRJNA685607_P_NODE_77335_length_247_cov_0.885057_g76976_i0 | PRJNA685607 | 77335 | 247 | 0.885057 | 2.18609079 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 79.3 | 5.19e-15 | NR | CAF0745338.1 | 1234261 | g76976 | i0 | 42.4 | 1.03238866396761 | 85 | 44 | 97.2 | 2 | 8 | 247 | 223 | 307 | CAF0745338.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 255 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 32232208 | 32232208 | PRJNA685607_P_NODE_39178_length_302_cov_1.362445_g38819_i0 | PRJNA685607 | 39178 | 302 | 1.362445 | 4.1145839 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 85.5 | 9.53e-19 | NR | RNA30453.1 | 10195 | g38819 | i0 | 70.8 | 1.29139072847682 | 65 | 18 | 63.6 | 1 | 300 | 109 | 76 | 140 | RNA30453.1 small subunit ribosomal S30e [Brachionus plicatilis] | diamond | 390 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis |
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);;