contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA946307" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 926353 | 926353 | PRJNA946307_P_NODE_151401_length_164_cov_2.539130_g150527_i0 | PRJNA946307 | 151401 | 164 | 2.53913 | 4.1641732 | Ploesoma truncatum | 2851073 | Rotifera | other_Eukaryota | 189 | 1e-43 | NTclustered | gi|83285204|gb|DQ297751.1| | 2851073 | g150527 | i0 | 89.333 | 60.4512195121951 | 150 | 16 | 91 | 0 | 1 | 150 | 219 | 70 | Ploesoma truncatus 28S ribosomal RNA gene, partial sequence | blastn | 9914 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Synchaetidae | Ploesoma | Ploesoma truncatum | |
| 3812782 | 3812782 | PRJNA946307_P_NODE_60203_length_206_cov_22.764331_g59329_i0 | PRJNA946307 | 60203 | 206 | 22.764331 | 46.89452186 | Synchaeta | 204744 | Rotifera | other_Eukaryota | 351 | 1.5899999999999995e-92 | NTclustered | gi|1516482269|gb|MH481723.1| | 1156574 | g59329 | i0 | 100 | 92.1456310679612 | 190 | 0 | 92 | 0 | 3 | 192 | 820 | 631 | Synchaeta oblonga isolate 200616_ST_I1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 18982 | 351 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Synchaetidae | Synchaeta | Synchaeta oblonga | |
| 4755371 | 4755371 | PRJNA946307_P_NODE_27004_length_248_cov_3.623116_g26130_i0 | PRJNA946307 | 27004 | 248 | 3.623116 | 8.98532768 | Adineta vaga complex sp. B JFF-2016 | 1813165 | Rotifera | other_Eukaryota | 435 | 1.91e-117 | NTclustered | gi|1005055631|gb|KU860774.1| | 1813165 | g26130 | i0 | 100 | 46.3266129032258 | 235 | 0 | 95 | 0 | 1 | 235 | 1323 | 1089 | Adineta vaga complex sp. B JFF-2016 isolate H158a 28S ribosomal RNA gene, partial sequence | blastn | 11489 | 435 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. B JFF-2016 | |
| 8912932 | 8912932 | PRJNA946307_P_NODE_155887_length_163_cov_2.456140_g155013_i0 | PRJNA946307 | 155887 | 163 | 2.45614 | 4.0035082 | Ploima | 84394 | Rotifera | other_Eukaryota | 226 | 7.559999999999997e-55 | NTclustered | gi|478683563|gb|KC193096.1| | 104777 | g155013 | i0 | 93.96 | 47.7546012269939 | 149 | 9 | 91 | 0 | 1 | 149 | 1640 | 1492 | Brachionus calyciflorus 28S ribosomal RNA gene, partial sequence | blastn | 7784 | 226 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 11129650 | 11129650 | PRJNA946307_P_NODE_127869_length_171_cov_6.418033_g126995_i0 | PRJNA946307 | 127869 | 171 | 6.418033 | 10.97483643 | Brachionus diversicornis | 396694 | Rotifera | other_Eukaryota | 278 | 2.17e-70 | NTclustered | gi|398258230|gb|JN605278.1| | 396694 | g126995 | i0 | 99.346 | 89.4736842105263 | 153 | 1 | 89 | 0 | 4 | 156 | 436 | 284 | Brachionus diversicornis isolate TC21 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 15300 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus diversicornis | |
| 13679745 | 13679745 | PRJNA946307_P_NODE_13071_length_362_cov_4.399361_g12203_i0 | PRJNA946307 | 13071 | 362 | 4.399361 | 15.92568682 | Asplanchna sieboldii | 84397 | Rotifera | other_Eukaryota | 569 | 7.659999999999997e-158 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g12203 | i0 | 96.254 | 93.5580110497238 | 347 | 13 | 96 | 0 | 15 | 361 | 1433 | 1779 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 33868 | 569 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 13680202 | 13680202 | PRJNA946307_P_NODE_157091_length_163_cov_1.508772_g156217_i0 | PRJNA946307 | 157091 | 163 | 1.508772 | 2.45929836 | Rotaria rotatoria | 231624 | Rotifera | other_Eukaryota | 270 | 3.4499999999999993e-68 | NTclustered | gi|109892432|gb|DQ656807.1| | 231624 | g156217 | i0 | 99.329 | 87.558282208589 | 149 | 1 | 91 | 0 | 1 | 149 | 1041 | 893 | Rotaria rotatoria isolate UK.3.6 28S ribosomal RNA gene, partial sequence | blastn | 14272 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria rotatoria | |
| 14013943 | 14013943 | PRJNA946307_P_NODE_133671_length_169_cov_2.116667_g132797_i0 | PRJNA946307 | 133671 | 169 | 2.116667 | 3.57716723 | Ploima | 84394 | Rotifera | other_Eukaryota | 263 | 5.989999999999999e-66 | NTclustered | gi|1845957847|gb|MT522671.1| | 47121 | g132797 | i0 | 97.419 | 91.7159763313609 | 155 | 2 | 91 | 1 | 4 | 156 | 1119 | 965 | Notommata copeus isolate JH_005H10 small subunit ribosomal RNA gene, partial sequence | blastn | 15500 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Notommatidae | Notommata | Notommata copeus | |
| 14014469 | 14014469 | PRJNA946307_P_NODE_36611_length_218_cov_5.207101_g35737_i0 | PRJNA946307 | 36611 | 218 | 5.207101 | 11.35148018 | Ploima | 84394 | Rotifera | other_Eukaryota | 239 | 1.38e-58 | NTclustered | gi|68271573|gb|DQ086754.1| | 333509 | g35737 | i0 | 87.5 | 95.3899082568807 | 208 | 24 | 94 | 1 | 1 | 206 | 225 | 18 | Uncultured Rotifera isolate ROTATO10 large subunit ribosomal RNA gene, partial sequence | blastn | 20795 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | uncultured Rotifera | |||||
| 15288256 | 15288256 | PRJNA946307_P_NODE_174812_length_150_cov_4.158416_g173938_i0 | PRJNA946307 | 174812 | 150 | 4.158416 | 6.237624 | Adineta | 104781 | Rotifera | other_Eukaryota | 261 | 1.86e-65 | NTclustered | gi|1127547405|gb|JQ999603.2| | 1193592 | g173938 | i0 | 98.639 | 27.78 | 147 | 2 | 98 | 0 | 1 | 147 | 270 | 416 | Adineta environmental sample clone GKJWQY101BXQZY 28S ribosomal RNA gene, partial sequence | blastn | 4167 | 261 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta environmental sample | |
| 16229254 | 16229254 | PRJNA946307_P_NODE_148933_length_165_cov_1.224138_g148059_i0 | PRJNA946307 | 148933 | 165 | 1.224138 | 2.0198277 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 243 | 7.63e-60 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g148059 | i0 | 95.395 | 10.8181818181818 | 152 | 7 | 92 | 0 | 14 | 165 | 1834 | 1985 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 1785 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 17506328 | 17506328 | PRJNA946307_P_NODE_8954_length_457_cov_8.281863_g8122_i0 | PRJNA946307 | 8954 | 457 | 8.281863 | 37.84811391 | Asplanchna sieboldii | 84397 | Rotifera | other_Eukaryota | 368 | 3.88e-97 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g8122 | i0 | 90.459 | 33.2078774617068 | 283 | 21 | 83 | 4 | 1 | 277 | 2095 | 1813 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 15176 | 368 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 19112258 | 19112258 | PRJNA946307_P_NODE_80175_length_194_cov_1.048276_g79301_i0 | PRJNA946307 | 80175 | 194 | 1.048276 | 2.03365544 | Adineta | 104781 | Rotifera | other_Eukaryota | 291 | 3.2599999999999993e-74 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g79301 | i0 | 95.604 | 54.9536082474227 | 182 | 6 | 93 | 1 | 15 | 194 | 1968 | 2149 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 10661 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 22938144 | 22938144 | PRJNA946307_P_NODE_25538_length_255_cov_1.611650_g24664_i0 | PRJNA946307 | 25538 | 255 | 1.61165 | 4.1097075 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 412 | 9.23e-111 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g24664 | i0 | 97.51 | 71.0745098039216 | 241 | 6 | 95 | 0 | 15 | 255 | 2550 | 2790 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 18124 | 412 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 23879631 | 23879631 | PRJNA946307_P_NODE_30199_length_237_cov_1.058511_g29325_i0 | PRJNA946307 | 30199 | 237 | 1.058511 | 2.50867107 | Plationus patulus | 360686 | Rotifera | other_Eukaryota | 287 | 5.359999999999999e-73 | NTclustered | gi|83285203|gb|DQ297750.1| | 360686 | g29325 | i0 | 90.783 | 71.9746835443038 | 217 | 17 | 91 | 2 | 15 | 230 | 297 | 511 | Plationus patulus 28S ribosomal RNA gene, partial sequence | blastn | 17058 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Plationus | Plationus patulus | |
| 25154450 | 25154450 | PRJNA946307_P_NODE_9940_length_427_cov_8.589947_g9093_i0 | PRJNA946307 | 9940 | 427 | 8.589947 | 36.67907369 | Asplanchna sieboldii | 84397 | Rotifera | other_Eukaryota | 318 | 3.68e-82 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g9093 | i0 | 89.453 | 34.7236533957845 | 256 | 21 | 83 | 4 | 178 | 427 | 1840 | 2095 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 14827 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii |
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);;