contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJEB12237" and tax_phylum = "Annelida"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15322869 | 15322869 | PRJEB12237_P_NODE_5313_length_262_cov_1.409692_g5117_i0 | PRJEB12237 | 5313 | 262 | 1.409692 | 3.69339304 | Metazoa | 33208 | Annelida | Annelida | 150 | 1.6799999999999994e-42 | NR | CAH1793798.1 | 6347 | g5117 | i0 | 79.3 | 27.8473282442748 | 87 | 18 | 99.6 | 0 | 1 | 261 | 81 | 167 | CAH1793798.1 unnamed protein product [Owenia fusiformis] | diamond | 7296 | 151 | 0.993377483443709 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 22972677 | 22972677 | PRJEB12237_P_NODE_6079_length_237_cov_1.450495_g5883_i0 | PRJEB12237 | 6079 | 237 | 1.450495 | 3.43767315 | Metazoa | 33208 | Annelida | Annelida | 124 | 1.28e-33 | NR | CAH1798696.1 | 6347 | g5883 | i0 | 74 | 8.7848101265822809 | 77 | 20 | 97.5 | 0 | 5 | 235 | 47 | 123 | CAH1798696.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 2082 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 23937935 | 23937935 | PRJEB12237_P_NODE_1559_length_578_cov_2.228361_g1380_i0 | PRJEB12237 | 1559 | 578 | 2.228361 | 12.87992658 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 131 | 4.32e-35 | NR | ABW90377.1 | 6446 | g1380 | i0 | 55.8 | 17.9117647058824 | 113 | 45 | 56.1 | 2 | 51 | 374 | 1 | 113 | ABW90377.1 putative ribosomal protein S10 [Sipunculus nudus] | diamond | 10353 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 26684668 | 26684668 | PRJEB12237_P_NODE_12121_length_150_cov_1.730435_g11925_i0 | PRJEB12237 | 12121 | 150 | 1.730435 | 2.5956525 | Alitta virens | 880429 | Annelida | Annelida | 45.4 | 0.00115 | NR | AJW77403.1 | 880429 | g11925 | i0 | 88.9 | 2.38 | 18 | 2 | 36 | 0 | 11 | 64 | 144 | 161 | AJW77403.1 vasa [Alitta virens] | diamond | 357 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Alitta | Alitta virens | |
| 26900208 | 26900208 | PRJEB12237_P_NODE_11581_length_154_cov_2.016807_g11385_i0 | PRJEB12237 | 11581 | 154 | 2.016807 | 3.10588278 | Opisthokonta | 33154 | Annelida | Annelida | 43.9 | 0.00311 | NR | ABW23172.1 | 6344 | g11385 | i0 | 54.1 | 5.04545454545455 | 37 | 16 | 72.1 | 1 | 6 | 116 | 142 | 177 | ABW23172.1 ribosomal protein rpl18 [Arenicola marina] | diamond | 777 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 27152659 | 27152659 | PRJEB12237_P_NODE_9522_length_174_cov_1.438849_g9326_i0 | PRJEB12237 | 9522 | 174 | 1.438849 | 2.50359726 | Metazoa | 33208 | Annelida | Annelida | 44.3 | 0.00422 | NR | KAK2161026.1 | 53620 | g9326 | i0 | 34.5 | 4.60344827586207 | 55 | 32 | 94.8 | 1 | 169 | 5 | 979 | 1029 | KAK2161026.1 hypothetical protein LSH36_122g02003 [Paralvinella palmiformis] | diamond | 801 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28675348 | 28675348 | PRJEB12237_P_NODE_7627_length_201_cov_1.445783_g7431_i0 | PRJEB12237 | 7627 | 201 | 1.445783 | 2.90602383 | Helobdella robusta | 6412 | Annelida | Annelida | 52.4 | 1.04e-6 | NR | XP_009025143.1 | 6412 | g7431 | i0 | 62.8 | 2.46268656716418 | 43 | 16 | 64.2 | 0 | 201 | 73 | 61 | 103 | XP_009025143.1 hypothetical protein HELRODRAFT_67827 [Helobdella robusta] | diamond | 495 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28794984 | 28794984 | PRJEB12237_P_NODE_10907_length_160_cov_1.280000_g10711_i0 | PRJEB12237 | 10907 | 160 | 1.28 | 2.048 | Metazoa | 33208 | Annelida | Annelida | 61.2 | 6.47e-10 | NR | ABW90377.1 | 6446 | g10711 | i0 | 58.3 | 4.78125 | 48 | 20 | 90 | 0 | 145 | 2 | 1 | 48 | ABW90377.1 putative ribosomal protein S10 [Sipunculus nudus] | diamond | 765 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 29117433 | 29117433 | PRJEB12237_P_NODE_10149_length_167_cov_1.212121_g9953_i0 | PRJEB12237 | 10149 | 167 | 1.212121 | 2.02424207 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 51.6 | 9.93e-6 | NR | KAK2153378.1 | 53620 | g9953 | i0 | 46.3 | 0.970059880239521 | 54 | 27 | 97 | 1 | 5 | 166 | 10 | 61 | KAK2153378.1 hypothetical protein LSH36_299g03010 [Paralvinella palmiformis] | diamond | 162 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 29773875 | 29773875 | PRJEB12237_P_NODE_1971_length_509_cov_2.014768_g1784_i0 | PRJEB12237 | 1971 | 509 | 2.014768 | 10.25516912 | Metazoa | 33208 | Annelida | Annelida | 128 | 3.19e-34 | NR | ABW90377.1 | 6446 | g1784 | i0 | 55.8 | 11.1866404715128 | 113 | 44 | 63.1 | 3 | 465 | 145 | 1 | 113 | ABW90377.1 putative ribosomal protein S10 [Sipunculus nudus] | diamond | 5694 | 129 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 31708089 | 31708089 | PRJEB12237_P_NODE_2837_length_412_cov_2.323607_g2641_i0 | PRJEB12237 | 2837 | 412 | 2.323607 | 9.57326084 | Sipunculus nudus | 6446 | Annelida | Annelida | 132 | 3.09e-36 | NR | ABW90377.1 | 6446 | g2641 | i0 | 55.8 | 7.94417475728155 | 113 | 45 | 78.6 | 2 | 354 | 31 | 1 | 113 | ABW90377.1 putative ribosomal protein S10 [Sipunculus nudus] | diamond | 3273 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 32461220 | 32461220 | PRJEB12237_P_NODE_3539_length_351_cov_4.800633_g3343_i0 | PRJEB12237 | 3539 | 351 | 4.800633 | 16.85022183 | Metazoa | 33208 | Annelida | Annelida | 144 | 2.2199999999999996e-37 | NR | XP_009022669.1 | 6412 | g3343 | i0 | 79 | 49.9145299145299 | 81 | 17 | 69.2 | 0 | 10 | 252 | 762 | 842 | XP_009022669.1 hypothetical protein HELRODRAFT_185027 [Helobdella robusta] | diamond | 17520 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta |
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);;