contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA306153" and tax_kingdom = "Viridiplantae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9304421 | 9304421 | PRJNA306153_S_NODE_2528_length_157_cov_3.679688_g2515_i0 | PRJNA306153 | 2528 | 157 | 3.679688 | 5.77711016 | Magnoliopsida | 3398 | Plants | Plants | 101 | 9e-26 | NR | XP_024981471.1 | 59895 | g2515 | i0 | 82.7 | 5.96178343949045 | 52 | 9 | 99.4 | 0 | 2 | 157 | 27 | 78 | XP_024981471.1 40S ribosomal protein S19-1-like [Cynara cardunculus var. scolymus] | diamond | 936 | 102 | 0.990196078431373 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Cynara | Cynara cardunculus | |
| 14405345 | 14405345 | PRJNA306153_S_NODE_132_length_537_cov_4.322835_g122_i0 | PRJNA306153 | 132 | 537 | 4.322835 | 23.21362395 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 211 | 7.98e-66 | NR | BAJ99030.1 | 112509 | g122 | i0 | 65.2 | 0.994413407821229 | 178 | 62 | 99.4 | 0 | 536 | 3 | 11 | 188 | BAJ99030.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 534 | 211 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 14405354 | 14405354 | PRJNA306153_S_NODE_332_length_381_cov_3.468750_g319_i0 | PRJNA306153 | 332 | 381 | 3.46875 | 13.2159375 | Selaginella moellendorffii | 88036 | Plants | Plants | 160 | 2.0899999999999999e-47 | NR | XP_002988167.1 | 88036 | g319 | i0 | 72.2 | 4.41732283464567 | 108 | 30 | 85 | 0 | 11 | 334 | 54 | 161 | XP_002988167.1 60S ribosomal protein L12 [Selaginella moellendorffii] | diamond | 1683 | 160 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Lycopodiopsida | Selaginellales | Selaginellaceae | Selaginella | Selaginella moellendorffii | |
| 16953728 | 16953728 | PRJNA306153_S_NODE_354_length_370_cov_4.809384_g341_i0 | PRJNA306153 | 354 | 370 | 4.809384 | 17.7947208 | Brassicaceae | 3700 | Plants | Plants | 126 | 5.53e-32 | NR | KAH0912220.1 | 3708 | g341 | i0 | 68.5 | 8.11621621621622 | 92 | 27 | 74.6 | 1 | 370 | 95 | 290 | 379 | KAH0912220.1 hypothetical protein HID58_035541 [Brassica napus] | diamond | 3003 | 127 | 0.992125984251969 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica napus | |
| 26789517 | 26789517 | PRJNA306153_S_NODE_901_length_251_cov_3.891892_g888_i0 | PRJNA306153 | 901 | 251 | 3.891892 | 9.76864892 | Lotus japonicus | 34305 | Plants | Plants | 156 | 1.78e-45 | NR | AFK41760.1 | 34305 | g888 | i0 | 91.6 | 0.99203187250996006 | 83 | 7 | 99.2 | 0 | 250 | 2 | 73 | 155 | AFK41760.1 unknown [Lotus japonicus] | diamond | 249 | 156 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Lotus | Lotus japonicus | |
| 27168831 | 27168831 | PRJNA306153_S_NODE_902_length_251_cov_3.536036_g889_i0 | PRJNA306153 | 902 | 251 | 3.536036 | 8.87545036 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 131 | 9.18e-37 | NR | CAG9462620.1 | 765719 | g889 | i0 | 72.3 | 18.8486055776892 | 83 | 23 | 99.2 | 0 | 249 | 1 | 10 | 92 | CAG9462620.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 4731 | 131 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 27281593 | 27281593 | PRJNA306153_S_NODE_1403_length_204_cov_5.017143_g1390_i0 | PRJNA306153 | 1403 | 204 | 5.017143 | 10.23497172 | Chlorellaceae | 35461 | Plants | Plants | 73.6 | 1.22e-13 | NR | PRW39386.1 | 3076 | g1390 | i0 | 57.4 | 6.11764705882353 | 61 | 25 | 88.2 | 1 | 204 | 25 | 198 | 258 | PRW39386.1 40S ribosomal S3a-2 isoform B [Chlorella sorokiniana] | diamond | 1248 | 74.3 | 0.990578734858681 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 27548133 | 27548133 | PRJNA306153_S_NODE_144_length_521_cov_4.400407_g134_i0 | PRJNA306153 | 144 | 521 | 4.400407 | 22.92612047 | Datura stramonium | 4076 | Plants | Plants | 164 | 1.3799999999999998e-47 | NR | MCE2055700.1 | 4076 | g134 | i0 | 54.2 | 6.6679462571977 | 168 | 76 | 96.7 | 1 | 15 | 518 | 40 | 206 | MCE2055700.1 60S ribosomal protein L6 [Datura stramonium] | diamond | 3474 | 164 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Datura | Datura stramonium | |
| 29410944 | 29410944 | PRJNA306153_S_NODE_1629_length_192_cov_5.576687_g1616_i0 | PRJNA306153 | 1629 | 192 | 5.576687 | 10.70723904 | Canna indica | 4628 | Plants | Plants | 58.2 | 1.85e-8 | NR | WOL19609.1 | 4628 | g1616 | i0 | 68.9 | 2.8125 | 45 | 14 | 70.3 | 0 | 192 | 58 | 125 | 169 | WOL19609.1 60S ribosomal protein L15 [Canna indica] | diamond | 540 | 58.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Zingiberales | Cannaceae | Canna | Canna indica | |
| 30422183 | 30422183 | PRJNA306153_S_NODE_1193_length_220_cov_3.570681_g1180_i0 | PRJNA306153 | 1193 | 220 | 3.570681 | 7.8554982 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 103 | 6.22e-25 | NR | KAF6257032.1 | 2650976 | g1180 | i0 | 70.8 | 11.6727272727273 | 72 | 19 | 95.5 | 1 | 216 | 7 | 63 | 134 | KAF6257032.1 component of cytosolic 80S ribosome and 40S small subunit [Scenedesmus sp. NREL 46B-D3] | diamond | 2568 | 103 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 31766899 | 31766899 | PRJNA306153_S_NODE_1477_length_200_cov_3.678363_g1464_i0 | PRJNA306153 | 1477 | 200 | 3.678363 | 7.356726 | Eukaryota | 2759 | Plants | Plants | 86.7 | 2.28e-19 | NR | RZS01643.1 | 4639 | g1464 | i0 | 65.2 | 42.57 | 66 | 23 | 99 | 0 | 199 | 2 | 35 | 100 | RZS01643.1 hypothetical protein BHM03_00031530 [Ensete ventricosum] | diamond | 8514 | 86.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Zingiberales | Musaceae | Ensete | Ensete ventricosum | |
| 32115107 | 32115107 | PRJNA306153_S_NODE_2458_length_159_cov_1.346154_g2445_i0 | PRJNA306153 | 2458 | 159 | 1.346154 | 2.14038486 | Closterium | 34145 | Plants | Plants | 77.8 | 5.33e-15 | NR | CAI5519321.1 | 2996811 | g2445 | i0 | 73.6 | 5 | 53 | 14 | 100 | 0 | 159 | 1 | 989 | 1041 | CAI5519321.1 unnamed protein product [Closterium sp. Naga37s-1] | diamond | 795 | 77.8 | 1 | Eukaryota | Viridiplantae | Streptophyta | Zygnematophyceae | Desmidiales | Closteriaceae | Closterium | Closterium sp. Naga37s-1 | ||
| 32715436 | 32715436 | PRJNA306153_S_NODE_1040_length_234_cov_4.312195_g1027_i0 | PRJNA306153 | 1040 | 234 | 4.312195 | 10.0905363 | Poaceae | 4479 | Plants | Plants | 98.6 | 4.29e-24 | NR | XP_062192623.1 | 29695 | g1027 | i0 | 70.6 | 4.38461538461539 | 68 | 20 | 87.2 | 0 | 2 | 205 | 76 | 143 | XP_062192623.1 large ribosomal subunit protein uL24z-like [Phragmites australis] | diamond | 1026 | 99.4 | 0.991951710261569 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Phragmites | Phragmites australis | |
| 32886657 | 32886657 | PRJNA306153_S_NODE_780_length_271_cov_6.111570_g767_i0 | PRJNA306153 | 780 | 271 | 6.11157 | 16.5623547 | Sphagnum jensenii | 128206 | Plants | Plants | 50.4 | 9.65e-5 | NR | CAK9253046.1 | 128206 | g767 | i0 | 42.6 | 0.597785977859779 | 54 | 30 | 59.8 | 1 | 262 | 101 | 314 | 366 | CAK9253046.1 unnamed protein product [Sphagnum jensenii] | diamond | 162 | 50.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum jensenii |
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);;