contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA994052" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 976517 | 976517 | PRJNA994052_P_NODE_47821_length_245_cov_0.906977_g46570_i0 | PRJNA994052 | 47821 | 245 | 0.906977 | 2.22209365 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 102 | 1.24e-25 | NR | CAF0711365.1 | 104777 | g46570 | i0 | 88.5 | 0.636734693877551 | 52 | 6 | 63.7 | 0 | 167 | 12 | 1 | 52 | CAF0711365.1 unnamed protein product [Brachionus calyciflorus] | diamond | 156 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27221782 | 27221782 | PRJNA994052_P_NODE_23122_length_300_cov_44.017621_g21893_i0 | PRJNA994052 | 23122 | 300 | 44.017621 | 132.052863 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 125 | 7.229999999999998e-32 | NR | UJR09579.1 | 104782 | g21893 | i0 | 98.4 | 7.32 | 61 | 1 | 61 | 0 | 296 | 114 | 319 | 379 | UJR09579.1 hypothetical protein I4U23_013814 [Adineta vaga] | diamond | 2196 | 126 | 0.992063492063492 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 28352936 | 28352936 | PRJNA994052_P_NODE_76006_length_205_cov_31.893939_g74750_i0 | PRJNA994052 | 76006 | 205 | 31.893939 | 65.38257495 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 46.6 | 8.92e-4 | NR | CAF0768887.1 | 104777 | g74750 | i0 | 72.4 | 0.424390243902439 | 29 | 8 | 42.4 | 0 | 1 | 87 | 227 | 255 | CAF0768887.1 unnamed protein product [Brachionus calyciflorus] | diamond | 87 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28416267 | 28416267 | PRJNA994052_P_NODE_80386_length_200_cov_38.110236_g79129_i0 | PRJNA994052 | 80386 | 200 | 38.110236 | 76.220472 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 52 | 1.14e-5 | NR | CAF1353005.1 | 433720 | g79129 | i0 | 39.7 | 5.07 | 68 | 32 | 88.5 | 2 | 16 | 192 | 109 | 176 | CAF1353005.1 unnamed protein product [Adineta steineri] | diamond | 1014 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28453750 | 28453750 | PRJNA994052_P_NODE_54686_length_234_cov_4.900621_g53431_i0 | PRJNA994052 | 54686 | 234 | 4.900621 | 11.46745314 | Ploima | 84394 | Rotifera | other_Eukaryota | 45.8 | 6.97e-4 | NR | AHZ34262.1 | 392764 | g53431 | i0 | 42.4 | 3.62820512820513 | 59 | 30 | 70.5 | 1 | 3 | 167 | 45 | 103 | AHZ34262.1 NADH dehydrogenase subunit 3 [Brachionus rubens] | diamond | 849 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 30152636 | 30152636 | PRJNA994052_P_NODE_65592_length_218_cov_23.668966_g64336_i0 | PRJNA994052 | 65592 | 218 | 23.668966 | 51.59834588 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 61.2 | 4.25e-10 | NR | CAF1251842.1 | 392033 | g64336 | i0 | 87.1 | 0.853211009174312 | 31 | 4 | 42.7 | 0 | 216 | 124 | 73 | 103 | CAF1251842.1 unnamed protein product, partial [Rotaria sordida] | diamond | 186 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 30500459 | 30500459 | PRJNA994052_P_NODE_59813_length_226_cov_48.143791_g58557_i0 | PRJNA994052 | 59813 | 226 | 48.143791 | 108.80496766 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 61.6 | 2.37e-10 | NR | RMZ94500.1 | 10195 | g58557 | i0 | 51.4 | 2.76106194690265 | 70 | 13 | 92.9 | 1 | 224 | 15 | 14 | 62 | RMZ94500.1 barrier-to-autointegration factor [Brachionus plicatilis] | diamond | 624 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 30784777 | 30784777 | PRJNA994052_P_NODE_74114_length_207_cov_80.880597_g72858_i0 | PRJNA994052 | 74114 | 207 | 80.880597 | 167.42283579 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 59.7 | 2.37e-8 | NR | CAF0715915.1 | 104777 | g72858 | i0 | 77.1 | 1.01449275362319 | 35 | 8 | 50.7 | 0 | 15 | 119 | 485 | 519 | CAF0715915.1 unnamed protein product [Brachionus calyciflorus] | diamond | 210 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31200978 | 31200978 | PRJNA994052_P_NODE_30675_length_280_cov_16.270531_g29432_i0 | PRJNA994052 | 30675 | 280 | 16.270531 | 45.5574868 | Adineta | 104781 | Rotifera | other_Eukaryota | 106 | 1.13e-26 | NR | CAF0776410.1 | 249248 | g29432 | i0 | 69.7 | 3.40714285714286 | 66 | 20 | 70.7 | 0 | 278 | 81 | 107 | 172 | CAF0776410.1 unnamed protein product [Adineta ricciae] | diamond | 954 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31512019 | 31512019 | PRJNA994052_P_NODE_80096_length_200_cov_107.724409_g78839_i0 | PRJNA994052 | 80096 | 200 | 107.724409 | 215.448818 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 89.4 | 2.6e-19 | NR | CAF0825838.1 | 433720 | g78839 | i0 | 73 | 4.725 | 63 | 17 | 94.5 | 0 | 194 | 6 | 260 | 322 | CAF0825838.1 unnamed protein product [Adineta steineri] | diamond | 945 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32081157 | 32081157 | PRJNA994052_P_NODE_15258_length_313_cov_5.445833_g14037_i0 | PRJNA994052 | 15258 | 313 | 5.445833 | 17.04545729 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 78.6 | 2.15e-14 | NR | CAF0961661.1 | 433720 | g14037 | i0 | 85.4 | 1.17891373801917 | 41 | 6 | 39.3 | 0 | 12 | 134 | 164 | 204 | CAF0961661.1 unnamed protein product [Adineta steineri] | diamond | 369 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32118865 | 32118865 | PRJNA994052_P_NODE_22518_length_302_cov_47.144105_g21289_i0 | PRJNA994052 | 22518 | 302 | 47.144105 | 142.3751971 | Rotaria | 231623 | Rotifera | other_Eukaryota | 75.5 | 2.37e-13 | NR | CAF3312438.1 | 392032 | g21289 | i0 | 73.9 | 0.913907284768212 | 46 | 12 | 45.7 | 0 | 301 | 164 | 662 | 707 | CAF3312438.1 unnamed protein product [Rotaria socialis] | diamond | 276 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis |
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);;