contig_metadata
13 rows where bioproject = "PRJEB4632" and tax_phylum = "Streptophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 990065 | 990065 | PRJEB4632_P_NODE_1081_length_206_cov_6.842105_g1043_i0 | PRJEB4632 | 1081 | 206 | 6.842105 | 14.0947363 | Eukaryota | 2759 | Plants | Plants | 381 | 2.0199999999999994e-101 | NTclustered | gi|1893169201|gb|MT735327.1| | 3349 | g1043 | i0 | 100 | 103.5 | 206 | 0 | 100 | 0 | 1 | 206 | 796 | 1001 | Pinus sylvestris isolate DM309 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 21321 | 381 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Pinus | Pinus sylvestris | |
| 2265286 | 2265286 | PRJEB4632_P_NODE_662_length_270_cov_1.071066_g624_i0 | PRJEB4632 | 662 | 270 | 1.071066 | 2.8918782 | Rosaceae | 3745 | Plants | Plants | 497 | 2.6399999999999998e-136 | NTclustered | gi|2183121001|gb|OK585101.1| | 3750 | g624 | i0 | 100 | 192.322222222222 | 269 | 0 | 99 | 0 | 1 | 269 | 108813 | 109081 | Malus domestica cultivar Red Fuji-TS03 plastid, complete genome | blastn | 51927 | 499 | 0.995991983967936 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Malus | Malus domestica | |
| 7367609 | 7367609 | PRJEB4632_P_NODE_706_length_260_cov_2.978610_g668_i0 | PRJEB4632 | 706 | 260 | 2.97861 | 7.744386 | Magnoliopsida | 3398 | Plants | Plants | 475 | 1.1899999999999999e-129 | NTclustered | gi|2699132188|emb|OZ022203.1| | 3755 | g668 | i0 | 99.615 | 111.273076923077 | 260 | 1 | 100 | 0 | 1 | 260 | 1211000 | 1211259 | Prunus dulcis genome assembly, chromosome: 7 | blastn | 28931 | 475 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Prunus | Prunus dulcis | |
| 9918217 | 9918217 | PRJEB4632_P_NODE_1088_length_201_cov_6.593750_g1050_i0 | PRJEB4632 | 1088 | 201 | 6.59375 | 13.2534375 | Rosales | 3744 | Plants | Plants | 372 | 1.18e-98 | NTclustered | gi|2810943367|gb|CP168765.1| | 3750 | g1050 | i0 | 100 | 102.960199004975 | 201 | 0 | 100 | 0 | 1 | 201 | 35457 | 35257 | Malus domestica cultivar Golden Delicious chromosome 01 | blastn | 20695 | 372 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Malus | Malus domestica | |
| 9918225 | 9918225 | PRJEB4632_P_NODE_748_length_251_cov_2.651685_g710_i0 | PRJEB4632 | 748 | 251 | 2.651685 | 6.65572935 | Pinus | 3337 | Plants | Plants | 459 | 1.1499999999999996e-124 | NTclustered | gi|1878849209|gb|MT796545.1| | 3339 | g710 | i0 | 99.602 | 105.972111553785 | 251 | 1 | 100 | 0 | 1 | 251 | 6278 | 6528 | Pinus contorta isolate DM604 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 26599 | 459 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Pinus | Pinus contorta | |
| 10264401 | 10264401 | PRJEB4632_P_NODE_609_length_283_cov_1.523810_g571_i0 | PRJEB4632 | 609 | 283 | 1.52381 | 4.3123823 | Poa annua | 93036 | Plants | Plants | 518 | 2.14e-142 | NTclustered | gi|1347727320|ref|NC_036973.1| | 93036 | g571 | i0 | 99.647 | 195 | 283 | 1 | 100 | 0 | 1 | 283 | 97943 | 97661 | Poa annua plastid, complete genome | blastn | 55185 | 518 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Poa | Poa annua | |
| 11193417 | 11193417 | PRJEB4632_P_NODE_629_length_277_cov_1.862745_g591_i0 | PRJEB4632 | 629 | 277 | 1.862745 | 5.15980365 | Pinus | 3337 | Plants | Plants | 507 | 4.53e-139 | NTclustered | gi|1878849209|gb|MT796545.1| | 3339 | g591 | i0 | 99.639 | 103.436823104693 | 277 | 1 | 100 | 0 | 1 | 277 | 313 | 37 | Pinus contorta isolate DM604 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 28652 | 512 | 0.990234375 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Pinus | Pinus contorta | |
| 15017869 | 15017869 | PRJEB4632_P_NODE_432_length_333_cov_1.738462_g394_i0 | PRJEB4632 | 432 | 333 | 1.738462 | 5.78907846 | Poaceae | 4479 | Plants | Plants | 608 | 1.479999999999999e-169 | NTclustered | gi|1214171912|gb|KY636002.1| | 4483 | g394 | i0 | 99.699 | 181.453453453453 | 332 | 1 | 99 | 0 | 2 | 333 | 97271 | 96940 | Aegilops bicornis voucher AE 788 chloroplast, partial genome | blastn | 60424 | 614 | 0.990228013029316 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Aegilops | Aegilops bicornis | |
| 21392121 | 21392121 | PRJEB4632_P_NODE_1017_length_232_cov_2.754717_g979_i0 | PRJEB4632 | 1017 | 232 | 2.754717 | 6.39094344 | Salix | 40685 | Plants | Plants | 429 | 8.2e-116 | NTclustered | gi|1881064953|gb|MT808329.1| | 75704 | g979 | i0 | 100 | 100 | 232 | 0 | 100 | 0 | 1 | 232 | 467 | 236 | Salix alba isolate DM300 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 23200 | 429 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Salix | Salix alba | |
| 21392126 | 21392126 | PRJEB4632_P_NODE_497_length_314_cov_2.987552_g459_i0 | PRJEB4632 | 497 | 314 | 2.987552 | 9.38091328 | Poales | 38820 | Plants | Plants | 575 | 1.4099999999999994e-159 | NTclustered | gi|1042812848|gb|KT153030.1| | 4499 | g459 | i0 | 99.682 | 1128.48089171975 | 314 | 1 | 100 | 0 | 1 | 314 | 19 | 332 | Avena fatua 18S ribosomal RNA gene, partial sequence | blastn | 354343 | 575 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Avena | Avena fatua | |
| 21392131 | 21392131 | PRJEB4632_P_NODE_777_length_250_cov_1.638418_g739_i0 | PRJEB4632 | 777 | 250 | 1.638418 | 4.096045 | Pinus | 3337 | Plants | Plants | 462 | 8.83e-126 | NTclustered | gi|1893169201|gb|MT735327.1| | 3349 | g739 | i0 | 100 | 104.272 | 250 | 0 | 100 | 0 | 1 | 250 | 5081 | 4832 | Pinus sylvestris isolate DM309 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 26068 | 462 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Pinus | Pinus sylvestris | |
| 25216180 | 25216180 | PRJEB4632_P_NODE_420_length_338_cov_1.686792_g382_i0 | PRJEB4632 | 420 | 338 | 1.686792 | 5.70135696 | Sapindales | 41937 | Plants | Plants | 608 | 1.509999999999999e-169 | NTclustered | gi|1198028429|ref|NC_034690.1| | 2708 | g382 | i0 | 99.112 | 192 | 338 | 3 | 100 | 0 | 1 | 338 | 110206 | 109869 | Citrus limon plastid, complete genome | blastn | 64896 | 614 | 0.990228013029316 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Rutaceae | Citrus | Citrus x limon | |
| 30412934 | 30412934 | PRJEB4632_P_NODE_933_length_243_cov_0.905882_g895_i0 | PRJEB4632 | 933 | 243 | 0.905882 | 2.20129326 | Zea mays | 4577 | Plants | Plants | 65.5 | 3.69e-10 | NR | AQA29577.1 | 4577 | g895 | i0 | 62.5 | 0.592592592592593 | 48 | 18 | 59.3 | 0 | 88 | 231 | 193 | 240 | AQA29577.1 putative transposase protein [Zea mays] | diamond | 144 | 65.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays |
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);;