contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJEB73599" and tax_clade = "Embryophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135201 | 135201 | PRJEB73599_P_NODE_6921_length_221_cov_5.578125_g6634_i0 | PRJEB73599 | 6921 | 221 | 5.578125 | 12.32765625 | Rutidosis leptorrhynchoides | 125765 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2922556849|ref|XR_011771451.1| | 125765 | g6634 | i0 | 94.444 | 0.606334841628959 | 36 | 2 | 16 | 0 | 186 | 221 | 3148 | 3113 | PREDICTED: Rutidosis leptorrhynchoides 28S ribosomal RNA (LOC139880634), rRNA | blastn | 134 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Rutidosis | Rutidosis leptorrhynchoides | |
| 995519 | 995519 | PRJEB73599_P_NODE_6561_length_232_cov_2.389163_g6274_i0 | PRJEB73599 | 6561 | 232 | 2.389163 | 5.54285816 | Magnoliopsida | 3398 | Plants | Plants | 429 | 8.2e-116 | NTclustered | gi|2328347789|ref|NC_067573.1| | 16915 | g6274 | i0 | 100 | 198 | 232 | 0 | 100 | 0 | 1 | 232 | 110388 | 110157 | Helwingia japonica chloroplast, complete sequence | blastn | 45936 | 429 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Aquifoliales | Helwingiaceae | Helwingia | Helwingia japonica | |
| 1409758 | 1409758 | PRJEB73599_P_NODE_3722_length_363_cov_4.928144_g3436_i0 | PRJEB73599 | 3722 | 363 | 4.928144 | 17.88916272 | Allium semenovii | 165656 | Plants | Plants | 392 | 1.7899999999999994e-104 | NTclustered | gi|2072688532|gb|MZ019479.1| | 165656 | g3436 | i0 | 86.761 | 174.04958677686 | 355 | 44 | 98 | 3 | 9 | 362 | 135562 | 135914 | Allium semenovii chloroplast | blastn | 63180 | 392 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Amaryllidaceae | Allium | Allium semenovii | |
| 7787540 | 7787540 | PRJEB73599_P_NODE_4007_length_345_cov_3.655063_g3720_i0 | PRJEB73599 | 4007 | 345 | 3.655063 | 12.60996735 | Hordeum vulgare | 4513 | Plants | Plants | 91.6 | 6.92e-14 | NTclustered | gi|2133663016|ref|XR_006614513.1| | 112509 | g3720 | i0 | 80.672 | 0.344927536231884 | 119 | 22 | 34 | 1 | 228 | 345 | 3124 | 3006 | PREDICTED: Hordeum vulgare subsp. vulgare 28S ribosomal RNA (LOC123414581), rRNA | blastn | 119 | 91.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 13748925 | 13748925 | PRJEB73599_P_NODE_6571_length_232_cov_2.113300_g6284_i0 | PRJEB73599 | 6571 | 232 | 2.1133 | 4.902856 | Poaceae | 4479 | Plants | Plants | 148 | 2.57e-31 | NTclustered | gi|2123588875|ref|XR_006435870.1| | 4565 | g6284 | i0 | 87.597 | 48.5215517241379 | 129 | 14 | 56 | 2 | 6 | 134 | 408 | 282 | PREDICTED: Triticum aestivum 28S ribosomal RNA (LOC123074126), rRNA | blastn | 11257 | 148 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 15437674 | 15437674 | PRJEB73599_P_NODE_6393_length_238_cov_1.861244_g6106_i0 | PRJEB73599 | 6393 | 238 | 1.861244 | 4.42976072 | Sesamum indicum | 4182 | Plants | Plants | 100 | 7.53e-17 | NTclustered | gi|1173814337|ref|XM_011088454.2| | 4182 | g6106 | i0 | 88.235 | 1.71008403361345 | 85 | 8 | 35 | 2 | 136 | 219 | 1117 | 1200 | PREDICTED: Sesamum indicum NADH dehydrogenase [ubiquinone] flavoprotein 1, mitochondrial-like (LOC105168390), transcript variant X2, mRNA | blastn | 407 | 100 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Pedaliaceae | Sesamum | Sesamum indicum | |
| 15437686 | 15437686 | PRJEB73599_P_NODE_8053_length_191_cov_1.518519_g7766_i0 | PRJEB73599 | 8053 | 191 | 1.518519 | 2.90037129 | Jacobaea vulgaris | 98722 | Plants | Plants | 52.8 | 0.016 | NTclustered | gi|2918395481|emb|OZ238157.1| | 98722 | g7766 | i0 | 96.875 | 0.167539267015707 | 32 | 0 | 16 | 1 | 77 | 107 | 26828179 | 26828148 | Jacobaea vulgaris genome assembly, chromosome: 9 | blastn | 32 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Jacobaea | Jacobaea vulgaris | |
| 16711879 | 16711879 | PRJEB73599_P_NODE_7434_length_206_cov_1.711864_g7147_i0 | PRJEB73599 | 7434 | 206 | 1.711864 | 3.52643984 | Alnus glutinosa | 3517 | Plants | Plants | 86.1 | 1.78e-12 | NTclustered | gi|2649024920|ref|XM_062321708.1| | 3517 | g7147 | i0 | 91.935 | 15.5388349514563 | 62 | 4 | 30 | 1 | 94 | 155 | 704 | 764 | PREDICTED: Alnus glutinosa large ribosomal subunit protein uL2m (LOC133882519), mRNA | blastn | 3201 | 86.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Betulaceae | Alnus | Alnus glutinosa | |
| 16711899 | 16711899 | PRJEB73599_P_NODE_9994_length_153_cov_2.096774_g9707_i0 | PRJEB73599 | 9994 | 153 | 2.096774 | 3.20806422 | Hibiscus syriacus | 106335 | Plants | Plants | 76.8 | 7.44e-10 | NTclustered | gi|1965313940|ref|XM_039188856.1| | 106335 | g9707 | i0 | 95.745 | 1.5359477124183 | 47 | 2 | 31 | 0 | 61 | 107 | 777 | 731 | PREDICTED: Hibiscus syriacus 60S ribosomal protein L7-2-like (LOC120184367), mRNA | blastn | 235 | 76.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Hibiscus | Hibiscus syriacus | |
| 17986722 | 17986722 | PRJEB73599_P_NODE_1155_length_700_cov_2.754098_g966_i0 | PRJEB73599 | 1155 | 700 | 2.754098 | 19.278686 | Oryza sativa | 4530 | Plants | Plants | 1181 | 0 | NTclustered | gi|116641696|emb|CT837035.1| | 39946 | g966 | i0 | 97.429 | 1 | 700 | 5 | 100 | 1 | 1 | 700 | 594 | 1280 | Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA119L05, full insert sequence | blastn | 700 | 1181 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 23948015 | 23948015 | PRJEB73599_P_NODE_4379_length_324_cov_2.461017_g4092_i0 | PRJEB73599 | 4379 | 324 | 2.461017 | 7.97369508 | Polypodiales | 3268 | Plants | Plants | 76.8 | 1.81e-9 | NTclustered | gi|2050223811|gb|MZ361031.1| | 41974 | g4092 | i0 | 92.593 | 1.5 | 54 | 2 | 17 | 2 | 4 | 57 | 7151 | 7100 | Pleurosoriopsis makinoi voucher X.C. Zhang 9478 (PE) small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 486 | 76.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polypodiopsida | Polypodiales | Polypodiaceae | Pleurosoriopsis | Pleurosoriopsis makinoi |
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);;