contig_metadata
17 rows where bioproject = "PRJEB20058", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25614162 | 25614162 | PRJEB20058_P_NODE_31649_length_745_cov_30.861111_g29142_i0 | PRJEB20058 | 31649 | 745 | 30.861111 | 229.91527695 | Metazoa | 33208 | Rotifera | other_Eukaryota | 1116 | 0 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g29142 | i0 | 95.809 | 37.9463087248322 | 692 | 28 | 93 | 1 | 23 | 714 | 1842 | 2532 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 28270 | 1127 | 0.990239574090506 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 26066485 | 26066485 | PRJEB20058_P_NODE_8701_length_1425_cov_53.052053_g7383_i0 | PRJEB20058 | 8701 | 1425 | 53.052053 | 755.99175525 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 280 | 5.86e-85 | NR | CAF0889837.1 | 392033 | g7383 | i0 | 49 | 4.96210526315789 | 294 | 145 | 61.7 | 3 | 248 | 1126 | 195 | 484 | CAF0889837.1 unnamed protein product [Rotaria sordida] | diamond | 7071 | 282 | 0.99290780141844 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 26203178 | 26203178 | PRJEB20058_P_NODE_94382_length_421_cov_13.119444_g91581_i0 | PRJEB20058 | 94382 | 421 | 13.119444 | 55.23285924 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 140 | 3.2499999999999996e-37 | NR | CAF0906992.1 | 249248 | g91581 | i0 | 95.6 | 0.484560570071259 | 68 | 3 | 48.5 | 0 | 210 | 413 | 1 | 68 | CAF0906992.1 unnamed protein product [Adineta ricciae] | diamond | 204 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 26430213 | 26430213 | PRJEB20058_P_NODE_244943_length_205_cov_4.562500_g242118_i0 | PRJEB20058 | 244943 | 205 | 4.5625 | 9.353125 | Philodinidae | 44580 | Rotifera | other_Eukaryota | 296 | 7.49e-76 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g242118 | i0 | 93.5 | 80.6 | 200 | 12 | 98 | 1 | 1 | 200 | 143 | 341 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 16523 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 26467642 | 26467642 | PRJEB20058_P_NODE_151112_length_312_cov_2.278884_g148290_i0 | PRJEB20058 | 151112 | 312 | 2.278884 | 7.11011808 | Encentrum astridae | 360661 | Rotifera | other_Eukaryota | 459 | 1.47e-124 | NTclustered | gi|124388846|gb|EF151006.1| | 360661 | g148290 | i0 | 95.47 | 83.8685897435897 | 287 | 13 | 92 | 0 | 22 | 308 | 1767 | 2053 | Encentrum astridae 28S ribosomal RNA gene, partial sequence | blastn | 26167 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Dicranophoridae | Encentrum | Encentrum astridae | |
| 26567299 | 26567299 | PRJEB20058_P_NODE_71704_length_491_cov_91.872093_g68929_i0 | PRJEB20058 | 71704 | 491 | 91.872093 | 451.09197663 | Brachionus | 10194 | Rotifera | other_Eukaryota | 460 | 6.72e-125 | NTclustered | gi|478683563|gb|KC193096.1| | 104777 | g68929 | i0 | 92.097 | 64.1975560081466 | 329 | 23 | 89 | 3 | 13 | 339 | 2453 | 2126 | Brachionus calyciflorus 28S ribosomal RNA gene, partial sequence | blastn | 31521 | 462 | 0.995670995670996 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 32928368 | 32928368 | PRJEB20058_P_NODE_29241_length_775_cov_9.495798_g26805_i0 | PRJEB20058 | 29241 | 775 | 9.495798 | 73.5924345 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 57.8 | 1.74e-5 | NR | CAF1378045.1 | 433720 | g26805 | i0 | 40 | 2.64387096774194 | 65 | 34 | 24.4 | 2 | 581 | 769 | 574 | 635 | CAF1378045.1 unnamed protein product [Adineta steineri] | diamond | 2049 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32996254 | 32996254 | PRJEB20058_P_NODE_171459_length_285_cov_145.058036_g168636_i0 | PRJEB20058 | 171459 | 285 | 145.058036 | 413.4154026 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 116 | 6.889999999999999e-31 | NR | RNA18592.1 | 10195 | g168636 | i0 | 94.6 | 0.589473684210526 | 56 | 3 | 58.9 | 0 | 202 | 35 | 92 | 147 | RNA18592.1 hypothetical protein BpHYR1_047983 [Brachionus plicatilis] | diamond | 168 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 33031079 | 33031079 | PRJEB20058_P_NODE_58588_length_547_cov_33.479424_g55833_i0 | PRJEB20058 | 58588 | 547 | 33.479424 | 183.13244928 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 107 | 2.0099999999999994e-23 | NR | CAF0831634.1 | 104777 | g55833 | i0 | 91.5 | 0.647166361974406 | 59 | 4 | 31.8 | 1 | 24 | 197 | 846 | 904 | CAF0831634.1 unnamed protein product [Brachionus calyciflorus] | diamond | 354 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 33031139 | 33031139 | PRJEB20058_P_NODE_67132_length_509_cov_22.535714_g64363_i0 | PRJEB20058 | 67132 | 509 | 22.535714 | 114.70678426 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 62.8 | 2.15e-8 | NR | CAF1382084.1 | 392033 | g64363 | i0 | 35.1 | 1.00196463654224 | 94 | 57 | 54.8 | 2 | 24 | 302 | 139 | 229 | CAF1382084.1 unnamed protein product [Rotaria sordida] | diamond | 510 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 33059563 | 33059563 | PRJEB20058_P_NODE_45685_length_622_cov_15.778966_g42993_i0 | PRJEB20058 | 45685 | 622 | 15.778966 | 98.14516852 | Adineta | 104781 | Rotifera | other_Eukaryota | 235 | 5.88e-69 | NR | CAF1046797.1 | 249248 | g42993 | i0 | 77.7 | 9.68971061093248 | 139 | 31 | 67 | 0 | 21 | 437 | 674 | 812 | CAF1046797.1 unnamed protein product [Adineta ricciae] | diamond | 6027 | 235 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 33076575 | 33076575 | PRJEB20058_P_NODE_246925_length_201_cov_4.507143_g244100_i0 | PRJEB20058 | 246925 | 201 | 4.507143 | 9.05935743 | Rotaria | 231623 | Rotifera | other_Eukaryota | 84 | 6.05e-17 | NR | CAF1213929.1 | 2762511 | g244100 | i0 | 97.4 | 1.70149253731343 | 38 | 1 | 56.7 | 0 | 20 | 133 | 468 | 505 | CAF1213929.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 342 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 33081753 | 33081753 | PRJEB20058_P_NODE_205902_length_252_cov_1.827225_g203078_i0 | PRJEB20058 | 205902 | 252 | 1.827225 | 4.604607 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 58.5 | 1.08e-7 | NR | CAF1014340.1 | 249248 | g203078 | i0 | 68.2 | 0.523809523809524 | 44 | 11 | 52.4 | 1 | 30 | 161 | 404 | 444 | CAF1014340.1 unnamed protein product [Adineta ricciae] | diamond | 132 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 33116175 | 33116175 | PRJEB20058_P_NODE_43727_length_636_cov_2.495652_g41056_i0 | PRJEB20058 | 43727 | 636 | 2.495652 | 15.87234672 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 52.4 | 6.17e-5 | NR | CAF5171725.1 | 392030 | g41056 | i0 | 28.3 | 1.16981132075472 | 120 | 83 | 55.2 | 1 | 605 | 255 | 2 | 121 | CAF5171725.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 744 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 33127760 | 33127760 | PRJEB20058_P_NODE_189791_length_265_cov_5.401961_g186967_i0 | PRJEB20058 | 189791 | 265 | 5.401961 | 14.31519665 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.2 | 1.13e-8 | NR | CAF1561206.1 | 249248 | g186967 | i0 | 78.1 | 3.03396226415094 | 32 | 7 | 36.2 | 0 | 34 | 129 | 60 | 91 | CAF1561206.1 unnamed protein product, partial [Adineta ricciae] | diamond | 804 | 58.5 | 0.994871794871795 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 33133310 | 33133310 | PRJEB20058_P_NODE_36751_length_693_cov_14.575949_g34154_i0 | PRJEB20058 | 36751 | 693 | 14.575949 | 101.01132657 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 142 | 8.28e-39 | NR | CAF1042695.1 | 104777 | g34154 | i0 | 42.3 | 1.42857142857143 | 163 | 94 | 70.6 | 0 | 96 | 584 | 6 | 168 | CAF1042695.1 unnamed protein product [Brachionus calyciflorus] | diamond | 990 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 33149760 | 33149760 | PRJEB20058_P_NODE_167384_length_290_cov_55.689956_g164561_i0 | PRJEB20058 | 167384 | 290 | 55.689956 | 161.5008724 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 145 | 3.2599999999999995e-42 | NR | RNA00032.1 | 10195 | g164561 | i0 | 96 | 0.775862068965517 | 75 | 3 | 77.6 | 0 | 267 | 43 | 99 | 173 | RNA00032.1 hypothetical protein BpHYR1_025377 [Brachionus plicatilis] | diamond | 225 | 145 | 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);;