contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA902515" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 881494 | 881494 | PRJNA902515_P_NODE_9401_length_272_cov_1.472362_g9378_i0 | PRJNA902515 | 9401 | 272 | 1.472362 | 4.00482464 | Oryza sativa | 4530 | Plants | Plants | 503 | 5.729999999999998e-138 | NTclustered | gi|32982681|dbj|AK072658.1| | 39947 | g9378 | i0 | 100 | 6.96691176470588 | 272 | 0 | 100 | 0 | 1 | 272 | 329 | 58 | Oryza sativa Japonica Group cDNA clone:J023134D11, full insert sequence | blastn | 1895 | 503 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 1246643 | 1246643 | PRJNA902515_P_NODE_14001_length_247_cov_0.896552_g13978_i0 | PRJNA902515 | 14001 | 247 | 0.896552 | 2.21448344 | Triticum | 4564 | Plants | Plants | 457 | 4.05e-124 | NTclustered | gi|2123742633|ref|XM_044495496.1| | 4565 | g13978 | i0 | 100 | 51.7611336032389 | 247 | 0 | 100 | 0 | 1 | 247 | 595 | 841 | PREDICTED: Triticum aestivum thioredoxin F, chloroplastic-like (LOC123071915), mRNA | blastn | 12785 | 457 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 1246660 | 1246660 | PRJNA902515_P_NODE_5541_length_333_cov_1.200000_g5518_i0 | PRJNA902515 | 5541 | 333 | 1.2 | 3.996 | Eukaryota | 2759 | Plants | Plants | 610 | 4.13e-170 | NTclustered | gi|194703603|gb|BT040881.1| | 4577 | g5518 | i0 | 99.7 | 55.4174174174174 | 333 | 1 | 100 | 0 | 1 | 333 | 995 | 1327 | Zea mays full-length cDNA clone ZM_BFc0144J03 mRNA, complete cds | blastn | 18454 | 610 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 5074780 | 5074780 | PRJNA902515_P_NODE_14664_length_245_cov_0.906977_g14641_i0 | PRJNA902515 | 14664 | 245 | 0.906977 | 2.22209365 | Triticum | 4564 | Plants | Plants | 381 | 2.4799999999999995e-101 | NTclustered | gi|383100753|emb|HE774675.1| | 4565 | g14641 | i0 | 94.694 | 38.6 | 245 | 13 | 100 | 0 | 1 | 245 | 1579 | 1335 | Triticum aestivum chromosome arm 3DS-specific BAC library, contig ctg1484 | blastn | 9457 | 381 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 9809076 | 9809076 | PRJNA902515_P_NODE_11528_length_252_cov_0.871508_g11505_i0 | PRJNA902515 | 11528 | 252 | 0.871508 | 2.19620016 | Triticum dicoccoides | 85692 | Plants | Plants | 455 | 1.49e-123 | NTclustered | gi|1931521616|ref|XM_037573914.1| | 85692 | g11505 | i0 | 99.206 | 15.6587301587302 | 252 | 2 | 100 | 0 | 1 | 252 | 754 | 1005 | PREDICTED: Triticum dicoccoides glyceraldehyde-3-phosphate dehydrogenase 2, cytosolic-like (LOC119295487), transcript variant X4, mRNA | blastn | 3946 | 455 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum dicoccoides | |
| 10175192 | 10175192 | PRJNA902515_P_NODE_15488_length_243_cov_0.917647_g15465_i0 | PRJNA902515 | 15488 | 243 | 0.917647 | 2.22988221 | Poaceae | 4479 | Plants | Plants | 444 | 3.09e-120 | NTclustered | gi|1214171912|gb|KY636002.1| | 4483 | g15465 | i0 | 99.588 | 189 | 243 | 1 | 100 | 0 | 1 | 243 | 96311 | 96553 | Aegilops bicornis voucher AE 788 chloroplast, partial genome | blastn | 45927 | 444 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Aegilops | Aegilops bicornis | |
| 13634838 | 13634838 | PRJNA902515_P_NODE_10651_length_257_cov_2.315217_g10628_i0 | PRJNA902515 | 10651 | 257 | 2.315217 | 5.95010769 | Arabidopsis thaliana | 3702 | Plants | Plants | 475 | 1.1699999999999999e-129 | NTclustered | gi|1360523775|emb|LT937414.1| | 3702 | g10628 | i0 | 100 | 90.9961089494163 | 257 | 0 | 100 | 0 | 1 | 257 | 14 | 270 | Arabidopsis thaliana other for ATSL021720 | blastn | 23386 | 475 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Arabidopsis | Arabidopsis thaliana | |
| 13634982 | 13634982 | PRJNA902515_P_NODE_15771_length_243_cov_0.917647_g15748_i0 | PRJNA902515 | 15771 | 243 | 0.917647 | 2.22988221 | Triticum aestivum | 4565 | Plants | Plants | 449 | 6.65e-122 | NTclustered | gi|241988926|dbj|AK330148.1| | 4565 | g15748 | i0 | 100 | 9.23868312757202 | 243 | 0 | 100 | 0 | 1 | 243 | 503 | 261 | Triticum aestivum cDNA, clone: SET1_E08, cultivar: Chinese Spring | blastn | 2245 | 449 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 14000583 | 14000583 | PRJNA902515_P_NODE_14391_length_246_cov_0.901734_g14368_i0 | PRJNA902515 | 14391 | 246 | 0.901734 | 2.21826564 | Glycine | 3846 | Plants | Plants | 449 | 6.74e-122 | NTclustered | gi|2027471614|ref|XM_003526881.5| | 3847 | g14368 | i0 | 99.593 | 99.7520325203252 | 246 | 1 | 100 | 0 | 1 | 246 | 2617 | 2372 | PREDICTED: Glycine max chaperone protein ClpC, chloroplastic (LOC100804035), transcript variant X2, mRNA | blastn | 24539 | 449 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 14000601 | 14000601 | PRJNA902515_P_NODE_7891_length_292_cov_1.575342_g7868_i0 | PRJNA902515 | 7891 | 292 | 1.575342 | 4.59999864 | Triticum | 4564 | Plants | Plants | 540 | 4.74e-149 | NTclustered | gi|1251759002|dbj|AK457535.1| | 4565 | g7868 | i0 | 100 | 99.1438356164384 | 292 | 0 | 100 | 0 | 1 | 292 | 588 | 297 | Triticum aestivum mRNA, clone: tplb0016f17, cultivar Chinese Spring | blastn | 28950 | 540 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 14909051 | 14909051 | PRJNA902515_P_NODE_12832_length_249_cov_0.886364_g12809_i0 | PRJNA902515 | 12832 | 249 | 0.886364 | 2.20704636 | Triticum aestivum | 4565 | Plants | Plants | 243 | 1.25e-59 | NTclustered | gi|300681568|emb|FN564435.1| | 4565 | g12809 | i0 | 85.232 | 10.3574297188755 | 237 | 34 | 95 | 1 | 9 | 245 | 488149 | 487914 | Triticum aestivum chromosome 3B-specific BAC library, contig ctg1030b | blastn | 2579 | 243 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 14909058 | 14909058 | PRJNA902515_P_NODE_13052_length_249_cov_0.886364_g13029_i0 | PRJNA902515 | 13052 | 249 | 0.886364 | 2.20704636 | Armeria pungens | 71827 | Plants | Plants | 54.7 | 0.006 | NTclustered | gi|2919994823|emb|OZ238830.1| | 71827 | g13029 | i0 | 94.444 | 0.144578313253012 | 36 | 1 | 14 | 1 | 200 | 235 | 28874 | 28840 | Armeria pungens genome assembly, organelle: plastid:chloroplast | blastn | 36 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Plumbaginaceae | Armeria | Armeria pungens | |
| 17459427 | 17459427 | PRJNA902515_P_NODE_14194_length_246_cov_0.901734_g14171_i0 | PRJNA902515 | 14194 | 246 | 0.901734 | 2.21826564 | Triticum aestivum | 4565 | Plants | Plants | 383 | 6.94e-102 | NTclustered | gi|1282796720|gb|MG560140.1| | 4565 | g14171 | i0 | 94.737 | 19.5243902439024 | 247 | 12 | 100 | 1 | 1 | 246 | 227263 | 227509 | Triticum aestivum gamma gliadin-A1, gamma gliadin-A3, gamma gliadin-A4, and LMW-A2 genes, complete cds | blastn | 4803 | 383 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 21283145 | 21283145 | PRJNA902515_P_NODE_13277_length_248_cov_0.891429_g13254_i0 | PRJNA902515 | 13277 | 248 | 0.891429 | 2.21074392 | Triticum aestivum | 4565 | Plants | Plants | 265 | 2.6499999999999997e-66 | NTclustered | gi|164455201|dbj|AB298186.1| | 4565 | g13254 | i0 | 86 | 2.98387096774194 | 250 | 32 | 100 | 3 | 1 | 248 | 9487 | 9239 | Triticum aestivum genes for P450, putative ankyrin repeat protein, P450, complete cds, clone: TAC TaBx3D-TaBx4D | blastn | 740 | 265 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 21283179 | 21283179 | PRJNA902515_P_NODE_14737_length_245_cov_0.906977_g14714_i0 | PRJNA902515 | 14737 | 245 | 0.906977 | 2.22209365 | Triticum dicoccoides | 85692 | Plants | Plants | 453 | 5.1900000000000006e-123 | NTclustered | gi|1931482503|ref|XR_005135681.1| | 85692 | g14714 | i0 | 100 | 4 | 245 | 0 | 100 | 0 | 1 | 245 | 794 | 550 | PREDICTED: Triticum dicoccoides uncharacterized LOC119275419 (LOC119275419), ncRNA | blastn | 980 | 453 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum dicoccoides | |
| 22558120 | 22558120 | PRJNA902515_P_NODE_14338_length_246_cov_0.901734_g14315_i0 | PRJNA902515 | 14338 | 246 | 0.901734 | 2.21826564 | Oryza sativa | 4530 | Plants | Plants | 455 | 1.4500000000000002e-123 | NTclustered | gi|32971966|dbj|AK061948.1| | 39947 | g14315 | i0 | 100 | 10.3983739837398 | 246 | 0 | 100 | 0 | 1 | 246 | 766 | 521 | Oryza sativa Japonica Group cDNA clone:001-042-E07, full insert sequence | blastn | 2558 | 455 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 22558121 | 22558121 | PRJNA902515_P_NODE_14378_length_246_cov_0.901734_g14355_i0 | PRJNA902515 | 14378 | 246 | 0.901734 | 2.21826564 | Triticum aestivum | 4565 | Plants | Plants | 453 | 5.2100000000000006e-123 | NTclustered | gi|2123758267|ref|XM_044499944.1| | 4565 | g14355 | i0 | 100 | 8.86178861788618 | 245 | 0 | 99 | 0 | 2 | 246 | 748 | 504 | PREDICTED: Triticum aestivum glycine-rich cell wall structural protein 1.8-like (LOC123077648), mRNA | blastn | 2180 | 453 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 22924278 | 22924278 | PRJNA902515_P_NODE_11778_length_252_cov_0.871508_g11755_i0 | PRJNA902515 | 11778 | 252 | 0.871508 | 2.19620016 | Triticum | 4564 | Plants | Plants | 466 | 6.89e-127 | NTclustered | gi|2123823865|ref|XM_044524175.1| | 4565 | g11755 | i0 | 100 | 16.5714285714286 | 252 | 0 | 100 | 0 | 1 | 252 | 2166 | 1915 | PREDICTED: Triticum aestivum stromal 70 kDa heat shock-related protein, chloroplastic-like (LOC123102745), mRNA | blastn | 4176 | 466 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 23833349 | 23833349 | PRJNA902515_P_NODE_14079_length_246_cov_1.768786_g14056_i0 | PRJNA902515 | 14079 | 246 | 1.768786 | 4.35121356 | Arabidopsis thaliana | 3702 | Plants | Plants | 455 | 1.4500000000000002e-123 | NTclustered | gi|902788|gb|U23795.1|ATU23795 | 3702 | g14056 | i0 | 100 | 24.6219512195122 | 246 | 0 | 100 | 0 | 1 | 246 | 744 | 989 | Arabidopsis thaliana IAA-amino acid hydrolase homolog ILL1 (ILL1) mRNA, complete cds | blastn | 6057 | 455 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Arabidopsis | Arabidopsis thaliana | |
| 24198191 | 24198191 | PRJNA902515_P_NODE_6019_length_324_cov_0.932271_g5996_i0 | PRJNA902515 | 6019 | 324 | 0.932271 | 3.02055804 | Triticum | 4564 | Plants | Plants | 571 | 1.8899999999999993e-158 | NTclustered | gi|2123939371|ref|XM_044569817.1| | 4565 | g5996 | i0 | 98.457 | 95.3796296296296 | 324 | 5 | 100 | 0 | 1 | 324 | 170 | 493 | PREDICTED: Triticum aestivum plastocyanin, chloroplastic-like (LOC123150017), mRNA | blastn | 30903 | 571 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum |
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);;