contig_metadata
15 rows where bioproject = "PRJNA994052", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 976232 | 976232 | PRJNA994052_P_NODE_23921_length_297_cov_118.482143_g22686_i0 | PRJNA994052 | 23921 | 297 | 118.482143 | 351.89196471 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 246 | 1.18e-60 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g22686 | i0 | 83.456 | 8.72390572390572 | 272 | 37 | 91 | 5 | 7 | 276 | 10913 | 11178 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 2591 | 246 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 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 | |
| 4804202 | 4804202 | PRJNA994052_P_NODE_30104_length_281_cov_127.076923_g28862_i0 | PRJNA994052 | 30104 | 281 | 127.076923 | 357.08615363 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 241 | 5.15e-59 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g28862 | i0 | 83.088 | 8.74021352313167 | 272 | 38 | 96 | 5 | 7 | 276 | 10913 | 11178 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 2456 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 13729784 | 13729784 | PRJNA994052_P_NODE_26291_length_291_cov_121.399083_g25051_i0 | PRJNA994052 | 26291 | 291 | 121.399083 | 353.27133153 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 241 | 5.36e-59 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g25051 | i0 | 83.088 | 8.90721649484536 | 272 | 38 | 93 | 5 | 7 | 276 | 10913 | 11178 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 2592 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 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);;